scala向mysql添加数据

版权归作者所有，任何形式转载请联系作者。
作者：tiankonghewo（来自豆瓣）
来源：https://www.douban.com/note/647108369/

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

import org.apache.commons.codec.binary.Base64
import org.json4s.JsonAST.JValue
import org.json4s.jackson.JsonMethods.compact

import scala.util.Random

object Hello {
  def main(args: Array[String]): Unit = {
    // connect to the database named "mysql" on the localhost
    val driver = "com.mysql.jdbc.Driver"
    val url = "jdbc:mysql://114.115.205.96:3306/mysql"
    val username = "root"
    val password = "root"

    var connection:Connection = null
    try {
      //Class.forName(driver)
      connection = DriverManager.getConnection(url, username, password)
      val ps = connection.createStatement()
      for (i <- 1 to 100000){
        val id=i
        val score=Random.nextInt(100)
        val query=s"insert into stu (id, score) values($id , $score)"
        ps.addBatch(query)
      }
      ps.executeBatch()
    } catch {
      case e => e.printStackTrace
    }
    connection.close()
  }

}