scala使用JDBC连接mysql数据库

package jdbc

 
import java.sql.DriverManager
import java.sql.Connection
 
object ScalaJDBC {
 
  def main(args: Array[String]) {
    // connect to the database named "mysql" on the localhost
    val driver = "com.mysql.jdbc.Driver"
    val url = "jdbc:mysql://localhost/scala_test"
    val username = "root"
    val password = "1234"
  
    var connection:Connection = null
 
    try {
      
      Class.forName(driver)
      connection = DriverManager.getConnection(url, username, password)
 
      val statement = connection.createStatement()
      val resultSet = statement.executeQuery("select name, password from scala_t")
      while ( resultSet.next() ) {
        val name = resultSet.getString("name")
        val password = resultSet.getString("password")
        println("name, password = " + password + ", " + password)
      }
    } catch {
       case e => e.printStackTrace
       //case _: Throwable => println("ERROR")
    }
    connection.close()
  }
 
}