Endless Endeavor

교육센터에서 배울땐 오라클로 했었는데

BoardDao.java

package endless.test;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.Vector;

public class BoardDao {
	Board board;
	Connection connection;
	PreparedStatement preparedStatement;
	DataBaseChoice dbchoice = new DataBaseChoice();
	Vector boardlist;
	ResultSet resultset;
	
	public void insert(Object object) throws SQLException, ClassNotFoundException{
		board = (Board) object;
		connection = dbchoice.makeConnection();
		String insertQuery = "INSERT INTO BOARD (id,title,content,hit,writedate) VALUES (?,?,?,0,now())";
		preparedStatement = connection.prepareStatement(insertQuery);
		preparedStatement.setString(1, board.getId());
		preparedStatement.setString(2, board.getTitle());
		preparedStatement.setString(3, board.getContent());
		preparedStatement.executeUpdate();
		
		preparedStatement.close();
		connection.close();
				
	}
	
	public Vector list() throws ClassNotFoundException, SQLException{
		boardlist = new Vector();
		
			connection = dbchoice.makeConnection();
			String query = "SELECT * FROM BOARD";
			preparedStatement = connection.prepareStatement(query);
			resultset = preparedStatement.executeQuery();
			
			while(resultset.next()){
				board = new Board();
				board.setWritenum(resultset.getInt("writenum"));
				board.setId(resultset.getString("id"));
				board.setTitle(resultset.getString("title"));
				board.setContent(resultset.getString("content"));
				board.setHit(resultset.getInt("hit"));
				board.setWritedate(resultset.getTimestamp("writedate"));
				
				boardlist.add(board);
			}
			preparedStatement.close();
			connection.close();
			
		return boardlist;
	}
	
	public int getBoardCount() throws SQLException, ClassNotFoundException {
		int value = 0;
		
		connection = dbchoice.makeConnection();
		String countQuery = "SELECT COUNT(*) FROM BOARD";
		preparedStatement = connection.prepareStatement(countQuery);
		resultset = preparedStatement.executeQuery();
		
		if(resultset.next()){
			value = resultset.getInt(1);
		}
		return value;
	}
	
}

글을 썼다면 간단한 내용으로 게시판의 화면에 보여질 글을 읽어와야한다.

즉. 글번호라든지 글제목 글쓴이 등 이 부분을 게시판에 보여줘야한다.

이부분을 BoardDao에 추가한다.

package endless.test;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.Vector;

public class BoardDao {
	Board board;
	Connection connection;
	PreparedStatement preparedStatement;
	DataBaseChoice dbchoice = new DataBaseChoice();
	Vector boardlist;
	ResultSet resultset;
	
	public void insert(Object object){
		board = (Board) object;
		try{
		connection = dbchoice.makeConnection();
		String insertQuery = "INSERT INTO BOARD (id,title,content,hit,writedate) VALUES (?,?,?,0,now())";
		preparedStatement = connection.prepareStatement(insertQuery);
		preparedStatement.setString(1, board.getId());
		preparedStatement.setString(2, board.getTitle());
		preparedStatement.setString(3, board.getContent());
		preparedStatement.executeUpdate();
		
		preparedStatement.close();
		connection.close();
		
		}catch(SQLException e){
			e.printStackTrace();
		}catch(ClassNotFoundException cnfe){
			cnfe.printStackTrace();
		}
		
	}
	
	public Vector list(){
		boardlist = new Vector();
		
		try {
			connection = dbchoice.makeConnection();
			String query = "SELECT * FROM BOARD";
			preparedStatement = connection.prepareStatement(query);
			resultset = preparedStatement.executeQuery();
			
			while(resultset.next()){
				board = new Board();
				board.setWritenum(resultset.getInt("writenum"));
				board.setId(resultset.getString("id"));
				board.setTitle(resultset.getString("title"));
				board.setContent(resultset.getString("content"));
				board.setHit(resultset.getInt("hit"));
				board.setWritedate(resultset.getTimestamp("writedate"));
				
				boardlist.add(board);
			}
			preparedStatement.close();
			connection.close();
			
		} catch (SQLException e) {
			e.printStackTrace();
		}catch(ClassNotFoundException cnfe){
			cnfe.printStackTrace();
		}
		
		return boardlist;
	}
}

write.jsp에 쓴 내용을 VO에 담아서 DB에 넣는 로직을 구현하는 BoardDao 파일을 만듭니다.

실행된 화면

게시판에 들어갈 항목을 VO로 만든다.

package endless.test;
import java.sql.Timestamp;
public class Board {
	private int writenum;					//글번호
	private String id;						//아이디
	private String title;					//제목
	private String content;					//내용
	private int hit;						//조회수
	private Timestamp writedate;			//글쓴시간
	public int getWritenum() {
		return writenum;
	}
	public void setWritenum(int writenum) {
		this.writenum = writenum;
	}
	public String getId() {
		return id;
	}
	public void setId(String id) {
		this.id = id;
	}
	public String getTitle() {
		return title;
	}
	public void setTitle(String title) {
		this.title = title;
	}
	public String getContent() {
		return content;
	}
	public void setContent(String content) {
		this.content = content;
	}
	public int getHit() {
		return hit;
	}
	public void setHit(int hit) {
		this.hit = hit;
	}
	public Timestamp getWritedate() {
		return writedate;
	}
	public void setWritedate(Timestamp writedate) {
		this.writedate = writedate;
	}
}