beanservlet.java

企业办公自动化管理系统

package swing;

import com.zh.conpool.Condata;
import java.io.Serializable;
import java.sql.ResultSet;

public class BeanServlet implements Serializable
{
        private String name="";
        private String dis="";
        private String sql="select * from tb_roes where perNam='";
        private String sqlend="'";
        Condata con=new Condata();
        ResultSet rs=null;

        public BeanServlet(){
          try{
            con.getConnection();
          }catch(Exception e){
          }
        }


        public String toUrl(String name){
                this.name=name;
                sql=sql+this.name+sqlend;
                try{
                        rs=con.executeQuery(sql);
                        if(rs.next()){
                                dis="Index2.jsp";
                        }else{
                                dis="Index.jsp";
                        }
                }catch(Exception e){

                }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;
                                  }
                }
                return dis;
          }
}