cart.java

本例讲述了如何使用JSP技术编写在线商务沟通系统

package com;
import java.util.*;
import java.sql.*;

public class Cart {

	public Vector Wares; 
	private Connection con;

	public Cart() {
		Wares = new Vector();
	}
	public void setWares(String[] wares) {
		for(int i = 0;i < wares.length;i ++) {
			try {
				int one = Integer.parseInt(wares[i]);
				addWares(one);
			}
			catch(Exception e) {
			}
		}
	}
	public void setConnection(Connection con) {
		this.con = con;
	}

	public CartWares one(int index) {
		return (CartWares)Wares.elementAt(index);
	}
	public void addWares(int WaresId) {
		for(int i = 0;i < Wares.size();i ++) {
			if(one(i).getWaresId() ==WaresId)
				return; 
		}
		CartWares one= new CartWares ();
		if(one.setWares(WaresId,con))
			Wares.addElement(one);
	}


	public int getNumber() {
		return Wares.size();
	}

	public void deleteWares(int index) {
		if(index >= 0 && index < Wares.size())
			Wares.removeElementAt(index);
	}
	public void clearCart() {
		Wares.removeAllElements();
	}
   public String getSubDate(){
       return DateTime.getDateTime();
   }
 

	public int storeOrder(Hashtable paras,String UserName) {

		int total = 0;

		for(int i = 0;i < Wares.size();i ++){
			CartWares one = one(i);
			int WaresId = one.getWaresId();
			String NumStr = (String)paras.get("NumStr"+i);
			int Number= 0;
			if(NumStr != null && !NumStr.equals("")) {
				try {
					Number = Integer.parseInt(NumStr);
				}
				catch(Exception e) {
					return 1;
				}
				if(Number < 0)
					return 1;
				if(Number > 0) {
					total += Number;
					one.setNumber(Number);
				}
			}
		}

		if(total == 0)
			return 3;
		String date=DateTime.getDateTime();
		try {
			Statement stmt = con.createStatement();
	        String sql="insert into order(UserName,Status,SubTime) values('"+UserName+"',0,'"+date+"')"
			stmt.executeUpdate(sql);
            String sql2="select Id from order where where UserName='"+UserName+"'and  SubTime='"+date+"'"; 
			ResultSet rs= stmt.executeQuery(sql2);
			if(rs.next()) {
				int OrderId = rs.getInt("Id");
				for(int i = 0;i < Wares.size();i ++) {
					CartWares one = one(i);
					one.insert(OrderId,con);
				}
           String sql3="update order set Status=1 ";
           stmt.excuteUpdate(sql3);
			}
			rs.close();
			stmt.close();
		}
		catch(SQLException e) {

			DBLog.getLog().println(DateTime.getDateTime()+"   "+e.toString());
			return 2;
		}
		return 0;
	}
  public int storeUser(String UserName,
                       String RealName,
                       String Address,
                       String PostNumber,
                       String Phone,
                       String PayWay,
                       String TransWay,
                       String subdate) {
       try {
			Statement stmt = con.createStatement();
            String sql="select Email from user_info where UserName='"+UserName+"'';
            stmt.executeQuery(sql);
	        String sql2="insert into order(RealName,Email,Address,PostNumber,Phone,PayWay,TransWay) values('"+RealName+"','"+Email+"','"+Address+"','"+PostNumber+"','"+Phone+"','"+PayWay+"','"+TransWay+"')" where UserName='"+UserName+"'and  SubTime='"+SubDate+"'";
			Resultset rs=stmt.executeUpdate(sq2);
            String Email=rs.getString("Email");
            String sql3="update order set Status=2 where UserName='"+UserName+"'and  SubTime='"+SubDate+"'";
            stmt.executeUpdate(sql3);
		  }
		  catch(SQLException e) {

			DBLog.getLog().println(DateTime.getDateTime()+"   "+e.toString());
			return 1;
		  }
 		return 0; 
   }

}