createtables.java

网络商店

package controller;

import javax.servlet.http.*;
import org.apache.struts.action.*;
import java.io.*;
import model.*;
import java.math.BigDecimal;

public class CreateTables extends Action {

  private final static String SUCCESS = "success";

  public ActionForward execute(ActionMapping mapping, ActionForm form,
          HttpServletRequest request, HttpServletResponse response)
          throws Exception {

    ActionMessages messages = new ActionMessages();
    ActionMessage msg;  
    
    msg = new ActionMessage("errors.detail", "create products table");
    messages.add("info", msg);
    ProductsBean.createTable();
    
    msg = new ActionMessage("errors.detail", "create orders table");
    messages.add("info", msg);
    OrdersBean.createTable();

    msg = new ActionMessage("errors.detail", "populate orders table");
    messages.add("info", msg);
    Product[] samples = {
      new Product("TDK CD-R 80min Printable", new BigDecimal(27.90)),
      new Product("HP 100-Pack 52x CD-R", new BigDecimal(19.99)),
      new Product("HP LightScribe 25-Pack CD-R", new BigDecimal(14.99)),
      new Product("Memorex 100-Pack CD-R", new BigDecimal(39.99)),
      new Product("TDK CD-R Printable 50pk", new BigDecimal(14.50)),
      new Product("Magnavox 100-Pack 52x CD-R", new BigDecimal(29.00)),
      new Product("TDK 10-Pack 24x CD-RW", new BigDecimal(29.99)),
    };
    for (Product p: samples) {
      ProductsBean.create(p);
    }

    saveMessages(request, messages);
    
    return mapping.findForward(SUCCESS);
  }
}