orderformbean.java

网上购物系统

package Model_OrderForm;
import DataBase.ConDataBase;
import Model_CartItem.*;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.util.Collection;
import java.util.HashMap;

public class OrderFormBean 
{
  public OrderFormBean()
  {
  }
  HashMap hm=new HashMap();
  public String InsertOrderForm(OrderForm of)
  {
    CartItem ci=new CartItem();
    String OrderID=of.getOrderID();
    String CustomerID=of.getCustomerID();
    String OrderDate=of.getOrderDate();
    String TotolMoney=of.getTotolMoney();
    String PayType=of.getPayType();
    String PayFlag=of.getPayFlag();
    String Flag=of.getFlag();
    
    Connection con=ConDataBase.getConnection();
    try{
      PreparedStatement ps=con.prepareStatement("insert into OrderForm values(?,?,?,?,?,?,?)");
      ps.setString(1,OrderID);
      ps.setString(2,CustomerID);
      ps.setString(3,OrderDate);
      ps.setString(4,TotolMoney);
      ps.setString(5,PayType);
      ps.setString(6,PayFlag);
      ps.setString(7,Flag);
      ps.executeUpdate();
      return "添加成功";
    }
    catch(Exception e)
    {
      System.out.println(e.getMessage());
      return null;
    }
  }
  
  public String InsertOrderFormList(OrderForm of)
  {
    String OrderID=of.getOrderID();
    String ItemID=of.getItemID();
    String Num=of.getNum();
    String Price=of.getPrice();
    
    Connection con=ConDataBase.getConnection();
    try{
      PreparedStatement ps=con.prepareStatement("insert into OrderFormList values(?,?,?,?)");
      ps.setString(1,OrderID);
      ps.setString(2,ItemID);
      ps.setString(3,Num);
      ps.setString(4,Price);
      ps.executeUpdate();
      return "添加成功";
    }
    catch(Exception e)
    {
      System.out.println(e.getMessage());
      return null;
    }
  }
}