个人信息管理系统.docxVIP

个人信息管理系统 1、登录界面 代码实现 public Boolean login(User user) throws SQLException{ Connection con=DB.connection(); boolean temp=true; String sql=select * from user where userName=+user.getUserNa me()+; PreparedStatement ps=DB.prepar(sql, con); ResultSet rs=null; rs=ps.executeQuery(); if(rs.next()){ sql=select * from user where password=+user.getPassword()+; ps=DB.prepar(sql, con); rs=ps.executeQuery(); if(rs.next()){ temp=true; }else{ temp=false; } }else{ temp=false; } DB.Close(con); DB.Close(rs); return temp; } public String register(User user){ String temp=sucess; Connection con=DB.connection(); String sql=select * from user where userName=+user.getUserNa me()+; PreparedStatement ps1=DB.prepar(sql,con); ResultSet rs=null; try { rs=ps1.executeQuery(); if(rs.next()){ temp=error; } sql=insert into user values (?,?,?,?,?); PreparedStatement ps2=DB.prepar(sql, con); ps2.setString(1, user.getUserName()); ps2.setString(2, user.getPassword()); ps2.setString(3, user.getSex()); ps2.setString(4, user.getBirth()); ps2.setString(5, user.getPhone()); ps2.executeUpdate(); DB.Close(ps2); } catch (SQLException e1) { e1.printStackTrace(); } DB.Close(con); DB.Close(ps1); return temp; } 2、主页面 3、个人信息界面 代码实现： Xml: action name=gerenAdd class=gerenAction method=gerenAdd /action action name=gerenDel class=gerenAction method=gerenDel /action action name=gerenMana class=gerenAction method=gerenMana result name=success/admin/geren/gerenMana.jsp/result /action action name=gerenEditPre class=gerenAction method=gerenEditPre result name=success/admin/geren/gerenEditPre.jsp/result /action action name=gerenEdit class=gerenAction method=gerenEdit /action public String gerenMana() { String sql=from TXuyuan where xuyuanDel=no; List xuyuanList=xuyuanDAO.getHibernateTemplate().find(sql); Map request=(Map)ServletActionContext.getContext().get(request); request.put(xuyuanList, xuyuanList); return ActionSupport.SUCCESS; } 代码实现： public String gerenAdd() { TGeren geren=new TGeren(); geren.setGerenBianhao(gerenBian