JSP动态网站开发技术与实践光盘素材13-15

package com.chapter15; import java.util.*; import java.sql.*; import java.text.*; public class User extends ExecuteDB { //定义类成员变量 private long UserID; private String UserName; private String UserPassword; private String RealName; private long DepartmentID; private String Sex; private String Degree; private String BornDate; private String UserSN; private String Telephone; private String Mobile; private String Email; private String InDate; private String Intro; private String Role; private String strSql; //初始化类成员变量 public User() { this.UserID=0; this.UserName=""; this.UserPassword=""; this.RealName=""; this.DepartmentID=0; this.Sex=""; this.Degree=""; this.BornDate = ""; this.UserSN=""; this.Telephone=""; this.Mobile=""; this.Email=""; this.InDate= ""; this.Intro=""; this.Role="0"; this.strSql=""; } //向users数据表中添加一条新记录 public boolean add() { this.strSql="insert into users "; this.strSql=this.strSql + "("; this.strSql=this.strSql + "UserName,"; this.strSql=this.strSql + "UserPassword,"; this.strSql=this.strSql + "RealName,"; this.strSql=this.strSql + "DepartmentID,"; this.strSql=this.strSql + "Sex,"; this.strSql=this.strSql + "Degree,"; this.strSql=this.strSql + "BornDate,"; this.strSql=this.strSql + "UserSN,"; this.strSql=this.strSql + "Telephone,"; this.strSql=this.strSql + "Mobile,"; this.strSql=this.strSql + "Email,"; this.strSql=this.strSql + "InDate,"; this.strSql=this.strSql + "Intro,"; this.strSql=this.strSql + "Role"; this.strSql=this.strSql + ") "; this.strSql=this.strSql + "values("; this.strSql=this.strSql + "'" + this.UserName + "',"; this.strSql=this.strSql + "'" + this.UserPassword + "',"; this.strSql=this.strSql + "'" + this.RealName + "',"; this.strSql=this.strSql + "'" + this.DepartmentID + "',"; this.strSql=this.strSql + "'" + this.Sex + "',"; this.strSql=this.strSql + "'" + this.Degree + "',"; this.strSql=this.strSql + "'" + this.BornDate + "',"; this.strSql=this.strSql + "'" + this.UserSN + "',"; this.strSql=this.strSql + "'" + this.Telephone + "',"; this.strSql=this.strSql + "'" + this.Mobile + "',"; this.strSql=this.strSql + "'" + this.Email + "',"; this.strSql=this.strSql + "'" + this.InDate + "',"; this.strSql=this.strSql + "'" + this.Intro + "',"; this.strSql=this.strSql + "'" + this.Role + "'"; this.strSql=this.strSql + ")"; boolean isAdd = super.exeSql(this.strSql); return isAdd; } //修改UserID对应的用户的信息 public boolean modify_info() { this.strSql="update users set"; this.strSql=this.strSql + " RealName=" + "'" + this.RealName + "',"; this.strSql=this.strSql + " DepartmentID=" + "'" + this.DepartmentID + "',"; this.strSql=this.strSql + " Sex=" + "'" + this.Sex + "',"; this.strSql=this.strSql + " Degree=" + "'" + this.Degree + "',"; this.strSql=this.strSql + " BornDate=" + "'" + this.BornDate + "',"; this.strSql=this.strSql + " UserSN=" + "'" + this.UserSN + "',"; this.strSql=this.strSql + " Telephone=" + "'" + this.Telephone + "',"; this.strSql=this.strSql + " Mobile=" + "'" + this.Mobile + "',"; this.strSql=this.strSql + " Email=" + "'" + this.Email + "',"; this.strSql=this.strSql + " InDate=" + "'" + this.InDate + "',"; this.strSql=this.strSql + " Intro=" + "'" + this.Intro + "'"; this.strSql=this.strSql + " where UserID='" + this.UserID + "'"; boolean isUpdate = super.exeSql(this.strSql); return isUpdate; } //修改UserID对应的用户的密码 public boolean modify_UserPassword() { this.strSql="update users set "; this.strSql=this.strSql + "UserPassword=" + "'" + this.UserPassword + "'"; this.strSql=this.strSql + " where UserID='" + this.UserID + "'"; boolean isUpdatekey = super.exeSql(this.strSql); return isUpdatekey; } //验证用户名和密码是否正确 public boolean valid() { this.strSql="select UserID,UserName,Role from `users` "; this.strSql=this.strSql + " where UserName='" + this.UserName + "'"; this.strSql=this.strSql + " and UserPassword='"+ this.UserPassword + "'"; try { ResultSet rs = super.exeQuery(this.strSql); if (rs.next()) { this.UserID=rs.getLong("UserID"); this.UserName=rs.getString("UserName"); this.Role = rs.getString("Role"); return true; } else { return false; } } catch(Exception e) { return false; } } //判断用户名是否存在 public boolean exist() { this.strSql="select * from users "; this.strSql=this.strSql + " where UserName='" + this.UserName + "'"; try { ResultSet rs = super.exeQuery(this.strSql); if (rs.next()) { return true; } else { return false; } } catch(Exception e) { return false; } } //获取类成员变量UserID对应的用户信息 public boolean init() { this.strSql="select * from users where UserID="; this.strSql=this.strSql + this.UserID; try { ResultSet rs = super.exeQuery(this.strSql); if (rs.next()) { this.UserID=rs.getLong("UserID"); this.UserName=rs.getString("UserName"); this.UserPassword=rs.getString("UserPassword"); this.RealName=rs.getString("RealName"); this.DepartmentID=rs.getLong("DepartmentID"); this.Sex=rs.getString("Sex"); this.Degree=rs.getString("Degree"); this.BornDate=rs.getString("BornDate"); this.UserSN=rs.getString("UserSN"); this.Telephone=rs.getString("Telephone"); this.Mobile=rs.getString("Mobile"); this.Email=rs.getString("Email"); this.InDate=rs.getString("InDate"); this.Intro=rs.getString("Intro"); this.Role=rs.getString("Role"); return true; } else { return false; } } catch(Exception ex) { return false; } } //获取类UserName对应的用户信息 public boolean init_byUserName() { this.strSql="select * from users where UserName like "; this.strSql=this.strSql + "'" + this.UserName + "'"; try { ResultSet rs = super.exeQuery(this.strSql); if (rs.next()) { this.UserID=rs.getLong("UserID"); this.UserName=rs.getString("UserName"); this.UserPassword=rs.getString("UserPassword"); this.RealName=rs.getString("RealName"); this.DepartmentID=rs.getLong("DepartmentID"); this.Sex=rs.getString("Sex"); this.Degree=rs.getString("Degree"); this.BornDate=rs.getString("BornDate"); this.UserSN=rs.getString("UserSN"); this.Telephone=rs.getString("Telephone"); this.Mobile=rs.getString("Mobile"); this.Email=rs.getString("Email"); this.InDate=rs.getString("InDate"); this.Intro=rs.getString("Intro"); this.Role=rs.getString("Role"); return true; } else { return false; } } catch(Exception ex) { return false; } } //获取成员变量DepartmentID对应的部门的所有人员信息，返回一个ResultSet类型对象 public ResultSet show_department_users() { this.strSql="select * from users where DepartmentID ="+this.DepartmentID; ResultSet rs = null; try { rs = super.exeQuery(this.strSql); } catch(Exception e) { System.out.println(e.toString()); } return rs; } //获取所有人员信息，返回一个ResultSet类型对象 public ResultSet show_users() { this.strSql="select UserID,UserName,RealName,DepartmentID,UserSN from users where Role = 0 order by UserSN desc"; ResultSet rs = null; try { rs = super.exeQuery(this.strSql); } catch(Exception e) { System.out.println