handlerauthen.java

一个自制的DB framework,使用的配置方式新颖

package bits;
import 	javax.servlet.*;
import 	javax.servlet.http.*;
import 	java.util.*;
import 	java.sql.*;
public class HandlerAuthen implements IHandle
{
  
	  public void handle(DBconnection conn,
	                     String strSQL,
	                     HttpServletRequest request )
	  {  		
	    int result=-1;
		  try 
		  {	 		   
	  		String strPWD=request.getParameter("c");
	  		if(strPWD==null)
	  		{
	  			strPWD=(String)request.getAttribute("c");
	  		}
	  		  Statement stResult=conn.execute(strSQL);	  	
	  			ResultSet rs1=stResult.getResultSet();
	        if(rs1.next())
	        {	
	          	 String strTemp=rs1.getString("users_pwd");
	          	 if(strPWD.equals(strTemp))
	          	 {
	          	
	          	 	result=0;    
				    request.setAttribute("applications",stResult);                                
	          	 }
	          	 else
	          	 {
	          	 	result=1;    
	          	 }      	 
	         }
	         else
	         {
	          	result=2;      
	         } 
	  		 	request.setAttribute("result",new Integer(result));
	      }
	      catch (Exception ex)
		    {
		      System.out.println(ex);
		    }	  		
	  }
}