//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.Submission;import com.yourcompany.struts.form.ShowSubmissionForm;/**  * MyEclipse Struts * Creation date: 11-24-2005 *  * XDoclet definition: * @struts:action path="/showSubmission" name="showSubmissionForm" scope="request" validate="true" */public class ShowSubmissionAction 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) {		ShowSubmissionForm showSubmissionForm = (ShowSubmissionForm) form;		// TODO Auto-generated method stub		ArrayList al = this.getSubmissionList();		request.setAttribute("submissionList", al);		return mapping.findForward("success");	}	private ArrayList getSubmissionList() {		ArrayList submissionList = 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 * from submission";			rs = stat.executeQuery(sql);			while (rs.next()) {				int id = rs.getInt(1);				String content = rs.getString(2);				String stuname = rs.getString(3);				String text = rs.getString(4);				Submission submission = new Submission();				submission.setId(id);				submission.setContent(content);				submission.setStuname(stuname);				submission.setText(text);				submissionList.add(submission);			}		} 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 submissionList;	}}