groupimpl.java

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

/* 
 * Created on 2007-2-23
 * 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.GroupDAO;
import com.yeqiangwei.club.dao.hibernate.support.HibernateFacade;
import com.yeqiangwei.club.dao.hibernate.support.HibernateProvider;
import com.yeqiangwei.club.dao.model.Group;
import com.yeqiangwei.club.exception.DAOException;
import com.yeqiangwei.club.param.GroupParameter;

public class GroupImpl implements GroupDAO {
	
	private static final String UPDATE_REGISTERDEFAULTNOID = "update com.yeqiangwei.club.dao.model.Group set registerDefault=? where groupId<>?";
	
	private static final String UPDATE_GUESTDEFAULTNOID = "update com.yeqiangwei.club.dao.model.Group set guestDefault=? where groupId<>?";
	
	private static final String FIND_GROUPID = "from com.yeqiangwei.club.dao.model.Group where groupId=?";
	
	private static final String DELETE_GROUPID = "delete from com.yeqiangwei.club.dao.model.Group where groupId=?";
	
	private static final String DELETES_GROUPID = "delete from com.yeqiangwei.club.dao.model.Group where groupId in (:ids)";
	
	private static final String FIND_GUESTDEFAULT = "from com.yeqiangwei.club.dao.model.Group where guestDefault=?";
	
	private static final String FIND_REGISTERDEFAULT = "from com.yeqiangwei.club.dao.model.Group where registerDefault=?";

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

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

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

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

	public Group findById(int id) {
        HibernateProvider<Group> facade = new HibernateFacade<Group>();
        facade.createQuery(FIND_GROUPID);
        facade.setInt(0, id);
        facade.setMaxResults(1);
        return facade.uniqueResult();
	}

	public List<Group> findByParameter(GroupParameter param) {
		StringBuffer hql = new StringBuffer();
		hql.append("from Group order by groupId asc");
		HibernateProvider<Group> facade = new HibernateFacade<Group>();
		facade.createQuery(hql.toString());
		return facade.executeQuery();
	}

	public long countByParameter(GroupParameter param) {
		StringBuffer hql = new StringBuffer();
		hql.append("select count(groupId) from Group ");
		HibernateProvider<Group> facade = new HibernateFacade<Group>();
    	facade.createQuery(hql);
		return facade.resultTotal();
	}

	public List<Group> findAll(GroupParameter param) {
		StringBuffer hql = new StringBuffer();
		hql.append("from Group");
		HibernateProvider<Group> facade = new HibernateFacade<Group>();
    	facade.createQuery(hql);
		return facade.executeQuery();  
	}

	public long countAll(GroupParameter param) {
		StringBuffer hql = new StringBuffer();
		hql.append("select count(groupId) from Group ");
		HibernateProvider<Group> facade = new HibernateFacade<Group>();
    	facade.createQuery(hql);
		return facade.resultTotal();
	}

	public int updateRegisterDefaultNoId(int groupId, boolean registerDefault) throws DAOException {
		HibernateProvider<Group> facade = new HibernateFacade<Group>();
    	facade.createQuery(UPDATE_REGISTERDEFAULTNOID);
    	facade.setBoolean(0, registerDefault);
    	facade.setInt(1,groupId);
		try{
			return facade.executeUpdate();
		}catch(HibernateException e){
			throw new DAOException(e);
		}
	}

	public int updateGuestDefaultNoId(int groupId, boolean guestDefault) throws DAOException {
		HibernateProvider<Group> facade = new HibernateFacade<Group>();
    	facade.createQuery(UPDATE_GUESTDEFAULTNOID);
    	facade.setBoolean(0, guestDefault);
    	facade.setInt(1,groupId);
		try{
			return facade.executeUpdate();
		}catch(HibernateException e){
			throw new DAOException(e);
		}
	}

	public Group findByGuestDefault() {
        HibernateProvider<Group> facade = new HibernateFacade<Group>();
        facade.createQuery(FIND_GUESTDEFAULT);
        facade.setBoolean(0,true);
        facade.setMaxResults(1);
        return facade.uniqueResult();
	}

	public Group findByRegisterDefault() {
        HibernateProvider<Group> facade = new HibernateFacade<Group>();
        facade.createQuery(FIND_REGISTERDEFAULT);
        facade.setBoolean(0,true);
        facade.setMaxResults(1);
        return facade.uniqueResult();
	}
	
	/*
	public static void main(String args[]){
		com.yeqiangwei.club.dao.hibernate.ConnectionManager.init();
		GroupImpl i = new GroupImpl();
		i.updateGuestDefaultNoId(7,false);
	}
	*/
	
}