import java.sql.*;

public class CheckCesiumMapConfigDetail {
    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, base_layer_type, base_layer_name, " +
                "base_layer_url, terrain_layer_type, terrain_layer_name, terrain_layer_url, " +
                "web_services, loaded_models, is_default, create_time, update_time " +
                "FROM WATERSHED.CESIUM_MAP_CONFIG ORDER BY update_time DESC"
            );
            
            while (rs.next()) {
                System.out.println("\n========================================");
                System.out.println("配置ID: " + rs.getLong("config_id"));
                System.out.println("用户ID: " + rs.getLong("user_id"));
                System.out.println("配置名称: " + rs.getString("config_name"));
                System.out.println("底图类型: " + rs.getString("base_layer_type"));
                System.out.println("底图名称: " + rs.getString("base_layer_name"));
                System.out.println("底图URL: " + rs.getString("base_layer_url"));
                System.out.println("地形类型: " + rs.getString("terrain_layer_type"));
                System.out.println("地形名称: " + rs.getString("terrain_layer_name"));
                System.out.println("地形URL: " + rs.getString("terrain_layer_url"));
                System.out.println("Web服务配置: " + rs.getString("web_services"));
                System.out.println("已加载模型配置: " + rs.getString("loaded_models"));
                System.out.println("是否默认: " + rs.getInt("is_default"));
                System.out.println("创建时间: " + rs.getTimestamp("create_time"));
                System.out.println("更新时间: " + rs.getTimestamp("update_time"));
                System.out.println("========================================");
            }

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