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

public class CheckProjectDetails {
    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 connection = DriverManager.getConnection(url, username, password);
            
            // Check table structure
            System.out.println("Checking table structure...");
            String describeSql = "SELECT column_name, data_type, data_length FROM user_tab_columns WHERE table_name = 'PROJECT'";
            PreparedStatement describeStmt = connection.prepareStatement(describeSql);
            ResultSet describeRs = describeStmt.executeQuery();
            while (describeRs.next()) {
                System.out.println("Column: " + describeRs.getString(1) + ", Type: " + describeRs.getString(2) + ", Length: " + describeRs.getString(3));
            }
            describeRs.close();
            describeStmt.close();
            
            // Query all project data
            System.out.println("\nQuerying all project data...");
            String selectSql = "SELECT project_id, project_name, project_details FROM PROJECT";
            PreparedStatement selectStmt = connection.prepareStatement(selectSql);
            ResultSet rs = selectStmt.executeQuery();
            
            while (rs.next()) {
                Long projectId = rs.getLong("project_id");
                String projectName = rs.getString("project_name");
                String projectDetails = rs.getString("project_details");
                
                System.out.println("Project ID: " + projectId + ", Project Name: " + projectName);
                
                if (projectDetails != null) {
                    System.out.println("Project Details Length: " + projectDetails.length());
                    System.out.println("Project Details (first 100 chars): " + projectDetails.substring(0, Math.min(100, projectDetails.length())) + "...");
                } else {
                    System.out.println("Project Details: null");
                }
                
                System.out.println("------------------------------");
            }
            
            rs.close();
            selectStmt.close();
            connection.close();
            
        } catch (Exception e) {
            e.printStackTrace();
        }
    }
}