wordbookdaoimpl.java

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

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

import java.sql.SQLException;
import java.util.List;

import org.hibernate.Criteria;
import org.hibernate.HibernateException;
import org.hibernate.Query;
import org.hibernate.Session;
import org.hibernate.criterion.Expression;
import org.hibernate.criterion.Order;
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.Wordbook;

public class WordBookDaoImpl extends DaoImpl implements WordBookDao {
	


	public List getAllAddress() {
		return this.getHibernateTemplate().find("from Wordbook as w where w.wordbook.wordid='1' and w.state='1' ");
	}

	public List getAllEngage() {
		return this.getHibernateTemplate().find("from Wordbook as w where w.wordbook.wordid='2' and w.state='1' ");
	}

	public List getAllIntentCourse() {
		return this.getHibernateTemplate().find("from Wordbook as w where w.wordbook.wordid='3' and w.state='1' ");
	}
	
	public List getAllDatailCourse() {
		return this.getHibernateTemplate().find("from Wordbook as w where w.wordbook.wordid='4' and w.state='1' ");
	}

	public List getAllDegree() {
		return this.getHibernateTemplate().find("from Wordbook as w where w.wordbook.wordid='5' and w.state='1' ");
	}

	public List getAllStudentSource() {
		return this.getHibernateTemplate().find("from Wordbook as w where w.wordbook.wordid='6' and w.state='1' ");
	}
	
	public List getAllCutStudent() {
		return this.getHibernateTemplate().find("from Wordbook as w where w.wordbook.wordid='7' and w.state='1' ");
	}
	
	public List getAllKnowPass() {
		return this.getHibernateTemplate().find("from Wordbook as w where w.wordbook.wordid='8' and w.state='1' ");
	}
	
	public List getAllIntent() {
		return this.getHibernateTemplate().find("from Wordbook as w where w.wordbook.wordid='9' and w.state='1' ");
	}

	public List getAllJob() {
		return this.getHibernateTemplate().find("from Wordbook as w where w.wordbook.wordid='10' and w.state='1' ");
	}

	public List getAllDept() {
		return this.getHibernateTemplate().find("from Wordbook as w where w.wordbook.wordid='11' and w.state='1' ");
	}

	

	
	
	/**
	 * 为字典树排序准备
	 */
	public List findAllWordBook() {
		return this.getHibernateTemplate().executeFind(new HibernateCallback(){

			public Object doInHibernate(Session session) throws HibernateException, SQLException {
				Criteria criteria = session.createCriteria(Wordbook.class);
				criteria.addOrder(Order.desc("wordtype")).addOrder(Order.asc("ordernumber"));
				return criteria.list();
			}
			
		});
	}

	/**
	 * 分页查询
	 */
	public PageInfo findWordBookByFatherid(final Wordbook word) {
		return pageInfoLookup(word,new PageInfoQueryCallback(){

			public void doInPageInfoString(PageInfoBuffer hql) {
				hql.append("select new Wordbook(w.wordid,w.nodename,w.remark,w.wordtype,w.ordernumber,w.state,ww.nodename) from Wordbook as w left outer join w.wordbook as ww ");
				if(word.getWordbook().getWordid().equals("0")){
					hql.append(" where ww.wordid is null ");
				}else{
					hql.append(" where ww.wordid=:wordid ");
				}
				if(word.getNodename()!=null&&!word.getNodename().equals("")){
					hql.append(" and w.nodename like :nodename ");
				}
				if(word.getState()!=null&&!word.getState().equals("")){
					hql.append(" and w.state=:state ");
				}
				hql.append(" order by w.wordtype,w.ordernumber ");
			}

			public void doInPageInfoValues(PageInfoMapValues values) {
				values.put("wordid", word.getWordbook().getWordid(),PageInfoQueryCallback.EQ);
				values.put("state", word.getState(),PageInfoQueryCallback.EQ);
				values.put("nodename", word.getNodename(),PageInfoQueryCallback.LIKE);	
			}
			
		});
	}

	/**
	 * 为添加做准备的系统字典的全部查询
	 */
	public List getAllFatherWordBook() {
		return this.getHibernateTemplate().executeFind(new HibernateCallback(){

			public Object doInHibernate(Session session) throws HibernateException, SQLException {
				Criteria criteria = session.createCriteria(Wordbook.class);
				criteria.add(Expression.eq("wordbook.wordid","0"));
				criteria.addOrder(Order.asc("ordernumber"));
				return criteria.list();
			}
			
		});
	}

	/**
	 *  根据主键查询指定字典
	 */
	public Wordbook getWordBook(String key) {
		return (Wordbook) this.getHibernateTemplate().get(Wordbook.class, key);
	}

	/**
	 * 查询是否存在同级下同名的字典
	 */
	public int getSameWordBook(final Wordbook wordbook) {
		return (Integer) this.getHibernateTemplate().execute(new HibernateCallback(){

			public Object doInHibernate(Session session) throws HibernateException, SQLException {
				Criteria criteria =session.createCriteria(Wordbook.class);
				criteria.add(Expression.eq("wordbook.wordid", wordbook.getWordbook().getWordid()));
				criteria.add(Expression.eq("nodename", wordbook.getNodename()));
				return criteria.setProjection(Projections.rowCount()).uniqueResult();
			}
		});
	}

	/**
	 * 保存
	 */
	public void save(Wordbook wordbook) {
		this.getHibernateTemplate().save(wordbook);
	}

	/**
	 * 为添加保存时的排序准备
	 */
	public int getWordOrderNumber(final Wordbook wordbook) {
		return (Integer) this.getHibernateTemplate().execute(new HibernateCallback(){

			public Object doInHibernate(Session session) throws HibernateException, SQLException {
				Criteria criteria =session.createCriteria(Wordbook.class);
				criteria.add(Expression.eq("wordbook.wordid", wordbook.getWordbook().getWordid()));
				return criteria.setProjection(Projections.rowCount()).uniqueResult();
			}
		});
	}

	/**
	 * 删除
	 */
	public void deleteWord(Wordbook wordbook) {
		this.getHibernateTemplate().delete(wordbook);
	}

	/**
	 * 字典状态的改变
	 */
	public void updateWordbookEnabled(final Wordbook wordbook) {
		this.getHibernateTemplate().execute(new HibernateCallback(){
			public Object doInHibernate(Session session) throws HibernateException, SQLException {
				Query query = session.createQuery("update Wordbook set state=:state where wordid=:wordid");
				query.setString("state", wordbook.getState());
				query.setString("wordid",wordbook.getWordid());				
				return query.executeUpdate();
			}
		});
	}

	/**
	 * 更新字典排顺序
	 */
	public void updateOrder(final Wordbook wordbook) {
		this.getHibernateTemplate().execute(new HibernateCallback(){
			public Object doInHibernate(Session session) throws HibernateException, SQLException {
				Query query = session.createQuery("update Wordbook set ordernumber=:ordernumber where wordid=:wordid");
				query.setLong("ordernumber", wordbook.getOrdernumber());
				query.setString("wordid",wordbook.getWordid());				
				return query.executeUpdate();
			}
		});
	}

	/**
	 * 是否存在同名的字典---用于更新
	 */
	public int getSameWord(final Wordbook word) {
		return (Integer)this.getHibernateTemplate().execute(new HibernateCallback(){

			public Object doInHibernate(Session session) throws HibernateException, SQLException {
				Criteria criteria = session.createCriteria(Wordbook.class);
				criteria.add(Expression.eq("wordbook.wordid", word.getWordbook().getWordid()));
				criteria.add(Expression.eq("nodename", word.getNodename()));
				criteria.add(Expression.not(Expression.eq("wordid", word.getWordid())));
				return criteria.setProjection(Projections.rowCount()).uniqueResult();
			}
			
		});
	}

	/**
	 * 字典更新主要方法
	 */
	public void updateWordbook(final Wordbook word) {
		Wordbook wordbook = (Wordbook) this.getHibernateTemplate().get(Wordbook.class, word.getWordid());
		wordbook.setWordbook(word.getWordbook());
		wordbook.setNodename(word.getNodename());
		wordbook.setState(word.getState());
		wordbook.setRemark(word.getRemark());
	}
}