mysql - 如何使用 Scala 在 Intellij IDE 中连接 MySQL 数据库？

Question

我正在尝试使用 Scala 连接到 Intellij IDE 中的 MySQL 数据库，但我不断收到 SQLException。

这是我的代码：

import java.sql.Connection
import java.sql.DriverManager


object main extends App {

    println("Hello World")

    val driver = "com.mysql.cj.jdbc.Driver"
    val url = "jdbc:mysql://localhost:3306/demodatabase"
    val username = "root"
    val password = "pass"

    var connection: Connection = DriverManager.getConnection(url, username, password)
    val statement = connection.createStatement()
    val resultSet = statement.executeQuery("SELECT * FROM persons;")
    println(resultSet)

    while (resultSet.next()) {
        println(resultSet.getString(1) + ", " + resultSet.getString(2) + ", " + resultSet.getString(3))
    }

    connection.close()
}

这是输出：

"C:\Program Files\Java\jdk-17\bin\java.exe" "-javaagent:D:\IntelliJ IDEA Community Edition 2021.2.2\lib\idea_rt.jar=60731:D:\IntelliJ IDEA Community Edition 2021.2.2\bin" -Dfile.encoding=UTF-8 -classpath "D:\IdeaProjects\Project 0 Revature\out\production\Project 0 Revature;C:\Users\RiotV\.ivy2\cache\org.scala-lang\scala-library\jars\scala-library-2.13.6.jar;C:\Users\RiotV\.ivy2\cache\org.scala-lang\scala-reflect\jars\scala-reflect-2.13.6.jar" main
Hello World
Exception in thread "main" java.sql.SQLException: No suitable driver found for jdbc:mysql://localhost:3306/demodatabase
    at java.sql/java.sql.DriverManager.getConnection(DriverManager.java:706)
    at java.sql/java.sql.DriverManager.getConnection(DriverManager.java:229)
    at main$.delayedEndpoint$main$1(main.scala:15)
    at main$delayedInit$body.apply(main.scala:6)
    at scala.Function0.apply$mcV$sp(Function0.scala:39)
    at scala.Function0.apply$mcV$sp$(Function0.scala:39)
    at scala.runtime.AbstractFunction0.apply$mcV$sp(AbstractFunction0.scala:17)
    at scala.App.$anonfun$main$1(App.scala:76)
    at scala.App.$anonfun$main$1$adapted(App.scala:76)
    at scala.collection.IterableOnceOps.foreach(IterableOnce.scala:563)
    at scala.collection.IterableOnceOps.foreach$(IterableOnce.scala:561)
    at scala.collection.AbstractIterable.foreach(Iterable.scala:919)
    at scala.App.main(App.scala:76)
    at scala.App.main$(App.scala:74)
    at main$.main(main.scala:6)
    at main.main(main.scala)

Process finished with exit code 1

它抛出了一个 SQLException “没有为 jdbc:mysql://localhost:3306/demodatabase 找到合适的驱动程序”，所以我不确定如何解决这个问题或我缺少什么驱动程序，因为我无法找到任何帮助对于 Scala 在线。

任何帮助是极大的赞赏。

标签： mysqlscalaintellij-idea