areaimpl.java

详细的建站源码 详细的建站源码 详细的建站源码 详细的建站源码

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

import java.util.List;

import com.yeqiangwei.club.dao.AreaDAO;
import com.yeqiangwei.club.dao.hibernate.support.HibernateFacade;
import com.yeqiangwei.club.dao.model.Area;
import com.yeqiangwei.club.param.AreaParameter;

public class AreaImpl implements AreaDAO {
	
	private static final String FIND_AREAID = "from Area where areaId=?";
	
	private static final String DELETE_AREAID = "delete from Area where areaId=?";
	
	private static final String DELETES_AREAID = "delete from Area where areaId in(:ids)";

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

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

	public int delete(Area item) {
    	HibernateFacade<Area> facade = new HibernateFacade<Area>();
		facade.createQuery(DELETE_AREAID);
		facade.setInt(0, item.getAreaId());
		int c = facade.executeUpdate();
		return c;
	}

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

	public Area findById(int id) {
    	HibernateFacade<Area> facade = new HibernateFacade<Area>();
		facade.createQuery(FIND_AREAID);
		facade.setCacheable(true);
		Area item = facade.uniqueResult();
		return item;
	}

	public List<Area> findByParameter(AreaParameter param) {
		StringBuffer hql = new StringBuffer();
		hql.append("from Area order by orderList desc, areaId");
    	HibernateFacade<Area> facade = new HibernateFacade<Area>();
		facade.createQuery(hql);
		facade.setFirstResult(param.getPagination().getStartRow());
		facade.setMaxResults(param.getPagination().getEndRow());
		facade.setCacheable(true);
		List<Area> list = facade.executeQuery();
		return list;
	}

	public long countByParameter(AreaParameter param) {
		StringBuffer hql = new StringBuffer();
		hql.append("select count(areaId) from Area");
    	HibernateFacade<Area> facade = new HibernateFacade<Area>();
		facade.createQuery(hql);
		facade.setCacheable(true);
		long c = facade.resultTotal();
		return c;
	}

	public List<Area> findAll(AreaParameter param) {
		StringBuffer hql = new StringBuffer();
		hql.append("from Area order by orderList desc, areaId");
    	HibernateFacade<Area> facade = new HibernateFacade<Area>();
		facade.createQuery(hql);
		facade.setFirstResult(param.getPagination().getStartRow());
		facade.setMaxResults(param.getPagination().getEndRow());
		List<Area> list = facade.executeQuery();
		return list;
	}

	public long countAll(AreaParameter param) {
		StringBuffer hql = new StringBuffer();
		hql.append("select count(areaId) from Area");
    	HibernateFacade<Area> facade = new HibernateFacade<Area>();
		facade.createQuery(hql);
		long c = facade.resultTotal();
		return c;
	}

}