sreachvendornameaction.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 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.my.struts.form.SearchVendorNameForm;

import com.my.struts.db.ConnOracle;

/**
 * MyEclipse Struts Creation date: 08-07-2006
 * 
 * XDoclet definition:
 * 
 * @struts.action validate="true"
 */
public class SreachVendorNameAction 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();
		SearchVendorNameForm f = (SearchVendorNameForm) form;

		try {
			String sql = "select * from table_vendor where vendor_name='"
					+ f.getVendorName() + "'";
			ResultSet rs = db.executeQuery(sql);
			if (rs.next()) {
				request.setAttribute("VENDOR_ID", rs.getString(1));
				request.setAttribute("VENDOR_NAME", rs.getString(2));
				return mapping.findForward("billPayment");
			} else {
				return mapping.findForward("searchVendorError");
			}
		} catch (Exception e) {
			e.printStackTrace();
		}
		return mapping.findForward("searchVendorError");
	}

}