挑错!
package test;
import java.sql.*;
public class JDBCBean {
public JDBCBean() {}
public ResultSet getResult() {
try {
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection conn=DriverManager.getConnection("jdbc:odbc:test");
Statement stmt=conn.createStatement();
ResultSet rs=stmt.executeQuery("select * from goods");
return rs;
}
catch(Exception e) {
System.out.println(e.getMessage());
}
return null;
}
}
这个是本人编写的JavaBean 经过测试,可以连接数据库并取出数据。
<%@ page import="java.sql.*" %>
<jsp:useBean id="db" class="test.JDBCBean" />
<%
ResultSet rs=db.getResult();
while(rs.next()) {
out.println(rs.getString(1)+"------"+rs.getString(2)+"<br>");
}
%>
这个是jsp文件。
出现错误:
java.lang.NullPointerException
at org.apache.jsp.JDBCBean$jsp._jspService(JDBCBean$jsp.java:90)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:107)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
谁知道是哪里的错误?