user.java

帮助文档打开后可以阅读资源

/**
 *  Title  hrms
 *  @author: dzc
 *  Company: hust
 *  Copyright: Copyright (c) 2005
 *  @version 1.0
 *  Date  :   2006-04
 *  Filename:User.java
 **/

package hrms.user;
import hrms.database.DBConnect;
import java.sql.*;

public class User {

	public String UserName, Password;

	public User()
	{
	};
  
	public String getUserName() 
	{
		return UserName;
	}

	public void setUserName(String s) 
	{
		this.UserName = s;
	}

	public String getPassword() 
	{
		return Password;
	}

	public void setPassword(String s)
	{
		this.Password = s;
	}

	/*
	 * Find User by UserName
	 */
	public static User FindByName(String _UserName) 
	{
		DBConnect dbc = null;
		User user = new User();
		try {
			dbc = new DBConnect();
			dbc.prepareStatement("SELECT * FROM users WHERE UserName = ?");
			dbc.setString(1, _UserName);
			ResultSet rs = dbc.executeQuery();
			if (rs.next()) 
			{
				user.setUserName(rs.getString("UserName"));
				user.setPassword(rs.getString("Password"));
			}
			else 
			{
				user = null;
			}
		} 
		catch (Exception e) 
		{
			System.err.println(e);
		}
		finally 
		{
			try 
			{
				dbc.close();
			}
			catch (Exception e) 
			{
				e.printStackTrace();
				user = null;
			}
		}
		return user;

	}


	/*
	 * Check Login
	 */
	public static boolean ChkLogin(String _UserName, String _Password)
			throws Exception 
	{
		DBConnect dbc = null;
		boolean IsExist = false;
		try 
		{
			String EncPassword;
			dbc = new DBConnect();
			dbc.prepareStatement("SELECT Password FROM users WHERE UserName = ? ");
			dbc.setString(1, _UserName);
			ResultSet rs = dbc.executeQuery();
			if (!rs.next()) 
			{
				IsExist = false;
			}
			else 
			{
				if (_Password.equals(rs.getString("Password")))
					IsExist = true;
			}
		} 
		catch (Exception e)
		{
			System.err.println(e);
		}
		finally 
		{
			try 
			{
				dbc.close();
			} 
			catch (Exception e) 
			{
				e.printStackTrace();
			}
		}
		return IsExist;
	}
	
	/*
	 * Modify Password
	 */

	public static String ModifyPassword(String _UserName, String _NewPassword) 
	{
		DBConnect dbc = null;
		try 
		{
			dbc = new DBConnect();
			dbc.prepareStatement("UPDATE users SET Password=? WHERE UserName=?");
			dbc.setString(1, _NewPassword);
			dbc.setString(2, _UserName);
			dbc.executeUpdate();
			dbc.close();
			return "1";

		}
		catch (Exception e) 
		{
			e.printStackTrace();
			return e.toString();
		}
	}


}