//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.ShowListForm;/** * MyEclipse Struts Creation date: 11-14-2005 *  * XDoclet definition: *  * @struts:action path="/showList" name="showListForm" scope="request" *                validate="true" */public class ShowListAction 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) {		ShowListForm showListForm = (ShowListForm) form;		// TODO Auto-generated method stub		ArrayList al = this.getProjectList();		request.setAttribute("projectList", al);		String userName = (String) request.getSession()				.getAttribute("userName");		if (userName == null)			return mapping.findForward("success");		return mapping.findForward("student");	}	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;	}}