Scala连接mysql的方法

1、先用MySQL建表、插数据

CREATE TABLE student(
id INT(10) PRIMARY KEY AUTO_INCREMENT,
NAME VARCHAR(32),
age INT(10)
)

INSERT INTO student(NAME,age) VALUES("zs",18),("ls",21)

2、idea加载驱动包

驱动包下载链接: https://pan.baidu.com/s/1aCQ6wfjS5ux_JHyBaGTFlA
提取码: hxrm
找到下载的驱动包 确认

3、scala代码

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

  object MysqlDemo{
    private val driver="com.mysql.jdbc.Driver"  //驱动
    private val url="jdbc:mysql://192.168.116.60:3306/scalademo"  //自己的ip地址:端口号/库名
    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):Int={
      val insertSqlString="insert into student(name,age) values(\""+uname+"\","+uage+")"
      val i:Int=connection.createStatement().executeUpdate(insertSqlString)
      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")
        val age=rs.getInt("age")
        println(id+"\t"+name+"\t"+age)
      }
    }

  def main(args: Array[String]): Unit = {
    getConnection()
    println(connection)
    val num=insert("kb09",6)
    println("结果为："+num)
    select()
  }
  }

打印结果为：