javax.servlet.ServletException: [Microsoft][ODBC Microsoft Access 驱动程序]COUNT 字段不正确
我的数据库表里没有COUNT字段啊
DNS:guestbook
表user:name,password,oicq,e-mail,user_id
代码如下:<%@ page import="java.sql.*" %>
<% Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection conn=null;
ResultSet rs=null;
String NAME=request.getParameter("name");
String PSW=request.getParameter("password");
String sql="select * from user where name="+NAME+" "+" and password="+PSW+"";
conn=DriverManager.getConnection("jdbc:odbc:guestbook");
Statement stmt=conn.createStatement();
rs=stmt.executeQuery(sql);
while(rs.next())
{
out.println("测试成功");
}
%>
我的数据库表里没有COUNT字段啊
DNS:guestbook
表user:name,password,oicq,e-mail,user_id
代码如下:<%@ page import="java.sql.*" %>
<% Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection conn=null;
ResultSet rs=null;
String NAME=request.getParameter("name");
String PSW=request.getParameter("password");
String sql="select * from user where name="+NAME+" "+" and password="+PSW+"";
conn=DriverManager.getConnection("jdbc:odbc:guestbook");
Statement stmt=conn.createStatement();
rs=stmt.executeQuery(sql);
while(rs.next())
{
out.println("测试成功");
}
%>
改一下试试