scala 连接mysql

import java.sql.{Connection, DriverManager, ResultSet}

object MySQLConnector {
  def main(args: Array[String]): Unit = {
    val url = "jdbc:mysql://localhost:3306/mydatabase"
    val username = "yourUsername"
    val password = "yourPassword"

    var connection: Connection = null
    try {
      // 加载MySQL JDBC驱动程序
      Class.forName("com.mysql.cj.jdbc.Driver")

      // 建立连接
      connection = DriverManager.getConnection(url, username, password)

      // 执行查询
      val statement = connection.createStatement()
      val resultSet: ResultSet = statement.executeQuery("SELECT * FROM mytable")

      // 处理结果集
      while (resultSet.next()) {
        println(resultSet.getString("columnName"))
      }
    } catch {
      case e: Exception => e.printStackTrace()
    } finally {
      // 关闭连接
      if (connection != null) {
        connection.close()
      }
    }
  }
}