control-model-jdbc BoardDao.java

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;
 
 
import org.springframework.stereotype.Repository;
 
 
import com.springbook.biz.board.BoardVO;
import com.springbook.biz.common.JDBCUtil;
import com.springbook.biz.user.UserVO;
 
public class BoardDAO {
    private Connection conn = null;
    private PreparedStatement stmt = null;
    private ResultSet rs = null;
    private final String CREATE_BOARD = " CREATE TABLE BOARD ("
            + " SEQ INT(10) AUTO_INCREMENT PRIMARY KEY, TITLE VARCHAR(20), WRITER VARCHAR(20), CONTENT VARCHAR(50))";
    private final String BOARD_INSERT = "INSERT INTO BOARD(TITLE, WRITER, CONTENT) VALUES(?,?,?)";
    private final String BOARD_UPDATE = "UPDATE BOARD SET TITLE=?, CONTENT=? WHERE SEQ=?";
    private final String BOARD_DELETE = "DELETE FROM BOARD WHERE SEQ=?";
    private final String BOARD_GET = "SELECT * FROM BOARD WHERE SEQ=?";
    private final String BOARD_LIST = "SELECT * FROM BOARD ORDER BY SEQ DESC";
    
    public void insertBoard(BoardVO vo) {
        System.out.println("===> JDBC insertBoard() ");
        conn = JDBCUtil.getConnection();
        try {
            stmt = conn.prepareStatement(BOARD_INSERT);
            stmt.setString(1, vo.getTitle());
            stmt.setString(2, vo.getWriter());
            stmt.setString(3, vo.getContent());
            stmt.execute();
        } catch (SQLException e) {
            // TODO Auto-generated catch block
            e.printStackTrace();
        } finally {
            JDBCUtil.close(stmt, conn);
        }
        
    }
    public List<BoardVO> getBoardList() {
        BoardVO board = null;
        List<BoardVO> boardList = new ArrayList<BoardVO>();
        try {
            System.out.println("===> JDBC로 getBoardList() 기능 처리");
            conn = JDBCUtil.getConnection();
            stmt = conn.prepareStatement(BOARD_LIST);
            
            rs = stmt.executeQuery();
            while(rs.next()) {
                board = new BoardVO();
                board.setTitle(rs.getString("TITLE"));
                board.setWriter(rs.getString("WRITER"));
                board.setContent(rs.getString("CONTENT"));
                boardList.add(board);
            }
        } catch (SQLException e) {
            // TODO Auto-generated catch block
            e.printStackTrace();
        }
        return boardList;
        
    }
}