【Java开源代码栏目提醒】:网学会员鉴于大家对Java开源代码十分关注,论文会员在此为大家搜集整理了“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;
}
}