银行操作系统源代码合编.docx

银行操作系统源代码publicclass Conn {//导入驱动包publicstatic Connection getCon(){Connection con=null;try {Class.forName(com.mysql.jdbc.Driver);//获得驱动con=DriverManager.getConnection(jdbc:mysql://localhost:3306/banksystemoperation,root, root);} catch (ClassNotFoundException e) {// TODO Auto-generated catch blocke.printStackTrace();} catch (SQLException e) {// TODO Auto-generated catch blocke.printStackTrace();}returncon;}}/////////////////////////////////////////////////////////////publicclass AdminDAO {/* * * 判断是否是柜员 */publicstaticboolean isAdmin(intadminid,String adminPassword){//传入的参数为柜员编号和密码inta=0;String temp = null;String temp1=null;Connection con=null;con=Conn.getCon(); //获得链接PreparedStatement pst=null;ResultSet rs=null;String sql=select adminpassword ,adminname from admin where adminid =+adminid+;try {pst=con.prepareStatement(sql);rs=pst.executeQuery();if(rs.next()){temp=rs.getString(adminpassword);//用temp来接查询到的柜员密码if(temp.equals(adminPassword)) //判断传入的柜员密码和数据库里的密码是否相同{a=1; //如果密码相同 a变量为1temp1=rs.getString(adminname); //用temp1来接柜员姓名}}} catch (SQLException e) {// TODO Auto-generated catch blocke.printStackTrace();}{try {con.close();pst.close();rs.close();} catch (SQLException e) {// TODO Auto-generated catch blocke.printStackTrace();} }if(a==1){System.out.println( System: +temp1+, 你好!); //显示登陆的柜员姓名returntrue; //如果a==1,返回true，否则返回false }else{ System.out.println(编号或密码有误！);returnfalse ;}}/* * 柜员登陆 */publicstaticboolean adminLog(){ System.out.println( *************************************); System.out.println( ** 柜员登陆 **); System.out.println( **---------------------------------**); System.out.println( ** 输入 0 退出 **); System.out.println( *************************************);Scanner sc=new Scanner(System.in);System.out.println(请输入柜