classesdaoimpl.java

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

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

import java.sql.SQLException;

import org.hibernate.HibernateException;
import org.hibernate.Query;
import org.hibernate.Session;
import org.springframework.orm.hibernate3.HibernateCallback;

import com.isoftstone.isscrmweb.web.mapping.Classesinfo;
import com.isoftstone.isscrmweb.web.mapping.Examinfo;

import org.pontifex.orm.hibernate3.DaoImpl;
import org.pontifex.orm.hibernate3.PageInfoQueryCallback;
import org.pontifex.web.mapping.PageInfo;

public class ClassesDaoImpl extends DaoImpl implements ClassesDao{

	public PageInfo getClassesList(final Classesinfo classesinfo) {
		return pageInfoLookup(classesinfo,new PageInfoQueryCallback(){

			public void doInPageInfoString(PageInfoBuffer hql) {
				hql.append(" select new Classesinfo(c.classesid as classesid , c.classescode as classescode ,wca.nodename as contextByaddress,wcc.nodename as contextBycourseid ,c.classessdate as classessdate ,c.classesedate as classesedate,c.classesstatus as classesstatus ,c.classesdes as classesdes)");
				hql.append(" from Classesinfo as c inner join c.wordbookByClassesaddress as wca inner join c.wordbookByClassescourseid as wcc where c.classesstatus <> 3 ");
				if(classesinfo.getClassescode() != null && classesinfo.getClassescode().length()>0){
					hql.append(" and c.classescode like :classescode ");
				}
				if(classesinfo.getContextBycourseid()!= null && classesinfo.getContextBycourseid().length()>0){
					System.out.println(classesinfo.getContextBycourseid());
					hql.append(" and wcc.wordid =:contextBycourseid ");
				}
				if(classesinfo.getContextByaddress() != null && classesinfo.getContextByaddress().length()>0){
					System.out.println(classesinfo.getContextByaddress());
					hql.append(" and wca.wordid =:contextByaddress ");
				}
				if(classesinfo.getClassesstatus()!=null && classesinfo.getClassesstatus().length()>0){
					hql.append(" and c.classesstatus =:classesstatus ");
				}
				if(classesinfo.getSdatefrom() != null){
					hql.append(" and c.classessdate >= :sdatefrom");
				}
				if(classesinfo.getSdateto() != null){
					hql.append(" and c.classessdate <= :sdateto");
				}
				if(classesinfo.getEdatefrom() != null ){
					hql.append(" and c.classesedate >= :edatefrom");
				}
				if(classesinfo.getEdateto() != null){
					hql.append(" and c.classesedate <= :edateto");
				}
				hql.append(" order by c.classessdate desc");
			}

			public void doInPageInfoValues(PageInfoMapValues values) {
				values.put("classescode", classesinfo.getClassescode(), PageInfoQueryCallback.LIKE);
				values.put("contextBycourseid", classesinfo.getContextBycourseid(), PageInfoQueryCallback.EQ);
				values.put("contextByaddress", classesinfo.getContextByaddress(), PageInfoQueryCallback.EQ);
				values.put("classesstatus", classesinfo.getClassesstatus(), PageInfoQueryCallback.EQ);
				values.put("sdatefrom", classesinfo.getSdatefrom());
				values.put("sdateto", classesinfo.getSdateto());
				values.put("edatefrom", classesinfo.getEdatefrom());
				values.put("edateto", classesinfo.getEdateto());
			}

			
		});
	}
	
	public Classesinfo getClassinfo(final Classesinfo classesinfo){
		return (Classesinfo) this.getHibernateTemplate().execute(new HibernateCallback(){

			public Object doInHibernate(Session session) throws HibernateException, SQLException {
				String sql = " select new Classesinfo(c.classesid as classesid , c.classescode as classescode ,wca.nodename as contextByaddress,wcc.nodename as contextBycourseid ,c.classessdate as classessdate ,c.classesedate as classesedate,c.classesstatus as classesstatus ,c.classesdes as classesdes)" +
							 " from Classesinfo as c inner join c.wordbookByClassesaddress as wca inner join c.wordbookByClassescourseid as wcc where c.classesstatus <> 3 " +
							 " and c.classesid=:classesid ";
				Query query = session.createQuery(sql);
				query.setString("classesid", classesinfo.getClassesid());
				return query.uniqueResult();
			}
			//,emi.empname as empnameByInvigilate,ems.empname as empnameBySchoolid
			//inner join e.empinfoByInvigilate as emi inner join e.empinfoBySchoolid as ems
		});
	}

}