大学生期末答辩项目，基于servlet+HTML+css+JavaScript+jsp+MySQL实现的银行管理系统，包含sql

package daoimpl; import java.sql.Connection; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.sql.Statement; import java.util.ArrayList; import java.util.List; import dao.bankDao; import entity.Bank; import entity.User; import util.DBUtil; public class bankdaoimpl implements bankDao { public void save(Bank bank) { Connection conn = null; PreparedStatement pst = null; try { conn = DBUtil.getConnection(); String sql = "insert into bank(name,sex,birthday,phone,num,balance,passwd,bankid) values (?,?,?,?,?,?,?,?)"; pst = conn.prepareStatement(sql); pst.setString(1, bank.getName()); pst.setString(2, bank.getSexString()); pst.setDate(3, new java.sql.Date(bank.getBirthday().getTime())); pst.setString(4, bank.getPhone()); pst.setString(5, bank.getNum()); pst.setInt(6, bank.getBalance()); pst.setString(7, bank.getPasswd()); pst.setString(8, bank.getBankid()); pst.execute(); } catch (Exception e) { e.printStackTrace(); }finally { if(pst!=null) {try{pst.close();}catch(Exception e2) {}} if(conn!=null) {try{conn.close();}catch(Exception e2) {}} } } public void update(String bankid,String num,int balance) { Connection conn = null; PreparedStatement pst = null; try { conn = DBUtil.getConnection(); String sql = "update bank set balance = balance + ? where bankid = ? and num=?"; pst = conn.prepareStatement(sql); pst.setInt(1, balance); pst.setString(2, bankid); pst.setString(3, num); pst.execute(); } catch (Exception e) { e.printStackTrace(); }finally { if(pst!=null) {try{pst.close();}catch(Exception e2) {}} if(conn!=null) {try{conn.close();}catch(Exception e2) {}} } } @Override public void delete(String bankid,String num,int balance) { Connection conn = null; PreparedStatement pst = null; try { conn = DBUtil.getConnection(); String sql = "update bank set balance = balance - ? where bankid = ? and passwd =?"; pst = conn.prepareStatement(sql); pst.setInt(1, balance); pst.setString(2, bankid); pst.setString(3, num); pst.execute(); } catch (Exception e) { e.printStackTrace(); }finally { if(pst!=null) {try{pst.close();}catch(Exception e2) {}} if(conn!=null) {try{conn.close();}catch(Exception e2) {}} } } @Override public Bank findBynum(int num) { return null; } public void transfer(String bankid,String passwd,String bankid2,int balance) { Connection conn = null; PreparedStatement pst = null; Connection conn1 = null; PreparedStatement pst1 = null; try { conn = DBUtil.getConnection(); conn1 = DBUtil.getConnection(); String sql = "update bank set balance = balance - ? where bankid = ? and passwd = ?;"; pst = conn.prepareStatement(sql); pst.setInt(1, balance); pst.setString(2, bankid); pst.setString(3, passwd); pst.execute(); String sql2 = "update bank set balance = balance + ? where bankid = ?;"; pst1 = conn1.prepareStatement(sql2); pst1.setInt(1, balance); pst1.setString(2, bankid2); pst1.execute(); } catch (Exception e) { e.printStackTrace(); }finally { if(pst!=null) {try{pst.close();}catch(Exception e2) {}} if(conn!=null) {try{conn.close();}catch(Exception e2) {}} } } public List<Bank> findBynum(String num,String passwd,String bankid){ String Bankid = null; String Num = null; Connection conn = null; ResultSet rs = null; Statement st = null; try { conn = DBUtil.getConnection(); String sql = "select * from bank where num = "+num+" and passwd = "+passwd+" and bankid = "+bankid; st = conn.prepareStatement(sql); rs = st.executeQuery(sql); List<Bank> list = new ArrayList<Bank>(); while(rs.next()) { Bank bank = new Bank(); bank.setName(rs.getString("name")); bank.setSexString(rs.getString("sex")); bank.setBirthday(rs.getDate("birthday")); bank.setPhone(rs.getString("phone")); num = rs.getString("num"); Num = num.substring(0,3)+"***"+ num.substring(14); bank.setNum(Num); bank.setBalance(rs.getInt("balance")); bank.setPasswd(rs.getString("passwd")); bankid = rs.getString("bankid"); Bankid = bankid.substring(0, 3) + "****" + bankid.substring(12); bank.setBankid(Bankid); list.add(bank); } return list; } catch (Exception e) { e.printStackTrace(); } finally { if(rs!=null) {try{rs.close();}catch(Exception e2) {}} if(conn!=null) {try{rs.close();}catch(Exception e2) {}} } return null; } public void regist(String username,String passwd,String phone) { Connection conn = null; PreparedStatement pst = null; try { conn = DBUtil.getConnection(); String sql = "insert into user(username,passwd,phone) values (?,?,?)"; pst = conn.prepareStatement(sql); pst.setString(1, username); pst.setString(2, passwd); pst.setString(3, phone); pst.execute(); } catch (Exception e) { e.printStackTrace(); }finally { if(pst!=null) {try{pst.close();}catch(Exception e2) {}} if(conn!=null) {try{conn.close();}catch(Exception e2) {}} } } public User login(String username,String passwd) { Connection conn = null; ResultSet rs = null; PreparedStatement pst = null; try { conn = DBUtil.getConnection(); String sql = "select * from user where username = ?"; pst = conn.prepareStatement(sql); pst.setString(1, username); rs = pst.executeQuery(); while(rs.next()) { User user = new User(); user.setUsername(rs.getString("username")); user.setPasswd(rs.getString("passwd")); return user; } } catch (Exception e) { e.printStackTrace(); } finally { if(rs!=null) {try{rs.close();}catch(Exception e2) {}} if(conn!=null) {try{rs.close();}catch(Exception e2) {}} } return null; } @Override public User toLogin(String username) { Connection conn = null; ResultSet rs = null; PreparedStatement pst = null; try { conn = DBUtil.getConnection(); String sql = "select * from user where username = ?"; pst = conn.prepareStatement(sql); pst.setString(1, username); rs = pst.executeQuery(); while(rs.next()) { User user = new User(); user.setUsername(rs.getString("username")); return user; } } catch (Exception e) { e.printStackTrace(); } finally { if(rs!=null) {try{rs.close();}catch(Exception e2) {}} if(conn!=null) {try{rs.close();}catch(Exception e2) {}} } return null; } }