| | |
| | | // 格式:[{字段1:值1, 字段2:值2},{字段1:值3, 字段2:值4}...]
|
| | | public NativeArray queryRecord(String tableName, NativeArray arrColumns, NativeObject arrTimeGroup, NativeArray arrOrderColumns, NativeObject arrLimit, NativeArray arrFilters) throws Exception
|
| | | {
|
| | | StringBuilder sbSQL = new StringBuilder();
|
| | | sbSQL.append("SELECT ");
|
| | | for(int i = 0; i < arrColumns.size(); i ++)
|
| | | {
|
| | | String colName = SMTStatic.toString(SMTAIServerApp.unwrapObject(arrColumns.get(i)));
|
| | | if(i > 0)
|
| | | sbSQL.append(",");
|
| | | sbSQL.append(colName);
|
| | | }
|
| | | |
| | | |
| | | return null;
|
| | | }
|
| | | |
| | | public NativeArray queryRecord1(String tableName, NativeArray arrColumns, NativeObject arrTimeGroup, NativeArray arrOrderColumns, NativeObject arrLimit, NativeArray arrFilters) throws Exception
|
| | | {
|
| | | if(tableName.startsWith("dev_names"))
|
| | | {
|
| | | NativeObject nvRec = new NativeObject();
|