package product.action;
import product.db.*;
import java.sql.*;
import javax.servlet.http.*;
import org.apache.struts.action.*;



public class AddAction extends Action{
   
 public ActionForward execute(ActionMapping mapping,ActionForm form,
        	HttpServletRequest request,HttpServletResponse response)
        	throws Exception 
    {	
    	Connection con = null;
    	Statement stmt = null;
    	String target = "failure";
    	String sql = "";
    	String name = request.getParameter("name");
    	String size = request.getParameter("size");
    	String unit = request.getParameter("unit");
    	String content = request.getParameter("content");
    	String product_factory = request.getParameter("product_factory");
    	String product_supply = request.getParameter("product_supply");
    	String color = request.getParameter("color");
    	String price_in = request.getParameter("price_in");
    	String price_agent = request.getParameter("price_agent");
    	String price_sale = request.getParameter("price_sale");
    	String price_detail = request.getParameter("price_detail");
    	String specification = request.getParameter("specification");
    	String note = request.getParameter("note");
    	sql = "insert into product(name,size,unit,content,product_factory,product_supply,"+
    	       "color,price_in,price_agent,price_sale,price_detail,specification,note,createDay)values('"+
    	       name+"','"+size+"','"+unit+"','"+content+"','"+product_factory+"','"+
    	       product_supply+"','"+color+"','"+price_in+"','"+price_agent+"','"+
    	       price_sale+"','"+price_detail+"','"+specification+"','"+note+"',now())";
    	System.out.println(sql);
    			 
         try{
         	  con = DatabaseConnection.getConnection();
         	  stmt = con.createStatement();
         	  if(stmt.executeUpdate(sql)==1)
     			target="success";
         	}catch(Exception e){e.printStackTrace();
         }
         	finally{
			try{
				if(con!=null){
					con.close();
				}
			}catch(Exception e2){}
		}       
	   return mapping.findForward(target);
	}
    	
 }