查询

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

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

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

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


 

HashMap<String,String>getInfo(String sqlkey,HashMap<String,Object> params)

String getInfoJson(String sqlkey,HashMap<String,Object> params)

B getInfo2b(String sqlkey,HashMap<String,Object> params)

T getInfo(String sqlkey,HashMap<String,Object> params,Class<T> t)

 

ArrayList<HashMap> select(String sqlkey,HashMap<String,Object> params)

String selectJson(String sqlkey,HashMap<String,Object> params)

ArrayList<T> select(String sqlkey,HashMap<String,Object> params,Class<T> t)

ArrayList<B> select2b(String sqlkey,HashMap<String,Object> params)

 

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

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

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

ArrayList<B> sql(String sqlkey,HashMap<String,Object> params).select2b()

 

HashMap<String,Object> getInfoObj(String sqlkey,HashMap<String,Object> params)

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

 

String getOne(String sqlkey,HashMap<String,Object> params)

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

 

HashMap<String,String> getRows(String sqlkey,HashMap<String,Object> params)

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

String getRowsJson(String sqlkey,HashMap<String,Object> params)

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

B getRows2b(String sqlkey,HashMap<String,Object> params)

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

T getRows(String sqlkey,HashMap<String,Object> params,Cl ass<T> t)

T sql(String sqlkey,HashMap<String,Object> params).getRows(Cl ass<T> t)

 

HashMap<String,Object> getRowsObj(String sqlkey,HashMap<String,Object> params)

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

 

ArrayList<String> getCols(String sqlkey,HashMap<String,Object> params)

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

String getColsJson(String sqlkey,HashMap<String,Object> params)

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

ArrayList<B> getCols2b(String sqlkey,HashMap<String,Object> params)

ArrayList<B> sql(String sqlkey,HashMap<String,Object> params).getCols2b()

ArrayList<T> getCols(String sqlkey,HashMap<String,Object> params,Class<T> t)

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

 

String toSql(String sqlkey,HashMap<String,Object> params)

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

 

举例:

user.m文件内容

insertuser=insert into sc_user (username,password,sex) values('{$username}','sdf',2)
getusers=select * from sc_user where id<{$id}

 

控制器:

UserM um=new UserM();
    HashMap<String,Object> params=new  HashMap<String,Object>();
    params.put("id",5);
    echo(um.select("getusers",params));

 

输出结果: