loginaction.java

这个程序是花了好几十万请人开发的

package struts.action;

import java.sql.ResultSet;

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.ActionForm;
import org.apache.struts.action.ActionForward;
import org.apache.struts.action.ActionMapping;

import struts.form.LoginForm;
import javabean.dbconnect;


public class LoginAction extends Action {


	public ActionForward execute(
		ActionMapping mapping,
		ActionForm form,
		HttpServletRequest request,
		HttpServletResponse response)
		throws Exception {
		
		HttpSession session=request.getSession();	
		LoginForm loginForm = (LoginForm) form;
		
		//String uid=(String)request.getAttribute("uid");
		//String pwd=(String)request.getAttribute("pwd");
		//if(uid==null||uid=="")
		//{
		  String uid=loginForm.getUid();
		  String pwd=loginForm.getPwd();
		//}

		dbconnect db=new dbconnect();
		
		int count=0;

		String sql="select * from USERTABLE where UUID='"+uid+"'";
		String sql1="select TIMES from MEMBER where UUID='"+uid+"'";
		ResultSet rs=db.executeQuery(sql);
		ResultSet rs1=db.executeQuery(sql1);
		String password="";
		String rname="";
		String sex="";
		String grant="";
		int times=0;
		
		try
		{
		   if(rs.next())
		  {
			  count++;
			  password=rs.getString("PWD").trim();
			  rname=rs.getString("RNAME");
			  sex=rs.getString("SEX");
			  grant=rs.getString("GRANTS");			  
		  }
		  rs.close();
		}
		catch(Exception e)
		{
			e.printStackTrace();
		}
		
		try
		{
		   if(rs1.next())
		  {
			times=rs1.getInt("TIMES");		  
		  }
		  rs1.close();
		}
		catch(Exception e)
		{
			e.printStackTrace();
		}
		
		if(count==1&&password.equals(pwd))
		{
			session.setAttribute("uid",uid);
			session.setAttribute("rname",rname);
			session.setAttribute("sex",sex);
			session.setAttribute("grant",grant);
			session.setAttribute("times",String.valueOf(times));
			
			sql="update MEMBER set TIMES=TIMES+1 where UUID='"+uid+"'";
			ResultSet rs2=db.executeQuery(sql);
			return (mapping.findForward("success"));
		}
		else
		return new ActionForward(mapping.getInput());
		
	}

}