import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;

public class UpdateProjectDetails {
    public static void main(String[] args) {
        // 使用UTF-8编码的连接字符串
        String url = "jdbc:dm://192.168.0.145:30236?charset=utf8&useUnicode=true&characterEncoding=utf8";
        String username = "WATERSHED";
        String password = "WaterShed./1224";

        try {
            Class.forName("dm.jdbc.driver.DmDriver");
            Connection connection = DriverManager.getConnection(url, username, password);
            
            // 更新项目ID为1的项目详情信息
            String sql = "UPDATE PROJECT SET project_details = ? WHERE project_id = 1";
            PreparedStatement stmt = connection.prepareStatement(sql);
            
            // 使用UTF-8编码的JSON数据，包含中文信息
            String projectDetailsJson = "{\"title\":\"数字孪生太浦河\",\"subtitle\":\"基于数字孪生技术的太浦河流域综合管理平台\",\"coverImage\":\"/assets/images/太浦河全景2.png\",\"overview\":\"数字孪生太浦河平台，运用多源数据融合等技术构建了符合太湖流域平原感潮河网地区特点的数据底板\",\"achievements\":[],\"caseStudies\":[{\"type\":\"image\",\"image\":\"/assets/images/太浦河全景2.png\",\"title\":\"流域监测中心\",\"description\":\"集成多源数据的综合监测中心\"}],\"technicalHighlights\":{\"dataBase\":{\"title\":\"数据底板\",\"description\":\"数据底板构建核心在于构建符合平原感潮河网双向水流、水位多变特点的全要素、高精度、动态化数字映射\",\"features\":[\"多源数据融合\",\"水利枢纽\",\"三维场景\"],\"images\":[\"/assets/images/太浦河全景2.png\"]}},\"applicationEffects\":[],\"materials\":[]}";
            
            stmt.setString(1, projectDetailsJson);
            int rowsUpdated = stmt.executeUpdate();
            
            System.out.println("成功更新了 " + rowsUpdated + " 条记录");
            
            stmt.close();
            connection.close();
            
        } catch (Exception e) {
            e.printStackTrace();
        }
    }
}