onlineimpl.java

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

/* 
 * Created on 2005-12-1
 * Last modified on 2007-1-21
 * Powered by YeQiangWei.com
 */
package com.yeqiangwei.club.dao.hibernate.impl;

import java.util.List;

import com.yeqiangwei.club.dao.OnlineDAO;
import com.yeqiangwei.club.dao.hibernate.support.HibernateFacade;
import com.yeqiangwei.club.dao.model.Online;
import com.yeqiangwei.club.param.OnlineParameter;

/**
 * @author YeQiangWei by 我容易么我
 * Powered by YeQiangWei.com
 */
public class OnlineImpl implements OnlineDAO{
	
	private static final String FIND_ONLINEID = "from Online where onlineId=?";
	
	private static final String DELETES_ONLINEID = "delete from Online where onlineId in (:ids)";
	
	private static final String DELETE_ONLINEID = "delete from Online where onlineId=?";

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

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

	public int delete(Online item) {
		HibernateFacade<Online> facade = new HibernateFacade<Online>();
		facade.createQuery(DELETE_ONLINEID);
		facade.setLong(0,item.getOnlineId());
		int c = facade.executeUpdate();
		return c;
	}

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

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

	public List<Online> findByParameter(OnlineParameter param) {
		StringBuffer hql = new StringBuffer();
		hql.append("from Online where onlineId>0");
		if(param.getUserIp()!=null){
			hql.append(" and userIp=");
			hql.append(param.getUserIp().longValue());
		}
		HibernateFacade<Online> facade = new HibernateFacade<Online>();
		facade.createQuery(hql);
		facade.setFirstResult(param.getPagination().getStartRow());
		facade.setMaxResults(param.getPagination().getEndRow());
		List<Online> list = facade.executeQuery();
		return list;
	}

	public long countByParameter(OnlineParameter param) {
		StringBuffer hql = new StringBuffer();
		hql.append("select count(onlineId) from Online where onlineId>0 ");
		if(param.getUserIp()!=null){
			hql.append(" and userIp=");
			hql.append(param.getUserIp().longValue());
		}
		HibernateFacade<Online> facade = new HibernateFacade<Online>();
		facade.createQuery(hql);
		long c = facade.resultTotal();
		return c;
	}

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

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

}