logonaction.java

struts 登陆的小例子,包括密码验证

/*
 * Generated by MyEclipse Struts
 * Template path: templates/java/JavaClass.vtl
 */
package com.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.DBbase;
import com.struts.form.LogonForm;

/** 
 * MyEclipse Struts
 * Creation date: 07-13-2007
 * 
 * XDoclet definition:
 * @struts.action path="/logon" name="logonForm" input="/logon.jsp" scope="request" validate="true"
 */
public class LogonAction extends Action {
	/*
	 * Generated Methods
	 */

	/** 
	 * Method execute
	 * @param mapping
	 * @param form
	 * @param request
	 * @param response
	 * @return ActionForward
	 */
	public ActionForward execute(ActionMapping mapping, ActionForm form,
			HttpServletRequest request, HttpServletResponse response) {
         //接收ActionForm中的数据
		    LogonForm logonForm = (LogonForm) form;
		    String name=logonForm.getName();
		    String password=logonForm.getPassword();
		 //验证数据库中纪录
		DBbase bb=new DBbase();
		ResultSet rr=null;
		int num=0;
		String sql="select count(*) as count  from usertt where name= '"+name+ "' and password= '"+password+"' "; 
		rr=bb.executeQuery(sql);
		try {
			if(rr.next()){
				num=rr.getInt("count");
			}
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		
		if(num>0)
		{
			request.setAttribute("name", name);//传值
			return mapping.findForward("ok");
		}else
		{
			return mapping.findForward("fail");
		}
		
	}
}