memberhibernatedao.java

这是基于spring +hibernate的项目

package com.pure.dao.hibernate;

import java.sql.SQLException;
import java.util.List;

import org.apache.commons.logging.Log;
import org.apache.commons.logging.LogFactory;
import org.hibernate.HibernateException;
import org.hibernate.Query;
import org.hibernate.Session;
import org.springframework.dao.DataAccessException;
import org.springframework.orm.hibernate3.HibernateCallback;

import com.pure.dao.MemberDAO;
import com.pure.domain.Member;
import com.pure.page.Page;

/**
 * 会员DAO接口实现类
 * 
 * @author pure
 * 
 */
public class MemberHibernateDAO extends BaseDao implements MemberDAO {
	protected final Log logger = LogFactory.getLog(getClass());

	public void insertMember(Member member) throws DataAccessException {
		this.getHibernateTemplate().save(member);
	}

	public void updateMember(Member member) throws DataAccessException {
		this.getHibernateTemplate().update(member);
	}

	public List getMemberList(final Page page) {
		return getHibernateTemplate().executeFind(new HibernateCallback() {
			public Object doInHibernate(Session s) throws HibernateException,
					SQLException {
				Query query = s.createQuery(page.getHql());
				query.setFirstResult(page.getStartRs());
				query.setMaxResults(page.getPerPage());
				List list = query.list();
				return list;

			}
		});
	}

	public Member getMember(final int id) {
		List dataList = this.getHibernateTemplate().find(
				"from Member websitemember where websitemember.id = ?",
				new Long(id));
		if (dataList.size() == 0) {
			return null;
		} else {
			return (Member) dataList.get(0);
		}
	}

	public Member getMember(final String username) {
		List dataList = this.getHibernateTemplate().find(
				"from Member websitemember where websitemember.username = ?",
				username);
		if (dataList.size() == 0) {
			return null;
		} else {
			return (Member) dataList.get(0);
		}
	}

	public void delMember(final int id) {
		getHibernateTemplate().executeFind(new HibernateCallback() {
			public Object doInHibernate(Session s) throws HibernateException,
					SQLException {
				// TODO 为什么有的地方不需要'From'也是正确的?而此处却要呢?
				Query query = s.createQuery("DELETE FROM Member WHERE id=:id");
				query.setInteger("id", id);
				query.executeUpdate();
				return null;
			}
		});
	}

	public Member login(Member member) {
		Object[] values = { member.getUsername(), member.getPassword() };
		List dataList = this
				.getHibernateTemplate()
				.find(
						"from Member websitemember where websitemember.username=? AND websitemember.password=?",
						values);
		if (dataList.size() == 0) {
			return null;
		} else {
			return (Member) dataList.get(0);
		}
	}

}