FlinkMysqlSource&FlinkMysqlSink

/**

 * 自定义Mysql Source

 */

public class CustomerMysqlSourceDemo {

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

        StreamExecutionEnvironment env = StreamExecutionEnvironment.getExecutionEnvironment();

        // 获得自定义Source对象

        DataStreamSource<UserInfo> mysqlSource = env.addSource(new MyMysqlSource());

        mysqlSource.print();

        env.execute("CustomerMySQLSourceDemo");

    }

    /**

     自定义Mysql Source实现类

     */

    public static class MyMysqlSource extends RichSourceFunction<UserInfo> {

        private Connection connection = null;       // 定义数据库连接对象

        private PreparedStatement ps = null;        // 定义PreparedStatement对象

        /*

        使用open方法, 这个方法在实例化类的时候会执行一次, 比较适合用来做数据库连接

         */

        @Override

        public void open(Configuration parameters) throws Exception {

            super.open(parameters);

            // 加载数据库驱动

            Class.forName("com.mysql.jdbc.Driver");

            // 创建数据库连接

            String url = "jdbc:mysql://node01:3306/flinkdemo?useUnicode=true&characterEncoding=utf-8&useSSL=false";

            this.connection