package elecstore;
import java.sql.*;
import java.sql.Date;
import java.text.*;
import java.util.*;
import javax.naming.*;
import javax.sql.*;
import elecstore.*;
public class UpdateBean {
 
 Products p = null;
 
 public int getPid() {
  return getPid();
  }
 
 public void setPid(int pid) {
  setPid(pid);
  }
 
 public String getProdId() {
  return getProdId();
  }
 
 public void setProdId (String prodId) {
  setProdId(prodId);
  }
 
 public String getProdType() {
  return getProdType();
  }
 
 public void setProdType (String prodType) {
  setProdType(prodType);
 }
 
 public String getMan() {
  return getMan();
  }
 
 public void setMan (String man) {
  setMan(man);
 }
 
 public String getProduct() {
  return getProduct();
  }
 
 public void setProduct (String product) {
  setProduct(product);
 }
 
 public int getQty() {
  return getQty();
  }
 
 public void setQty (int qty) {
  setQty(qty);
  }
 
 public String getPrice() {
  return getPrice();
  }
 
 public void setPrice (String price) {
  setPrice(price);
  }
 
 public Date getDateAdded() {
  return getDateAdded();
  }
 
 public void setDateAdded (Date dateAdded) {
  setDateAdded(dateAdded);
 }
 
 public boolean getStockOnOrder() {
  return getStockOnOrder();
  }
 
 public void setStockOnOrder (boolean stockOnOrder) {
  setStockOnOrder(stockOnOrder);
 }
 
 public UpdateBean() throws SQLException, NamingException
 {
  String jdbcDriver = "sun.jdbc.odbc.JdbcOdbcDriver";
     String dbURL = "jdbc:odbc:qc310";
     String user = "Lukas";
     String password = "12345";
 
  System.out.println("TEST HERE - UpdateBean");
  Connection con = null;
  Connection con2 = null;
                Statement select = null;
                PreparedStatement updateProduct = null;
                ResultSet rs = null;;
  ResultSet rs2 = null;
 
  try {
   System.out.println("TEST HERE - making database connection...");
   // Load in the JDBC-ODBC driver
                        Class.forName(jdbcDriver);
 
                        // Create connection
                        con = DriverManager.getConnection(dbURL, user, password);
                        System.out.println("\n...Connection to Electronic Store Database Established\n");
                        System.out.println("TEST HERE - database connection ok...");
 
                        Statement stmt = con.createStatement();
                        System.out.println("SQL Statement created...");
   rs = stmt.executeQuery("SELECT * FROM Elecstore");
 
 
      while (rs.next()) { 
 
                        p = new Products(rs.getInt(1),
                                         rs.getString(2), 
                                         rs.getString(3), 
                                         rs.getString(4), 
                                         rs.getString(5), 
                                         rs.getInt(6), 
                                         rs.getString(7), 
                                         rs.getDate(8), 
                                         rs.getBoolean(9));  
 
         System.out.println(p.getPid() + " " + p.getProdId() + "\t" + p.getProdType() + "\t\t" + p.getMan() + "\t\t" + p.getProduct() + "\t\t\t" + p.getPrice() + "\t\t\t" + p.getQty() + "\t\t\t" + p.getDateAdded() + "\t\t\t" + p.getStockOnOrder());
                        }
                        rs.close();  
 
  }
 
  catch(Exception e) {
   e.printStackTrace();;
   }
 
 
  try {
 
   Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
   con2 = DriverManager.getConnection("jdbc:odbc:qc310");
   updateProduct = con.prepareStatement("UPDATE Elecstore SET Qty = ?, Price = ? WHERE ProductID = ?");
 
    updateProduct.setInt (1, p.getQty());
    updateProduct.setString (2, p.getPrice());
    updateProduct.setString (3, p.getProdId());
 
    updateProduct.executeUpdate();
 
   if (!rs2.next())
    throw new SQLException("Missing Products data row");
 
  }
 
  catch(Exception e) {
   System.out.println(e);
  }
 
  finally {
   try { rs.close(); } catch (Exception ex) {}
   try { con.close(); } catch (Exception ex) {}
  }
 }
}

package elecstore;
import java.sql.Date;
 
/**
 * This domain object represents a player in a sports league.
 * The data attributes are all package-private to allow access to them
 * in the {@link RegisterService} class.
 */
public class Products {
  int pid;
  int qty;
  String prodId;
  String prodType;
  String man;
  String product;
  String price;
  Date dateAdded;
  boolean stockOnOrder;
 
  /**
   * This is the constructor.  It is package-private to prevent
   * misuse.  The {@link RegisterServer} method should be used to
   * create a new player object.
   */
  //Product(String prodID) {
  //  this(+1, "", prodID, "", "", "", "");
  //}
  /**
   * This is the full constructor.
   */
 
   Products(int pid, String prodId, String prodType, String man,
         String product, int qty, String price, Date dateAdded, boolean stockOnOrder) {
 
    this.pid = pid;
    this.prodId = prodId;
    this.prodType = prodType;
    this.man = man;
    this.product = product;
    this.qty = qty;
    this.price = price;
    this.dateAdded = dateAdded;
    this.stockOnOrder = stockOnOrder;
  }
  public int getQty() {
  return qty;
   }
 
  public void setQty(int qty){
 this.qty = qty;
 }
 
  public int getPid() {
 return pid;
   }
 
  public void setPid(int pid){
 this.pid = pid;
 }
 
  public String getProdId() {
 return prodId;
   }
 
  public void setProdId(String prodId){
 this.prodId = prodId;
 }
 
  public String getProdType(){
 return prodType;
 }
 
  public void setProdType(){
 this.prodType = prodType;
 }
 
  public String getMan(){
 return man;
 }
  public void setMan(String man){
 this.man = man;
 }
  public String getProduct(){
 return product;
 }
  public void setProduct(String product){
 this.product = product;
 }
 
  public String getPrice(){
 return price;
   }
 
  public void setPrice(String price){
 this.price = price;
 }
  public Date getDateAdded() {
  return dateAdded;
   }
 
  public void setDateAdded(Date dateAdded){
 this.dateAdded = dateAdded;
 }
  public boolean getStockOnOrder() {
  return stockOnOrder;
   }
 
  public void setStockOnOrder(boolean stockOnOrder){
 this.stockOnOrder = stockOnOrder;
 }
}

package elecstore;
import java.io.*;
import java.sql.*;
import java.text.*;
import javax.naming.*;
import javax.servlet.*;
import javax.servlet.http.*;
import org.apache.struts.action.*;
import elecstore.*;
import elecstore.UpdateBean;
public class ActionUpdate extends Action
{
 public ActionForward perform(ActionMapping mapping, ActionForm actionForm,
   HttpServletRequest request, HttpServletResponse response)
   throws IOException, ServletException {
 
  ActionErrors errors = null;
  try {
   UpdateBean update = new UpdateBean();
   UpdateForm form = (UpdateForm)actionForm;
 
   System.out.println(form.getProdId());
   update.setProdId(form.getProdId());
 
   System.out.println(form.getQty());
   update.setQty(form.getQty());
 
   System.out.println(form.getPrice());
   update.setPrice(form.getPrice());
 
   request.setAttribute("prodId",update.getProdId());
   request.setAttribute("qty", new Integer(update.getQty()));
   request.setAttribute("price",update.getPrice());
      return mapping.findForward("update");
  }
 
  catch (NamingException ex) {
         errors = new ActionErrors();
            errors.add("database", new ActionError("errors.naming.error"));
  }
  catch (SQLException ex) {
         errors = new ActionErrors();
            errors.add("database", new ActionError("errors.database.error"));
  }
  catch (Exception e) {
   System.out.println("AN OTHER" + e);
  }
  saveErrors(request,errors);
  return mapping.findForward("error");
 }
}

package elecstore;
import javax.servlet.http.*;
import org.apache.struts.action.*;
public class UpdateForm extends ActionForm {
    private String prodId;
    private String price;
    private int qty;
 
 public void setProdId (String prodId) { this.prodId = prodId; }
 public String getProdId () { return prodId; }
 
 public void setPrice (String price) { this.price = price; }
 public String getPrice () { return price; }
 public void setQty (int qty) { this.qty = qty; }
 public int getQty () { return qty; }
 public void reset(ActionMapping mapping, HttpServletRequest request) {
    prodId = null;
 price = null;
 qty = 0;
    }
 public ActionErrors validate(ActionMapping mapping,
                                 HttpServletRequest request) {
 
        ActionErrors errors = new ActionErrors();
        if (prodId == null)
            errors.add("prodId", new ActionError("errors.prodId.required"));
 
  else if (prodId.length() == 0)
             errors.add("prodId", new ActionError("errors.prodId.novalue"));
  else if (price == null)
       errors.add("price", new ActionError("errors.price.required"));
 
  else if (price.length() == 0)
              errors.add("price", new ActionError("errors.price.novalue"));
 
  else if (qty == 0)
       errors.add("qty", new ActionError("errors.qty.required"));
 
  return errors;
  }
 
 }