抛出一个“no suitable driver”异常?为什么？？？

dida200 2002-11-18 06:09:54

为什么我用这两个文件，就是执行不了呢？
老出没有匹配的驱动,抛出一个（“no suitable driver”）异常!!!!!!!!!!!!!!
我在我的机器上，配置了一个odbc数据源，叫abs
我的环境是：windows2000 server, tomcat4.0

这个是.jsp文件

<%@page language="java" import="java.sql.*"%>
<%@page contentType="text/html;charset=gb2312"%>
<html><head>
<title>查询用户信息</title>
</head>
<body>

<jsp:useBean id="user" scope="page" class="SQLServer.SQLServer_dbconnect"/>
查询用信息
<hr>
<%
ResultSet rs;
rs=user.executeQuery("select * from Employeeinfo");
while(rs.next())
{
%>
用户ID：<%=rs.getInt("employeeid")%><BR> 用户姓名：<%=rs.getString("employeename")%><BR>
用户功能组：<%=rs.getString("emplyeepower")%><br>
<%}

%>
</body>
</html>

这个是SQLServer_dbconnect.java文件

package SQLServer;
import java.sql.*;

public class SQLServer_dbconnect
{
String sDBDriver="sun.jdbc.odbc.JdbcOdbcDriver";
String sConnStr="jdbc.odbc.abs";
Connection conn=null;
ResultSet rs=null;
public SQLServer_dbconnect()
{
try{
Class.forName(sDBDriver);
}
catch (java.lang.ClassNotFoundException e)
{
System.err.println("Class SQLServer_dbconnect not found!"+e.getMessage());
}
}
public ResultSet executeQuery(String sql)
{
rs=null;
try
{
conn=DriverManager.getConnection(sConnStr,"abs","abs");
Statement stmt=conn.createStatement();
rs=stmt.executeQuery(sql);
}
catch(SQLException ex)
{
System.err.println("aq.executeQuery:"+ex.getMessage());
}
return rs;
}
public ResultSet executeUpdate(String sql)
{
rs=null;
try{
conn=DriverManager.getConnection(sConnStr,"abs","abs");
Statement stmt=conn.createStatement();
rs=stmt.executeQuery(sql);
}
catch(SQLException ex)
{
System.err.println("ap.executeQUery:"+ex.getMessage());
}
return rs;
}

}

...全文