planaction.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.PlanForm;

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

			int planno = ((PlanForm) form).getPlan_no();
			Date date = ((PlanForm) form).getDate();
			int spareno = ((PlanForm) form).getSpare_no();
			String sparename = ((PlanForm) form).getSpare_name();
			float quan = ((PlanForm) form).getQuan();
			String units = ((PlanForm) form).getUnits();
			String depname = ((PlanForm)form).getDep_name();
			String person = ((PlanForm)form).getPerson();
			String spec = ((PlanForm)form).getSpare_spec();
			int appno = ((PlanForm)form).getApp_no();
			DBConnect dbc = null;
	        try{
	                dbc = new DBConnect();
	                dbc.prepareStatement("INSERT INTO plan_info (plan_no,spare_no,spare_name,dep_name,quan,units,date,person,spare_spec ) VALUES ( ?,?,?,?,?,?,?,?,? )");
	                dbc.setInt(1,planno);	               
	                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.executeUpdate();
	                }catch (Exception e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		finally{
        try{
                dbc.close();
        }catch(Exception e){
                e.printStackTrace();
                }
        try{dbc = new DBConnect();
  	  dbc.prepareStatement("update order_applying_info set state=1 where applying_no = ?");
	  dbc.setInt(1,appno);
	  dbc.executeUpdate();          	
        }catch(Exception e1){
        	e1.printStackTrace();
        }finally{
        try{
                dbc.close();
        }catch(Exception e){
                e.printStackTrace();
                }
        }
	        }return mapping.findForward("plan");
	}
}