scala 操作mysql_IDEA 环境中使用Scala连接mysql数据库并读取数据。

package cn.brent.sparkstreamming

import java.sql.{Connection, DriverManager}

import scala.collection.mutable.ArrayBuffer

object DBUntils {

val mysqlConf = Map(

"driver" -> "com.mysql.jdbc.Driver",

"url" -> "jdbc:mysql://192.168.239.129:3306/spark",

"username" -> "hive",

"password" -> "hive"

)

def getMysqlConn():Connection = {

Class.forName(mysqlConf("driver"))

DriverManager.getConnection(mysqlConf("url"),mysqlConf("username"),mysqlConf("password"))

}

def getBlackList():Array[String]={

val conn = getMysqlConn()

val info = new ArrayBuffer[String]()

try{

val statement = conn.createStatement()

val sql = "select website