Types

SINGLE QUERY OPERATIONS

SELECT

  • select without where conditions

SELECT_WPARAMS

  • select with where conditions

DML

  • all DML operations return -1 in failure else success

DML_GENID

  • all DML operations return id if it success else -1. But Table should has auto increment ID.

MULTI_DML - ARRAY INSERT OPERATIONS

MULTI_DML

  • JSONArray input insert/update multiple data in same table

MULTIPLE DML OPERATION FOR DIFFERENT TABLES

multi_process(jconx_query_array,json_data)

jconx_query_array is ArrayList, each String has JCONX_QUERY format. return is JSONArray. If any DML statement throw error, it doesn't execute other statements.