使用Scala连接Mysql

添加Mysql连接驱动包，本文使用mysql-connect-java-5.1.38.jar
下载网址：https://downloads.mysql.com/archives/c-j/

import java.sql.{Connection, DriverManager, PreparedStatement, ResultSet}

object MysqlDemo {
  private val driver ="com.mysql.jdbc.Driver"
  private val url="jdbc:mysql://192.168.136.20:3306/scalademo"
  private val username="root"
  private val password="ok"
	//获取连接
  private var connection:Connection=null

  def getConnection():Unit={
    Class.forName(driver)
    connection=DriverManager.getConnection(url,username,password)
  }
	//增
  def insert(uname:String,uage:Int)={
    val insertSqlString="insert into student(name,age) values(?,?)"
    val prStamt = connection.prepareStatement(insertSqlString)
    prStamt.setString(1,uname)
    prStamt.setInt(2,uage)
    val i:Int=prStamt.executeUpdate()
  }
	//查
  def select():Unit={
    val selectStrSql="select id,name,age from student"
    val rs: ResultSet=connection.createStatement().executeQuery(selectStrSql)
    while (rs.next()){
      var id = rs.getInt("id")
      var name = rs.getString("name")
      var age = rs.getInt("age")
      println(id+"\t"+name+"\t"+age)
    }
  }

  def main(args: Array[String]): Unit = {
    getConnection()
    println(connection)
    //val num = insert("kb09",6)  //增
    select()					//查
  }
}