orderaction.java

利用当前管理信息系统科学的、实用的理论

package com.haizi.struts.action;

import java.sql.Date;

import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import org.apache.struts.action.Action;
import org.apache.struts.action.ActionForm;
import org.apache.struts.action.ActionForward;
import org.apache.struts.action.ActionMapping;

import com.haizi.struts.datebase.DBConnect;
import com.haizi.struts.formbean.OrderForm;

public class OrderAction extends Action {
	public ActionForward execute(
			ActionMapping mapping,
			ActionForm form,
			HttpServletRequest request,
			HttpServletResponse response) {

			int conno = ((OrderForm) form).getCon_no();
			Date date = ((OrderForm) form).getDate();
			int spareno = ((OrderForm) form).getSpare_no();
			String sparename = ((OrderForm) form).getSpare_name();
			float quan = ((OrderForm) form).getQuan();
			String units = ((OrderForm) form).getUnits();
			String depname = ((OrderForm)form).getDep_name();
			String person = ((OrderForm)form).getPerson();
			String spec = ((OrderForm)form).getSpare_spec();
			float price = ((OrderForm)form).getPrice();
			String memo = ((OrderForm)form).getCon_memo();
			int planno = ((OrderForm)form).getPlan_no();
			DBConnect dbc = null;
	        try{
	                dbc = new DBConnect();
	                dbc.prepareStatement("INSERT INTO con_info (con_no,spare_no,spare_name,dep_name,quan,units,date,person,spare_spec,memo,price ) VALUES ( ?,?,?,?,?,?,?,?,? )");
	                dbc.setInt(1,conno);	               
	                dbc.setInt(2,spareno);
	                dbc.setString(3,sparename);
	                dbc.setString(4,depname);
	                dbc.setFloat(5,quan);
	                dbc.setString(6,units);
	                dbc.setDate(7,date);
	                dbc.setString(8,person);
	                dbc.setString(9,spec);
	                dbc.setString(10,memo);
	                dbc.setFloat(11,price);
	                dbc.executeUpdate();

	        }catch(Exception e){
	                System.err.println(e);
	                return mapping.findForward("error") ;	        	   
        }
	      try{
	    	  dbc = new DBConnect();
	    	  dbc.prepareStatement("update plan_info set state=`1` where applying_no = "+planno);
	    	  dbc.executeUpdate();    
	      } catch (Exception e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		} 
		finally{
        try{
                dbc.close();
        }catch(Exception e){
                e.printStackTrace();
                }
	        
	        }return mapping.findForward("order");
	}
}