orderdetailspeer.java

A JSP Based EShop for searching books and placing Orders

package eshop.model;

import java.util.Hashtable;
import java.util.Enumeration;
import java.sql.SQLException;
import java.sql.Statement;
import eshop.beans.CartItem;

public class OrderDetailsPeer {

  public static void insertOrderDetails(Statement stmt, long orderId,
      Hashtable shoppingCart) throws SQLException {
    String sql;
    Enumeration enumList = shoppingCart.elements();
    while (enumList.hasMoreElements()) {
      CartItem item = (CartItem)enumList.nextElement();
      sql = "insert into order_details (order_id, book_id, quantity,"
          + " price, title, author) values ('" + orderId + "','"
          + item.getBookID() + "','" + item.getQuantity() + "','"
          + item.getPrice() + "','" + item.getTitle() + "','"
          + item.getAuthor() + "')"
          ;
      stmt.executeUpdate(sql);
      }
    }
  }