userserviceimpl.java

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

package com.chinatelecom.service.impl;

import java.util.Iterator;
import java.util.List;
import java.util.Set;

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.TDept;
import com.chinatelecom.mode.TPcroom;
import com.chinatelecom.mode.TUser;
import com.chinatelecom.service.IUserService;

/**
 * 人员管理模块
 * 
 * @author Administrator
 * 
 */
public class UserServiceImpl extends HibernateDaoSupport implements
		IUserService {
	/**
	 * 查找人员列表(包括分页)
	 */
	public List findAllUsers(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.getNamedQuery("findAllUsers");
		q.setFirstResult(startPage);
		q.setMaxResults(ROWS_PER_PAGE);
		List list = q.list();
		if (session.isOpen()) {
			session.close();
		}
		return list;
	}

	/**
	 * 查找人员列表
	 */
	public List findUserList() {
		// TODO Auto-generated method stub
		HibernateTemplate ht = this.getHibernateTemplate();
		return ht.findByNamedQuery("findAllUsers");
	}

	private static int ROWS_PER_PAGE = 4;

	/**
	 * 得到总页数
	 */
	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 int getTotalCounts() {
		// TODO Auto-generated method stub
		List list = this.getHibernateTemplate().find("from TUser");
		return list.size();
	}

	/**
	 * 新增人员
	 */
	public void addUser(TUser user) {
		// TODO Auto-generated method stub
		this.getHibernateTemplate().save(user);
	}

	/**
	 * deleteUser方法
	 * 
	 * 删除人员
	 * 
	 */
	public void deleteUser(String[] str) {
		// TODO Auto-generated method stub
		for (int i = 0; i < str.length; i++) {
			HibernateTemplate ht = this.getHibernateTemplate();
			TUser user = (TUser) ht.get(TUser.class, str[i]);
			Set set = user.getTDepts();
			Iterator it = set.iterator();
			while (it.hasNext()) {
				TDept dept = (TDept) it.next();
				it.remove();
			}
			// System.out.println(user.getTPcrooms());
			Set roomset = user.getTPcrooms();
			Iterator roomit = roomset.iterator();
			while (roomit.hasNext()) {
				TPcroom room = (TPcroom) roomit.next();
				roomit.remove();
			}
			ht.delete(user);
		}
	}

	public TUser findUserById(String userId) {
		// TODO Auto-generated method stub
		// HibernateTemplate ht = this.getHibernateTemplate();
		// TUser user = (TUser)ht.get(TUser.class, userId);
		Session session = this.getSession();
		Query q = session.createQuery("from TUser t where t.userId = ?");
		q.setParameter(0, userId);
		List list = q.list();
		if (list.size() == 0) {
			return null;
		}
		TUser user = (TUser) list.get(0);
		if (session.isOpen()) {
			session.close();
		}
		return user;
	}

	public List findListByStr(String str, String userName) {
		// TODO Auto-generated method stub

		if (!"".equals(userName)) {
			str += " and t.userName like ?";
			Session session = this.getSession();
			Query q = session.createQuery(str);
			userName = "%" + userName + "%";
			q.setParameter(0, userName);
			List list = q.list();
			if(session.isOpen()){
				session.close();
			}
			return list;
		} else {
			return this.getHibernateTemplate().find(str);
		}
	}

	public List findUserListroom(Long l) {
		// TODO Auto-generated method stub
		HibernateTemplate ht = this.getHibernateTemplate();
		List list = ht.find("from TUser t where t.TDept.deptId=" + l);
		return list;
	}

	public void updateUser(TUser user) {
		// TODO Auto-generated method stub
		HibernateTemplate ht = this.getHibernateTemplate();
		ht.update(user);
	}

	public List findManager() {
		// TODO Auto-generated method stub
		HibernateTemplate ht = this.getHibernateTemplate();
		List list = ht.find("from TUser t where t.userType='M'");
		return list;
	}
}