flink批处理访问mysql_Flink批处理之JDBC读写Mysql--Scala

1、环境

jdk 1.8.0_108

Scala 2.11.8

Flink 1.7.2

MySql 8.0.13

2、Maven依赖

org.apache.flink

flink-scala_2.11

1.7.2

org.apache.flink

flink-jdbc_2.12

1.7.2

mysql

mysql-connector-java

5.1.46

3、读取和写入代码

package com.zander.flink

import org.apache.flink.api.common.typeinfo.BasicTypeInfo

import org.apache.flink.api.java.io.jdbc.{JDBCInputFormat, JDBCOutputFormat}

import org.apache.flink.api.java.typeutils.RowTypeInfo

import org.apache.flink.api.scala.{ExecutionEnvironment, _}

import org.apache.flink.types.Row

import scala.collection.mutable.ArrayBuffer

/**

* Created By User: zander

* Created On Date: 2019/11/20 0020 11:01

*/

object FlinkReadMySqlTest {

private val JDBC_URL: String = "jdbc:mysql://192.168