使用apache poi和DFC将DQL查询结果写入并附加到java中的excel中。

import java.io.FileOutputStream;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;
import org.apache.poi.ss.usermodel.*;

import com.documentum.fc.client.*;
import com.documentum.fc.common.*;

public class DQLToExcel {
    public static void main(String[] args) {
        try {
            // 创建新的Excel文件
            Workbook workbook = new HSSFWorkbook();
            Sheet sheet = workbook.createSheet("DQL Results");

            // 连接到Documentum服务器
            IDfClient client = DfClient.getLocalClient();
            IDfSessionManager sessionManager = client.newSessionManager();
            IDfLoginInfo loginInfo = new DfLoginInfo();
            loginInfo.setUser("username");
            loginInfo.setPassword("password");
            sessionManager.setIdentity("repository", loginInfo);
            IDfSession session = sessionManager.getSession("repository");

            // 执行DQL查询
            String dqlQuery = "SELECT object_name, r_object_id FROM dm_document WHERE folder('/Temp')";
            IDfQuery query = new DfQuery();
            query.setDQL(dqlQuery);
            IDfCollection collection = query.execute(session, IDfQuery.DF_READ_QUERY);

            // 获取查询结果并写入Excel文件
            int rowNumber = 0;
            while (collection.next()) {
                Row row = sheet.createRow(rowNumber++);
                Cell cell1 = row.createCell(0);
                cell1.setCellValue(collection.getString("object_name"));
                Cell cell2 = row.createCell(1);
                cell2.setCellValue(collection.getString("r_object_id"));
            }

            // 保存Excel文件
            FileOutputStream outputStream = new FileOutputStream("path/to/excel.xls");
            workbook.write(outputStream);
            outputStream.close();

            // 关闭连接和资源
            collection.close();
            sessionManager.release(session);
            sessionManager.clearIdentity("repository");
        } catch (Exception e) {
            e.printStackTrace();
        }
    }
}