deptaddaction.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.ResultSet;
import java.sql.SQLException;

import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import org.apache.struts.action.Action;
import org.apache.struts.action.ActionError;
import org.apache.struts.action.ActionErrors;
import org.apache.struts.action.ActionForm;
import org.apache.struts.action.ActionForward;
import org.apache.struts.action.ActionMapping;

import com.my.struts.form.DeptaddForm;

import com.my.struts.db.ConnOracle;

/**
 * MyEclipse Struts Creation date: 08-03-2006
 * 
 * XDoclet definition:
 * 
 * @struts.action path="/deptadd" name="deptaddForm" input="/departmentAdd.jsp"
 *                validate="true"
 */
public class DeptaddAction extends Action {

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

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

	/**
	 * Method execute
	 * 
	 * @param mapping
	 * @param form
	 * @param request
	 * @param response
	 * @return ActionForward
	 * @throws SQLException
	 */
	@SuppressWarnings("deprecation")
	public ActionForward execute(ActionMapping mapping, ActionForm form,
			HttpServletRequest request, HttpServletResponse response)
			throws SQLException {
		DeptaddForm deptaddForm = (DeptaddForm) form;
		ConnOracle conn = new ConnOracle();
		ResultSet rs = null;
		// String sql1="select * from table_dept where
		// dept_name='"+deptaddForm.getDeptname()+"'";
		// ResultSet rs=conn.executeQuery(sql1);
		// if(rs.next()){
		// ActionErrors errors = deptaddForm.validate(mapping, request);
		// errors.add("check", new ActionError("have been exsite"));
		// addErrors(request, errors);
		// rs.close();
		// conn.close();
		// return mapping.findForward("departmentAdd");
		// }
		// else {
		rs = conn.executeQuery("select count(*) from table_dept");
		rs.next();
		int number = rs.getInt(1) + 1;

		String sql = "insert into table_dept values('" + number + "','"
				+ deptaddForm.getDeptname() + "','"
				+ deptaddForm.getDeptdescription() + "')";
		int i = conn.executeUpdate(sql);
		rs.close();
		conn.close();
		return mapping.findForward("departmentMain");
	}

}