scala 链接 jdbc

package mysqlstu

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


object MysqlDemo {

  private val driver="com.mysql.jdbc.Driver"
  private val url="jdbc:mysql://192.168.83.100:3306/scalademo"
  private val username="root"
  private val password="123456"

  private var connection:Connection = null

  def getConnection():Unit={
    Class.forName(driver)
    connection = DriverManager.getConnection(url,username,password)
  }

  def insert(uname:String, uage:Int):Int={
//    val inserSqlString = "insert into student(name,age) values(\""+uname+"\","+uage+")"
//    val i: Int = connection.createStatement().executeUpdate(inserSqlString)
//    i

    val inserSqlString2 = "insert into student(name,age) values(?,?)"
    val prStamt: PreparedStatement = connection.prepareStatement(inserSqlString2)
    prStamt.setString(1,uname)
    prStamt.setInt(2,uage)
    val i: Int = prStamt.executeUpdate()
    i
  }

  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("kb",6)
    println("结果为："+num)
//    select()
  }

}