求肋!!我是菜鸟!我写了一个类来连接数据库。能类调用可以连到数据库。但是通JSP就是没有反映·!忘各位大侠指点迷津
package test;
import java.sql.*;
public class SQLConnection {
String sDBDriver = "sun.jdbc.odbc.JdbcOdbcDriver";
String sConnStr = "jdbc:odbc:sync";
Connection connect = null;
ResultSet rs = null;
String username="sa",psw="sa";
//String dbo= null;
// Connection dbo=null;
//ResultSet
public SQLConnection() {
//String sConnStr = "jdbc:odbc:sync";
try {
Class.forName(sDBDriver);
//DriverManager.getConnection(sConnStr,username,psw);
//sqlConn=java.sql.DriverManager.getConnection(strConn,sa,psw);
}
catch(java.lang.ClassNotFoundException e) {
System.err.println( e.getMessage());
}
//return Class.GetReflectionFactoryAction;
}
public ResultSet executeQuery(String sql)
{
try {
connect = DriverManager.getConnection(sConnStr,username,psw);
Statement stmt = connect.createStatement();
rs = stmt.executeQuery(sql);
}
catch(SQLException ex)
{
System.err.println(ex.getMessage());
}
return rs;
}
这是页面调用JavaBean
<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<%@ page import ="test.SQLConnection"%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<jsp:useBean id="ss" class="test.SQLConnection"></jsp:useBean>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>无标题文档</title>
</head>
<body>
<%
String strsql="select * from usefinfo";
ResultSet rs =ss.executeQuery(strsql);
while(rs.next())
{
out.println("sdf");
}
if(rs==null)
{out.print("null");}
%>
</body>
</html>
这是页面报错:
org.apache.jasper.JasperException
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:372)
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)
root cause
java.lang.NullPointerException
org.apache.jsp.list_jsp._jspService(list_jsp.java:65)
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)