serviceuserdaoimpl.java

电信计费项目 该系统在Sun Solaris下开发,运行于Apache Tomcat平台,采用J2EE架构

package com.tarena.netctoss.model.persist;

import java.util.List;
import com.tarena.util.*;
import org.hibernate.*;

import com.tarena.netctoss.model.biz.entity.*;

public class ServiceUserDAOImpl implements IServiceUserDAO {

	public void delete(Long service_user_id) throws UserException {
		Session session = HibernateFactoryManager.getSession();
		try {
			ServiceUser serviceUser = findByID(service_user_id);
			serviceUser.setUser(null);
			serviceUser.setPrice(null);
			session.delete(serviceUser);
		} catch (HibernateException e) {
			e.printStackTrace();
			throw new UserException("delete ServiceUser error");
		}
	}
	
	@SuppressWarnings("unchecked")
	public List<ServiceUser> findAll() throws UserException {
		List<ServiceUser> serviceUsers = null;
		Session session = HibernateFactoryManager.getSession();
		String hql ="from ServiceUser";
		try {
			Query q=session.createQuery(hql);
			serviceUsers = q.list();
		} catch (HibernateException e) {
			e.printStackTrace();
			throw new UserException("findAll ServiceUser error");
		}
		return serviceUsers;
	}
	
	public void insert(ServiceUser s_user) throws UserException {
		Session session = HibernateFactoryManager.getSession();
		try {
			session.saveOrUpdate(s_user);
		} catch (HibernateException e) {
			e.printStackTrace();
			throw new UserException("insert ServiceUser error");
		}
	}
	
	public void update(ServiceUser s_user) throws UserException {
		Session session = HibernateFactoryManager.getSession();
		try {
			session.saveOrUpdate(s_user);
		} catch (HibernateException e) {
			e.printStackTrace();
			throw new UserException("update ServiceUser error");
		}
	}
	
	public ServiceUser findByID(Long service_user_id) throws UserException{
		ServiceUser s_user = null;
		Session session = HibernateFactoryManager.getSession();
		String hql = "from ServiceUser s_user where s_user.service_user_id=?";
		try {
			Query q = session.createQuery(hql);
			q.setLong(0, service_user_id);
			s_user =(ServiceUser) q.uniqueResult();
		} catch (HibernateException e) {
			e.printStackTrace();
			throw new UserException("ServiceUser findByID is error");
		}
		return s_user;
	}
	
	@SuppressWarnings("unchecked")
	public List<ServiceUser> findByUser(User user) throws UserException{
		List<ServiceUser> serviceUsers = null;
		Session session = HibernateFactoryManager.getSession();
		String hql ="from ServiceUser s_user where s_user.user=?";
		try {
			Query q=session.createQuery(hql);
			q.setEntity(0, user);
			serviceUsers = q.list();
		} catch (HibernateException e) {
			e.printStackTrace();
			throw new UserException(" ServiceUser findByUser error");
		}
		return serviceUsers;
	}
	
	@SuppressWarnings("unchecked")
	public List<ServiceUser> findByUserID(Long user_id) throws UserException{
		List<ServiceUser> serviceUsers = null;
		Session session = HibernateFactoryManager.getSession();
		String hql ="from ServiceUser s_user where s_user.user.user_id=?";
		try {
			Query q=session.createQuery(hql);
			q.setLong(0, user_id);
			serviceUsers = q.list();
		} catch (HibernateException e) {
			e.printStackTrace();
			throw new UserException(" ServiceUserByID findByUser error");
		}
		return serviceUsers;
	}
}