如何在java中将表的增量从DB读取到Kafka Producer中？

import java.sql.*;
import java.util.Properties;
import org.apache.kafka.clients.producer.*;

public class DBToKafka {
    public static void main(String[] args) {
        // 设置数据库连接信息
        String url = "jdbc:mysql://localhost:3306/mydb";
        String username = "root";
        String password = "password";

        // 设置Kafka Producer配置
        Properties props = new Properties();
        props.put("bootstrap.servers", "localhost:9092");
        props.put("key.serializer", "org.apache.kafka.common.serialization.StringSerializer");
        props.put("value.serializer", "org.apache.kafka.common.serialization.StringSerializer");

        try {
            // 连接数据库
            Connection conn = DriverManager.getConnection(url, username, password);

            // 执行SQL查询
            Statement stmt = conn.createStatement();
            ResultSet rs = stmt.executeQuery("SELECT * FROM mytable WHERE timestamp > '2022-01-01'");

            // 创建Kafka Producer
            Producer<String, String> producer = new KafkaProducer<>(props);

            // 遍历查询结果集，发送消息到Kafka
            while (rs.next()) {
                String key = rs.getString("id");
                String value = rs.getString("data");
                ProducerRecord<String, String> record = new ProducerRecord<>("mytopic", key, value);
                producer.send(record);
            }

            // 关闭数据库连接和Kafka Producer
            rs.close();
            stmt.close();
            conn.close();
            producer.close();
        } catch (SQLException e) {
            e.printStackTrace();
        }
    }
}