top_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.Top_loginForm;
import javabean.dbconnect;


public class Top_loginAction extends Action {


	public ActionForward execute(
		ActionMapping mapping,
		ActionForm form,
		HttpServletRequest request,
		HttpServletResponse response)
		throws Exception {
			
		HttpSession session=request.getSession();
		Top_loginForm indexForm = (Top_loginForm) form;
		String uid=indexForm.getUid();
		   uid=new String(uid.getBytes("ISO-8859-1"));
		String pwd=indexForm.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="";
		int times=0;
		String grant="";
		
		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("tlogin"));
		}
		else
		return new ActionForward(mapping.getInput());
		
	}

}