updatebillaction.java

本人制作的运用Struts技术的联系项目 员工管理系统

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

package com.my.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.my.struts.db.ConnOracle;

/**
 * MyEclipse Struts Creation date: 08-07-2006
 * 
 * XDoclet definition:
 * 
 * @struts.action input="billPayment.jsp" validate="true"
 */
public class UpdateBillAction 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) {

		ConnOracle db = new ConnOracle();

		try {
			String sql = "update table_bill set BILL_PAID_FLAG = 1 where BILL_ID ="
					+ request.getParameter("BILL_ID");
			db.executeUpdate(sql);
			db.close();

			// System.out.println(request.getParameter("VENDOR_ID"));
			// System.out.println(request.getParameter("VENDOR_NAME"));
			request
					.setAttribute("VENDOR_ID", request
							.getParameter("VENDOR_ID"));
			request.setAttribute("VENDOR_NAME", request
					.getParameter("VENDOR_NAME"));

			return mapping.findForward("billPayment");
		} catch (Exception e) {
			e.printStackTrace();
		}
		return mapping.findForward("searchVendorError");

	}

}