우리는 인터페이스를 사용하여 구현할 것이다 Service가 Interface를 멤버변수로 가지고 있으면 (의존관계로 가지고 있으면) 어노테이션만 클래스에 다르게 설정하는지에 따라 다른 객체를 주입 받을 수 있게 된다 즉, 코드의 변경이 적어져 결합도가 낮아지고 유지보수가 용이해진다
Service는 DAO를 사용한다
Service와 DAO는 각각 Interface를 활용하여 구현한다
코드 구현
InterfaceBoardDAO.java
public interface InterfaceBoardDAO {
public List<BoardDTO> selectAll(BoardDTO bDTO);
public BoardDTO selectOne(BoardDTO bDTO);
public boolean insert(BoardDTO bDTO);
public boolean update(BoardDTO bDTO);
public boolean delete(BoardDTO bDTO);
}
BoardDAO.java
package com.jhyun.app;
import java.util.List;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.jdbc.core.BeanPropertyRowMapper;
import org.springframework.jdbc.core.JdbcTemplate;
import org.springframework.stereotype.Repository;
@Repository
public class BoardDAO implements InterfaceBoardDAO{
@Autowired
private JdbcTemplate jdbcTemplate;
private final String SELECTALL="SELECT * FROM BOARD ORDER BY BID DESC";
private final String SELECTONE="SELECT * FROM BOARD WHERE BID=?";
private final String INSERT="INSERT INTO BOARD VALUES((SELECT NVL(MAX(BID),100)+1 FROM BOARD),?,?)";
private final String UPDATE="UPDATE BOARD SET CONTENT=? WHERE BID=?";
private final String DELETE="DELETE FROM BOARD WHERE BID=?";
@Override
public List<BoardDTO> selectAll(BoardDTO bDTO) {
return jdbcTemplate.query(SELECTALL, new BeanPropertyRowMapper<BoardDTO>(BoardDTO.class));
}
@Override
public BoardDTO selectOne(BoardDTO bDTO) {
Object[] args= { bDTO.getBid() };
try {
return jdbcTemplate.queryForObject(SELECTONE, args, new BeanPropertyRowMapper<BoardDTO>(BoardDTO.class));
}
catch(Exception e) {
return null;
}
}
@Override
public boolean insert(BoardDTO bDTO) {
int result=jdbcTemplate.update(INSERT, bDTO.getMid(), bDTO.getContent());
return result>0 ? true : false;
}
@Override
public boolean update(BoardDTO bDTO) {
int result=jdbcTemplate.update(UPDATE, bDTO.getContent(), bDTO.getBid());
return result>0 ? true : false;
}
@Override
public boolean delete(BoardDTO bDTO) {
int result=jdbcTemplate.update(DELETE, bDTO.getBid());
return result>0 ? true : false;
}
}
