loginaction.java

利用当前管理信息系统科学的、实用的理论

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

package com.haizi.struts.action;

import java.sql.ResultSet;

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.haizi.struts.datebase.*;
/** 
 * MyEclipse Struts
 * Creation date: 06-11-2006
 * 
 * XDoclet definition:
 * @struts.action validate="true"
 */
public class LoginAction extends Action {

	// --------------------------------------------------------- Instance Variables

	// --------------------------------------------------------- Methods

	/** 
	 * Method execute
	 * @param mapping
	 * @param form
	 * @param request
	 * @param response
	 * @return ActionForward
	 */
	public ResultSet rs;
	
	public ActionForward execute(
		ActionMapping mapping,
		ActionForm form,
		HttpServletRequest request,
		HttpServletResponse response) {
		String password =((LoginForm) form).getPassword();
		String name = ((LoginForm) form).getName();
		
		DBConnect dbc = null;
		try{
			dbc  = new DBConnect();
			dbc.prepareStatement("SELECT * FROM user_info WHERE name = ? and password = ?");
			dbc.setString(1,name);
			dbc.setString(2,password);
			rs = dbc.executeQuery();
			if(!rs.next()){
				return mapping.findForward("error1");
			}
		}catch(Exception e){
			return mapping.findForward("error1");
		}finally{
			try{
				dbc.close();
			}catch(Exception e){
				e.printStackTrace();
			}
		}
		return mapping.findForward("success");
	} 
}