我用的是TomCat,请大侠们帮我看看这段调用access数据库的jsp程序那里错了!每次都提示“From字句语法错误”!
我用的是TomCat,请大侠们帮我看看这段调用access数据库的jsp程序那里错了!每次都提示“From字句语法错误”!
<%@page import="java.sql.*" contentType="text/html;charset=gb2312"%>
<%!
String status = null;
%>
<%
status = request.getParameter("comm");
Connection connection = null;
Statement statement = null;
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
connection = DriverManager.getConnection("jdbc:odbc:text");
statement = connection.createStatement();
ResultSet rs = statement.executeQuery("SELECT * FROM text");
rs.next();
out.println(rs.getString("name"));
%>
ODBC中设置的数据源名字为"text",只有一个表,名字为"text".