loginaction.java

来自「Eclipse+Struts+MYSQL的留言板,Struts开发入门程序Str」· Java 代码 · 共 81 行

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

package com.dimscar.struts.action;

import java.sql.ResultSet;
import java.sql.SQLException;

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.dimscar.struts.form.LoginForm;
import com.dimscar.util.ConnectionPool;
import com.dimscar.util.Constants;

/**
 * MyEclipse Struts Creation date: 11-09-2006
 * 
 * XDoclet definition:
 * 
 * @struts.action path="/login" name="loginForm" input="/form/login.jsp"
 *                scope="request" validate="true"
 */
public class LoginAction extends Action {

	/**
	 * Method execute
	 * 
	 * @param mapping
	 * @param form
	 * @param request
	 * @param response
	 * @return ActionForward
	 */
	public ActionForward execute(ActionMapping mapping, ActionForm form,
			HttpServletRequest request, HttpServletResponse response) {
		
		
		
		LoginForm loginForm = (LoginForm) form;
		
		
		//用户名
		String userId = loginForm.getUserId();
		
		//密码
		String password = loginForm.getPassword();
		
		//SQL
		String sql = "select * from user where userId='"+userId+"' and password='"+password+"'";
			
		//连接数据库
		ConnectionPool connpool = ConnectionPool.getInstance();
		
		//查找结果
		ResultSet rs = connpool.Query(sql);
		
		try {
			if(rs.next()){
				//如果存在,则把用户名和密码放到session里,然后再转入list.jsp查看留言簿所有列表
				request.getSession().setAttribute("userForm",loginForm);
				
				return mapping.findForward("loginSuccess");
			}else{
				//如果不存在,则返回login.jsp提示登录出错!
				request.setAttribute("error",Constants.LOGIN_ERROR);
				return mapping.findForward("loginError");
			}
		} catch (SQLException e) {
			e.printStackTrace();
		}
		return mapping.findForward("loginSuccess");
	}

}