--------------网上银行系统-------------

public static void search(String aid) { Connection con = null; //UserBean userbean = null; try { con = JNDICon.getPool("jdbc/pool"); System.out.println("------------"); //userbean = new UserBean(); Statement st = con.createStatement(); String sql1 = "select * from account where aid='" + aid + "'"; ResultSet rs1 = st.executeQuery(sql1); //System.out.println(rs.next()); if (rs1.next()) { //userbean.setAid("aid"); System.out.println("XXXXXXX"); System.out.println(rs1.getString (1)); String cardid = rs1.getString("cardid"); System.out.println(rs1.getString("cardid")); System.out.println(rs1.getString("balance")); //userbean.setCardid(rs.getString("cardid")); //userbean.setCardid(rs.getString("balance")); //Statement st2 = con.createStatement(); String sql2 = "select * from users where cardid='" + cardid + "'"; ResultSet rs2 = st.executeQuery(sql2); if (rs2.next()) { System.out.println("XXXXXXX"); //userbean.setUsername(rs2.getString("username")); //userbean.setEmail(rs2.getString("email")); //userbean.setTelephone(rs2.getString("Telephone")); System.out.println(rs2.getString ("username")); System.out.println(rs2.getString("email")); System.out.println(rs2.getString("Telephone")); } } } catch (Exception e) { e.printStackTrace(); } finally { try { if (con != null) { con.close(); } } catch (Exception e) { e.printStackTrace(); } } //return userbean; } public static boolean transfer(String fromId, String toId, float money) { Connection con = null; int num = 0 ; float amoney = 0; float tomoney=0; boolean result = false; try { con = JNDICon.getPool("jdbc/pool"); // Statement st0=con.createStatement(); // String sql0="insert into dealinfo86 " ArrayList al=new ArrayList(); Statement st0 = con.createStatement(); String sql0 = "select * from account"; ResultSet rs0 = st0.executeQuery(sql0); //ResultSetMetaData rsmd=rs.getMetaData(); //int cols=rsmd.getColumnCount(); while (rs0.next()) { //if (rs.getString("aid").equals(toId)) { //num = rs.getRow(); al.add(rs0.getString(1)); if(al.contains(toId)){ String sql1="select*from account where aid='"+toId+"'"; ResultSet rs1=st0.executeQuery(sql1); if(rs1.next()){ tomoney=Float.parseFloat(rs1.getString("balance")); } else{ return false; } String sql2="select*from account where aid='"+fromId+"'"; ResultSet rs2=st0.executeQuery(sql2); if( rs2.next()){ amoney = Float.parseFloat(rs2.getString("balance")); } else{ return false; } if (amoney < money) { result=false; } else { Statement st1 = con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY); String sql3="select*from dealinfo"; ResultSet rs3=st1.executeQuery(sql3); if(rs3.last()) num=rs3.getRow(); Statement st2= con.createStatement(); String info = "zhuanzhang@toId"; String sql4 = "insert into dealinfo values('" + (num+1) + "','" + fromId + "','" + money + "','" + new Date() + "','" + info + "')"; st2.execute(sql4); //System.out.println(result); String sql5="update account set balance='"+(amoney-money)+"'where aid='"+fromId+"'"; int i=st2.executeUpdate(sql5); System.out.println(i); String sql6="update account set balance='"+(tomoney+money)+"'where aid='"+toId+"'"; st2.executeUpdate(sql6); result=true; } } else{ result=false; } } } catch (Exception e) { e.printStackTrace(); } finally { try { if (con != null) { con.close(); } } catch (Exception e) { e.printStackTrace(); } } return result; } }