你语法有问题吧?是什么表?应该是这样的吧!
SELECT * FROM ??? WHERE username = "xxx" and passwd= "xxx" JSP中可以访问SELECT的结果集吗?我没用过JSP:),可以这样试
SELECT COUNT(*) FROM ??? WHERE username = "xxx" and passwd = "xxx"
如果结果集为0表示没记录
SELECT * FROM ??? WHERE username = "xxx" and passwd= "xxx" JSP中可以访问SELECT的结果集吗?我没用过JSP:),可以这样试
SELECT COUNT(*) FROM ??? WHERE username = "xxx" and passwd = "xxx"
如果结果集为0表示没记录
String sql=select * from 表名 where username='xxxx' and passwd='xxx'";
Statement stmt =conn.createStatement();
ResultSet rs=stmt.executeQuery(sql);
if(rs.next())
{
out.println("YES");
}
else
{
out.println("NO");
}
给分给分!