//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.SubmitForm;/** * MyEclipse Struts Creation date: 11-23-2005 *  * XDoclet definition: *  * @struts:action path="/submit" name="submitForm" input="/submit.jsp" *                scope="request" validate="true" */public class SubmitAction 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) {		SubmitForm submitForm = (SubmitForm) form;		// TODO Auto-generated method stub		String hidden = submitForm.getHidden();		String radio = submitForm.getRadio();		String name = (String) request.getSession().getAttribute("userName");		String id = submitForm.getId();		String stuname = submitForm.getStuname();		String text = submitForm.getText();		if (hidden != null) {			this.submit(id, stuname, text);			submitForm.setHidden(null);			return mapping.findForward("success");		}		ArrayList al = this.getProjectList(radio, name);		request.setAttribute("projectList", al);		return mapping.findForward("submit");	}	private ArrayList getProjectList(String radio, String name) {		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 where id='" + radio					+ "'";			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);				project.setName(name);				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;	}	private void submit(String id, String stuname, String text) {		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 content;			String sql = "select content from project where id='" + id + "'";			rs = stat.executeQuery(sql);			rs.next();			content = rs.getString(1);			sql = "select count(*) from submission where id='" + id					+ "' and stuname='" + stuname + "'";			rs = stat.executeQuery(sql);			rs.next();			int count = rs.getInt(1);			if (1 == count) {				sql = "update submission set text='" + text + "'where id='"						+ id + "' and stuname='" + stuname + "'";				stat.executeUpdate(sql);			} else {				sql = "insert into submission values('" + id + "','" + content						+ "','" + stuname + "','" + text + "')";				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();			}		}	}}