在指定了DataSet的Input后,只需要指定一个OutputFormat即可,OutputFormat的作用就是将数据集写入指定的存储中。
//创建数据汇
public static OutputFormat insertMysql(){
OutputFormat insertMysql = JDBCOutputFormat.buildJDBCOutputFormat()
.setDrivername("com.mysql.jdbc.Driver")
.setDBUrl("jdbc:mysql://10.250.115.210:3306/jerry")
.setUsername("root")
.setPassword("123456")
.setQuery("insert into test(id, age) values(?,?)")
.finish();
return insertMysql;
}
public static void main(String[] args) throws Exception {
ExecutionEnvironment env = ExecutionEnvironment.getExecutionEnvironment();
DataSet inputMysql = jdbcRead(env);
//输出到mysql
inputMysql.output(insertMysql());
env.execute();
}