Scala异常通过设置角色命令运行对postgreSQL的查询

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

object ScalaExceptionExample {
  def main(args: Array[String]): Unit = {
    val url = "jdbc:postgresql://localhost:5432/mydatabase"
    val username = "myusername"
    val password = "mypassword"

    var connection: Connection = null

    try {
      // 建立数据库连接
      connection = DriverManager.getConnection(url, username, password)

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

      // 处理查询结果
      while (resultSet.next()) {
        val column1 = resultSet.getString("column1")
        val column2 = resultSet.getInt("column2")
        // 其他处理逻辑...
      }

      // 关闭数据库连接
      resultSet.close()
      statement.close()
    } catch {
      case e: SQLException =>
        e.printStackTrace()
        // 异常处理逻辑...
    } finally {
      // 关闭数据库连接
      if (connection != null) {
        connection.close()
      }
    }
  }
}