registerimpl.java

野蔷薇论坛源码 java 自己看看吧。 学习用

/* 
 * Created on 2007-2-10
 * Last modified on 2007-11-3
 * Powered by YeQiangWei.com
 */
package com.yeqiangwei.club.dao.hibernate.impl;

import java.util.List;

import org.hibernate.HibernateException;

import com.yeqiangwei.club.dao.RegisterDAO;
import com.yeqiangwei.club.dao.hibernate.support.HibernateFacade;
import com.yeqiangwei.club.dao.hibernate.support.HibernateProvider;
import com.yeqiangwei.club.dao.model.Register;
import com.yeqiangwei.club.exception.DAOException;
import com.yeqiangwei.club.param.RegisterParameter;

public class RegisterImpl implements RegisterDAO {
	
	private static final String FIND_REGISTERID = "from Register where registerId=?";
	
	private static final String FIND_NUMBER = "from Register where registerNumber=? order by registerId desc";
	
	private static final String FIND_KEY = "from Register where registerKey=? order by registerId desc";
	
	private static final String FIND_KEY_NUMBER = "from Register where registerKey=? And registerNumber=? ";
	
	private static final String DELETE_REGISTERID = "delete from Register where registerId=?";
	
	private static final String DELETES_REGISTERID = "delete from Register where registerId in (:ids)";
	
	public static void main(String args[]){
		com.yeqiangwei.club.dao.hibernate.ConnectionManager.init();
		com.yeqiangwei.club.dao.hibernate.ConnectionManager.beginTransaction();
		com.yeqiangwei.club.dao.hibernate.ConnectionManager.commitTransaction();
		com.yeqiangwei.club.dao.hibernate.ConnectionManager.closeSession();
	}

	public void create(Register item) throws DAOException {
		HibernateProvider<Register> facade = new HibernateFacade<Register>();
		try{
			facade.save(item);
		}catch(HibernateException e){
			throw new DAOException(e);
		}
	}

	public void update(Register item) throws DAOException {
		HibernateProvider<Register> facade = new HibernateFacade<Register>();
		try{
			facade.update(item);
		}catch(HibernateException e){
			throw new DAOException(e);
		}
	}

	public int delete(Register item) throws DAOException {
    	HibernateProvider<Register> facade = new HibernateFacade<Register>();
		facade.createQuery(DELETE_REGISTERID);
		facade.setInt(0, item.getRegisterId());
		try{
			return facade.executeUpdate();
		}catch(HibernateException e){
			throw new DAOException(e);
		}
	}

	public int delete(List<Integer> ids) throws DAOException {
    	HibernateProvider<Register> facade = new HibernateFacade<Register>();
		facade.createQuery(DELETES_REGISTERID);
		facade.setParameterList("ids",ids);
		try{
			return facade.executeUpdate();
		}catch(HibernateException e){
			throw new DAOException(e);
		}
	}

	public Register findById(int id) {
		HibernateFacade<Register> facade = new HibernateFacade<Register>();
		facade.createQuery(FIND_REGISTERID);
		facade.setInt(0,id);
		return facade.uniqueResult();
	}

	public Register findByNumber(String number) {
		HibernateFacade<Register> facade = new HibernateFacade<Register>();
		facade.createQuery(FIND_NUMBER);
		facade.setString(0,number);
		facade.setMaxResults(1);
		return facade.uniqueResult();
	}
	
	public Register findByKey(String key) {
		HibernateFacade<Register> facade = new HibernateFacade<Register>();
		facade.createQuery(FIND_KEY);
		facade.setString(0,key);
		facade.setMaxResults(1);
		return facade.uniqueResult();
	}

	public Register findByKeyAndNumber(String key, String number) {
		HibernateFacade<Register> facade = new HibernateFacade<Register>();
		facade.createQuery(FIND_KEY_NUMBER);
		facade.setString(0,key);
		facade.setString(1,number);
		facade.setMaxResults(1);
		return  facade.uniqueResult();
	}
	
	public List<Register> findByParameter(RegisterParameter param) {
		StringBuffer hql = new StringBuffer();
		hql.append("from Register ");
		hql.append(" order by registerId desc ");
		HibernateFacade<Register> facade = new HibernateFacade<Register>();
		facade.createQuery(hql);
		facade.setFirstResult(param.getPagination().getStartRow());
		facade.setMaxResults(param.getPagination().getEndRow());
		return facade.executeQuery();
	}

	public long countByParameter(RegisterParameter param) {
		StringBuffer hql = new StringBuffer();
		hql.append("select count(registerId) from Register ");
		HibernateFacade<Register> facade = new HibernateFacade<Register>();
		facade.createQuery(hql);
		return facade.resultTotal();
	}

	public List<?> findAll(RegisterParameter param) {
		return null;
	}

	public long countAll(RegisterParameter param) {
		return 0;
	}
}