使用scala读取本地数据写入到Mysql

package com.badou

import com.badou.config.MysqlConf
import scala.io.Source

object TestMysql extends App {
// 通过3306端口访问mysql数据库，ip地址自行修改
val url = “jdbc:mysql://x.x.x.x:3306/badou?useUnicode=true&characterEncoding=utf-8&useSSL=false”
val driver = “com.mysql.jdbc.Driver”
// 设置mysql的用户名、密码，例user、word
val username = “user”
val password = “word”

var connection : Connection = _
// 注册
Class.forName(driver)
// 得到连接

connection = DriverManager.getConnection(url, username, password)
val statment = connection.createStatement()
// 去product.csv取数据，存到mysql
// 本地存放products.csv的地址
val input = “G:\Largedata\data\products.csv”
val sourceFile = Source.fromFile(input, “utf-8”)
//过滤异常数据
val data = sourceFile.getLines().toList
.filter(!_.startsWith(“product_id”)).map { line =