udpateshowaction.java

基于j2ee中structs写软件

/*
 * Generated by MyEclipse Struts
 * Template path: templates/java/JavaClass.vtl
 */
package com.yourcompany.struts.action;

import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.Statement;

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

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.DAO.JobDAO;
import com.util.DB;

/**
 * MyEclipse Struts Creation date: 11-08-2008
 * 
 * XDoclet definition:
 * 
 * @struts.action scope="request" validate="true"
 */
public class UdpateshowAction extends Action {
	/*
	 * Generated Methods
	 */

	/**
	 * Method execute
	 * 
	 * @param mapping
	 * @param form
	 * @param request
	 * @param response
	 * @return ActionForward
	 */
	public ActionForward execute(ActionMapping mapping, ActionForm form,
			HttpServletRequest request, HttpServletResponse response) {
		// TODO Auto-generated method stub
		HttpSession session = request.getSession();
		String param = request.getParameter("urlParamName");
		String sql = "select * from news where jobId=" + param;
		DB db = new DB();
		try {
			Connection conn = db.getConnection();
			Statement sm = conn.createStatement();
			ResultSet rs = sm.executeQuery(sql);
			if (rs.next()) {
				JobDAO job = new JobDAO(String.valueOf(rs.getInt("jobId")), rs
						.getString("jobType"), rs.getString("jobName"), String
						.valueOf(rs.getInt("staffNum")), rs
						.getString("staffRequire"), rs.getString("startDate"),
						rs.getString("endDate"), rs.getString("relationInfo"));
				session.setAttribute("job", job);
			}
			conn.close();
		} catch (Exception e) {
		}
		return mapping.findForward("update");

	}
}