vendoraddaction.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.db.*;
import com.my.struts.form.VendorAddForm;

/**
 * MyEclipse Struts Creation date: 08-04-2006
 * 
 * XDoclet definition:
 * 
 * @struts.action path="/vendorAdd" name="vendorAddForm" scope="request"
 *                validate="true"
 */
public class VendorAddAction 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) {
		VendorAddForm f = (VendorAddForm) form;

		ConnOracle db = new ConnOracle();
		ResultSet rs = db
				.executeQuery("select * from table_vendor where vendor_name = '"
						+ f.getVendorName() + "'");
		try {
			if (rs.next()) {
				return mapping.findForward("vendorError");
			} else {
				String sql = "insert into table_vendor values(seq_vendor_id.nextval,'"
						+ f.getVendorName()
						+ "','"
						+ f.getVendorAddress()
						+ "','"
						+ f.getVendorPhone()
						+ "','"
						+ f.getVendorFax()
						+ "','" + f.getVendorContactPerson() + "')";
				// System.out.println(sql);
				db.executeUpdate(sql);
				return mapping.findForward("vendorMain");
			}
		} catch (SQLException e) {
			// TODO 自动生成 catch 块
			e.printStackTrace();
		}
		return mapping.findForward("vendorError");
	}

}