小型銀行管理系統(tǒng)的部分代碼介紹

1、更多企業(yè)學(xué)院：./Shop/中小企業(yè)管理全能版183套講座+89700份資料./Shop/40.shtml總經(jīng)理、高層管理49套講座+16388份資料./Shop/38.shtml中層管理學(xué)院46套講座+6020份資料 ./Shop/39.shtml國學(xué)智慧、易經(jīng)46套講座./Shop/41.shtml人力資源學(xué)院56套講座+27123份資料./Shop/44.shtml各階段員工培訓(xùn)學(xué)院77套講座+ 324份資料./Shop/49.shtml員工管理企業(yè)學(xué)院67套講座+ 8720份資料./Shop/42.shtml工廠生產(chǎn)管理學(xué)院52套講座+ 13920份資料./Shop/43.s

2、html財務(wù)管理學(xué)院53套講座+ 17945份資料 ./Shop/45.shtml銷售經(jīng)理學(xué)院56套講座+ 14350份資料./Shop/46.shtml銷售人員培訓(xùn)學(xué)院72套講座+ 4879份資料./Shop/47.shtml小型銀行管理系統(tǒng)的部分代碼登陸package dao;import java.sql.Connection;import java.sql.DriverManager;import java.sql.ResultSet;import java.sql.SQLException;import java.util.ArrayList;import java.uti

3、l.List;import java.sql.*;public class loginprivate String sName;private String sPass;private String sState;/數(shù)據(jù)庫連接設(shè)置protected static String dbClassName = "com.mysql.jdbc.Driver"protected static String dbUrl = "jdbc:mysql:/localhost:3306/bank"protected static String dbUser = "

4、root" protected static String dbPwd = "root" 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 ge

5、tsState() return sState;public void setsState(String sState) this.sState = sState;/* * 創(chuàng)建數(shù)據(jù)庫連接 * */private void NewConnect()try if (conn = null) Class.forName(dbClassName).newInstance();conn = DriverManager.getConnection(dbUrl, dbUser, dbPwd);elsereturn; catch (Exception ee) ee.printStackTrace();pub

6、lic List stuSearch()String sql="select * from person where name='"+sName+"' and pass='"+sPass+"' and state='"+sState+"'"/System.out.println(sql);List list=new ArrayList();ResultSet rs = null;try if(conn=null)NewConnect();/如果數(shù)據(jù)庫連接為空，則創(chuàng)建r

7、s = conn.createStatement().executeQuery(sql); catch (SQLException e) e.printStackTrace(); try /通過循環(huán)，將數(shù)據(jù)結(jié)果集中的內(nèi)容取出while(rs.next() login 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.

8、add(ep); catch (SQLException e) / TODO 自動生成 catch 塊e.printStackTrace();return list;/查詢結(jié)果，數(shù)組返回數(shù)據(jù)庫package dao;import java.sql.Connection;import java.sql.DriverManager;import java.sql.ResultSet;import java.sql.Statement;public class shujuku public shujuku(String sql)/接受一個SQL語句并執(zhí)行 try Class.forName(&quo

9、t;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(); stmt.executeUpdate(sql); stmt.close(); catch(Exception

10、e) e.printStackTrace(); 數(shù)據(jù)package dao;import java.sql.Connection;import java.sql.DriverManager;import java.sql.ResultSet;import java.sql.Statement;public class shuju public static String shuj()/查詢出賬戶的最大值并返回這個最大值供其他方法調(diào)用 String s=null; try Class.forName("com.mysql.jdbc.Driver"); String url=&

11、quot;jdbc:mysql:/localhost/Bank?useUnicode=true&characterEncoding=GBK" Connection con=DriverManager.getConnection(url,"root","root"); Statement stmt=con.createStatement(); ResultSet rs=stmt.executeQuery("select max(cid) as cid from Bank.yonghuxinxi "); while(rs

12、.next() s=rs.getString("cid"); stmt.close(); rs.close(); catch(Exception e) e.printStackTrace(); return s; 數(shù)據(jù)庫連接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

13、t 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;/數(shù)據(jù)庫連接設(shè)置protected static String dbClassName = "com.mysql.jdbc.Driver"protected sta

14、tic 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 S

15、tring 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() ret

16、urn 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;/* * 創(chuàng)建數(shù)據(jù)庫連接 * */private void NewConnect()tr

17、y if (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,passwa

18、rd,sex,tel) values ("+ "'"+this.ename+"',"+ "'"+this.eid+"',"+ "'"+this.eaddr+"',"+ "'"+this.esalary+"',"+ "'"+this.epassward+"',"+ "'"+this.

19、esex+"',"+ "'"+this.etel+"')"System.out.println(ssql);try if(conn=null) NewConnect();/如果數(shù)據(jù)庫連接為空，則創(chuàng)建/執(zhí)行SQL語句，插入員工信息conn.createStatement().executeUpdate(ssql); catch (SQLException e) e.printStackTrace(); /* * 刪除員工 * param stu */public void DelEmployee()/拼裝刪除員工

20、的SQL語句String ssql="delete from employee where id ='"+this.eid+"'"try if(conn=null) NewConnect();/如果數(shù)據(jù)庫連接為空，則創(chuàng)建/執(zhí)行SQL語句，刪除員工信息conn.createStatement().executeUpdate(ssql); catch (SQLException e) e.printStackTrace(); /* * 員工查詢 * param x * return */public Vector<Vector>

21、stuSearch()/拼裝查詢員工的SQL語句String sql="select name,id,addr,salary,passward,sex,tel from employee"/如果姓名非空，則將姓名作為查詢條件if(this.ename!=null)sql+=" where name='"+this.ename+"'"/如果性別非空，則將性別作為查詢條件Vector<Vector> v =new Vector<Vector>();/List list=new ArrayList()

22、;ResultSet rs = null;try if(conn=null)NewConnect();/如果數(shù)據(jù)庫連接為空，則創(chuàng)建/執(zhí)行查詢，查詢結(jié)果保存在數(shù)據(jù)結(jié)果集rs中/rs = conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE).executeQuery(sql);rs = conn.createStatement().executeQuery(sql); catch (SQLException e) e.printStackTrace(); try /通過循環(huán)，將數(shù)據(jù)結(jié)果集中的

23、內(nèi)容取出while(rs.next()/每一條員工記錄作為一個對象，加入到數(shù)組中/*Employee stuinfo = new Employee();stuinfo.setename(rs.getString("name");stuinfo.seteid(rs.getString("id");stuinfo.setesex(rs.getString("sex");stuinfo.setesalary(rs.getString("salary");stuinfo.setepassward(rs.getString(

24、"passward");stuinfo.seteaddr(rs.getString("addr");stuinfo.setetel(rs.getString("tel");*/Vector<String> ve = new Vector<String>();for(int i = 1;i<8;i+)ve.add(rs.getString(i);v.add(ve); catch (SQLException e) / TODO 自動生成 catch 塊e.printStackTrace();return v;

25、/查詢結(jié)果，員工信息數(shù)組返回開戶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(String s,String ss)/判斷用戶輸入的賬戶、密碼是否正確，如果正確返回1,否則返回0 int a=0; try Class.forName("com.mysql.jdbc.Driver"); Str

26、ing 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(

27、) 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)/判斷數(shù)據(jù)庫中是否存在賬戶名s,若存在返回1,否則返回0 int a=0; try Class.forName("com.mysql.jdbc.Driv

28、er"); 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");

29、while(rs.next() if (rs.getString("cid").equals(s) 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/Ban

30、k?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("je"); rs.close(); stmt.close(); catch(Exception e) e

31、.printStackTrace(); return a; public static String cxsju(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.getConnection(url,"root","root"); Statement stmt=con.createStatement(); R