如何使用Scala查询memSQL？

libraryDependencies += "mysql" % "mysql-connector-java" % "8.0.23"

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

object MemSQLQueryExample {
  def main(args: Array[String]): Unit = {
    // 数据库连接信息
    val url = "jdbc:mysql://localhost:3306/your_database_name"
    val username = "your_username"
    val password = "your_password"

    // 加载MySQL驱动
    Class.forName("com.mysql.cj.jdbc.Driver")

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

    try {
      // 创建Statement对象
      val statement = connection.createStatement()

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

      // 处理结果集
      while (resultSet.next()) {
        val column1 = resultSet.getString("column1_name")
        val column2 = resultSet.getInt("column2_name")
        println(s"Column1: $column1, Column2: $column2")
      }
    } catch {
      case e: Exception => e.printStackTrace()
    } finally {
      // 关闭连接
      connection.close()
    }
  }
}