studentloginaction.java

类似平时玩的魔方

//Created by MyEclipse Struts
// XSL source (default): platform:/plugin/com.genuitec.eclipse.cross.easystruts.eclipse_3.9.210/xslt/JavaClass.xsl

package com.yourcompany.struts.action;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.http.HttpSession;

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.form.StudentLoginForm;

/**
 * MyEclipse Struts Creation date: 11-14-2005
 * 
 * XDoclet definition:
 * 
 * @struts:action path="/studentLogin" name="studentLoginForm"
 *                input="/studentLogin.jsp" scope="request" validate="true"
 */
public class StudentLoginAction 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) {
		StudentLoginForm studentLoginForm = (StudentLoginForm) form;
		// TODO Auto-generated method stub
		String name = studentLoginForm.getName();
		String password = studentLoginForm.getPassword();
		if (this.checkUser(name, password) != true) {
			ActionErrors errors = new ActionErrors();
			ActionError error1 = new ActionError("error1");
			errors.add("name", error1);
			if (!errors.isEmpty()) {
				saveErrors(request, errors);
				return mapping.getInputForward();
			}
		}
		HttpSession hs = request.getSession();
		hs.setAttribute("userName", name);

		return mapping.findForward("success");

	}

	private boolean checkUser(String userName, String pwd) {
		boolean bl = false;
		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 count(*) from student where name='" + userName
					+ "' and password='" + pwd + "'";
			rs = stat.executeQuery(sql);
			rs.next();
			int count = rs.getInt(1);

			if (1 == count) {
				bl = true;
			}
		}

		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 bl;
	}

}