如何在debian10上安装jdbc以在java8中工作?

uujelgoq  于 2021-07-12  发布在  Java
关注(0)|答案(1)|浏览(426)

我正试图使用这段代码连接到Java8上的mysql数据库,但我得到一个异常,即找不到jdbc驱动程序类。debian 10的解决方案是什么?java.lang.classnotfoundexception:com.mysql.jdbc.driver

  1. import java.sql.*;
  2. class MysqlCon {
  3. public static void main(String args[]) {
  4. try {
  5. Class.forName("com.mysql.jdbc.Driver");
  6. Connection con = DriverManager.getConnection(
  7. "jdbc:mysql://localhost:3306/sonoo","root","root");
  8. //here sonoo is database name, root is username and password
  9. Statement stmt=con.createStatement();
  10. ResultSet rs=stmt.executeQuery("select * from emp");
  11. while(rs.next())
  12. System.out.println(rs.getInt(1) + " " + rs.getString(2) + " " + rs.getString(3));
  13. con.close();
  14. } catch(Exception e) {
  15. System.out.println(e);
  16. }
  17. }
  18. }
flvlnr44

flvlnr441#

当从命令行调用java程序时,应该添加额外的参数-cp或-classpath,并引用jdbc库jar文件。
例子:

  1. # Java directory
  2. export JAVA_DIR="/usr/java8_64"
  3. # Classpath
  4. export CLASSPATH="/usr/lib/mysql-connector-java.jar"
  5. # Start application
  6. ${JAVA_DIR}/bin/java -jar <MY_JAR_FILE_NAME> -classpath ${CLASSPATH}

相关问题