adminimpl.java

这是一款最新的野蔷薇论坛源码,有需要的朋友可以尽情下载

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

import java.util.List;

import com.yeqiangwei.club.dao.AdminDAO;
import com.yeqiangwei.club.dao.hibernate.support.HibernateFacade;
import com.yeqiangwei.club.dao.model.Admin;
import com.yeqiangwei.club.param.AdminParameter;

public class AdminImpl implements AdminDAO {
	
	private static final String FIND_USERNAME_PASSWORD = "from Admin where userName=? and password=?";
	
	private static final String FIND_USERNAME = "from Admin where userName=?";
	
	private static final String FIND_ADMINID = "from Admin where adminId=?";
	
	private static final String DELETE_ADMINID = "delete from Admin where adminId=?";
	
	private static final String DELETES_ADMINID = "delete from Admin where adminId in (:ids)";

	public Admin create(Admin item) {
		HibernateFacade<Admin> facade = new HibernateFacade<Admin>();
		item = facade.save(item);		
		return item;
	}

	public Admin update(Admin item) {
		HibernateFacade<Admin> facade = new HibernateFacade<Admin>();
		item = facade.update(item);		
		return item;
	}

	public int delete(Admin item) {
		HibernateFacade<Admin> facade = new HibernateFacade<Admin>();
		facade.createQuery(DELETE_ADMINID);
		facade.setInt(0, item.getAdminId());
		int c = facade.executeUpdate();
		return c;
	}

	public int delete(List ids) {
		HibernateFacade<Admin> facade = new HibernateFacade<Admin>();
		facade.createQuery(DELETES_ADMINID);
		facade.setParameterList("ids", ids);
		int c = facade.executeUpdate();
		return c;
	}

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

	public List<Admin> findByParameter(AdminParameter param){
		StringBuffer hql = new StringBuffer();
		hql.append("from Admin order by adminId desc ");
		HibernateFacade<Admin> facade = new HibernateFacade<Admin>();
		//facade.setFirstResult(param.getPagination().getStartRow());
		//facade.setMaxResults(param.getPagination().getPage());
		facade.createQuery(hql);
		List<Admin> list = facade.executeQuery();
		return list;
	}

	public Admin findByUserNameAndPassword(String userName, String password)
	{
		HibernateFacade<Admin> facade = new HibernateFacade<Admin>();
		facade.createQuery(FIND_USERNAME_PASSWORD);
		facade.setString(0,userName);
		facade.setString(1,password);
		facade.setMaxResults(1);
		Admin item = (Admin) facade.uniqueResult();
		return item;
	}

	public Admin findByUserName(String userName)
	{
		HibernateFacade<Admin> facade = new HibernateFacade<Admin>();
		facade.createQuery(FIND_USERNAME);
		facade.setString(0,userName);
		facade.setMaxResults(1);
		Admin item = facade.uniqueResult();
		return item;
	}
	
	public long countByParameter(AdminParameter param){
		StringBuffer hql = new StringBuffer();
		hql.append("select count(adminId) from Admin");
		HibernateFacade<Admin> facade = new HibernateFacade<Admin>();
		facade.createQuery(hql);
		long c = facade.resultTotal();
		return c;
	}

	public List findAll(AdminParameter param) {
		return null;
	}

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

}