React DB 연결(Mybatis)

BoardController

@RestController
public class BoardController {

	@Autowired
	private BoardService boardService;
	
	//추가
//	@PostMapping("insert")
//	public void insert(@RequestBody Board board) {
//		boardService.insert(board);
//	}
	
	//추가(입력 2 방법 때문에 이렇게 수정)
	@PostMapping("insert")
	public Board insert(@RequestBody Board board) {
		boardService.insert(board);
		return board;
	}
	
	
	//전체보기
	@GetMapping("list")
	public List<Board>list(){
		return boardService.list();
	}
	
	//삭제
	@DeleteMapping("delete/{num}")
	public void delete(@PathVariable Long num) {
		boardService.delete(num);
	}
	
}

 

Board

@Getter @Setter
public class Board {
	private Long num;
	private String title;
	private String content;
}

 

BoardMapper

@Mapper
public interface BoardMapper {

	//게시판 글쓰기
	@Insert("insert into board(title, content) values(#{title}, #{content})")
	@Options(useGeneratedKeys = true, keyProperty = "num")
	public void insert(Board board);
	

	//게시판 전체보기
	@Select("select * from board")
	public List<Board>lists();
	
	//삭제
	@Delete("delete from board where num=#{num}")
	public Long delete(Long num);
}

 

BoardService

@Service
public class BoardService {

	@Autowired
	private BoardMapper boardMapper;

	//추가
	public void insert(Board board) {
		boardMapper.insert(board);
	}
	
	
	//전체보기
	public List<Board>list(){
		return boardMapper.lists();
	}
	
	//삭제
	public void delete(Long num) {
		boardMapper.delete(num);
	}
}