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

leonard520 2010-07-15 09:41:51

写了一个很简单的Java连接数据库的程序

运行环境是Linux（服务器），编写代码环境是windows

现在的问题是，放到服务器Linux上，javac hello.java生成hello.class可以正常运行
但是如果在windows上使用Eclipse导出成jar包（用Eclipse插件fatjar导出的），都会产生如下错误：java.lang.ClassNotFoundException: com.mysql.jdbc.Driver

由于最后需要解决的是一个比较大的项目，所以最好能导成jar包运行，所以希望得到解决方式，本人是Java新手

import java.sql.*;

public class hello
{
public static void main(String[] args)
{
String driver = "com.mysql.jdbc.Driver"; //driver¡ªjar included in CLASSPATH
String url = "jdbc:mysql://localhost/dns"; //connector, test is DB name.
String user = "root"; // user name
String password = ""; //user password
ResultSet rs;
String domain;

try {
Class.forName(driver);
Connection conn = DriverManager.getConnection(url, user, password);
if(!conn.isClosed())
System.out.println("Succeeded connecting to the Database!");
Statement statement;
statement = conn.createStatement();

String sql = "select * from fast;";

rs = statement.executeQuery(sql);
if(rs.next()) {
domain = rs.getString("name");
System.out.print(domain);
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} catch (ClassNotFoundException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}

}
}

...全文