Scala与MySQL的交互

在idea上导入mysql的jdbc驱动：
我这里使用的是5.1.38


在Mysql中新创建一个库和表：

CREATE DATABASE ScalaDemon;
CREATE TABLE student(
id INT(20) PRIMARY KEY AUTO_INCREMENT,
NAME VARCHAR(20),
age INT(10)
);

在Scala上建立连接并实现SQL：

import java.sql.{Connection, DriverManager}

object ScalaDemon {
  private val driver="com.mysql.jdbc.Driver"
  private val url="jdbc:mysql://192.168.136.10:3306/ScalaDemon"
  private val username="root"
  private val password="ok"

  var conn:Connection=null

  //建立连接
    def getConnect()={
      Class.forName(driver)
       conn = DriverManager.getConnection(url,username,password)
    }
  //增
  def insert(name:String,age:Int)={
    val insertSql="insert into student(name,age)values(\""+name+"\","+age+")"
    val i = conn.createStatement().executeUpdate(insertSql)
    i
  }
  //删
  def delete(id:Int)={
    val deleteSql=s"delete from student where id=$id"
    val i = conn.createStatement().executeUpdate(deleteSql)
    i
  }
  //改
  def update(name:String,id:Int)={
    val updateSql="update student set name=\""+name+"\"  where id="+id+""
    val i = conn.createStatement().executeUpdate(updateSql)
    i
  }
  //查
  def select()={
    val selSql="select id,name,age from student"
    val set = conn.createStatement().executeQuery(selSql)
    while(set.next()) {
      var id=set.getInt("id")
      var name=set.getString("name")
      var age=set.getInt("age")
      println(id+":"+name+":"+age)
    }
  }

  def main(args: Array[String]): Unit = {
    getConnect()
    insert("Tony",25)
    delete(3)
    update("Hulk",7)
    select()
  }
}