//Created by MyEclipse Struts// XSL source (default): platform:/plugin/com.genuitec.eclipse.cross.easystruts.eclipse_3.9.210/xslt/JavaClass.xslpackage 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;	}}