/**
 * 이 소스는 Spring 프레임워크 워크북에서 사용한 예제 소스입니다. 
 * 이 소스는 모든 개발자들이 자유롭게 수정 및 배포할 수 있습니다. 
 * 단, 이 소스를 기반으로 새로운 애플리케이션을 개발할 경우 출처를 명시해 주시면 됩니다. 
 */
package net.javajigi.board.dao;

import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;

import net.javajigi.board.model.Board;
import net.javajigi.common.dao.MyJdbcDaoSupport;

import org.springframework.dao.DataAccessException;
import org.springframework.jdbc.core.PreparedStatementSetter;
import org.springframework.jdbc.core.ResultReader;

public class SpringJDBCBoardDAO extends MyJdbcDaoSupport implements BoardDAO {

	public Board insert(Board board) throws DataAccessException {
		return null;
	}

	public Board update(Board board) throws DataAccessException {
		// TODO Auto-generated method stub
		return null;
	}

	public int delete(int boardNo) throws DataAccessException {
		// TODO Auto-generated method stub
		return 0;
	}

	public Board findBoard(int boardNo) throws DataAccessException {
		// TODO Auto-generated method stub
		return null;
	}

	public List findBoardList(int currentPage, final int countPerPage)
			throws DataAccessException {
		final int start = (currentPage - 1) * countPerPage;

		String sql = getMessageSourceAccessor().getMessage(
				"board.sql.select.list");

		PreparedStatementSetter psSetter = new PreparedStatementSetter() {
			public void setValues(PreparedStatement ps) throws SQLException {
				ps.setInt(1, start);
				ps.setInt(2, countPerPage);
			}
		};

		ResultReader resultReader = new ResultReader() {
			List boardList = new ArrayList();

			public void processRow(ResultSet rs) throws SQLException {
				Board board = new Board();
				board.setBoardNo(rs.getInt("boardNo"));
				board.setTitle(rs.getString("title"));
				board.setName(rs.getString("name"));
				board.setEmail(rs.getString("email"));
				board.setCreateDate(rs.getString("createdate"));
				board.setHitCount(rs.getInt("hitCount"));

				boardList.add(board);
			}

			public List getResults() {
				return boardList;
			}
		};

		List list = getJdbcTemplate().query(sql, psSetter, resultReader);

		return list;
	}

	public int updateHitCount(int boardNo) throws DataAccessException {
		// TODO Auto-generated method stub
		return 0;
	}

	public int getTotalNo() throws DataAccessException {
		// TODO Auto-generated method stub
		return 0;
	}

}