//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.ActionError;import org.apache.struts.action.ActionErrors;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.CreateProjectForm;/**  * MyEclipse Struts * Creation date: 11-14-2005 *  * XDoclet definition: * @struts:action path="/createProject" name="createProjectForm" input="/createProject.jsp" scope="request" validate="true" */public class CreateProjectAction 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) {		CreateProjectForm createProjectForm = (CreateProjectForm) form;		// TODO Auto-generated method stub		String id = createProjectForm.getNumber();		String content = createProjectForm.getContent();		if (this.createProject(id, content) != true) {			ActionErrors errors = new ActionErrors();			ActionError error2 = new ActionError("error2");			errors.add("number", error2);			if (!errors.isEmpty()) {				saveErrors(request, errors);				return mapping.getInputForward();			}		}		ArrayList al = this.getProjectList();		request.setAttribute("projectList", al);		return mapping.findForward("success");	}	private boolean createProject(String id, String content) {		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 s = "select count(*) from project where Id='"			+ id + "'";	rs = stat.executeQuery(s);	rs.next();	int count = rs.getInt(1);	if (count != 0) {		return false;	}	String sql = "insert into project values('" + id + "','"			+ content + "')";	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();			}		}		return true;	}		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;	}}