创建可运行的JAR文件:在Java JDBC中使用Intellij和mysql连接器

huangapple 未分类评论55阅读模式
英文:

Creating runable jar file Intellij with mysql connector in Java JDBC

问题

我在创建一个可运行的包含mysql连接器库的jar文件时遇到了问题。

我的IDE是IntelliJ,我已经成功地将mysql连接器导入到我的库中,所以我的应用程序在IntelliJ中可以正常使用sql。

但是当我创建一个artifact并将我的应用程序导出为一个jar文件时,我遇到了错误:
    `java.sql.SQLException: No suitable driver found for jdbc:mysql:`

在我的Java代码中,我使用了以下代码。在IntelliJ中,这在完全正常,但在终端中运行时却不行:

    String myDriver = "com.mysql.cj.jdbc.Driver";
    String myUrl = "jdbc:mysql://website.com/mydatabase_db";
    Class.forName(myDriver);
    Connection conn = DriverManager.getConnection(myUrl, "myuser", "myPassword");

我尝试在终端中运行以下代码:
`java -cp mysql-connector-java-8.0.19.jar -jar application.jar`
英文:

I'm having an issue with creating a runable jar file that includes mysql connector library.

So my IDE is IntelliJ and I have successfully imported mysql connector to my library so my application works fine with sql in IntelliJ.

But when I create a artifact and export my application to a jar file, I got the error:
java.sql.SQLException: No suitable driver found for jdbc:mysql:

In my java code I use the following code. And this works perfectly fine in IntelliJ, but not when I run it in my terminal

String myDriver = "com.mysql.cj.jdbc.Driver";
            String myUrl = "jdbc:mysql://website.com/mydatabase_db";
            Class.forName(myDriver);
            Connection conn = DriverManager.getConnection(myUrl, "myuser", "myPassword");

I try to run the code in my terminal with:
java -cp mysql-connector-java-8.0.19.jar -jar application.jar

huangapple
  • 本文由 发表于 2020年3月15日 17:46:41
  • 转载请务必保留本文链接:https://java.coder-hub.com/60691572.html
匿名

发表评论

匿名网友

:?: :razz: :sad: :evil: :!: :smile: :oops: :grin: :eek: :shock: :???: :cool: :lol: :mad: :twisted: :roll: :wink: :idea: :arrow: :neutral: :cry: :mrgreen:

确定