usermanager.java

jsp制作的一个信息管理系统源码,完整实用版

package user;

import java.io.*;
import java.sql.*;
import common.DBManager;

/**
 * Title:UserManager
 * Description:管理系统用户
 * Copyright: Copyright (c) 2002
 * Company:
 * @author pwbell
 * @version 1.0
 */

public class UserManager {
	
	public UserManager() {
		// default constructor
	}
	
	/**
	 *得到所有用户集合
	 */
	public ResultSet getUserSet() {
		
		return (new DBManager()).execQuery("select * from UserInfo order by tid asc");
	}
	
	public String getLoginName(int uid) {
		
		ResultSet rs = (new DBManager()).execQuery("select loginname from UserInfo where uid=" + uid);
		
		String loginname = null;
		try {
			if(rs != null && rs.next()) {
				loginname = rs.getString(1);
				rs.close();
			}
		} catch(SQLException ex) {
			System.err.println("UserManager.getUserLoginName():" + ex.getMessage());
		}
		return loginname;
	}
	
	public String getTrueName(int uid) {
		
		ResultSet rs = (new DBManager()).execQuery("select truename from UserInfo where uid=" + uid);
		
		String truename = null;
		try {
			if(rs != null && rs.next()) {
				truename = rs.getString(1);
				rs.close();
			}
		} catch(SQLException ex) {
			System.err.println("UserManager.getUserLoginName():" + ex.getMessage());
		}
		return truename;
	}	
	
	/**
	 *根据给定登陆名和密码得到该用户的类型
	 */
	public int getTID(int uid) {
		
		int     defaultType = 0;				
		ResultSet myResults = (new DBManager()).execQuery("select * from UserInfo where uid=" + uid);		
		
		
		try {
			if(myResults != null && myResults.next()) {
				defaultType = myResults.getInt("tid");
				myResults.close();
			}				
		} catch(SQLException ex) {
			System.err.print("UserManager.getUserType(): " + ex.getMessage());
		}				
		return defaultType;	
	}
	
	/**
	 *根据给定登陆名和密码得到该用户的ID
	 */
	public int getUID(String loginname, String password) {
		
		int     defaultID     = 0;
		String  queryString   = "select * from UserInfo " + 
							    "where " +
							    "(loginname='" + loginname + "')" +
							    " And (password='" + password + "')";
		DBManager myDBManager = new DBManager();
		ResultSet myResults   = myDBManager.execQuery(queryString);
		
			
		if(myResults != null) {
			try {
				if(myResults.next()) 
					defaultID = myResults.getInt("uid");
				myResults.close();
			} catch(SQLException ex) {
				System.err.print("UserManager.getUserType(): " + ex.getMessage());
			}
			
		}		
		myDBManager.closeManager();			
		return defaultID;	
	}
	
	/**
	 *得到系统用户数目
	 */
	public int getUserNum() {
	
		int usernum = 0;
		
		DBManager myDBManager = new DBManager();		
		String  myQueryString = "select count(*) from UserInfo";
		ResultSet 		   rs = myDBManager.execQuery(myQueryString);
		
		try {
			if(rs != null && rs.next()) {
				usernum = rs.getInt(1);
				rs.close();
			}
			myDBManager.closeManager();
		} catch(SQLException ex) {
			System.err.println("UserManger:getUserNum():" + ex.getMessage());
		}		
		return usernum;
	}
	
	
	/**
	 *得到系统用户id的最大值,
	 *主要用于增加系统用户时
	 *计算新用户的id号
	 */
	public int getMaxUID() {
		
		DBManager myDBManager = new DBManager();	
		String  myQueryString = "select max(uid) from UserInfo";
		ResultSet          rs = myDBManager.execQuery(myQueryString);
		
		int maxuserid = -1;
		
		try {
			if(rs != null && rs.next()) {
				maxuserid = rs.getInt(1);
				rs.close();
			}
			myDBManager.closeManager();
		} catch(SQLException ex) {
			System.err.println("UserManager.getMaxUserID : " + ex.getMessage());
		}		
		return maxuserid;
	}
	
	/**
	 *插入新用户
	 */
	public void insertNewUser(String loginname, String password, int tid, String truename) {

		DBManager myDBManager = new DBManager();		
		
		int uid = getMaxUID() + 1;		
					
		String myInsertString = "insert into UserInfo values("
								+ uid + ",'" + loginname + "','"
								+ password + "'," + tid 
								+ ",'" + truename + "')";	
		myDBManager.execInsert(myInsertString);
		myDBManager.closeManager();	 		
	}
	
	/**
	 *删除给定用户
	 */
	public void deleteUser(int uid) {
	
		DBManager myDBManager = new DBManager();
		String myDeleteString = "delete from UserInfo where uid=" + uid;
		
		myDBManager.execDelete(myDeleteString);
		myDBManager.closeManager();
	}
	
	/**
	 *查看给定用户是否存在
	 */
	public boolean isUserExisted(String loginname) {
		
		DBManager myDBManager = new DBManager();
		String  myQueryString = "select * from UserInfo where loginname='" + loginname + "'";
		ResultSet 		   rs = myDBManager.execQuery(myQueryString);
		//System.out.println(myQueryString);
		boolean flag = false;
		
		try {
			if(rs != null && rs.next())
			{
				flag = true;				
				rs.close();
			}
			myDBManager.closeManager();
		} catch(SQLException ex) {
			System.err.println("UserManger:getUserNum():" + ex.getMessage());
		}
		return flag;
	}	
	
	public static void main(String args[]) {
		
		UserManager userManager = new UserManager();
		System.out.println(userManager.getMaxUID());
		System.out.println(userManager.getTrueName(7));
		
		System.out.println(userManager.isUserExisted("pwbell"));
		System.out.println(userManager.getUserSet());
		userManager.insertNewUser("tt","tt",1,"tt");
	}		

}