📄 user.java
字号:
/**
* Title pams
* @author: dzc
* Company: hust
* Copyright: Copyright (c) 2005
* @version 1.0
* Date : 2005-05-11
* User encapsulation
* Filename:User.java
**/
package pams.user;
import pams.database.DBConnect;
import pams.system.*;
import pams.util.*;
import java.sql.*;
import java.util.*;
public class User {
public String UserName, Password, Status, FullName, DeptName,
GroupName;
public java.sql.Date EffectiveDate, ExpiryDate, PwdModifyDate;
public int LoginFailCount;
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;
}
public String getStatus()
{
return Status;
}
public void setStatus(String s)
{
this.Status = s;
}
public String getFullName()
{
return FullName;
}
public void setFullName(String s)
{
this.FullName = s;
}
public String getDeptName()
{
return DeptName;
}
public void setDeptName(String s)
{
this.DeptName = s;
}
public String getGroupName()
{
return GroupName;
}
public void setGroupName(String s)
{
this.GroupName = s;
}
public String getEffectiveDate()
{
if (this.EffectiveDate != null)
return DataConvert.sqlDateToStr(EffectiveDate);
else
return "";
}
public void setEffectiveDate(String strBir)
{
if (strBir != null)
this.EffectiveDate = DataConvert.StrTosqlDate(strBir);
else
this.EffectiveDate = null;
}
public String getExpiryDate()
{
if (this.ExpiryDate != null)
return DataConvert.sqlDateToStr(ExpiryDate);
else
return "";
}
public void setExpiryDate(String strBir)
{
if (strBir != null)
this.ExpiryDate = DataConvert.StrTosqlDate(strBir);
else
this.ExpiryDate = null;
}
public String getPwdModifyDate()
{
if (this.PwdModifyDate != null)
return DataConvert.sqlDateToStr(PwdModifyDate);
else
return "";
}
public void setPwdModifyDate(String strBir)
{
if (strBir != null)
this.PwdModifyDate = DataConvert.StrTosqlDate(strBir);
else
this.PwdModifyDate = null;
}
public String getLoginFailCount()
{
return DataConvert.IntToStr(LoginFailCount);
}
public void setLoginFailCount(int i)
{
this.LoginFailCount = i;
}
/*
* 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"));
user.setEffectiveDate(rs.getString("EffectiveDate"));
user.setExpiryDate(rs.getString("ExpiryDate"));
user.setStatus(rs.getString("Status"));
user.setFullName(rs.getString("FullName"));
user.setDeptName(rs.getString("DeptName"));
user.setGroupName(rs.getString("GroupName"));
user.setPwdModifyDate(rs.getString("PwdModifyDate"));
user.setLoginFailCount(rs.getInt("LoginFailCount"));
}
else
{
user = null;
}
}
catch (Exception e)
{
System.err.println(e);
}
finally
{
try
{
dbc.close();
}
catch (Exception e)
{
e.printStackTrace();
user = null;
}
}
return user;
}
/*
* Add User
*/
public static String Add(String _UserName, String _Password, String _EffectiveDate,
String _ExpiryDate, String _Status,
String _FullName, String _DeptName,String _GroupName,
String _UserName2)
{
DBConnect dbc = null;
try
{
dbc = new DBConnect();
dbc.prepareStatement("INSERT INTO Users (UserName,Password,EffectiveDate,ExpiryDate,Status,FullName,DeptName,PwdModifyDate,LoginFailCount,GroupName) VALUES ( ?,?,?,?,?,?,?,?,?,?)");
dbc.setString(1, _UserName);
dbc.setString(2, _Password);
dbc.setDate(3, DataConvert.StrTosqlDate(_EffectiveDate));
dbc.setDate(4, DataConvert.StrTosqlDate(_ExpiryDate));
dbc.setString(5, _Status);
dbc.setString(6, _FullName);
dbc.setString(7, _DeptName);
dbc.setDate(8, DataConvert.StrTosqlDate(DataConvert.getStringDate()));
dbc.setInt(9, 0);
dbc.setString(10, _GroupName);
dbc.executeUpdate();
Log.Add(_UserName2, "Users", "Add");
dbc.close();
return "1";
}
catch (Exception e)
{
System.err.println(e);
return e.toString();
}
}
/*
* Modify User
*/
public static String Modify(String _UserName, String _EffectiveDate,
String _ExpiryDate,String _Status,
String _FullName, String _DeptName,String _GroupName,
String _UserName2)
{
DBConnect dbc = null;
try
{
dbc = new DBConnect();
dbc.prepareStatement("UPDATE Users SET EffectiveDate=?,ExpiryDate=?,Status=?,FullName=?,DeptName=?,GroupName=? WHERE UserName=?");
dbc.setDate(1, DataConvert.StrTosqlDate(_EffectiveDate));
dbc.setDate(2, DataConvert.StrTosqlDate(_ExpiryDate));
dbc.setString(3, _Status);
dbc.setString(4, _FullName);
dbc.setString(5, _DeptName);
dbc.setString(6, _GroupName);
dbc.setString(7, _UserName);
dbc.executeUpdate();
Log.Add(_UserName2, "Users", "Modify");
dbc.close();
return "1";
}
catch (Exception e)
{
e.printStackTrace();
return e.toString();
}
}
/*
* Delete User
*/
public static String Delete(String _UserName, String _UserName2)
{
try
{
DBConnect dbc = new DBConnect();
dbc.prepareStatement("DELETE FROM Users WHERE UserName=?");
dbc.setString(1, _UserName);
dbc.executeUpdate();
Log.Add(_UserName, "Users", "Delete");
dbc.close();
return "1";
}
catch (Exception e)
{
e.printStackTrace();
return e.toString();
}
}
/*
* the User exists?
*/
public static boolean IsExist(String _UserName) throws Exception
{
DBConnect dbc = null;
boolean IsExist = false;
try
{
dbc = new DBConnect();
dbc.prepareStatement("SELECT * FROM Users WHERE UserName = ?");
dbc.setString(1, _UserName);
ResultSet rs = dbc.executeQuery();
if (!rs.next())
{
IsExist = false;
}
else
{
IsExist = true;
}
}
catch (Exception e)
{
System.err.println(e);
}
finally
{
try
{
dbc.close();
}
catch (Exception e)
{
e.printStackTrace();
}
}
return IsExist;
}
/*
* Check Login
*/
public static boolean ChkLogin(String _UserName, String _Password)
throws Exception
{
DBConnect dbc = null;
boolean IsExist = false;
try
{
dbc = new DBConnect();
dbc.prepareStatement("SELECT Password FROM Users WHERE UserName=? AND Password=?");
dbc.setString(1, _UserName);
dbc.setString(2, _Password);
ResultSet rs = dbc.executeQuery();
if (rs.next())
{
IsExist = true;
}
}
catch (Exception e)
{
System.err.println(e);
}
finally
{
try
{
dbc.close();
}
catch (Exception e)
{
e.printStackTrace();
}
}
return IsExist;
}
/*
* List All Admin
*/
public static Vector ListAllAdmin()
{
DBConnect dbc = null;
Vector UserVector = new Vector();
try
{
dbc = new DBConnect();
dbc.prepareStatement("SELECT * FROM Users WHERE GroupName='setup' OR GroupName='confirm' ORDER BY UserName ASC");
ResultSet rs = dbc.executeQuery();
while (rs.next())
{
User user = new User();
user.setUserName(rs.getString("UserName"));
user.setPassword(rs.getString("Password"));
user.setEffectiveDate(rs.getString("EffectiveDate"));
user.setExpiryDate(rs.getString("ExpiryDate"));
user.setStatus(rs.getString("Status"));
user.setFullName(rs.getString("FullName"));
user.setDeptName(rs.getString("DeptName"));
user.setPwdModifyDate(rs.getString("PwdModifyDate"));
user.setLoginFailCount(rs.getInt("LoginFailCount"));
user.setGroupName(rs.getString("GroupName"));
UserVector.add(user);
}
}
catch (Exception e)
{
System.err.println("error:" + e);
}
finally
{
try
{
dbc.close();
}
catch (Exception e)
{
e.printStackTrace();
}
}
return UserVector;
}
/*
* List All User
*/
public static Vector ListAllUser()
{
DBConnect dbc = null;
Vector UserVector = new Vector();
try
{
dbc = new DBConnect();
dbc.prepareStatement("SELECT * FROM Users WHERE GroupName='normal' ORDER BY UserName ASC");
ResultSet rs = dbc.executeQuery();
while (rs.next())
{
User user = new User();
user.setUserName(rs.getString("UserName"));
user.setPassword(rs.getString("Password"));
user.setEffectiveDate(rs.getString("EffectiveDate"));
user.setExpiryDate(rs.getString("ExpiryDate"));
user.setStatus(rs.getString("Status"));
user.setFullName(rs.getString("FullName"));
user.setDeptName(rs.getString("DeptName"));
user.setPwdModifyDate(rs.getString("PwdModifyDate"));
user.setLoginFailCount(rs.getInt("LoginFailCount"));
user.setGroupName(rs.getString("GroupName"));
UserVector.add(user);
}
}
catch (Exception e)
{
System.err.println("error:" + e);
}
finally
{
try
{
dbc.close();
}
catch (Exception e)
{
e.printStackTrace();
}
}
return UserVector;
}
public static Vector ListLockDelUser()
{
DBConnect dbc = null;
Vector UserVector = new Vector();
try
{
dbc = new DBConnect();
dbc.prepareStatement("SELECT * FROM Users WHERE Status='Lock' OR Status='Delete' ORDER BY UserName ASC");
ResultSet rs = dbc.executeQuery();
while (rs.next())
{
User user = new User();
user.setUserName(rs.getString("UserName"));
user.setPassword(rs.getString("Password"));
user.setEffectiveDate(rs.getString("EffectiveDate"));
user.setExpiryDate(rs.getString("ExpiryDate"));
user.setStatus(rs.getString("Status"));
user.setFullName(rs.getString("FullName"));
user.setDeptName(rs.getString("DeptName"));
user.setPwdModifyDate(rs.getString("PwdModifyDate"));
user.setLoginFailCount(rs.getInt("LoginFailCount"));
user.setGroupName(rs.getString("GroupName"));
UserVector.add(user);
}
}
catch (Exception e)
{
System.err.println("error:" + e);
}
finally
{
try
{
dbc.close();
}
catch (Exception e)
{
e.printStackTrace();
}
}
return UserVector;
}
/*
* UnLock User
*/
public static String UnLock(String _UserName,String _UserName2)
{
DBConnect dbc = null;
try
{
dbc = new DBConnect();
User user = User.FindByName(_UserName);
String strSQL;
if ((user.getStatus()).equals("Lock"))
{
strSQL = "UPDATE Users SET Status='Normal',LoginFailCount=0 WHERE UserName=?";
dbc.prepareStatement(strSQL);
dbc.setString(1, _UserName);
dbc.executeUpdate();
Log.Add(_UserName2, "Users", "Modify");
}
else if ((user.getStatus()).equals("Delete"))
{
strSQL = "DELETE FROM Users WHERE Status='Delete' AND UserName=?";
dbc.prepareStatement(strSQL);
dbc.setString(1, _UserName);
dbc.executeUpdate();
Log.Add(_UserName2, "Users", "Modify");
}
dbc.close();
return "1";
}
catch (Exception e)
{
e.printStackTrace();
return e.toString();
}
}
/*
* Modify Password
*/
public static String ModifyPassword(String _UserName, String _NewPassword)
{
DBConnect dbc = null;
try
{
dbc = new DBConnect();
dbc.prepareStatement("UPDATE Users SET Password=?,PwdModifyDate=? WHERE UserName=?");
dbc.setString(1, _NewPassword);
dbc.setDate(2, DataConvert.StrTosqlDate(DataConvert.getStringDate()));
dbc.setString(3, _UserName);
dbc.executeUpdate();
Log.Add(_UserName, "Users", "Modify");
dbc.close();
return "1";
}
catch (Exception e)
{
e.printStackTrace();
return e.toString();
}
}
/*
* Increase LoginFailCount
*/
public static String IncreaseLoginFailCount(String _UserName)
{
DBConnect dbc = null;
try
{
dbc = new DBConnect();
dbc.prepareStatement("UPDATE Users SET LoginFailCount=LoginFailCount+1 WHERE UserName=?");
dbc.setString(1, _UserName);
dbc.executeUpdate();
Log.Add(_UserName, "Users", "Modify");
dbc.close();
return "1";
}
catch (Exception e)
{
e.printStackTrace();
return e.toString();
}
}
/*
* Reset LoginFailCount
*/
public static String ResetLoginFailCount(String _UserName)
{
DBConnect dbc = null;
try
{
dbc = new DBConnect();
dbc.prepareStatement("UPDATE Users SET LoginFailCount=0 WHERE UserName=?");
dbc.setString(1, _UserName);
dbc.executeUpdate();
Log.Add(_UserName, "Users", "Modify");
dbc.close();
return "1";
}
catch (Exception e)
{
e.printStackTrace();
return e.toString();
}
}
/*
* Lock User
*/
public static String Lock(String _UserName)
{
DBConnect dbc = null;
try
{
dbc = new DBConnect();
dbc.prepareStatement("UPDATE Users SET Status='Lock' WHERE UserName=?");
dbc.setString(1, _UserName);
dbc.executeUpdate();
Log.Add(_UserName, "Users", "Modify");
dbc.close();
return "1";
}
catch (Exception e)
{
e.printStackTrace();
return e.toString();
}
}
/*
* the User is effective?
*/
public static boolean IsNotEffective(String _UserName) throws Exception
{
DBConnect dbc = null;
boolean IsExist = false;
try
{
dbc = new DBConnect();
dbc.prepareStatement("SELECT * FROM Users WHERE UserName=? AND EffectiveDate>?");
dbc.setString(1, _UserName);
dbc.setString(2, DataConvert.getStringDate());
ResultSet rs = dbc.executeQuery();
if (!rs.next())
{
IsExist = false;
}
else
{
IsExist = true;
}
}
catch (Exception e)
{
System.err.println(e);
}
finally
{
try
{
dbc.close();
}
catch (Exception e)
{
e.printStackTrace();
}
}
return IsExist;
}
/*
* the User is Expire?
*/
public static boolean IsExpire(String _UserName) throws Exception
{
DBConnect dbc = null;
boolean IsExist = false;
try
{
dbc = new DBConnect();
dbc.prepareStatement("SELECT * FROM Users WHERE UserName=? AND ExpiryDate<?");
dbc.setString(1, _UserName);
dbc.setString(2, DataConvert.getStringDate());
ResultSet rs = dbc.executeQuery();
if (!rs.next())
{
IsExist = false;
}
else
{
IsExist = true;
}
}
catch (Exception e)
{
System.err.println(e);
}
finally
{
try
{
dbc.close();
}
catch (Exception e)
{
e.printStackTrace();
}
}
return IsExist;
}
}⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -