银行操作系统源代码题稿.docx

银行操作系统源代码 public class Conn {//导入驱动包 public static 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 block e.printStackTrace(); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } return con; } } ///////////////////////////////////////////////////////////// public class AdminDAO { /* * * 判断是否是柜员 */ public static boolean isAdmin(int adminid,String adminPassword){//传入的参数为柜员编号和密码 int a=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变量为1 temp1=rs.getString(adminname); //用temp1来接柜员姓名 } } } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); }{ try { con.close(); pst.close(); rs.close(); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } } if(a==1){ System.out.println( System: +temp1+, 你好!); //显示登陆的柜员姓名 return true; //如果a==1,返回true，否则返回false } else { System.out.println(编号或密码有误！); return false ; } } /* * 柜员登陆 */ public static boolean adminLog(){ System.out.println( *************************************); System.out.println( ** 柜员登陆