关于jsp连接到Access的问题
我在做一个用户登陆的页面的时候出现了问题,不知道如何解决,请各位帮忙
代码如下:
<%@ page contentType="html.text ; charest=gb2312" language="java" %>
<%@ page import="java.sql.*" %>
<% String url="jdbc:odbc:checkuser";
String driver="sun.jdbc.odbc.JdbcOdbcDriver";
Class.forName(driver);
Connection conn=DriverManager.getConnection(url);
Statement sqlStatement=conn.createStatement();
String sql="select*from table";
ResultSet rs=sqlStatement.executeQuery(sql);
String username=request.getParameter("username");
String password=request.getParameter("password");
String role="非会员";
while(rs.next())
{
if(username.equals(rs.getString("username"))&&password.equals(rs.getString("password")))
{
role=rs.getString("role");
}
}%>
<html>
<title>用户登陆</title>
<body>你是<%= role %>
</body>
</html>
我调试的时候发现是可以连接上数据库的,但是不能读取表。
错误提示如下:
javax.servlet.ServletException: [Microsoft][ODBC Microsoft Access Driver] FROM 子句语法错误。
org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:825)
org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:758)
org.apache.jsp.getin_jsp._jspService(getin_jsp.java:75)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:94)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:324)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:292)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:236)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)