《(2020年)企业管理运营小型银行管理系统的功能代码》由会员分享,可在线阅读,更多相关《(2020年)企业管理运营小型银行管理系统的功能代码(12页珍藏版)》请在金锄头文库上搜索。
1、小型银行管理系统的部分代码登陆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;import java.sql.*;public class loginprivate String sName;private String sPass;private String sState;/数据库连接设置prot
2、ected 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 = root; private static Connection conn = null; public String getsName() return sName;public void setsName(Strin
3、g 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 sState) this.sState = sState;/* * 创建数据库连接 * */private void NewConnect()try if (conn = null) Class.forName(dbCl
4、assName).newInstance();conn = DriverManager.getConnection(dbUrl, dbUser, dbPwd);elsereturn; catch (Exception ee) ee.printStackTrace();public List stuSearch()String sql=select * from person where name=+sName+ and pass=+sPass+ and state=+sState+;/System.out.println(sql);List list=new ArrayList();Resul
5、tSet rs = null;try if(conn=null)NewConnect();/如果数据库连接为空,则创建rs = conn.createStatement().executeQuery(sql); catch (SQLException e) e.printStackTrace(); try /通过循环,将数据结果集中的内容取出while(rs.next() login ep = new login();ep.setsName(ep.getsName();ep.setsSPass(ep.getsPass();ep.setsState(ep.getsState();/System.
6、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.Connection;import java.sql.DriverManager;import java.sql.ResultSet;import java.sql.Statement;public class shujuku pu
7、blic shujuku(String sql)/接受一个SQL语句并执行 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(); stmt.executeUpdate(sql); stmt.close(); catch(E
8、xception 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 String shuj()/查询出账户的最大值并返回这个最大值供其他方法调用 String s=null; try Class.forName(com.mysql.jdbc.Driver); String url=jdbc
9、: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.next() s=rs.getString(cid); stmt.close(); rs.close();
10、 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.util.ArrayList;import java.util.List;import java.util.Vector;import java.sql.*;public class Employee private
11、 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.mysql.jdbc.Driver;protected static String dbUrl = jdbc:mysql:/localhost:3306/bank;protected static String db
12、User = 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 String geteid() return eid;public void seteid(String eid) this.eid = eid;public String geteaddr() return eaddr;
13、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 epassward;public void setepassward(String epassward) this.epassward = epassward;public String getesex() return esex;public void setesex(String esex) this.esex = esex;public String