java mysql发送数据到kafka，消费数据之后将数据保存进hive

一.连接mysql

public class JdbcToMysql {
   
    private static Connection connection = JdbcConnecMysql.getConnection();
    private static PreparedStatement ps;
    private static ResultSet resultSet;

    public static List<Table> getData(String tables) {
   
        String sql = "select * from " + tables;
        List<Table> testData = new ArrayList<>();
        try {
   
            ps = JdbcConnecMysql.preparedStatement(connection, sql);
            resultSet = ps.executeQuery();
            while (resultSet.next()) {
   
                Table test = new Table();
                test.setId(resultSet.getInt("id"));
                test.setName(resultSet.getString("name"));
                test.setAge(resultSet.getInt("age"));
                testData.add(test);
            }
        } catch (SQLException e) {
   
            e.printStackTrace();
        }
        System.out.println("===="+testData);
        return testData;
    }

    public static void main(String[] args) {
   
        Scanner scanner = new Scanner(System.in);
        System.out.println("请输入表名：");
        String tables = scanner.next();
        JdbcToMysql.getData(tables);
    }
}

二.将数据发送给kafka生产者

public class JdbcConnecKafkaProducer {
   
    private static KafkaProducer<String, String> producer;
    private final static String TOPIC = "test";
    public JdbcConnecKafkaProducer() {
   
        Properties ppt = new Properties();
        ppt.put("bootstrap.servers", "10.0.13.145:9092")