Spring MVC
Last updated
@Service
public class BoardService {
private BoardDao boardDao;
public BoardDto getBoardDetail(int id) {
if (id <= 0) {
throw new IllegalArgumentException("invalid id");
}
return boardDao.selectBoard(id);
}
}@Repository
public class BoardDao {
private SqlMapClientTemplate sqlMapClientTemplate;
public BoardDto selectBoard(int id) {
return (BoardDto) sqlMapClientTemplate.queryForObject(
"Board.selectBoard",
id
);
}
}<sqlMap namespace="Board">
<select id="selectBoard"
parameterClass="int"
resultClass="com.example.BoardDto">
SELECT
id,
title,
writer,
content
FROM board
WHERE id = #value#
</select>
</sqlMap>public class BoardDto {
private int id;
private String title;
private String writer;
private String content;
public int getId() { return id; }
public void setId(int id) { this.id = id; }
public String getTitle() { return title; }
public void setTitle(String title) { this.title = title; }
public String getWriter() { return writer; }
public void setWriter(String writer) { this.writer = writer; }
public String getContent() { return content; }
public void setContent(String content) { this.content = content; }
}