小型银行管理系统的功能代码资料.docVIP

小型银行管理系统的部分代码 登陆 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 login{ private 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 = 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 getsState() { return sState; } public void setsState(String sState) { this.sState = sState; } /** * 创建数据库连接 * */ private void NewConnect(){ try { if (conn == null) { Class.forName(dbClassName).newInstance(); conn = DriverManager.getConnection(dbUrl, dbUser, dbPwd); } else return; } 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(); ResultSet 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.out.println(ep.getsName()+ep.getsPass()+ep.getsState()); list.add(ep); } } catch (SQLException e) { // TODO 自动生成 catch 块 e.printStackTrace(); } return list;//查询结果，数组返回 } } 数据库