Flink java 之读取 MySQL 数据源

最新推荐文章于 2024-04-23 18:52:22 发布

程序员 Harry

最新推荐文章于 2024-04-23 18:52:22 发布

阅读量1.2k

点赞数

分类专栏： Flink 文章标签： java flink mysql

本文链接：https://blog.csdn.net/weixin_46376562/article/details/125575107

版权

Flink 专栏收录该内容

19 篇文章 3 订阅

订阅专栏

0. 创建maven工程

<?xml version="1.0" encoding="UTF-8"?>
<project xmlns="http://maven.apache.org/POM/4.0.0"
         xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
         xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">
    <modelVersion>4.0.0</modelVersion>

    <groupId>org.daidai</groupId>
    <artifactId>Flink1.13_Java</artifactId>
    <version>1.0-SNAPSHOT</version>
    <build>
        <plugins>
            <plugin>
                <groupId>org.apache.maven.plugins</groupId>
                <artifactId>maven-compiler-plugin</artifactId>
                <configuration>
                    <source>8</source>
                    <target>8</target>
                </configuration>
            </plugin>
        </plugins>
    </build>

    <properties>
        <flink.version>1.13.0</flink.version>
        <java.version>1.8</java.version>
        <scala.binary.version>2.12</scala.binary.version>
        <slf4j.version>1.7.15</slf4j.version>
        <lombok.version>1.18.24</lombok.version>
        <mysql-connector.version>8.0.29</mysql-connector.version>
    </properties>
    <dependencies>
        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <version>${mysql-connector.version}</version>
        </dependency>
        <dependency>
            <groupId>org.projectlombok</groupId>
            <artifactId>lombok</artifactId>
            <version>${lombok.version}</version>
        </dependency>
        <!-- 引入 Flink 相关依赖-->
        <dependency>
            <groupId>org.apache.flink</groupId>
            <artifactId>flink-java</artifactId>
            <version>${flink.version}</version>
        </dependency>
        <dependency>
            <groupId>org.apache.flink</groupId>
            <artifactId>flink-streaming-java_${scala.binary.version}</artifactId>
            <version>${flink.version}</version>
            <exclusions>
                <exclusion>
                    <artifactId>slf4j-api</artifactId>
                    <groupId>org.slf4j</groupId>
                </exclusion>
            </exclusions>
        </dependency>
        <dependency>
            <groupId>org.apache.flink</groupId>
            <artifactId>flink-clients_${scala.binary.version}</artifactId>
            <version>${flink.version}</version>
        </dependency>
        <!-- 引入日志管理相关依赖-->
        <dependency>
            <groupId>org.slf4j</groupId>
            <artifactId>slf4j-api</artifactId>
            <version>${slf4j.version}</version>
        </dependency>
        <dependency>
            <groupId>org.slf4j</groupId>
            <artifactId>slf4j-log4j12</artifactId>
            <version>${slf4j.version}</version>
        </dependency>
        <dependency>
            <groupId>org.apache.logging.log4j</groupId>
            <artifactId>log4j-to-slf4j</artifactId>
            <version>2.14.0</version>
        </dependency>
    </dependencies>

</project>

1. 创建flink执行环境

package com.daidai.mysqlsource;

import com.daidai.mysqlsource.domain.OneMarkOneSum;
import com.daidai.mysqlsource.source.MyMysqlSource;
import org.apache.flink.streaming.api.datastream.DataStreamSource;
import org.apache.flink.streaming.api.environment.StreamExecutionEnvironment;

public class MySqlSource {
    public static void main(String[] args) throws Exception {

        StreamExecutionEnvironment env = StreamExecutionEnvironment.getExecutionEnvironment();


        env.execute();

    }
}

2. 创建MySQL数据源

2.1 创建输出数据类型

package com.daidai.mysqlsource.domain;

import lombok.AllArgsConstructor;
import lombok.Data;
import lombok.NoArgsConstructor;

@Data
@AllArgsConstructor
@NoArgsConstructor
public class OneMarkOneSum {
    private String showName;
    private int lowMark;
    private int num;
    private int numberSum;
}

2.2 创建数据源连接

package com.daidai.mysqlsource.source;

import com.daidai.mysqlsource.domain.OneMarkOneSum;
import org.apache.flink.configuration.Configuration;
import org.apache.flink.streaming.api.functions.source.RichParallelSourceFunction;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;

public class MyMysqlSource extends RichParallelSourceFunction<OneMarkOneSum> {
    private Connection connection = null;
    private PreparedStatement preparedStatement = null;

    @Override
    public void open(Configuration parameters) throws Exception {
        connection = DriverManager.getConnection(
                "jdbc:mysql://localhost:3306/test",
                "root",
                "000000"
        );
        String sql = "select showName, lowMark, number, numberSum from onemarkonesum";
        preparedStatement = connection.prepareStatement(sql);
    }

    @Override
    public void run(SourceContext<OneMarkOneSum> sourceContext) throws Exception {


        ResultSet resultSet = preparedStatement.executeQuery();
        while (resultSet.next()) {
            String showName = resultSet.getNString("showName");
            int lowMark = resultSet.getInt("lowMark");
            int number = resultSet.getInt("number");
            int numberSum = resultSet.getInt("numberSum");
            sourceContext.collect(new OneMarkOneSum(showName, lowMark, number, numberSum));
        }
        Thread.sleep(1000);
    }

    @Override
    public void cancel() {
    }

    @Override
    public void close() throws Exception {
        if (connection != null) {
            connection.close();
        }
        if (preparedStatement != null) {
            preparedStatement.close();
        }
    }
}

3. 添加MySQL数据源

package com.daidai.mysqlsource;

import com.daidai.mysqlsource.domain.OneMarkOneSum;
import com.daidai.mysqlsource.source.MyMysqlSource;
import org.apache.flink.streaming.api.datastream.DataStreamSource;
import org.apache.flink.streaming.api.environment.StreamExecutionEnvironment;

public class MySqlSource {
    public static void main(String[] args) throws Exception {

        StreamExecutionEnvironment env = StreamExecutionEnvironment.getExecutionEnvironment();

        DataStreamSource<OneMarkOneSum> oneMarkOneSumDataStreamSource = env.addSource(new MyMysqlSource());

        oneMarkOneSumDataStreamSource.print();

        env.execute();

    }
}