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()}}}}