231228 HTML BoardDAO.java

package com.sukgi.dao;
 
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.util.ArrayList;
import java.util.List;
 
import com.sukgi.dto.BoardDTO;
 
import conn.sukgi.db.DBConnection;
 
public class BoardDAO {
    DBConnection dbCon = new DBConnection();
    
    public List<BoardDTO> boardList() {
        List<BoardDTO> list = new ArrayList<BoardDTO>();
        
        Connection con = dbCon.getConn();
        PreparedStatement stmt = null;
        ResultSet rs = null;
        String sql = "SELECT * FROM board LIMIT 0,10";
        
        try {
            stmt = con.prepareStatement(sql);
            rs = stmt.executeQuery();
            
            list = new ArrayList<BoardDTO>();
            
            while (rs.next()) {
                BoardDTO  dto = new BoardDTO();
                dto.setBoard_no(rs.getInt(1));
                dto.setBoard_title(rs.getString(2));
                dto.setBoard_write(rs.getString(3));
                dto.setBoard_date(rs.getString(4));
                dto.setBoard_count(rs.getInt(5));
                
                list.add(dto);
            }
            
        } catch (Exception e) {
            // TODO: handle exception
        }
        
        
        
        
        return list;
        
    }
 
}