＜Zhuu_ZZ＞Scala(八)与数据库的JDBC

• 首先在Mysql里建库建表

CREATE DATABASE scalademo

USE scalademo

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)

SELECT * FROM student

• 然后在IDEA里写scala语句就ok

package mysqlstu

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

object MysqlDemo {
  //连接属性
 private val driver="com.mysql.jdbc.Driver"
  private val url="jdbc:mysql://192.168.198.201: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):Int={
    //第一种方法：变量名传值
  //val inserSqlString="insert into student(name,age) values(\""+uname+"\","+uage+")"  //因为uname是string类型所以用转义符保留双引号
//    val i = connection.createStatement().executeUpdate(inserSqlString)

    //第二种方法：用？传值
    val inserSqlString="insert into student(name,age) values(?,?)"
    val statement = connection.prepareStatement(inserSqlString)
    statement.setString(1,uname)
    statement.setInt(2,uage)
    val i=statement.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)
    println(if(insert("zhu", 23)!=null) "数据插入成功" else "数据插入失败")
    select()
  }
}