PreparedStatement

 PreparedStatement 与StateMent 主要区别于 ps 是预编译，多次查询同样语法，但是参数不同的情况，只需要给？参数赋值即可，示例忽略try。

  def transforDeviceId(): Unit = {
    val url = "jdbc:mysql://localhost:3306/origin_platform"
    val outPath = new File("e://testdata//output.txt")
    var conn: Connection = null
    var prepareStat: PreparedStatement = null
    var rs: ResultSet = null

    Class.forName("com.mysql.jdbc.Driver")
    conn = DriverManager.getConnection(url, "root", "root")

    // 处理完写出数据的位置
    var fileWrite = new BufferedOutputStream(new FileOutputStream(outPath))

    // 读取文件
    val source = Source.fromFile("e://testdata//1569571348230.txt", "utf-8")
    // 获取行
    val lineIterator = source.getLines

    var line = ""
    var sqlStr = "select `device` from tb_device_map wher