flinkaddsource

csdnfan_

已于 2022-07-09 11:25:17 修改

阅读量435

点赞数

文章标签： flink

于 2022-06-22 14:51:16 首次发布

本文链接：https://blog.csdn.net/csdnfan_/article/details/125409242

版权

class MySOurceMysql extends RichSourceFunction[String]{
  var conn: Connection =null
  var ps: PreparedStatement =null


  override def open(parameters: Configuration): Unit ={
  //  Driver
    Class.forName("com.mysql.jdbc.Driver")
   conn= DriverManager.getConnection("jdbc:mysql://hdp1:3306/1912b", "root", "root")
   ps=  conn.prepareStatement("select * from t_zk1")
  }

  override def close(): Unit ={
    conn.close()
    ps.close()
  }

  override def run(sourceContext: SourceFunction.SourceContext[String]): Unit = {
    val rs: ResultSet = ps.executeQuery()
    while (rs.next()){
      val s1: String = rs.getString(1)
      val s2: String = rs.getString(2)
      sourceContext.collect(s1+","+s2)
    }
        rs.close()
  }

  override def cancel(): Unit = ???
}