Jkas

参数：Object ...params,可以是HashMap<Integer,Object> params

1、查询

ArrayList<HashMap> preSelect(String sqlkey,Object ...params)

ArrayList<HashMap> sql(String sqlkey).prepareSelect(Object ...params)

String preSelectJson(String sqlkey,Object ...params)

String sql(String sqlkey).prepareSelectJson(Object ...params)

ArrayList<B> preSelect2b(String sqlkey,Object ...params)

ArrayList<B> sql(String sqlkey).prepareSelect2b(Object ...params)

ArrayList<T> preSelect(String sqlkey,Class<T> t,Object ...params)

ArrayList<T> sql(String sqlkey).prepareSelect(Class<T> t,Object ...params)

String preOne(String sqlkey,Object ...params)

String sql(String sqlkey).prepareOne(Object ...params)

HashMap<String,String> preRows(String sqlkey,Object ...params)

HashMap<String,String> sql(String sqlkey).prepareRows(Object ...params)

String preRowsJson(String sqlkey,Object ...params)

String sql(String sqlkey).prepareRowsJson(Object ...params)

B preRows2b(String sqlkey,Object ...params)

B sql(String sqlkey).prepareRows2b(Object ...params)

T preRows(String sqlkey,Class<T> t,Object ...params)

T sql(String sqlkey).prepareRows(Class<T> t,Object ...params)

HashMap<String,Object> preRowsObj(String sqlkey,Object ...params)

HashMap<String,Object> sql(String sqlkey).prepareRowsObj(Object ...params)

ArrayList<String> preCols(String sqlkey,Object ...params)

ArrayList<String> sql(String sqlkey).prepareCols(Object ...params)

String preColsJson(String sqlkey,Object ...params)

String sql(String sqlkey).prepareColsJson(Object ...params)

ArrayList<B> preCols2b(String sqlkey,Object ...params)

ArrayList<B> sql(String sqlkey).prepareCols2b(Object ...params)

ArrayList<T> preCols(String sqlkey,Class<T> t,Object ...params)

ArrayList<T> sql(String sqlkey).prepareCols(Class<T> t,Object ...params)

2、插入

int preQuery(String sqlkey,Object ...params)

int sql(String sqlkey).prepareInsert(Object ...params)

3、更新

int preQuery(String sqlkey,Object ...params)

int sql(String sqlkey).prepareUpdate(Object ...params)

4、删除

int preQuery(String sqlkey,Object ...params)

int sql(String sqlkey).prepareDelete(Object ...params)

5、批量处理

第1步：void sql(String sqlkey).prepares()；//预处理准备

第2步（以下其一操作，重复多次情况用）：预处理执行

ArrayList<HashMap> preparesSelect(HashMap<Integer,Object> params)

String preparesSelectJson(HashMap<Integer,Object> params)

ArrayList<T> preparesSelect(HashMap<Integer,Object> params,Class<T> t)

String preparesOne(HashMap<Integer,Object> params)

HashMap<String,String> perparesRows(HashMap<Integer,Object> params)

String perparesRowsJson(HashMap<Integer,Object> params)

T perparesRows(HashMap<Integer,Object> params,Class<T> t)

ArrayList<String> preparesCols(HashMap<Integer,Object> params)

String preparesColsJson(HashMap<Integer,Object> params)

ArrayList<T> preparesCols(HashMap<Integer,Object> params,Class<T> t)

int preparesQuery(HashMap<Integer,Object> params)

第3步：

void preparesClose()；//关闭所有资源（必须）