supplyaction.java

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

package com.haizi.struts.action;

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

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

			int supno = ((SupplyForm) form).getSup_no();
			String supname = ((SupplyForm) form).getSup_name();
			String credit = ((SupplyForm) form).getCredit();
			String address = ((SupplyForm)form).getAddress();
			String email = ((SupplyForm) form).getEmail();
			String phone = ((SupplyForm)form).getPhone();
			
			DBConnect dbc = null;
	        try{
	                dbc  = new DBConnect();
	                dbc.prepareStatement("INSERT INTO sup_info ( sup_no,sup_name,credit,address,email,phone ) VALUES ( ?,?,?,?,?,? )");
	                dbc.setInt(1,supno);
	                dbc.setString(2,supname);
	                dbc.setString(3,credit);
	                dbc.setString(4,address);
	                dbc.setString(5,email);
	                dbc.setString(6,phone);
	                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("supply");
	}

}