empinfodaoimpl.java

这是一个用java三层框架做的ISS学员管理系统

package com.isoftstone.isscrmweb.web.dao.user;

import java.sql.SQLException;

import org.hibernate.HibernateException;
import org.hibernate.Session;
import org.hibernate.criterion.Expression;
import org.hibernate.criterion.Projections;
import org.pontifex.orm.hibernate3.DaoImpl;
import org.pontifex.orm.hibernate3.PageInfoQueryCallback;
import org.pontifex.web.mapping.PageInfo;
import org.springframework.orm.hibernate3.HibernateCallback;

import com.isoftstone.isscrmweb.web.mapping.Empinfo;

public class EmpInfoDaoImpl extends DaoImpl implements EmpInfoDao {

	public int findEmpByID(final Empinfo empInfo) {
		return (Integer) this.getHibernateTemplate().execute(new HibernateCallback() {
					public Object doInHibernate(Session session)
							throws HibernateException, SQLException {
						return session.createCriteria(Empinfo.class).add(
								Expression.eq("empcode", empInfo.getEmpcode()))
								.setProjection(Projections.rowCount())
								.uniqueResult();
					}
				});

	}

	public void saveEmpInfo(Empinfo empInfo) {
		this.getHibernateTemplate().save(empInfo);
	}

	public PageInfo getEmpList(final Empinfo empinfo) {
		return pageInfoLookup(empinfo ,new PageInfoQueryCallback(){

			public void doInPageInfoString(PageInfoBuffer hql) {
				hql.append(" select new Empinfo(e.empid, wbw.wordid,wbw.nodename, wbdr.wordid ,wbdr.nodename, wbdt.wordid, wbdt.nodename, wbj.wordid ,wbj.nodename");
				hql.append(" ,e.empcode, e.empname, e.empsex, e.empbirth, e.emphometown, e.emptel, e.empemail, e.empresume, e.empaddress, e.status) ");
				hql.append(" from Empinfo as e inner join e.wordbookByWorkid as wbw inner join e.wordbookByDegreeid as wbdr inner join e.wordbookByDeptid as wbdt inner join e.wordbookByJobid as wbj ");
				hql.dynamicMatchWhere();
				hql.isNotEmpty(empinfo.getEmpcode(),"e.empcode like :empcode");
				hql.isNotEmpty(empinfo.getEmpname(),"e.empname like :empname");
				hql.isNotEmpty(empinfo.getStatus(),"e.status = :status");
				hql.isNotEmpty(empinfo.getWordbookByDeptid().getWordid(), "wbdt.wordid = :deptid");
				hql.isNotEmpty(empinfo.getWordbookByWorkid().getWordid(), "wbw.wordid = :addressid");
				hql.append(" order by e.empid ");
			}

			public void doInPageInfoValues(PageInfoMapValues values) {
				values.put("empcode", empinfo.getEmpcode(),PageInfoQueryCallback.LIKE);
				values.put("empname", empinfo.getEmpname(),PageInfoQueryCallback.LIKE);
				values.put("status", empinfo.getStatus(),PageInfoQueryCallback.EQ);
				values.put("deptid", empinfo.getWordbookByDeptid().getWordid(),PageInfoQueryCallback.EQ);
				values.put("addressid", empinfo.getWordbookByWorkid().getWordid(),PageInfoQueryCallback.EQ);
			}
			
		});
	}

	public Empinfo getDetailEmpinfo(final String empid) {
		
		return (Empinfo) this.getHibernateTemplate().execute(new HibernateCallback(){

			public Object doInHibernate(Session session) throws HibernateException, SQLException {
				StringBuffer hql = new StringBuffer();
				hql.append(" select new Empinfo(e.empid, wbw.wordid,wbw.nodename, wbdr.wordid ,wbdr.nodename, wbdt.wordid, wbdt.nodename, wbj.wordid ,wbj.nodename");
				hql.append(" ,e.empcode, e.empname, e.empsex, e.empbirth, e.emphometown, e.emptel, e.empemail, e.empresume, e.empaddress, e.status) ");
				hql.append(" from Empinfo as e inner join e.wordbookByWorkid as wbw inner join e.wordbookByDegreeid as wbdr inner join e.wordbookByDeptid as wbdt inner join e.wordbookByJobid as wbj ");
				hql.append(" where e.empid=:empid ");		
				return session.createQuery(hql.toString()).setString("empid", empid).uniqueResult();
			}
			
		});
	}


}