Flink 连接数据库并获取数据(Java)

前期准备

Flink提供了JDBC连接器，需要添加如下依赖

<!--选择自己需要的版本号-->
<dependency>
	<groupId>org.apache.flink</groupId>
	<artifactId>flink-connector-jdbc_${scala.binary.version}</artifactId>
	<version>${flink.version}</version>
</dependency>
<!--还是通过jdbc去连接数据库,所以需要加上对应的驱动器-->
<dependency>
	<groupId>mysql</groupId>
	<artifactId>mysql-connector-java</artifactId>
	<version>${mysql-connector.version}</version>
</dependency>

连接测试

测试代码如下

package org.eects;

import org.apache.flink.api.common.typeinfo.BasicTypeInfo;
import org.apache.flink.api.java.typeutils.RowTypeInfo;
import org.apache.flink.streaming.api.datastream.DataStream;
import org.apache.flink.streaming.api.environment.StreamExecutionEnvironment;
import org.apache.flink.types.Row;
import org.apache.flink.connector.jdbc.JdbcInputFormat;

/**
 * <p>
 * 数据库读取
 * </p>
 *
 * @author 13706
 * @since 2021/4/9
 */
public class JdbcReader {
    public static void main(String[] args) throws Exception{
        String sql = "select EqDeg from EqInfo";
		String drivername = "com.mysql.cj.jdbc.Driver";//根据建议修改为这个
		String url = "jdbc:mysql://host:3306/database";
		String user = "root"
		String password = "yourpassword"
		
        StreamExecutionEnvironment env = StreamExecutionEnvironment.getExecutionEnvironment();
        
        DataStream<Row> data = env.createInput(JdbcInputFormat.buildJdbcInputFormat()
                .setDrivername(drivername)
                .setDBUrl(url)
                .setUsername(user)
                .setPassword(password)
                .setQuery(sql)
                .setRowTypeInfo(new RowTypeInfo(BasicTypeInfo.FLOAT_TYPE_INFO))//此处的EqDeg是float类型
                .finish());
        //输出测试是否获取到数据
        data.print();
        env.execute();
    }
}

输出结果如下

3>6.0