如何使用单个getconnection在scala jdbc中查询postgres和oracle中的数据？

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

val url = "jdbc:postgresql://localhost:5432/database_name" // PostgreSQL连接URL
val driver = "org.postgresql.Driver" // PostgreSQL驱动类
val username = "your_username" // 数据库用户名
val password = "your_password" // 数据库密码

val url = "jdbc:oracle:thin:@localhost:1521:database_name" // Oracle连接URL
val driver = "oracle.jdbc.driver.OracleDriver" // Oracle驱动类
val username = "your_username" // 数据库用户名
val password = "your_password" // 数据库密码

Class.forName(driver)

val connection: Connection = DriverManager.getConnection(url, username, password)

val query = "SELECT * FROM table_name"

val statement = connection.createStatement()
val resultSet: ResultSet = statement.executeQuery(query)

while (resultSet.next()) {
  // 处理每一行数据
  val column1 = resultSet.getString("column1")
  val column2 = resultSet.getInt("column2")
  // ...
}

resultSet.close()
statement.close()

connection.close()