Third-Party Databases and EMSE APIs
Civic Platform provides APIs that enable administrators to search for, insert, delete, and update records in third-party databases with SQL statements.
Invoke SQL statements in third-party databases with these EMSE APIs.
| API Name | API Detail | API Description |
|---|---|---|
| aa.util.update | ScriptResult update(String dataSourceName, String sqlString, Object[ ] parameters) | Use this API for inserting, deleting, and updating records. |
| aa.util.batchUpdate | ScriptResult batchUpdate(String dataSourceName, String sqlString, Object[ ] parameters) | Use this API for batch inserting, deleting, and updating records. |
| aa.util.select | ScriptResult select(String dataSourceName, String sqlString, Object[ ] parameters) | Use this API for searching for records. |
|
Note: These APIs do not support the DROP TABLE operation of data
definition language (DDL) or stored procedures.
|
||
Invoke SQL statements in third-party databases with these APIs.
| API Name | API Detail | API Description |
|---|---|---|
| aa.util.update | ScriptResult update(String dataSourceName, String sqlString, Object[ ] parameters) | Use this API for inserting, deleting, and updating records. |
| aa.util.batchUpdate | ScriptResult batchUpdate(String dataSourceName, String sqlString, Object[ ] parameters) | Use this API for batch inserting, deleting, and updating records. |
| aa.util.select | ScriptResult select(String dataSourceName, String sqlString, Object[ ] parameters) | Use this API for searching for records. |
|
Note: These APIs do not support the DROP TABLE operation of data
definition language (DDL) or stored procedures.
|
||