datadictionarydaoimpl.java

CRM源码CRM源码CRM源码CRM源码CRM源码CRM源码

package com.bjsxt.crm.dao.hibernate.impl;

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

import org.hibernate.HibernateException;
import org.hibernate.Session;
import org.springframework.orm.hibernate3.HibernateCallback;
import org.springframework.orm.hibernate3.support.HibernateDaoSupport;

import com.bjsxt.crm.dao.DataDictionaryDAO;
import com.bjsxt.crm.model.DataDictionary;

public class DataDictionaryDAOImpl extends HibernateDaoSupport implements
		DataDictionaryDAO {

	public void delete(DataDictionary customer) {
		getHibernateTemplate().delete(customer);
	}

	public List findByCategory(String category) {
		return getHibernateTemplate().find("from DataDictionary d where d.category = ?",category);
	}

	public DataDictionary findByCategoryAndCode(final String category, final String code) {
		return 
			(DataDictionary)getHibernateTemplate().execute(new HibernateCallback(){

				public Object doInHibernate(Session session) throws HibernateException, SQLException {
					return session
						.createQuery("from DataDictionary d where d.category = ? and d.code = ?")
						.setParameter(0, category)
						.setParameter(1, code)
						.uniqueResult();
				}
				
			});
	}

	public DataDictionary findById(int dataDictionaryId) {
		return (DataDictionary)getHibernateTemplate().load(DataDictionary.class, dataDictionaryId);
	}

	public String findText(final String category, final String code) {
		return 
			(String)getHibernateTemplate().execute(new HibernateCallback(){

			public Object doInHibernate(Session session) throws HibernateException, SQLException {
				return session
					.createQuery("select d.text from DataDictionary d where d.category = ? and d.code = ?")
					.setParameter(0, category)
					.setParameter(1, code)
					.uniqueResult();
			}
			
		});
	}

	public void save(DataDictionary dataDictionary) {
		getHibernateTemplate().save(dataDictionary);
	}

	public void update(DataDictionary dataDictionary) {
		getHibernateTemplate().update(dataDictionary);
	}

}