examdaoimpl.java

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

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

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.Examinfo;
import com.isoftstone.isscrmweb.web.mapping.Exampoint;

import org.pontifex.orm.hibernate3.DaoImpl;
import org.pontifex.orm.hibernate3.PageInfoQueryCallback;
import org.pontifex.web.mapping.PageInfo;
import com.isoftstone.isscrmweb.web.mapping.Userinfo;

public class ExamDaoImpl extends DaoImpl implements ExamDao {
	public PageInfo getExamList(final Examinfo examInfo){
		return pageInfoLookup(examInfo,new PageInfoQueryCallback(){
			
			public void doInPageInfoString(PageInfoBuffer hql) {
				hql.append(" select new Examinfo(e.examid as examid,ek.kindname as kindname,c.classescode as classescode,e.examtime as examtime,e.state as state) ");
				hql.append(" from Examinfo as e inner join e.classesinfo as c inner join e.examkind as ek where e.state <> 2 ");
				if(examInfo.getClassescode()!=null && examInfo.getClassescode().length()>0){
					hql.append(" and c.classescode like :classescode");
				}
				if(examInfo.getKindname()!=null && examInfo.getKindname().length() >0){
					hql.append(" and ek.kindname like :kindname");
				}
				if(examInfo.getState()!=null && examInfo.getState().length() >0){
					hql.append(" and e.state =:state");
				}
				if(examInfo.getDate_form()!=null){
					hql.append(" and e.examtime >= :time_from");
				}
				if(examInfo.getDate_to()!=null){
					hql.append(" and e.examtime <= :time_to");
				}
				hql.append(" order by e.examtime desc");
			}
			
			public void doInPageInfoValues(PageInfoMapValues values) {
				values.put("classescode", examInfo.getClassescode(), PageInfoQueryCallback.LIKE);
				values.put("kindname", examInfo.getKindname(), PageInfoQueryCallback.LIKE);
				values.put("state", examInfo.getState(), PageInfoQueryCallback.EQ);
				values.put("time_from", examInfo.getDate_form());
				values.put("time_to", examInfo.getDate_to());
			}

		});
	}
	
	public Examinfo getExam(final Examinfo examInfo){
		return (Examinfo) this.getHibernateTemplate().execute(new HibernateCallback(){

			public Object doInHibernate(Session session) throws HibernateException, SQLException {
				String sql = " select new Examinfo(e.examid as examid,ek.kindname as kindname,c.classescode as classescode,e.examtime as examtime,e.state as state,emi.empname as empnameByInvigilate,ems.empname as empnameBySchoolid) " +
						" from Examinfo as e inner join e.classesinfo as c inner join e.examkind as ek inner join e.empinfoByInvigilate as emi inner join e.empinfoBySchoolid as ems " +
						" where e.examid=:examid ";
				Query query = session.createQuery(sql);
				query.setString("examid", examInfo.getExamid());
				return query.uniqueResult();
			}
			//,emi.empname as empnameByInvigilate,ems.empname as empnameBySchoolid
			//inner join e.empinfoByInvigilate as emi inner join e.empinfoBySchoolid as ems
		});
	}
	
	public void saveExam(Examinfo examinfo){
		this.getHibernateTemplate().save(examinfo);
	}
	
	public void updateExam(Examinfo examinfo){
		this.getHibernateTemplate().update(examinfo);
	}
	
	public void savePoint(Exampoint exampoint){
		this.getHibernateTemplate().save(exampoint);
	}
}