请教java.lang.ClassNotFoundException: com.mysql.jdbc.Driver

catail 2005-03-30 10:07:12

错误信息：
---------------------------------------------------------------
java.lang.ClassNotFoundException: com.mysql.jdbc.Driver

jsp：
----------------------------------------------------------------
<%@ page language="java" import="java.util.*,pack.*,java.sql.*" %>
<!DOCTYPE HTML PUBLIC "-//w3c//dtd html 4.0 transitional//en">
<html>
<head>
</head>
<body bgcolor="#FFFFFF">

<%
Connection con = GetCon.get();
Statement stmt = con.createStatement();
ResultSet rs = stmt.executeQuery("select count(*) from Offices");
rs.next();
%>
<%=rs.getInt(1)%>

</body>
</html>

调用的类GetCon：
---------------------------------------------------
package pack;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

public class GetCon {
public static Connection get() throws SQLException {
Connection con = null;
try {
Class.forName("com.mysql.jdbc.Driver");
DriverManager.registerDriver(new com.mysql.jdbc.Driver());
String dbUrl = "jdbc:mysql://localhost:3306/report?useUnicode&characterEncoding=GB2312&user=root";
String dbUser = "root";
String dbPwd = "";

con = java.sql.DriverManager.getConnection(dbUrl);
} catch(Exception e) {
System.out.println(e);
}
return con;
}
public static void main(String[] args) {
try{
Connection con;
Statement stmt;
ResultSet rs;

con = GetCon.get();
stmt = con.createStatement();
rs = stmt.executeQuery("select count(*) from ReportByMonth");
rs.next();
System.out.println(rs.getInt(1));
} catch (Exception e) {
System.out.println(e);
}
}
}

...全文