方法一:
此方法可以执行查询,更新,删除的SQL;
SqlBuffer buffer = SqlBuffer.instance();
buffer.add("select * from T_PM_USER").ln();
IFMIsqlFacade instance = FMIsqlFacadeFactory.getRemoteInstance();
instance.executeSql(buffer.toString());
方法二:
只能执行查询SQL;
SqlBuffer buffer = SqlBuffer.instance();
buffer.add("select * from T_PM_USER").ln();
IRowSet rs = SQLExecutorFactory.getRemoteInstance(buffer.toString()).executeSQL();
方法三:
此方法可以执行查询,更新,删除的SQL;
FDCSQLBuilder builder = new FDCSQLBuilder();
builder.appendSql("select * from T_PM_USER");
IRowSet rowSet = builder.executeQuery();
方法四:
此方法可以执行查询(更新,删除未验证)
com.kingdee.bos.dao.query.SQLExecutor;
String sql = "select * from T_PM_USER";
SQLExecutor se = new SQLExecutor(sql);
RowSet rs = se.executeSQL();
if (rs.next()) {
//.....
}
金蝶EAS BOS 无需上下文就可以执行SQL的方法
最新推荐文章于 2023-01-05 10:31:37 发布