银行客户管理系统，JSP开发

package com.bms.model; import java.sql.Connection; import java.sql.ResultSet; import java.sql.SQLException; import java.sql.Statement; import java.util.ArrayList; public class BusiDao { private Double strAll = null; private Double getRecAll() { return this.strAll; } private void setRecAll(Double s) { this.strAll = s; } private void insert(String bms_id,String client_id,String money,String all,int isIn) { Connection conn = null; Statement stmt = null; String sql = null; conn = ConnDBC3P0.getInstance().getConn(); stmt = ConnDBC3P0.createStmt(conn); if(isIn == 0) { sql = "insert into bankin values('"+bms_id+"','"+client_id+"',now(),"+money+",'"+all+"')"; } else if(isIn == 1){ sql = "insert into bankout values('"+bms_id+"','"+client_id+"',now(),"+money+",'"+all+"')"; } else if(isIn == 2) { sql = "insert into transfer values('"+bms_id+"','"+client_id+"',now(),"+money+",'"+all+"')"; } ConnDBC3P0.exetUpdate(stmt, sql); } private void updateClient(String client_id,String money,boolean isIn) { Connection conn = null; Statement stmt = null; ResultSet rs = null; String sql = null; conn = ConnDBC3P0.getInstance().getConn(); stmt = ConnDBC3P0.createStmt(conn); sql = "select client_all from client where client_id='"+client_id+"'"; rs = ConnDBC3P0.exetQuery(stmt, sql);//exetQuery(sql); Double all = null; try { if(rs.next()){ all = new Double(rs.getString(1)); } System.out.println("all == " + all); } catch (NumberFormatException e) { e.printStackTrace(); } catch (SQLException e) { e.printStackTrace(); } if(isIn) { all += new Double(money); } else { all -= new Double(money); } sql = "update client set client_all='"+all.toString()+"' where client_id='"+client_id+"'"; ConnDBC3P0.exetUpdate(stmt, sql); ConnDBC3P0.close(conn, stmt, rs); } public boolean bankIn(String bms_id,String client_id,String money) { boolean b = false; Connection conn = null; Statement stmt = null; ResultSet rs = null; String sql = null; conn = ConnDBC3P0.getInstance().getConn(); stmt = ConnDBC3P0.createStmt(conn); sql = "select client_all from client where client_id='"+client_id+"'"; rs = ConnDBC3P0.exetQuery(stmt, sql); Double all = null; System.out.println("client = " + client_id + " bms_id = " + bms_id + " money = " + money); Double mon = new Double(money); try { if(rs.next()) { all = new Double(rs.getString(1)); this.setRecAll(all); b = true; } } catch (NumberFormatException e) { e.printStackTrace(); } catch (SQLException e) { e.printStackTrace(); } finally { ConnDBC3P0.close(conn, stmt, rs); } if(b) { this.updateClient(client_id, money, true); this.insert(bms_id, client_id, mon.toString(), new Double(all.doubleValue()+mon.doubleValue()).toString(), 0); } return b; } public boolean bankOut(String bms_id,String client_id,String money) { int b = 0; Connection conn = null; Statement stmt = null; ResultSet rs = null; String sql = null; conn = ConnDBC3P0.getInstance().getConn(); stmt = ConnDBC3P0.createStmt(conn); sql = "select client_all from client where client_id='"+client_id+"'"; rs = ConnDBC3P0.exetQuery(stmt, sql); Double all = null; Double mon = new Double(money); try { if(rs.next()) { all = new Double(rs.getString(1)); this.setRecAll(all); System.out.println("----------all = " + all + " mon = " + mon); if(all >= mon) { //有足够的钱取出 b = 1; } } else { this.updateClient(client_id, money, false); this.insert(bms_id, client_id, mon.toString(), mon.toString(), 1); this.setRecAll(0.0); b = 2; } } catch (NumberFormatException e) { e.printStackTrace(); } catch (SQLException e) { e.printStackTrace(); } finally { ConnDBC3P0.close(conn, stmt, rs); } if(b == 1) { this.updateClient(client_id, money, false); this.insert(bms_id, client_id, mon.toString(), new Double(all.doubleValue()-mon.doubleValue()).toString(), 1); } return b!=0; } private boolean isUserExist(String transfer_id) { boolean b = false; Connection conn = ConnDBC3P0.getInstance().getConn(); Statement stmt = ConnDBC3P0.createStmt(conn); String sql = "select count(*) from client where client_id='"+transfer_id+"'"; ResultSet rs = ConnDBC3P0.exetQuery(stmt, sql);//(stmt, sql); try { if(rs.next()) b = true; } catch (SQLException e) { e.printStackTrace(); } return b; } public boolean transfer(String bms_id,String client_id,String transfer_id,String money) { boolean b = false; if(this.isUserExist(client_id)) { b = b | bankOut(bms_id, client_id, money); this.insert(bms_id, client_id, money, this.getRecAll().toString(), 2); b |= bankIn(bms_id, transfer_id, money); } return b; } public ArrayList<BankInBean> getIninfo(String ID) { ArrayList<BankInBean> al = new ArrayList<BankInBean>(); Connection conn = null; Statement stmt = null; ResultSet rs = null; String sql = null; conn = ConnDBC3P0.getInstance().getConn(); stmt = ConnDBC3P0.createStmt(conn); sql = "select * from bankin where client_id='"+ID+"'"; rs = ConnDBC3P0.exetQuery(stmt, sql); try { while(rs.next()) { BankInBean bb = new BankInBean(); bb.setBms_id(rs.getString("bms_id")); bb.setClient_id(rs.getString("client_id")); bb.setBankin_money(rs.getString("bankin_money")); bb.setBankin_time(new java.util.Date(rs.getTimestamp("bankin_time").getTime())); bb.setClient_all(rs.getString("client_all")); al.add(bb); } } catch (SQLException e) { e.printStackTrace(); } System.out.println("banin size : ---------" + al.size()); return al; } public ArrayList<BankOutBean> getOutinfo(String ID) { ArrayList<BankOutBean> al = new ArrayList<BankOutBean>(); Connection conn = null; Statement stmt = null; ResultSet rs = null; String sql = null; conn = ConnDBC3P0.getInstance().getConn(); stmt = ConnDBC3P0.createStmt(conn); sql = "select * from bankout where client_id='"+ID+"'"; rs = ConnDBC3P0.exetQuery(stmt, sql); try { while(rs.next()) { BankOutBean bb = new BankOutBean(); bb.setBms_id(rs.getString("bms_id")); bb.setClient_id(rs.getString("client_id")); bb.setBankout_money(rs.getString("bankout_money")); bb.setBankout_time(new java.util.Date(rs.getTimestamp("bankout_time").getTime())); bb.setClient_all(rs.getString("client_all")); al.add(bb); } } catch (SQLException e) { e.printStackTrace(); } System.out.println("banout size : " + al.size()); return al; } public ArrayList<TransferBean> getTransferinfo(String ID) { ArrayList<TransferBean> al = new ArrayList<TransferBean>(); Connection conn = null; Statement stmt = null; ResultSet rs = null; String sql = null; conn = ConnDBC3P0.getInstance().getConn(); stmt = ConnDBC3P0.createStmt(conn); sql = "select * from transfer where client_id='"+ID+"'"; rs = ConnDBC3P0.exetQuery(stmt, sql); try { while(rs.next()) { TransferBean bb = new TransferBean(); bb.setBms_id(rs.getString("bms_id")); bb.setClient_id(rs.getString("client_id")); bb.setTransfer_money(rs.getString("transfer_money")); bb.setTransfer_time(new java.util.Date(rs.getTimestamp("transfer_time").getTime())); bb.setClient_all(rs.getString("client_all")); al.add(bb); } } catch (SQLException e) { e.printStackTrace(); } System.out.println("transfer size : -----" + al.size()); return al; } /* public static void main(String[] args) { BusiDao bd = new BusiDao(); if(null != bd.getTransferinfo()) { System.ou