Connector program for MSSql in Scala

ConnectorRDBMS.scala

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

object Connector {
  def main(args: Array[String]): Unit = {
    
    DriverManager.registerDriver(new com.microsoft.sqlserver.jdbc.SQLServerDriver());
    // we can form this below URL in different forms to encrypt our password and DBName
    val url = "jdbc:sqlserver://SERVER_INSTANCE;databaseName=DB_NAME;user=USER_NAME;password=PASSWORD;"
   
    // there's probably a better way to do this
    var connection:Connection = null

    try {
      // make the connection

      connection = DriverManager.getConnection(url)

      // create the statement, and run the select query
      val statement = connection.createStatement()
      val resultSet = statement.executeQuery("SELECT * FROM TABLE_NAME")
      while ( resultSet.next() ) {
        println(resultSet.getString(1) + " || " + resultSet.getString(2))
      }
    } catch {
      case e => e.printStackTrace
    }
    connection.close()

  }

}