diccontentserviceimpl.java

一个简单的用Spring+Hibernate+Struts的亿阳信通系统

package com.chinatelecom.service.impl;

import java.util.List;

import org.hibernate.Query;
import org.hibernate.Session;
import org.springframework.orm.hibernate3.HibernateTemplate;
import org.springframework.orm.hibernate3.support.HibernateDaoSupport;

import com.chinatelecom.mode.TDicContent;
import com.chinatelecom.service.IDicContentService;
/**
 * 字典内容的管理
 * @author 王晓翠
 *
 */
public class DicContentServiceImpl extends HibernateDaoSupport implements IDicContentService {
	
	private static int ROWS_PER_PAGE = 4;
	/**
	 * 得到记录的总条数
	 */
	public int getTotalCounts() {
		// TODO Auto-generated method stub
		HibernateTemplate ht = this.getHibernateTemplate();
		List list = ht.find("from TDicContent");
		return list.size();
	}
	/**
	 * 得到总页数
	 */
	public int getTotalPages() {
		// TODO Auto-generated method stub
		int count = this.getTotalCounts();
		// System.out.println("count" + count);
		if ((count % ROWS_PER_PAGE) == 0) {
			return count / ROWS_PER_PAGE;
		} else {
			return count / ROWS_PER_PAGE + 1;
		}
	}

	/**
	 * 新增字典
	 */
	public void addContent(TDicContent content) {
		// TODO Auto-generated method stub
		HibernateTemplate ht = this.getHibernateTemplate();
		ht.save(content);
	}
	/**
	 * 删除字典
	 */
	public void deleteContent(String[] str) {
		// TODO Auto-generated method stub
		for(int i = 0;i < str.length;i ++){
			HibernateTemplate ht = this.getHibernateTemplate();
			TDicContent content = (TDicContent)ht.get(TDicContent.class, Long.parseLong(str[i]));
			ht.delete(content);
		}
	}
	/**
	 * 得到字典列表
	 */
	public List findContent(int page) {
		// TODO Auto-generated method stub
		int startPage = (page - 1) * ROWS_PER_PAGE;
		HibernateTemplate ht = this.getHibernateTemplate();
		Session session = ht.getSessionFactory()
				.openSession();
		Query q = session.createQuery("from TDicContent");
		q.setFirstResult(startPage);
		q.setMaxResults(ROWS_PER_PAGE);
		List list = q.list();
		if(session.isOpen()){
			session.close();
		}
		return list;
	}
	/**
	 * 通过一定的条件来查询字典
	 */
	public List findContentByStr(String str, String dicName, String dicNote) {
		// TODO Auto-generated method stub
		Session session = this.getSession();
		Query q = null;
		if(!"".equals(dicName)){
			str += " and t.dicName like ?";
			dicName = "%" + dicName + "%";
			if(!"".equals(dicNote)){
				str += " and t.dicNote like ?";
				dicNote = "%" + dicNote + "%";
				q = session.createQuery(str);
				q.setParameter(0, dicName);
				q.setParameter(1, dicNote);
			}else{
				q = session.createQuery(str);
				q.setParameter(0, dicName);
			}
		}else{
			if(!"".equals(dicNote)){
				str += " and t.dicNote like ?";
				dicNote = "%" + dicNote + "%";
				q = session.createQuery(str);
				q.setParameter(0, dicNote);
			}else{
				q = session.createQuery(str);
			}
		}
		List list = q.list();
		if(session.isOpen()){
			session.close();
		}
		return list;
	}
	/**
	 * 更新字典
	 */
	public void updateContent(TDicContent content) {
		// TODO Auto-generated method stub
		HibernateTemplate ht = this.getHibernateTemplate();
		ht.update(content);
	}
	/**
	 * 通过id查找字典
	 */
	public TDicContent findContentById(long dicType) {
		// TODO Auto-generated method stub
		HibernateTemplate ht = this.getHibernateTemplate();
		TDicContent content = (TDicContent)ht.get(TDicContent.class, dicType);
		return content;
	}
	/**
	 * 通过字典类型查找字典列表
	 */
	public List findContentByList(Long dis) {
		HibernateTemplate ht = this.getHibernateTemplate();
		List list=ht.find("from TDicContent t where t.TDicType="+dis);
		return list;
	}

}