spareaction.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.ApplyForm;
import com.haizi.struts.formbean.SpareForm;

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

			int spareno = ((SpareForm) form).getSpare_no();
			String sparename = ((SpareForm) form).getSpare_name();
			String spec = ((SpareForm) form).getSpare_spec();
			String units = ((SpareForm) form).getUnits();
			
			DBConnect dbc = null;
	        try{
	                dbc  = new DBConnect();
	                dbc.prepareStatement("INSERT INTO spare_info (spare_no,spare_name,spare_spec,units) VALUES (?,?,?,?)");
	                dbc.setInt(1,spareno);
	                dbc.setString(2,sparename);
	                dbc.setString(3,spec);
	                dbc.setString(4,units);
	                dbc.executeUpdate();
	        }catch(Exception e){
	                System.err.println(e);
	                return mapping.findForward("error1") ;
	        }finally{
	        try{
	                dbc.close();
	        }catch(Exception e){
	                e.printStackTrace();
	                }
	        }return mapping.findForward("spare");
	}
}