USERBEAN 调用的处理
package com.xinxi.model;
import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.Statement;
//封装对USERS表的操作
public class UserBeanCl {
//关闭资源函数
public void close(){
try{
if(rs!=null){rs.close();rs=null;
}
if(sm!=null){sm.close();sm=null;
}
if(ct!=null){ct.close();ct=null;
}
}catch(Exception ex){
ex.printStackTrace();
}
}
//
ResultSet rs=null;
Statement sm=null;
Connection ct=null;
public boolean CheckUser(String u,String p){
boolean b=false;
try{
ct=new ConnDB().getConn();
sm=ct.createStatement();
rs=sm.executeQuery("select top 1 passwd from users where username='"+u+"'");
if(rs.next())
{
if(rs.equals(p))
{
b=true;
}
}
}catch(Exception ex){
ex.printStackTrace();
}
finally{
this.close();
}
return b;
}
}