Scala的JDBC操作MySQL

Scala 连接 MySQL 操作数据库基本步骤

• 获取数据库连接
• 创建操作方法
• main() 方法实现操作
• 以下示例以查询和插入操作为示例演示

import java.sql.{Connection, DriverManager}

object MysqlDemo {
  private val driver="com.mysql.jdbc.Driver"
  private val url="jdbc:mysql://192.168.8.99: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(name:String,age:Int):Int={
    //val insertSqlString="insert into student(name,age) values(\""+name+"\","+age+")"
    //val statement = connection.prepareStatement(insertSqlString)
    //connection.createStatement().executeUpdate(insertSqlString)

	val insertSqlString2 = "insert into student(name,age) values(?,?)"
    val prStamt = connection.prepareStatement(insertSqlString2)
    prStamt.setString(1,name)
    prStamt.setInt(2,age)
    prStamt.executeUpdate()
  }

//查询数据库
  def select():Unit={
    val selectStrSql="select id,name,age from student"
    val rs = 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()
    insert("kb09",6)	//调用插入方法实现数据库数据插入
    select()		//调用查询方法查看数据库
  }
}