javaweb实现简单个人信息管理系统

package user; import java.sql.Connection; import java.sql.PreparedStatement; import java.sql.ResultSet; public class userdao { /*根据用户名查找密码*/ public user findusername(String username){ dbutil dbutil1=new dbutil(); Connection con=dbutil1.getconnection(); PreparedStatement stmt=null; ResultSet set=null; String sql="select * from userinformation where username=?"; user user=new user(); try{ stmt=con.prepareStatement(sql); stmt.setString(1, username); set=stmt.executeQuery(); while(set.next()){ user.setUsername(set.getString("username")); user.setPassword(set.getString("password")); } }catch (Exception e){ e.printStackTrace(); } return user; } /* 判断是否注册成功*/ public int register(user user) { dbutil dbutil1=new dbutil(); Connection con=dbutil1.getconnection(); PreparedStatement stmt=null; int res=0; String sql="insert into userinformation values(?,?,?,?,?,?,?,?,?,?)"; try { stmt=con.prepareStatement(sql); stmt.setString(1,user.getUsername()); stmt.setString(2, user.getPassword()); stmt.setString(3, user.getName()); stmt.setString(4, user.getSex()); stmt.setString(5, user.getEdu()); stmt.setString(6, user.getNation()); stmt.setString(7, user.getWork()); stmt.setString(8, user.getPhone()); stmt.setString(9, user.getPlace()); stmt.setString(10, user.getEmail()); res=stmt.executeUpdate(); }catch(Exception e) { e.printStackTrace(); } return res; } /* 修改信息*/ public int updatemessage(user user) { dbutil dbutil1=new dbutil(); Connection con=dbutil1.getconnection(); PreparedStatement stmt=null; int res=0; String sql="update userinformation set name=?,sex=?,edu=?,nation=?,work=?,phone=?,place=?,email=? where username=?"; try { stmt=con.prepareStatement(sql); stmt.setString(1, user.getName()); stmt.setString(2, user.getSex()); stmt.setString(3, user.getEdu()); stmt.setString(4, user.getNation()); stmt.setString(5, user.getWork()); stmt.setString(6, user.getPhone()); stmt.setString(7, user.getPlace()); stmt.setString(8, user.getEmail()); stmt.setString(9, user.getUsername()); res=stmt.executeUpdate(); }catch(Exception e) { e.printStackTrace(); } return res; } /*修改密码*/ public int updatepassword(user user) { dbutil dbutil1=new dbutil(); Connection con=dbutil1.getconnection(); PreparedStatement stmt=null; int res=0; String sql="update userinformation set password=? where username=?"; try { stmt=con.prepareStatement(sql); stmt.setString(1, user.getPassword()); stmt.setString(2, user.getUsername()); res=stmt.executeUpdate(); }catch(Exception e) { e.printStackTrace(); } return res; } /* public static void main(String args[]) { user user=new user("wanjie666","56789","万福心","男","学生","汉族","学生","18879147069","江西省南昌市进贤县近乎佳苑","2196447160@qq.com"); System.out.print(new userdao().updatepassword(user)); } */ }