Scala之Demo1

1.创建Connection的object，在scala里面称为单例对象

package com.test
import java.sql.DriverManager
import java.sql.Connection

object SingleMySqlConn {

  private var driver = "com.mysql.jdbc.Driver"
  private var url = "jdbc:mysql://localhost/bms"
  private var connection: Connection = null;

  def getConnection(username: String, password: String): Connection = {

    if (connection == null) {

      try {
       
        Class.forName(driver)
        connection = DriverManager.getConnection(url, username, password)

        connection
      } 
      catch{
        
        case e=>e.printStackTrace()
        null
      }

    } else {

      connection
    }

  }
}

2.客户端调用连接MySQL单例对象的方法

package com.test
import java.sql.DriverManager
import java.sql.Connection

object ScalaMySql {

  def main(args: Array[String]): Unit = {