userservice.java

struts+hibernate做的一个用户注册管理系统

package com.user.service;



import java.util.ArrayList;
import java.util.List;

import org.hibernate.Query;
import org.hibernate.Session;
import org.hibernate.SessionFactory;
import org.hibernate.Transaction;
import org.hibernate.cfg.Configuration;

import com.user.hibernate.User;

public class UserService {
	List list = new ArrayList();

	/**
	 * 检查用户合法性和用户类别 并返回要跳转页面的参数
	 */
	public int checkUser(String userName, String UserPwd) {
		SessionFactory sf = new Configuration().configure()
				.buildSessionFactory();
		Session session = sf.openSession();
		String str = new String();
		int UserType;
		str = " from User as un where un.userId=:stuName and un.userPwd=:stuPassword";
		Query query = session.createQuery(str);
		query.setString("stuName", userName);
		query.setString("stuPassword", UserPwd);
		list = query.list();
		
		if (query.list().size() != 0) {
//			System.out.println("-------------");
			UserType = ((User) (query.list().get(0))).getUserType();
//			System.out.println(UserType);
//			System.out.println("成功登陆");
			return UserType;//登陆成功并返回用户类型
		} else {
//			System.out.println("0");
//			System.out.println("登陆失败");
			return 0; //登陆失败返回
		}
	}

		/**
		 * 检查用户名是否存在
		 */
		public boolean checkUserName(String userName) {
			boolean haveName;
			SessionFactory sf = new Configuration().configure()
					.buildSessionFactory();
			Session session = sf.openSession();
			String str = new String();
			str = " from User as un where un.userId=:stuName";
			Query query = session.createQuery(str);
			query.setString("stuName", userName);
			list = query.list();
			
			if (query.list().size() != 0) {
				haveName = true;
			} else {
				haveName = false;
			}
			return haveName;
		}
		
	/**
	 * 
	 * 添加注册一个新用户
	 */
	public void insertUser(User user){
		SessionFactory sf = new Configuration().configure()
		.buildSessionFactory();
		Session session = sf.openSession();
		Transaction tx = session.beginTransaction();
		session.save(user);
		tx.commit();
		session.close();
	}
	
	/**
	 * 显示用户信息
	 */
	public List getUser(){
		return list;
	}
	
	/**
	 * 
	 * 修改用户信息
	 */
	public void editUser(User user){
		SessionFactory sf = new Configuration().configure()
		.buildSessionFactory();
		Session session = sf.openSession();
		Transaction tx = session.beginTransaction();
		session.update(user);
		tx.commit();
		session.close();
	}
	/**
	 * 
	 * 查找一个用户信息
	 */
	public User getOneUser(String userId){
		String sql = new String();
		sql = " from User as un where un.userId=:stuName";
		SessionFactory sf = new Configuration().configure()
		.buildSessionFactory();
		Session session = sf.openSession();
		Query query = session.createQuery(sql);
		query.setString("stuName", userId);
		User user = (User) query.list().get(0);
		session.close();
		return user;
	}
	/**
	 * 
	 * 查找所有用户信息
	 */
	public List listUser(){
		String sql = new String();
		sql = " from User as un where un.userType=1";
		SessionFactory sf = new Configuration().configure()
		.buildSessionFactory();
		Session session = sf.openSession();
		Query query = session.createQuery(sql);
		List listUser = query.list();
		session.close();
		return listUser;
	}
	/**
	 * 批量删除选择的用户
	 * @param delUserId
	 */
	public List delUser(String [] delUserId){
		SessionFactory sf = new Configuration().configure()
		.buildSessionFactory();
		Session session = sf.openSession();
		Transaction tx = session.beginTransaction();
		
		for(int i=0;i<delUserId.length;i++){
			User user = (User)session.get(User.class, delUserId[i]);
			session.delete(user);
		}
		tx.commit();
		session.close();
		List listUser = listUser();
		return listUser;
	}
}