大数据——Scala连接MySQL数据库

添加MySQL连接驱动到项目中

• 点击IDEA的File下的Project Structure
  
• 选择Libraries，点击+，选择Java

• 导入MySQL驱动jar包
  

连接

• 这边使用的版本是mysql-connector-java-5.1.38
• 编写jdbc程序连接至数据库，实现增加数据和查询数据的功能

代码展示

package nj.zb.kb09.mysqlstu

import java.sql.{Connection, DriverManager, PreparedStatement, ResultSet}
object MysqlDemo {
  private val driver = "com.mysql.jdbc.Driver"
  private val url = "jdbc:mysql://192.168.136.100/scalademo"
  private val username = "root"
  private val password = "ok"

  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 statement:PreparedStatement=connection.prepareStatement(insertSqlString)
    //statement.setString(1,uname)
    //statement.setInt(2,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")
      var 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()
  }
}