这个ODBC查询有错吗?运行不出来啊
<%@ page language="java" import="java.sql.*" pageEncoding="gb2312" %><html>
<body>
<%
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection conn=DriverManager.getConnection("jdbc:odbc:DSSchool");
Statement stat=conn.createStatement();
String sql="select ID,NAME,PRICE FROM BOOK ";
ResultSet rs =stat.executeQuery(sql);
while(rs.next()){
String ID=rs.getString("ID");
String NAME=rs.getString("NAME");
String PRICE=rs.getString("PRICE");
out.println(ID+" "+NAME+" "+PRICE+"<BR>");
}
stat.close();
conn.close();
%>