import java.sql.*;

public class QueryCesiumMapConfigData {
    public static void main(String[] args) {
        String url = "jdbc:dm://192.168.0.145:30236?charset=utf8";
        String username = "WATERSHED";
        String password = "WaterShed./1224";

        try {
            Class.forName("dm.jdbc.driver.DmDriver");
            Connection conn = DriverManager.getConnection(url, username, password);
            Statement stmt = conn.createStatement();

            System.out.println("=== 查询所有配置数据 ===");
            ResultSet rs = stmt.executeQuery("SELECT config_id, user_id, config_name, is_default, create_time, update_time FROM WATERSHED.CESIUM_MAP_CONFIG ORDER BY user_id, update_time DESC");
            
            while (rs.next()) {
                System.out.println("ID: " + rs.getLong("config_id") + 
                    ", 用户ID: " + rs.getLong("user_id") + 
                    ", 配置名称: " + rs.getString("config_name") + 
                    ", 是否默认: " + rs.getInt("is_default") + 
                    ", 创建时间: " + rs.getTimestamp("create_time") + 
                    ", 更新时间: " + rs.getTimestamp("update_time"));
            }

            System.out.println("\n=== 统计每个用户的配置数量 ===");
            ResultSet rs2 = stmt.executeQuery("SELECT user_id, COUNT(*) as count FROM WATERSHED.CESIUM_MAP_CONFIG GROUP BY user_id");
            
            while (rs2.next()) {
                System.out.println("用户ID: " + rs2.getLong("user_id") + ", 配置数量: " + rs2.getInt("count"));
            }

            System.out.println("\n=== 查找重复配置（同一用户有多条） ===");
            ResultSet rs3 = stmt.executeQuery("SELECT user_id, COUNT(*) as count FROM WATERSHED.CESIUM_MAP_CONFIG GROUP BY user_id HAVING COUNT(*) > 1");
            
            boolean hasDuplicates = false;
            while (rs3.next()) {
                hasDuplicates = true;
                System.out.println("用户ID: " + rs3.getLong("user_id") + ", 重复数量: " + rs3.getInt("count"));
            }
            
            if (!hasDuplicates) {
                System.out.println("没有发现重复配置");
            }

            rs.close();
            rs2.close();
            rs3.close();
            stmt.close();
            conn.close();
            
        } catch (Exception e) {
            e.printStackTrace();
        }
    }
}