小型银行管理系统的部分代码介绍.docx

《小型银行管理系统的部分代码介绍.docx》由会员分享，可在线阅读，更多相关《小型银行管理系统的部分代码介绍.docx（13页珍藏版）》请在淘文阁 - 分享文档赚钱的网站上搜索。

1、更多企业学院：./Shop/中小企业管理全能版183套讲座+89700份资料./Shop/40.shtml总经理、高层管理49套讲座+16388份资料./Shop/38.shtml中层管理学院46套讲座+6020份资料./Shop/39.shtml国学智慧、易经46套讲座./Shop/41.shtml人力资源学院56套讲座+27123份资料./Shop/44.shtml各阶段员工培训学院77套讲座+ 324份资料./Shop/49.shtml员工管理企业学院67套讲座+ 8720份资料./Shop/42.shtml工厂生产管理学院52套讲座+ 13920份资料./Shop/43.shtml财务

2、管理学院53套讲座+ 17945份资料./Shop/45.shtml销售经理学院56套讲座+ 14350份资料./Shop/46.shtml销售人员培训学院72套讲座+ 4879份资料./Shop/47.shtml小型银行管理系统的部分代码登陆package dao;import java.sql.Connection;import java.sql.DriverManager;import java.sql.ResultSet;import java.sql.SQLException;import java.util.ArrayList;import java.util.List;impor

3、t java.sql.*;public class loginprivate String sName;private String sPass;private String sState;/数据库连接设置protected static String dbClassName = com.mysql.jdbc.Driver;protected static String dbUrl = jdbc:mysql:/localhost:3306/bank;protected static String dbUser = root; protected static String dbPwd = ro

4、ot; private static Connection conn = null; public String getsName() return sName;public void setsName(String sName) this.sName = sName;public String getsPass() return sPass;public void setsSPass(String sPass) this.sPass = sPass;public String getsState() return sState;public void setsState(String sSt

5、ate) this.sState = sState;/* * 创建数据库连接 * */private void NewConnect()try if (conn = null) Class.forName(dbClassName).newInstance();conn = DriverManager.getConnection(dbUrl, dbUser, dbPwd);elsereturn; catch (Exception ee) ee.printStackTrace();public List stuSearch()String sql=select * from person wher

6、e name=+sName+ and pass=+sPass+ and state=+sState+;/System.out.println(sql);List list=new ArrayList();ResultSet rs = null;try if(conn=null)NewConnect();/如果数据库连接为空，则创建rs = conn.createStatement().executeQuery(sql); catch (SQLException e) e.printStackTrace(); try /通过循环，将数据结果集中的内容取出while(rs.next() login

7、 ep = new login();ep.setsName(ep.getsName();ep.setsSPass(ep.getsPass();ep.setsState(ep.getsState();/System.out.println(ep.getsName()+ep.getsPass()+ep.getsState();list.add(ep); catch (SQLException e) / TODO 自动生成 catch 块e.printStackTrace();return list;/查询结果，数组返回数据库package dao;import java.sql.Connectio

8、n;import java.sql.DriverManager;import java.sql.ResultSet;import java.sql.Statement;public class shujuku public shujuku(String sql)/接受一个SQL语句并执行 try Class.forName(com.mysql.jdbc.Driver); String url=jdbc:mysql:/localhost/Bank?useUnicode=true&characterEncoding=GBK; Connection con=DriverManager.getConn

9、ection(url,root,root); Statement stmt=con.createStatement(); stmt.executeUpdate(sql); stmt.close(); catch(Exception e) e.printStackTrace(); 数据package dao;import java.sql.Connection;import java.sql.DriverManager;import java.sql.ResultSet;import java.sql.Statement;public class shuju public static Stri

10、ng shuj()/查询出账户的最大值并返回这个最大值供其他方法调用 String s=null; try Class.forName(com.mysql.jdbc.Driver); String url=jdbc:mysql:/localhost/Bank?useUnicode=true&characterEncoding=GBK; Connection con=DriverManager.getConnection(url,root,root); Statement stmt=con.createStatement(); ResultSet rs=stmt.executeQuery(sel

11、ect max(cid) as cid from Bank.yonghuxinxi ); while(rs.next() s=rs.getString(cid); stmt.close(); rs.close(); catch(Exception e) e.printStackTrace(); return s; 数据库连接package dao;import java.sql.Connection;import java.sql.DriverManager;import java.sql.ResultSet;import java.sql.SQLException;import java.u

12、til.ArrayList;import java.util.List;import java.util.Vector;import java.sql.*;public class Employee private String ename;private String eid;private String eaddr;private String esalary;private String epassward;private String esex;private String etel;/数据库连接设置protected static String dbClassName = com.m

13、ysql.jdbc.Driver;protected static String dbUrl = jdbc:mysql:/localhost:3306/bank;protected static String dbUser = root; protected static String dbPwd = root; private static Connection conn = null; public String getename() return ename;public void setename(String ename) this.ename = ename;public Stri

14、ng geteid() return eid;public void seteid(String eid) this.eid = eid;public String geteaddr() return eaddr;public void seteaddr(String eaddr) this.eaddr = eaddr;public String getesalary() return esalary;public void setesalary(String esalary) this.esalary = esalary;public String getepassward() return

15、 epassward;public void setepassward(String epassward) this.epassward = epassward;public String getesex() return esex;public void setesex(String esex) this.esex = esex;public String getetel() return etel;public void setetel(String etel) this.etel = etel;/* * 创建数据库连接 * */private void NewConnect()try i

16、f (conn = null) Class.forName(dbClassName).newInstance();conn = DriverManager.getConnection(dbUrl, dbUser, dbPwd);elsereturn; catch (Exception ee) ee.printStackTrace();/* * 增加员工 * param stu */public void AddEmployee()/拼装插入员工信息的SQL语句String ssql=insert into employee(name,id,addr,salary,passward,sex,te

17、l) values (+ +this.ename+,+ +this.eid+,+ +this.eaddr+,+ +this.esalary+,+ +this.epassward+,+ +this.esex+,+ +this.etel+);System.out.println(ssql);try if(conn=null) NewConnect();/如果数据库连接为空，则创建/执行SQL语句，插入员工信息conn.createStatement().executeUpdate(ssql); catch (SQLException e) e.printStackTrace(); /* * 删除员

18、工 * param stu */public void DelEmployee()/拼装删除员工的SQL语句String ssql=delete from employee where id =+this.eid+;try if(conn=null) NewConnect();/如果数据库连接为空，则创建/执行SQL语句，删除员工信息conn.createStatement().executeUpdate(ssql); catch (SQLException e) e.printStackTrace(); /* * 员工查询 * param x * return */public Vector

19、 stuSearch()/拼装查询员工的SQL语句String sql=select name,id,addr,salary,passward,sex,tel from employee;/如果姓名非空，则将姓名作为查询条件if(this.ename!=null)sql+= where name=+this.ename+;/如果性别非空，则将性别作为查询条件Vector v =new Vector();/List list=new ArrayList();ResultSet rs = null;try if(conn=null)NewConnect();/如果数据库连接为空，则创建/执行查询，

20、查询结果保存在数据结果集rs中/rs = conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE).executeQuery(sql);rs = conn.createStatement().executeQuery(sql); catch (SQLException e) e.printStackTrace(); try /通过循环，将数据结果集中的内容取出while(rs.next()/每一条员工记录作为一个对象，加入到数组中/*Employee stuinfo = new Employ

21、ee();stuinfo.setename(rs.getString(name);stuinfo.seteid(rs.getString(id);stuinfo.setesex(rs.getString(sex);stuinfo.setesalary(rs.getString(salary);stuinfo.setepassward(rs.getString(passward);stuinfo.seteaddr(rs.getString(addr);stuinfo.setetel(rs.getString(tel);*/Vector ve = new Vector();for(int i =

22、1;i8;i+)ve.add(rs.getString(i);v.add(ve); catch (SQLException e) / TODO 自动生成 catch 块e.printStackTrace();return v;/查询结果，员工信息数组返回开户package dao;import java.sql.Connection;import java.sql.DriverManager;import java.sql.ResultSet;import java.sql.Statement;public class Cxshuju public static int cxshuj(Stri

23、ng s,String ss)/判断用户输入的账户、密码是否正确，如果正确返回1,否则返回0 int a=0; try Class.forName(com.mysql.jdbc.Driver); String url=jdbc:mysql:/localhost/Bank?useUnicode=true&characterEncoding=GBK; Connection con=DriverManager.getConnection(url,root,root); Statement stmt=con.createStatement(); ResultSet rs=stmt.executeQue

24、ry(select * from bank.yonghuxinxi); while(rs.next() if (rs.getString(cid).equals(s) & rs.getString(mm).equals(ss) a=1; break; stmt.close(); rs.close(); catch(Exception e) e.printStackTrace(); return a; public static int cxshuj(String s)/判断数据库中是否存在账户名s,若存在返回1,否则返回0 int a=0; try Class.forName(com.mysq

25、l.jdbc.Driver); String url=jdbc:mysql:/localhost/Bank?useUnicode=true&characterEncoding=GBK; Connection con=DriverManager.getConnection(url,root,root); Statement stmt=con.createStatement(); ResultSet rs=stmt.executeQuery(select * from bank.yonghuxinxi); while(rs.next() if (rs.getString(cid).equals(s

26、) a=1; break; stmt.close(); rs.close(); catch(Exception e) e.printStackTrace(); return a; public static String cxsj(String s)/查询余额 String a=null; try Class.forName(com.mysql.jdbc.Driver); String url=jdbc:mysql:/localhost/Bank?useUnicode=true&characterEncoding=GBK; Connection con=DriverManager.getCon

27、nection(url,root,root); Statement stmt=con.createStatement(); ResultSet rs=stmt.executeQuery(s); while(rs.next() a=rs.getString(je); rs.close(); stmt.close(); catch(Exception e) e.printStackTrace(); return a; public static String cxsju(String s)/查询身份证号 String a=null; try Class.forName(com.mysql.jdbc

28、.Driver); String url=jdbc:mysql:/localhost/Bank?useUnicode=true&characterEncoding=GBK; Connection con=DriverManager.getConnection(url,root,root); Statement stmt=con.createStatement(); ResultSet rs=stmt.executeQuery(s); while(rs.next() a=rs.getString(sid); rs.close(); stmt.close(); catch(Exception e)

29、 e.printStackTrace(); return a; public static String chaxsj(String s)/查询历史信息 String a=; try String a1=null,a2=null,a3=null,a4=null,a5=null,a6=null; Class.forName(com.mysql.jdbc.Driver); String url=jdbc:mysql:/localhost/Bank?useUnicode=true&characterEncoding=GBK; Connection con=DriverManager.getConne

30、ction(url,root,root); Statement stmt=con.createStatement(); ResultSet rs=stmt.executeQuery(s); while(rs.next() a1=rs.getString(cid); a2=rs.getString(sid); a3 = rs.getString(je); a4 = rs.getString(cun); a5=rs.getString(qu); a6=rs.getString(date); String a0= 卡号：+a1+ 身份证号：+ a2+ 金额：+a3+ 存入：+a4+ 取出：+a5+ 日期：+a6; a=a+a0+nn; rs.close(); stmt.close(); catch(Exception e) e.printStackTrace(); return a;