flink链接mysql_flink操作mysql

Flink读写mysql

如果是mvn项目的话，需要预先导入相应的包：

org.apache.flink

flink-jdbc_2.11

1.9.2

mysql

mysql-connector-java

5.1.24

1、读

import java.time.LocalDateTime

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.{DataSet, ExecutionEnvironment, _}

import org.apache.flink.types.Row

import org.apache.log4j.Logger

object OperatorMysql extends Logger("opeartorMysql") {

val log = Logger.getLogger("opeartorMysql")

def main(args: Array[String]): Unit = {

val env = ExecutionEnvironment.getExecutionEnvironment

val driver = "com.mysql.jdbc.Driver"

val url