Scala之读取mysql数据

Scala读取mysql数据

import java.sql.{Connection, DriverManager}


object MySQLApp {

  def main(args: Array[String]): Unit = {
    val url ="jdbc:mysql://localhost:3306/tax"
    val username = "root"
    val password = "root"
    var connection:Connection = null
    try{
      //创建连接
      classOf[com.mysql.jdbc.Driver]
      connection = DriverManager.getConnection(url,username,password)
      val statement = connection.createStatement()
      val resultSet = statement.executeQuery("SELECT id,name from person")
      while (resultSet.next()){
        val id = resultSet.getString("id")
        val name = resultSet.getString("name")

        println(s"$id , $name")
      }
    }catch {
      case e:Exception => e.printStackTrace()
    }finally {
      if(connection == null){
        connection.close()
      }
    }
  }
}