实例:socket 数据源,查看进程编号最终输出 sink 之 print 打印 AI检测代码解析 package cn.itcast.day06.sink; import org.apache.flink.configuration.Configuration; import org.apache.flink.streaming.api.datastream.DataStreamSource; import org.apache.flink.streaming.api.environment.StreamExecutionEnvironment; impor...
配置MySQL Sink,确保使用手动事务提交。 transformedStream.addSink(newJdbcSink<Tuple2<String,Integer>>(// 添加 JDBC Sink"jdbc:mysql://localhost:3306/database_name",// 数据库连接字符串(element,preparedStatement)->{// 设置准备语句preparedStatement.setString(1,element.f0);// 第一个字段preparedStatement...
mysqlXADataSource.setUrl("jdbc:mysql://lx01:3306/test_db?useSSL=false");// 设置urlmysqlXADataSource.setUser("root");// 设置用户mysqlXADataSource.setPassword("password");// 设置密码returnmysqlXADataSource; } );// 添加jdbc sinkcustomizeSource.addSink(exactlyOneJdbcSink); env.execute(); ...
模拟几条数据流,写入到 MySQL中。 packageicu.wzk;importorg.apache.flink.configuration.Configuration;importorg.apache.flink.streaming.api.datastream.DataStreamSource;importorg.apache.flink.streaming.api.functions.sink.RichSinkFunction;importorg.apache.flink.streaming.api.scala.StreamExecutionEnvironment;importjava...
import java.sql.DriverManager; import java.sql.PreparedStatement; import java.sql.ResultSet; /** * @Description TODO * @Author zytshijack * @Date 2019-05-14 08:32 * @Version 1.0 */ public class SourceFromMySQL extends RichSourceFunction<Student> { //Student就是一个自定义类 ...
object JdbcSink { def main(args: Array[String]): Unit = { //创建执行环境 val env = StreamExecutionEnvironment.getExecutionEnvironment val inputStream = env.readTextFile("/opt/java2020_study/maven/flink1/src/main/resources/sensor.txt") ...
创建自定义sink类MySQLSinkFunction.java,这是本文的核心,有关数据库的连接、断开、写入数据都集中在此: package com.bolingcavalry.customize; import org.apache.flink.configuration.Configuration; import org.apache.flink.streaming.api.functions.sink.RichSinkFunction; ...
import java.sql.{Connection, DriverManager} import com.google.gson.Gson import org.apache.flink.configuration.Configuration import org.apache.flink.streaming.api.functions.sink.{RichSinkFunction, SinkFunction} class MysqlSink(url: String, user: String, pwd: String) extends RichSinkFunction[String] {...
一个Person的类,对应MySQL中的一张表的字段。 模拟几条数据流,写入到 MySQL中。 package icu.wzk;import org.apache.flink.configuration.Configuration;import org.apache.flink.streaming.api.datastream.DataStreamSource;import org.apache.flink.streaming.api.functions.sink.RichSinkFunction;import org.apache.flink...