enteraction.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.EnterForm;

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

			int enterno = ((EnterForm) form).getEnter_no();
			Date date = ((EnterForm) form).getDate();
			String name = ((EnterForm) form).getName();
			int spareno = ((EnterForm) form).getSpare_no();
			String sparename = ((EnterForm) form).getSpare_name();
			float price= ((EnterForm) form).getPrice();
			float quan = ((EnterForm) form).getQuan();
			String units = ((EnterForm) form).getUnits();
			String depname = ((EnterForm)form).getDep_name();
			String supname = ((EnterForm)form).getSup_name();
			int storeno = ((EnterForm)form).getStore_no();
			String spec = ((EnterForm)form).getSpare_spec();
			
			DBConnect dbc = null;
	        try{
	                dbc  = new DBConnect();
	                dbc.prepareStatement("INSERT INTO enter_sto_info ( enter_no,name,spare_no,spare_name,dep_name,quan,units,date,sup_name,price,store_no,spare_spec ) VALUES ( ?,?,?,?,?,?,?,?,?,?,?,? )");
	                dbc.setInt(1,enterno);
	                dbc.setString(2,name);
	                dbc.setInt(3,spareno);
	                dbc.setString(4,sparename);
	                dbc.setString(5,depname);
	                dbc.setFloat(6,quan);
	                dbc.setString(7,units);
	                dbc.setDate(8,date);
	                dbc.setString(9,supname);
	                dbc.setFloat(10,price);
	                dbc.setInt(11,storeno);
	                dbc.setString(12,spec);
	                dbc.executeUpdate();

	        }catch(Exception e){
	                System.err.println(e);
	                return mapping.findForward("error") ;
	        }finally{
	            try{
	                dbc.close();
	        }catch(Exception e){
	                e.printStackTrace();
	                }
	        }
	        try{
                dbc  = new DBConnect();
                dbc.prepareStatement("INSERT INTO store_info ( store_no,name,spare_no,spare_name,quan,units,date,sup_name,price,enter_no ) VALUES ( ?,?,?,?,?,?,?,?,?,? )");
                dbc.setInt(1,storeno);
                dbc.setString(2,name);
                dbc.setInt(3,spareno);
                dbc.setString(4,sparename);
                dbc.setFloat(5,quan);
                dbc.setString(6,units);
                dbc.setDate(7,date);
                dbc.setString(8,supname);
                dbc.setFloat(9,price);
                dbc.setInt(10,enterno);
                dbc.executeUpdate();

        }catch(Exception e){
                System.err.println(e);
                return mapping.findForward("error") ;
        }
        finally{
        try{
                dbc.close();
        }catch(Exception e){
                e.printStackTrace();
                }
	        
	        }return mapping.findForward("enter");
	}
}