rousservlet.java

企业办公自动化管理系统

package swing;

import javax.servlet.*;
import javax.servlet.http.*;
import java.io.*;
import java.util.*;
import com.zh.conpool.Condata;
import java.sql.ResultSet;

public class RousServlet extends HttpServlet {

	Condata con=new Condata();

  public RousServlet(){
  	
  	try{
  		con.getConnection();
  	}catch(Exception e){
  		e.getStackTrace();
  	}
  }
  
  public void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
  	
  	ResultSet rs=null;
  	String name="";
  	String sql="select * from tb_roes where perNam='";
  	String dispatcher="";
  	request.setCharacterEncoding("gb2312");
  	
  	try{
	  	name=request.getParameter("name");
	  	if(name!=null){
		    try{
		  		sql=sql+name+"'";
		  		rs=con.executeQuery(sql);
		  		if(rs.next()){
		  			dispatcher="roes/Index2.jsp";
		  		}else{
		  			dispatcher="roes/Index.jsp";
		  		}
		  	}catch(Exception e){
		  		e.getMessage();
		  	}finally{
		  		try{
		  			if(rs!=null){
		  				rs.close();
		  				rs=null;
		  			}
		  		}catch(Exception ee){
		  			rs=null;
		  		}
		  		try{
		  			if(con!=null){
		  				con.close();
		  				con=null;
		  			}
		  		}catch(Exception eee){
		  			con=null;
		  		}
	  		}
	
	  	}
	  
	  	RequestDispatcher requestDis=request.getRequestDispatcher(dispatcher);
	  	requestDis.forward(request,response);
	  }catch(Exception eeee){
	  	eeee.printStackTrace();
	  }
  }
  
  public void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
    doPost(request, response);
  }
}