网上购物系统的JSP实现和网页

package cart; import java.sql.*; import java.util.*; import java.math.*; import java.io.*; public class CartManager { String sDBDriver = "sun.jdbc.odbc.JdbcOdbcDriver"; String sConnStr = "jdbc:odbc:cart"; Connection conn = null; ResultSet rs = null; private String userName=new String(""); private int pageSize=10; private Vector orderItem=new Vector(); private String queryProductId=new String(""); private int orderPrice=0; private String orderId=new String(""); public CartManager() { } public int checkUser(String userName,String userPassword) { int result=0; UserEntity user=null; try{ user=UserEntity.queryUser(userName); } catch(SQLException ex) { System.err.println(ex.getMessage()); } if(user==null) return 0; String pass=user.getUserPassword(); if(pass.compareTo(userPassword)==0) { result=1; this.userName=userName; } return result; } public void setPageSize(int pageSize) { this.pageSize=pageSize; } public Vector queryProduct(int pageCount) { Vector v=null; try{ v=ProductEntity.queryProduct(queryProductId,pageCount,this.pageSize); } catch(SQLException ex) { System.err.println(ex.getMessage()); } return v; } public void insertOrder()//insert intoDataBase { try { if(orderPrice==0) return; OrderEntity oe=new OrderEntity("null",userName,"null",Integer.toString(orderPrice)); //insert order orderId=oe.insertOrder(); //insert order items for(int i=0;i<orderItem.size();i++) { OrderItemEntity oi=(OrderItemEntity)orderItem.elementAt(i); oi.setOrderId(orderId); oi.insertOrderItem(); } } catch(SQLException ex) { System.err.println("InsertOrder executeQuery: " + ex.getMessage()); } //clear order variable orderItem.removeAllElements(); orderPrice=0; } public void addOrderItem(String productId,String productPrice)//add to Session private variables { for(int i=0;i<orderItem.size();i++) { OrderItemEntity oi=(OrderItemEntity)orderItem.elementAt(i); String pId=oi.getProductId(); if(pId.compareTo(productId)==0) { int num=Integer.parseInt(oi.getProductNum()); ++num; oi.setProductNum(Integer.toString(num)); this.orderPrice+=Integer.parseInt(productPrice); return; } } OrderItemEntity oiNew=new OrderItemEntity("null","null",productId,"1",Integer.parseInt(productPrice)); orderItem.add(oiNew); this.orderPrice+=Integer.parseInt(productPrice); } public void deleteOrderItem(String productId)//delete from Session private varibles { for(int i=0;i<orderItem.size();i++) { OrderItemEntity oi=(OrderItemEntity)orderItem.elementAt(i); String pId=oi.getProductId(); if(pId.compareTo(productId)==0) { int num=Integer.parseInt(oi.getProductNum()); --num; oi.setProductNum(Integer.toString(num)); if(num==0) orderItem.removeElementAt(i); this.orderPrice-=oi.getPrice(); return; } } } public Vector getOrderItem() { return orderItem; } public String getUserName() { return userName; } public void setQueryProductId(String queryProductId) { this.queryProductId=queryProductId; } public String getQueryProductId() { return queryProductId; } public String getOrderPrice() { return Integer.toString(orderPrice); } public String getOrderId() { return orderId; } }