package com.liz;
import java.sql.*;
public class UserBeanCl
{
private Connection ct=null;
private Statement ps=null;
private ResultSet rs=null;
public boolean checkUser(String u,String p)
{
boolean b=false;
try {
ConnDB cd=new ConnDB();
try {
cd.getConn();
}
catch (Exception ex) {
System.out.println("没有连接");
}
try {
rs=ps.executeQuery("select top 1 password from [dbo].[user] where userId='"+u+"'");
}
catch (Exception ex) {
System.out.println("此处出错!!!");
} if(rs.next())
{
String dbpasswd=rs.getString(1);
if(dbpasswd.equals(p))
{
b=true;
}
}
}
catch (Exception ex) {
ex.printStackTrace();
} return b;
} }
只有本站会员才能查看附件,请 登录