closeprojectaction.java

类似平时玩的魔方

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

package com.yourcompany.struts.action;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;
import java.util.ArrayList;

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.yourcompany.struts.Project;
import com.yourcompany.struts.form.CloseProjectForm;

/** 
 * MyEclipse Struts
 * Creation date: 11-14-2005
 * 
 * XDoclet definition:
 * @struts:action path="/closeProject" name="closeProjectForm" input="/closeProject.jsp" scope="request" validate="true"
 * @struts:action-forward name="delete" path="/createProject.jsp"
 * @struts:action-forward name="success" path="/sList.jsp"
 */
public class CloseProjectAction 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) {
		CloseProjectForm closeProjectForm = (CloseProjectForm) form;
		// TODO Auto-generated method stub
		String hidden = closeProjectForm.getHidden();
		String radio = closeProjectForm.getRadio();
		if(hidden != null) {
			this.closeProject(radio);
			closeProjectForm.setHidden(null);
			ArrayList al = this.getProjectList();
			request.setAttribute("projectList", al);
			return mapping.findForward("success");
		}
		ArrayList al = this.getProjectList();
		request.setAttribute("projectList", al);
		return mapping.findForward("delete");
	}

	private void closeProject(String radio) {
		String mySQLURL = "jdbc:mysql://127.0.0.1:3306/cose";
		String mySQLDriverName = "org.gjt.mm.mysql.Driver";
		Connection conn = null;
		Statement stat = null;
		ResultSet rs = null;

		try {
			Class.forName(mySQLDriverName).newInstance();
			conn = DriverManager.getConnection(mySQLURL, "root", "root");
			stat = conn.createStatement();
			String sql = "delete from project where Id='" + radio + "'";
			stat.executeUpdate(sql);

		} catch (Exception e) {
			e.printStackTrace();
		} finally {
			try {
				if (rs != null)
					rs.close();
				if (stat != null)
					stat.close();
				if (conn != null)
					conn.close();
			} catch (Exception e) {
				e.printStackTrace();
			}

		}
		
	}
	
	private ArrayList getProjectList() {
		ArrayList projectList = new ArrayList();
		String mySQLURL = "jdbc:mysql://127.0.0.1:3306/cose";
		String mySQLDriverName = "org.gjt.mm.mysql.Driver";
		Connection conn = null;
		Statement stat = null;
		ResultSet rs = null;

		try {
			Class.forName(mySQLDriverName).newInstance();
			conn = DriverManager.getConnection(mySQLURL, "root", "root");
			stat = conn.createStatement();
			String sql = "select id, content from project";
			rs = stat.executeQuery(sql);
			while (rs.next()) {
				int id = rs.getInt(1);
				String content = rs.getString(2);
				Project project = new Project();
				project.setId(id);
				project.setContent(content);
				projectList.add(project);

			}

		} catch (Exception e) {
			e.printStackTrace();
		} finally {
			try {
				if (rs != null)
					rs.close();
				if (stat != null)
					stat.close();
				if (conn != null)
					conn.close();
			} catch (Exception e) {
				e.printStackTrace();
			}

		}
		return projectList;
	}

}