类未找到异常与com.mysql.jdbc.Driver [重复]

6ljaweal  于 2023-11-16  发布在  Mysql
关注(0)|答案(1)|浏览(171)

此问题在此处已有答案

Connect Java to a MySQL database(14个答案)
21天前关闭
这是我的第一篇文章,我希望我能接触到小组。我拉我的头发与这个问题。
我正在使用LAMP运行一个EC2 Ubuntu微示例。我正在使用Java和JDBC访问mysql数据库。
问题是Java代码在我执行以下命令时不断抛出“ClassNotFound”异常:Class.forName(“com.mysql.jdbc.Driver”);
我已经安装了以下内容:

  1. sudo apt-get install mysql-server
  2. sudo apt-get install mysql-client
  3. sudo apt-get install libmysql-java

字符串
我在Java文件中的导入是:

  1. import java.text.CharacterIterator;
  2. import java.text.StringCharacterIterator;
  3. import java.util.regex.*;
  4. import java.sql.*;
  5. import java.util.Properties;
  6. import java.net.*;
  7. import java.sql.Connection;
  8. import java.sql.DriverManager;


我的$CLASSPATH显示:

  1. .:/usr/share/java/mysql.jar:/usr/share/java/mysql-connector-java.jar:/usr/share/java/mysql.jar:/usr/share/java/mysql-connector-java.jar:/usr/share/java/mysql-5.1.10.jar:/usr/share/java/mysql-connector-java-5.1.10.jar


在/usr/share/java中:

  1. drwxr-xr-x 3 root root 4096 2012-05-25 02:01 .
  2. drwxr-xr-x 316 root root 12288 2012-05-24 21:21 ..
  3. -rwxrwxrwx 1 root root 448964 2009-11-23 22:38 gnome-java-bridge.jar
  4. -rwxrwxrwx 1 root root 2621 2010-03-05 04:16 libintl.jar
  5. lrwxrwxrwx 1 root root 31 2012-05-25 02:01 mysql-5.1.10.jar -> mysql-connector-java-5.1.10.jar
  6. -rwxrwxrwx 1 root root 754057 2010-01-26 08:02 mysql-connector-java-5.1.10.jar
  7. lrwxrwxrwx 1 root root 31 2012-05-25 02:01 mysql-connector-java.jar -> mysql-connector-java-5.1.10.jar
  8. lrwxrwxrwx 1 root root 16 2012-05-25 02:01 mysql.jar -> mysql-5.1.10.jar


这是一段总是将异常消息抛出到输出文件的代码:

  1. try {
  2. try {
  3. Class.forName("com.mysql.jdbc.Driver");
  4. outyyy.write("Class loaded \n");
  5. }
  6. catch (ClassNotFoundException e) {
  7. outyyy.write("Class not found! \n");
  8. outyyy.write(e.getMessage() + " \n");
  9. }
  10. this._connection = DriverManager.getConnection(url, this._user, this._pass);
  11. this._isConnected = true;
  12. }
  13. catch (Exception e) {
  14. this._isConnected = false;
  15. }


我不确定它是否相关,但我可以使用PHP访问和查询数据库。

qybjjes1

qybjjes11#

设置类路径

  1. export CLASSPATH=$CLASSPATH:/usr/share/java/mysql-connector-java.jar

字符串
来源:http://marksman.wordpress.com/2009/03/01/setting-up-mysqljdbc-driver-on-ubuntu/

相关问题