【日常开发】使用查询分析器调用接口预留的接口

栏目:eas cloud知识作者:金蝶来源:金蝶云社区发布:2024-09-16浏览:1

【日常开发】使用查询分析器调用接口预留的接口

**1,示例代码** ```java -- 代码示例 /** * 查询相关表的时间戳字段值 * @param tableName * @param fid * @param fileds * @return * @throws Exception */ public static String setDateToSpecificTimeNew(String tableName, String fid, String... fileds) throws Exception { Context context = ConfigMDUtil.getContext(); StringBuilder sql = new StringBuilder("SELECT "); sql.append("fid"); sql.append(","); for (int i = 0; i < fileds.length; i++) { sql.append(fileds[i]); sql.append(","); } sql.deleteCharAt(sql.length() - 1); sql.append(" from "); sql.append(tableName + " where fid = '"); sql.append(fid + "'"); HashMap map = new HashMap(); IRowSet rowSet = DbUtil.executeQuery(context, sql.toString()); if (rowSet != null && rowSet.next()) { for (int i = 0; i < fileds.length; i++) { map.put(fileds[i], rowSet.getTime(fileds[i]).getTime()); } } StringBuilder result = new StringBuilder(); result.append("表"); result.append(tableName); result.append("查询时间戳结果为---> "); result.append("fid" + "=" + fid); result.append(" "); result.append(map.toString()); return result.toString(); } ``` **2,触发示例**: com.kingdee.eas.basedata.assistant.app.O_PeriodControllerBean.setDateToSpecificTimeNew("T_BD_ExchangeRate","HxsHGDMUQiuFN/eEzvSF24DlR+4=","FAVAILTIME"); 在查询分析器以运行“客户端方式”或则“服务端方式”执行,需要根基实际情况选择 ![image.webp](/download/01003e45550505904dfc8150fae274fc87d8.webp)

【日常开发】使用查询分析器调用接口预留的接口

**1,示例代码**```java-- 代码示例/** * 查询相关表的时间戳字段值 * @param tableName * @param fid * @param fileds ...
点击下载文档
分享:
确认删除?
回到顶部
客服QQ
  • 客服QQ点击这里给我发消息