初学jsp,javabean连接数据库调用总是报错，疯了，求大神解决方案
初学jsp,javabean连接数据库调用总是报错，疯了，求大神
原来一直用asp，现改为jsp，感觉比asp复杂多了
弄个了连接数据库好几天了，一直搞不定，请帮助。环境变量什么：JAVA_HOME,PATH,CLASSPATH都配置过了
网站目录：
ConnDB.java代码：
test.jsp代码
报错信息
HTTP Status 500 - An exception occurred processing JSP page /test.jsp at line 14
type Exception report
message An exception occurred processing JSP page /test.jsp at line 14
description The server encountered an internal error that prevented it from fulfilling this request.
exception
org.apache.jasper.JasperException: An exception occurred processing JSP page /test.jsp at line 14
11: <p><h3>show javabean:</h3></p>
12: <jsp:useBean id="hh" class="MyConn.ConnDB" scope="page"> </jsp:useBean>
13: <%
14: ResultSet rs=hh.executeQuery("select * from dzgs_user");
15: if(rs!=null)
16: {
17: while(rs.next())
------解决思路----------------------
换成
打印出来看看是啥子错误
------解决思路----------------------
DriverManager要用Connection接收啊
------解决思路----------------------
Class.forName(dbClassName).newInstance();
注册时newinstance()什么鬼？
------解决思路----------------------
Class.forName(dbClassName);
conn = DriverManager.getConnection(dbUrl,dbUser,dbPwd);
原来一直用asp，现改为jsp，感觉比asp复杂多了
网站目录：
ConnDB.java代码：
package MyConn;
import java.sql.*;
import java.io.*;
import java.util.*;
public class ConnDB
{
private Connection conn=null;
private Statement stmt=null;
private ResultSet rs=null;
private static String dbClassName="com.microsoft.jdbc.sqlserver.SQLServerDriver";
private static String dbUrl="jdbc:microsoft:sqlserver://10.28.160.8:1433;DatabaseName=dzgs";
private static String dbUser="sa";
private static String dbPwd="123";
public static Connection getConnection()//连接数据库的方法
{
Connection conn=null;
try{
Class.forName(dbClassName).newInstance();
DriverManager.getConnection(dbUrl,dbUser,dbPwd);
}
catch(Exception e)
{e.printStackTrace();
}
if(conn==null)
{System.err.print("警告:DbConnectionManager()获得数据库链接失败.\r\n\r\n链接类型:"+dbClassName+"\r\n链接位置:"+dbUrl+"\r\n用户/密码"+dbUser+"/"+dbPwd);
}
return conn;
}
public ResultSet executeQuery(String sql)//执行查询语句
{ try{
conn=getConnection();
stmt=conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
rs=stmt.executeQuery(sql);
}
catch(SQLException e)
{System.err.print(e.getMessage());
}
return rs;
}
public int executeUpdate(String sql)//执行更新操作（返回更新行数）
{ int result=0;
try{conn=getConnection();
stmt=conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
result=stmt.executeUpdate(sql);
}
catch(SQLException e)
{result=0;
}
try{
stmt.close();
}
catch(SQLException e){
}
return result;
}
public int executeUpdate_id(String sql)//执行更新操作（返回自动编号）
{ int result=0;
try{conn=getConnection();
stmt=conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
result=stmt.executeUpdate(sql);
String ID="select @@IDENTITY as id";
result=stmt.executeUpdate(ID);
if(rs.next()){
int autoID=rs.getInt("id");
result=autoID;
}
}
catch(SQLException e)
{result=0;
}
return result;
}
public void close()//关闭数据库连接
{ try{if(rs!=null)
{rs.close();
}
if(stmt!=null)
{
stmt.close();
}
if(conn!=null)
{
conn.close();
}
}
catch(Exception e)
{e.printStackTrace(System.err);
}
}
}
test.jsp代码
<%@ page contentType="text/html;charset=GB2312" %>
<%@ page import="MyConn.ConnDB"%>
<%@ page import="java.sql.*" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312" />
<title>javabean</title>
</head>
<body>
<p><h3>show javabean:</h3></p>
<jsp:useBean id="hh" class="MyConn.ConnDB" scope="page"> </jsp:useBean>
<%
ResultSet rs=hh.executeQuery("select * from dzgs_user");
if(rs!=null)
{
while(rs.next())
{
out.println(rs.getString(1));
}
}
else
{
out.println("ResultSet is NULL");
}
%>
</body>
</html>
报错信息
HTTP Status 500 - An exception occurred processing JSP page /test.jsp at line 14
type Exception report
message An exception occurred processing JSP page /test.jsp at line 14
description The server encountered an internal error that prevented it from fulfilling this request.
exception
org.apache.jasper.JasperException: An exception occurred processing JSP page /test.jsp at line 14
11: <p><h3>show javabean:</h3></p>
12: <jsp:useBean id="hh" class="MyConn.ConnDB" scope="page"> </jsp:useBean>
13: <%
14: ResultSet rs=hh.executeQuery("select * from dzgs_user");
15: if(rs!=null)
16: {
17: while(rs.next())
------解决思路----------------------
ResultSet rs=hh.executeQuery("select * from dzgs_user");
换成
ResultSet rs= null;
try {
rs = hh.executeQuery("select * from dzgs_user");
}catch (Exception e } {
//打印出来
打印出来看看是啥子错误
------解决思路----------------------
DriverManager要用Connection接收啊
------解决思路----------------------
Class.forName(dbClassName).newInstance();
注册时newinstance()什么鬼？
------解决思路----------------------
Class.forName(dbClassName);
conn = DriverManager.getConnection(dbUrl,dbUser,dbPwd);