/**
 * 이 소스는 Spring 프레임워크 워크북에서 사용한 예제 소스입니다. 
 * 이 소스는 모든 개발자들이 자유롭게 수정 및 배포할 수 있습니다. 
 * 단, 이 소스를 기반으로 새로운 애플리케이션을 개발할 경우 출처를 명시해 주시면 됩니다. 
 */
package net.javajigi.board.dao;

import java.sql.SQLException;
import java.util.List;

import net.javajigi.board.model.Board;

import org.hibernate.HibernateException;
import org.hibernate.Query;
import org.hibernate.Session;
import org.springframework.dao.DataAccessException;
import org.springframework.orm.ObjectRetrievalFailureException;
import org.springframework.orm.hibernate3.HibernateCallback;
import org.springframework.orm.hibernate3.support.HibernateDaoSupport;

public class BoardDAOHibernate extends HibernateDaoSupport implements BoardDAO {

	public Board insert(Board board) throws DataAccessException {
		getHibernateTemplate().save(board);

		return board;
	}

	public Board update(Board board) throws DataAccessException {
		getHibernateTemplate().update(board);

		return board;
	}

	public int delete(int boardNo) throws DataAccessException {
		getHibernateTemplate().delete(findBoard(boardNo));

		return 1;
	}

	public Board findBoard(int boardNo) throws DataAccessException {
		Board board = (Board) getHibernateTemplate().get(Board.class,
				new Integer(boardNo));
		if (board == null) {
			throw new ObjectRetrievalFailureException(Board.class, new Integer(
					boardNo));
		}

		return board;
	}

	public List findBoardList(final int currentPage, final int countPerPage)
			throws DataAccessException {
		return (List) getHibernateTemplate().execute(new HibernateCallback() {
			public Object doInHibernate(Session session)
					throws HibernateException, SQLException {
				Query query = session
						.createQuery("from Board board order by board.createDate");
				int start = (currentPage - 1) * countPerPage;
				query.setFirstResult(start);
				query.setMaxResults(countPerPage);

				return query.list();
			}
		});
	}

	public int updateHitCount(int boardNo) throws DataAccessException {
		Board board = (Board) getHibernateTemplate().get(Board.class,
				new Integer(boardNo));
		if (board != null) {
			board.setHitCount(board.getHitCount() + 1);
		}

		getHibernateTemplate().update(board);

		return 1;
	}

	public int getTotalNo() throws DataAccessException {
		List resultList = getHibernateTemplate().find(
				"SELECT count(board) FROM Board board");
		Integer totalNo = (Integer) resultList.get(0);

		return totalNo.intValue();
	}
}