J2EE JSP 购物车 源代码

package pfc.str; import java.sql.Connection; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.sql.Statement; import java.util.ArrayList; public class OrderBeanBO { private PreparedStatement ps = null; private ResultSet rs = null; private Connection ct = null; /** * 生成订单 * @param mbo 用户的购物车 * @param userID 用户id * @return 返回一个订单详细信息bean [OrderInfoBean] */ public OrderInfoBean addOrder(MyCartBO mbo,String userID){ OrderInfoBean oib = new OrderInfoBean(); boolean b = true; try{ ct = new ConnDB().getConn(); ps = ct.prepareStatement("insert into orders (userID,isPayed,totailPrice) values(?,?,?)"); System.out.println("abc"); ps.setString(1, userID); ps.setByte(2, (byte)0); ps.setFloat(3, mbo.getAllPrice()); System.out.println("abcd"); int a = ps.executeUpdate(); if(a==1){ System.out.println("abcde"); ps=ct.prepareStatement("select max(ordersID) from orders"); System.out.println("abcdef"); rs = ps.executeQuery(); int ordersID=0; if(rs.next()){ System.out.println("abcdefg"); ordersID = rs.getInt(1); } ArrayList al = mbo.showMyCat(); System.out.println("abcdefgh"); //我们可以使用批量操作数据库的方法，提供操作数据库的效率。 Statement sm = ct.createStatement(); for(int i=0;i<al.size();i++){ GoodsBean gb = (GoodsBean)al.get(1); sm.addBatch("insert into orderdetail value('"+ordersID+"','"+gb.getGoodsID()+"','"+mbo.getGoodsNumByID(gb.getGoodsID()+"")+"')"); System.out.println("abcdefghj"); } sm.executeBatch(); //多表查询 String sql = "select ordersID,truename,address,postcode,telephone,totailPrice,username,email,orderDate,payMode,isPayed from users ,orders where users.userID = orders.userID"; System.out.println("abcdefghjk"); ps = ct.prepareStatement(sql); rs = ps.executeQuery(); if(rs.next()){ System.out.println("abcdefghjkl"); oib.setOrdersID(rs.getInt(1)); oib.setTruename(rs.getString(2)); oib.setAddress(rs.getString(3)); oib.setPostcode(rs.getString(4)); oib.setTelephone(rs.getString(5)); oib.setTotailPrice(rs.getFloat(6)); oib.setUsername(rs.getString(7)); oib.setEmail(rs.getString(8)); oib.setOrderDate(rs.getDate(9)); oib.setPayMode(rs.getString(10)); oib.setIsPayed(rs.getByte(11)); } } }catch(Exception e){ b=false; e.printStackTrace(); }finally{ this.close(); } if(b){ System.out.println("abcdefghjkli"); return oib; }else{ return null; } } // 关闭资源 public void close( ){ try{ if(rs!= null ){ rs.close(); rs=null; } if(ps!= null ){ ps.close(); ps = null; } if(ct!= null ){ ct.close(); ct=null; } }catch(Exception e){ e.printStackTrace(); } } }