applyingaction.java

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

//Created by MyEclipse Struts
// XSL source (default): platform:/plugin/com.genuitec.eclipse.cross.easystruts.eclipse_4.1.1/xslt/JavaClass.xsl

package com.haizi.struts.action;

import java.sql.*;

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.*;

/** 
 * MyEclipse Struts
 * Creation date: 06-16-2006
 * 
 * XDoclet definition:
 * @struts.action validate="true"
 */
public class ApplyingAction extends Action {

	// --------------------------------------------------------- Instance Variables

	// --------------------------------------------------------- Methods

	/** 
	 * Method execute
	 * @param mapping
	 * @param form
	 * @param request
	 * @param response
	 * @return ActionForward
	 */
	public ActionForward execute(
		ActionMapping mapping,
		ActionForm form,
		HttpServletRequest request,
		HttpServletResponse response) {

		int no = ((ApplyForm) form).getApplying_no();
		String username = ((ApplyForm) form).getUser_name();
		int spareno = ((ApplyForm) form).getSpare_no();
		String sparename = ((ApplyForm) form).getSpare_name();
		String spec = ((ApplyForm) form).getSpare_spec();
		float quan = ((ApplyForm) form).getQuan();
		String units = ((ApplyForm) form).getUnits();
		Date date = ((ApplyForm) form).getDate();
		
		DBConnect dbc = null;
        try{
                dbc  = new DBConnect();
                dbc.prepareStatement("INSERT INTO order_applying_info ( applying_no,user_name,spare_no,spare_name,spare_spec,quan,units,date ) VALUES ( ?,?,?,?,?,?,?,? )");
                dbc.setInt(1,no);
                dbc.setString(2,username);
                dbc.setInt(3,spareno);
                dbc.setString(4,sparename);
                dbc.setString(5,spec);
                dbc.setFloat(6,quan);
                dbc.setString(7,units);
                dbc.setDate(8,date);
                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("again");
}
	}