信息系统开发实践-任务发布系统（TaskMS）（八）

JavaBeans的设计和实现

（五）User类和UserInfor类是和用户相关的两个类。User类是用于管理用户登录的类，UserInfor是关于用户个人信息的类。详情如下：

public class User {

public String UserName, Password, Unit;//用户名、密码、所属部门（单位）

public boolean IsAdmin;//是否管理员

/* 通过用户名确定用户 */

public static User FindByName(String _UserName){

DBConnect dbc = null;

User user = new User();

try {

dbc = new DBConnect();

dbc.prepareStatement("SELECT * FROM UserTable WHERE UserName = ?");

dbc.setString(1, _UserName);

ResultSet rs = dbc.executeQuery();

if (rs.next()){

user.setUserName(rs.getString("UserName"));

user.setPassword(rs.getString("Password"));

user.setIsAdmin(rs.getBoolean("IsAdmin"));

user.setUnit(rs.getString("Unit"));

}else

{user = null;}}

catch (Exception e)

{System.err.println(e);

}finally

{try

{dbc.close();

}catch (Exception e)

{e.printStackTrace();

user = null;

}}

return user;}

/*验证登录*/

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 UserTable 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;}

/*修改密码*/

public static String ModifyPassword(String _UserName, String _NewPassword)

{DBConnect dbc = null;

try

{

dbc = new DBConnect();

dbc.prepareStatement("UPDATE UserTable 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();}}

UserInfor类详情：

public class UserInfor {

public String Mobile,Name,Sex,Adress,School,Discipline,Depart;//手机号，姓名，性别，家庭住址，学校地址，专业，部门（单位）

public java.sql.Date Birthday,RegDate;//出生日期，注册日期

public int GetS,UseS,Ulevel;//获得的积分，使用的积分，用户级别

/*列出同一单位的人员列表*/

public static Vector ListByDepart(String _Depart) {

DBConnect dbc = null;

Vector UserInforVector = new Vector();

String strSQL = "SELECT * FROM UserInfor where Depart=? ORDER BY RegDate DESC";

try {

dbc = new DBConnect();

dbc.prepareStatement(strSQL);

dbc.setString(1, _Depart);

//dbc.setString(2, _Depart);

ResultSet rs = dbc.executeQuery();

while (rs.next()) {

UserInfor userInfor = new UserInfor();

userInfor.setMobile(rs.getString("Mobile"));

userInfor.setName(rs.getString("Name"));

userInfor.setSex(rs.getString("Sex"));

userInfor.setBirthday(rs.getString("Birthday"));

userInfor.setRegDate(rs.getString("RegDate"));

userInfor.setUlevel(rs.getInt("Ulevel"));

userInfor.setAdress(rs.getString("Adress"));

userInfor.setGetS(rs.getInt("GetS"));

userInfor.setUseS(rs.getInt("UseS"));

userInfor.setSchool(rs.getString("School"));

userInfor.setDiscipline(rs.getString("Discipline"));

userInfor.setDepart(rs.getString("Depart"));

UserInforVector.add(userInfor);

}} catch (Exception e) {

System.err.println(e);

} finally {

try {

dbc.close();

} catch (Exception e) {

e.printStackTrace();

}}

return UserInforVector;

}

/*更新用户级别*/

public static String UpdateUlevel(String _Mobile, int _Ulevel) {

DBConnect dbc = null;

try {

dbc = new DBConnect();

dbc.prepareStatement("UPDATE UserInfor SET Ulevel=? WHERE Mobile=?");

dbc.setInt(1, _Ulevel);

dbc.setString(2, _Mobile);

dbc.executeUpdate();

dbc.close();

return "1";

} catch (Exception e) {

e.printStackTrace();

return e.toString();

}}

/*更新用户得分*/

public static String UpdateGets(String _Mobile, int _Gets) {

DBConnect dbc = null;

try {

dbc = new DBConnect();

dbc.prepareStatement("UPDATE UserInfor SET Gets=? WHERE Mobile=?");

dbc.setInt(1, _Gets);

dbc.setString(2, _Mobile);

dbc.executeUpdate();

dbc.close();

return "1";

} catch (Exception e) {

e.printStackTrace();

return e.toString();

}}

/*更新用户使用得分*/

public static String UpdateUseS(String _Mobile, int _UseS) {

DBConnect dbc = null;

try {

dbc = new DBConnect();

dbc.prepareStatement("UPDATE UserInfor SET UseS=? WHERE Mobile=?");

dbc.setInt(1, _UseS);

dbc.setString(2, _Mobile);

dbc.executeUpdate();

dbc.close();

return "1";

} catch (Exception e) {

e.printStackTrace();

return e.toString();

}}

/* 增加积分明细 */

public static String AddS(String _UNO,String _Mobile, String _Sort, int _Score,String _GDate,String _Note) {

DBConnect dbc = null;

try {

dbc = new DBConnect();

dbc.prepareStatement("INSERT INTO GetS (UNO,Mobile,Sort,Score,GetDate,Note) VALUES (?,?,?,?,?,?)");

dbc.setString(1, _UNO);

dbc.setString(2, _Mobile);

dbc.setString(3, _Sort);

dbc.setInt(4, _Score);

dbc.setDate(5, DataConvert.StrTosqlDate(_GDate));

dbc.setString(6, _Note);

dbc.executeUpdate();

dbc.close();

return "1";

} catch (Exception e) {

System.err.println(e);

return e.toString();}}}