Understanding EMSE APIs

You can invoke SQL statements in third-party databases by the following three 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.