利用Java语言编写的学生通讯录管理系统

package bookstore.bean; import java.util.*; import java.sql.*; import bookstore.common.*; public class UserBean { private String userid; private String username; private String userpass; private String type; private java.util.Date birthday; private String sex; private String qq; private String phone; private String comment; private String email; private String local; private String address; private String managerid; private String managerpass; private String managertype; public String getUserid() { return userid; } public void setUserid(String userid) { this.userid = userid; } public String getUsername() { return username; } public void setUsername(String username) { this.username = username; } public String getUserpass() { return userpass; } public void setUserpass(String userpass) { this.userpass = userpass; } public String getType() { return type; } public void setType(String type) { this.type = type; } public java.util.Date getBirthday() { return birthday; } public void setBirthday(java.util.Date birthday) { this.birthday = birthday; } public String getSex() { return sex; } public void setSex(String sex) { this.sex = sex; } public String getQq() { return qq; } public void setQq(String qq) { this.qq = qq; } public String getPhone() { return phone; } public void setPhone(String phone) { this.phone = phone; } public String getComment() { return comment; } public void setComment(String comment) { this.comment = comment; } public String getEmail() { return email; } public void setEmail(String email) { this.email = email; } public String getLocal() { return local; } public void setLocal(String local) { this.local = local; } public String getAddress() { return address; } public void setAddress(String address) { this.address = address; } public String getmanagerid() { return managerid; } public void setmanagerid(String managerid) { this.managerid = managerid; } public String getmanagerpass() { return managerpass; } public void setmanagerpass(String managerpass) { this.managerpass = managerpass; } public String getmanagertype() { return managertype; } public void setmanagertype(String managertype) { this.managertype = managertype; } // 添加用户 public void add() throws Exception { // 连接对象 Connection con=null; // 创建DBBean对象 DBBean db = new DBBean(); // 添加语句，根据参数编写动态的添加语句 StringBuffer sql = new StringBuffer(); sql.append("insert into usertable values('"); sql.append(userid); // 用户ID sql.append("','"); sql.append(username); // 用户名 sql.append("','"); sql.append(userpass); // 口令 sql.append("','"); sql.append(sex); sql.append("','"); sql.append(type); sql.append("','"); sql.append(phone); sql.append("','"); sql.append(qq); sql.append("','"); sql.append(email); sql.append("','"); sql.append(new java.sql.Date(birthday.getTime())); // 生日 sql.append("','"); sql.append(local); sql.append("','"); sql.append(address); sql.append("','"); sql.append(comment); // 备注 sql.append("')"); try { // 获取连接 con = db.getConnection(); // 执行插入语句 db.executeUpdate(sql.toString()); }catch(Exception e) { System.out.println(e.toString()); } finally { db.close(); } } //根据主键查询用户 public UserBean findUserById(String userid) { boolean find=false; // 连接对象 Connection con=null; // 结果集对象 ResultSet rs=null; // 创建DBBean对象 DBBean db = new DBBean(); // 查询语句 StringBuffer sql = new StringBuffer(); sql.append("select * from usertable where userid='"); sql.append(userid); sql.append("'"); try { // 获取连接 con = db.getConnection(); // 执行select语句，返回结果集对象 rs=db.executeQuery(sql.toString()); // 指向结果集的第一条 if(rs.next()){ // 获取结果集中的信息 String tmpUserid=rs.getString(1); String tmpUsername=rs.getString(2); String tmpUserpass=rs.getString(3); String tmpSex=rs.getString(4); String tmpType=rs.getString(5); String tmpPhone=rs.getString(6); String tmpQq=rs.getString(7); String tmpEmail=rs.getString(8); java.util.Date tmpBirthday=rs.getDate(9); String tmpLocal=rs.getString(10); String tmpAddress=rs.getString(11); String tmpComment=rs.getString(12); // 创建用户对象 UserBean user = new UserBean(); // 根据获取的用户信息初始化用户对象 user.setUserid(tmpUserid); user.setUsername(tmpUsername); user.setUserpass(tmpUserpass); user.setType(tmpType); user.setBirthday(tmpBirthday); user.setSex(tmpSex); user.setQq(tmpQq); user.setPhone(tmpPhone); user.setAddress(tmpAddress); user.setEmail(tmpEmail); user.setLocal(tmpLocal); user.setComment(tmpComment); return user; } }catch(Exception e) { System.out.println(e.toString()); } finally { db.close(); } // 返回查找的结果 return null; } public UserBean findUsername(String username) { boolean find=false; // 连接对象 Connection con=null; // 结果集对象 ResultSet rs=null; // 创建DBBean对象 DBBean db = new DBBean(); // 查询语句 StringBuffer sql = new StringBuffer(); sql.append("select * from usertable where username='"); sql.append(username); sql.append("'"); try { // 获取连接 con = db.getConnection(); // 执行select语句，返回结果集对象 rs=db.executeQuery(sql.toString()); // 指向结果集的第一条 if(rs.next()){ // 获取结果集中的信息 String tmpUserid=rs.getString(1); String tmpUsername=rs.getString(2); String tmpUserpass=rs.getString(3); String tmpSex=rs.getString(4); String tmpType=rs.getString(5); String tmpPhone=rs.getString(6); String tmpQq=rs.getString(7); String tmpEmail=rs.getString(8); java.util.Date tmpBirthday=rs.getDate(9); String tmpLocal=rs.getString(10); String tmpAddress=rs.getString(11); String tmpComment=rs.getString(12); // 创建用户对象 UserBean user = new UserBean(); // 根据获取的用户信息初始化用户对象 user.setUserid(tmpUserid); user.setUsername(tmpUsername); user.setUserpass(tmpUserpass); user.setType(tmpType); user.setBirthday(tmpBirthday); user.setSex(tmpSex); user.setQq(tmpQq); user.setPhone(tmpPhone); user.setAddress(tmpAddress); user.setEmail(tmpEmail); user.setLocal(tmpLocal); user.setComment(tmpComment); return user; } }catch(Exception e) {