Java用户管理程序

〃用户管理程序//系统界面import java.sql.*;import java.util.*;public classTest public static voidmainString[]args{Scannersc=new ScannerSystem.in;Userinfo UInfo=new Userlnfo;UserlnfoDao UInfoDao=new UserInfoDao;whiletrue{欢迎使用用System.out.println；户管理程序请输入用户名;System.out.print Stringname=sc.next;；请输入密码System.ot/t.print Stringpassword=sc.next;Ulnfo.SNamename;UInfo.SPasswordpassword;if UInfoDao.CheckUInfo.GNameO.,UInfo.GPassword==true{System,ot/t.print In;录成功}finally{ConnectionDb.CLoseConnconnps,rs;}return list;//验证账号密码public booleanCheckString Name,String Password{二boolean flagfalse;Connection conn=null;PreparedStatement ps=null;ResultSet rs=null;try{conn=ConnectionDb•Conn;String sql=[userName]^[userPassword]Jps=conn.prepareStatementsql;rs=ps•executeQuery;whilers.next{ifName.equalsrs.getStringlPassword.equalsrs.getString2{flag=true;}}catchException e{e.printStackTrace;}finally{ConnectionDb.CLoseConnconnps,rs;}return flag;}break;}else账号或者密码错误;System.out.print In}}whiletrue{查询全部用户信息）;System.out.println Syste插入用户信息）；更改m.out.println System.out.用户信息）；删除用户printIn System•out•printIn信息）；System.oc/t.println int退出）；num=sc.nextlnt;switchnum{forUserInfo u:UInfoDao.select{System•out.printlnu•GName++u.GPassword;查System.out.println询成功；break;；请输入要增加的用户账号System.out.printString Iname=sc.next;；请输入增加用户的密码System.out.printString Ipassword=sc.next;UInfoDao.Insert Inarnea,Ipassword;添System.out.printIn；加成功break;；.请输入要修改的用户账号System.printString Uname=sc.next;；请输入新密码System.out.printString Upassword=sc.next;UInfoDao.updateUname^Upassword;修System.out.printIn；改成功break;；请输入要要删除的用户账号System.out.printString Dname=sc.next;UInfoDao.deleteDname;删System.out.printIn除成功）break;；return;default:continue;}}〃连接数据库class ConnectionDb{publicstaticConnection Conn{Connection conn=null;Stringdriver=try{Class./or/Vawe driver;StringconStr=conn=DriverManager.getConnectionconStr-try{ifconn!=null{conn.close;}}catchException e{e.printStackTrace;}}〃实体类:封装数据class Userlnfo{private IntegerId;private StringName;private String Password;public voidSIdInteger Id{this.Id=Id;public voidSNameString Name{this.Name=Name;public voidSPasswordString Password{this•Password=Password;}public IntegerGId{return Id;public StringGName{return Name;public StringGPassword{return Password;〃数据库操作class UserInfoDao〃插入public voidInsertString Name,String Password{Connectionconn=null;PreparedStatement ps=null;tryconn=ConnectionDb•Conn;String sql=intops=conn.prepareStatementsql;ps•setString1Name;ps•setstring2,Password;ps•executeUpdate;}catchException e{e.printStackTrace;}finally{ConnectionDb.C^oseConnconnps,null;}〃删除public voiddeleteString Name{Connection conn=null;PreparedStatement ps=null;try{conn=ConnectionDb•Conn;String sql=from userinfowhere・Jps=conn.prepareStatementsql;ps•setStringl Name;Jps•executellpdate;}catchException e{e.printStackTrace;}finally{ConnectionDb.CLoseConnconnps,null;}〃修改public voidupdateString Name,StringPassword{Connection conn=null;PreparedStatement ps=null;try{conn=ConnectionDb.Conn;String sql=Jps=conn.prepareStatementsql;ps•setString2,Name;ps•setStringl Password;ps•executellpdate;}catchException e{e.printStackTrace;}finally{ConnectionDb.CLoseConnconnps,null;}〃查询全部数据public ArrayListUserInfoselect{ArrayListUserInfo list=newArrayListUserInfo;Connection conn=null;PreparedStatement ps=null;ResultSet rs=null;tryconn=ConnectionDb.Conn;String sql=・yps=conn.prepareStatementsql;rs=ps•executeQuery;whilers.next{Userinfo u=new Userlnfo;u.SIdIntegerrs.getObjectl;u.SNamers.getString2;u.SPasswordrs.getString3;list.addu;}}catchException e{e.printStackTrace;。