E10--二次开发数据库操作

1. 数据库的操作方法

ExecuteSqlEntity executeSqlEntity = new ExecuteSqlEntity();  
executeSqlEntity.setSql(Base64.encode(sql));  
// groupId 可以访问 E10地址/api/datasource/ds/group?sourceType=LOGIC 获取  
executeSqlEntity.setGroupId("weaver-workflow-report-serviceworkflowreport");  
executeSqlEntity.setSourceType(SourceType.LOGIC);  
Map<String, Object> datas = dataSetService.executeSql(executeSqlEntity);

sourceType的枚举值如下:

ETEAMS("eteams"),  
FORM("form"),  
BIZ("biz"),  
LOGIC("logic"),  
EXTERNAL("external"),  
INNERAPI("innerapi"),  
EXTERNALDATASET("externalDataSet"),  
LOCALDS("localds"),  
BIDS("biDs"),  
INTEGRATION("integration");

2. GroupId的获取方式

2.1 api接口

访问 E10地址/api/datasource/ds/group?sourceType=LOGIC获取接口中的id字段值作为groupId的值

2.2 查询数据库

在数据库中执行如下语句:select service_mark,application,application_mark,application_name from eteams.ds_mark_service_relation where application_name is not null and application_name != ''