@@ -227,26 +227,107 @@ public static boolean isWord(String key) {
227227 //judge >>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
228228
229229
230+ //JSONObject内关键词 key <<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<
230231
231- public static final String KEY_COLUMNS = "@columns" ;//@key关键字都放这个类
232+ public static final String KEY_COLUMN = "@column" ;//@key关键字都放这个类
233+ public static final String KEY_GROUP = "@group" ;//@key关键字都放这个类
234+ public static final String KEY_HAVING = "@having" ;//@key关键字都放这个类
235+ public static final String KEY_ORDER = "@order" ;//@key关键字都放这个类
232236
233- /**set columns need to be returned
234- * @param columns "column0,column1,column2..."
237+ /**set keys need to be returned
238+ * @param keys key0, key1, key2 ...
239+ * @return {@link #setColumn(String)}
240+ */
241+ public JSONObject setColumn (String ... keys ) {
242+ return setColumn (StringUtil .getString (keys ));
243+ }
244+ /**set keys need to be returned
245+ * @param keys "key0,key1,key2..."
235246 * @return
236247 */
237- public JSONObject setColumns (String columns ) {
238- put (KEY_COLUMNS , columns );
248+ public JSONObject setColumn (String keys ) {
249+ put (KEY_COLUMN , keys );
239250 return this ;
240251 }
241- public String getColumns () {
242- return getString (KEY_COLUMNS );
252+ public String getColumn () {
253+ return getString (KEY_COLUMN );
243254 }
244-
255+
256+ /**set keys for group by
257+ * @param keys key0, key1, key2 ...
258+ * @return {@link #setGroup(String)}
259+ */
260+ public JSONObject setGroup (String ... keys ) {
261+ return setGroup (StringUtil .getString (keys ));
262+ }
263+ /**set keys for group by
264+ * @param keys "key0,key1,key2..."
265+ * @return
266+ */
267+ public JSONObject setGroup (String keys ) {
268+ put (KEY_GROUP , keys );
269+ return this ;
270+ }
271+ public String getGroup () {
272+ return getString (KEY_GROUP );
273+ }
274+
275+ /**set keys for having
276+ * @param keys count(key0) > 1, sum(key1) <= 5, function2(key2) ? value2 ...
277+ * @return {@link #setHaving(String)}
278+ */
279+ public JSONObject setHaving (String ... keys ) {
280+ return setHaving (StringUtil .getString (keys ));
281+ }
282+ /**set keys for having
283+ * @param keys "key0,key1,key2..."
284+ * @return
285+ */
286+ public JSONObject setHaving (String keys ) {
287+ put (KEY_HAVING , keys );
288+ return this ;
289+ }
290+ public String getHaving () {
291+ return getString (KEY_HAVING );
292+ }
293+
294+ /**set keys for order by
295+ * @param keys key0, key1+, key2- ...
296+ * @return {@link #setOrder(String)}
297+ */
298+ public JSONObject setOrder (String ... keys ) {
299+ return setOrder (StringUtil .getString (keys ));
300+ }
301+ /**set keys for order by
302+ * @param keys "key0,key1+,key2-..."
303+ * @return
304+ */
305+ public JSONObject setOrder (String keys ) {
306+ put (KEY_ORDER , keys );
307+ return this ;
308+ }
309+ public String getOrder () {
310+ return getString (KEY_ORDER );
311+ }
312+
313+
314+ //JSONObject内关键词 key >>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
245315
246316
247317
248318 //Request,默认encode <<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<
249319
320+
321+ /**
322+ * encode = true
323+ * @param value
324+ * @param parts path = keys[0] + "/" + keys[1] + "/" + keys[2] + ...
325+ * @return #put(key+"@", StringUtil.getString(keys, "/"), true)
326+ */
327+ public Object putPath (String key , String ... keys ) {
328+ return put (key +"@" , StringUtil .getString (keys , "/" ), true );
329+ }
330+
250331 /**
251332 * encode = true
252333 * @param key
@@ -260,10 +341,10 @@ public JSONObject putNull(String key, boolean isNull) {
260341 * @param key
261342 * @param isNull
262343 * @param encode
263- * @return
344+ * @return put(key+"{}", SQL.isNull(isNull), encode);
264345 */
265346 public JSONObject putNull (String key , boolean isNull , boolean encode ) {
266- put (key + "{}" , SQL .isNull (isNull ), encode );
347+ put (key + "{}" , SQL .isNull (isNull ), encode );
267348 return this ;
268349 }
269350 /**
@@ -288,10 +369,10 @@ public JSONObject putEmpty(String key, boolean isEmpty, boolean trim) {
288369 * @param key
289370 * @param isEmpty
290371 * @param encode
291- * @return
372+ * @return put(key+"{}", SQL.isEmpty(key, isEmpty, trim), encode);
292373 */
293374 public JSONObject putEmpty (String key , boolean isEmpty , boolean trim , boolean encode ) {
294- put (key + "{}" , SQL .isEmpty (key , isEmpty , trim ), encode );
375+ put (key + "{}" , SQL .isEmpty (key , isEmpty , trim ), encode );
295376 return this ;
296377 }
297378 /**
@@ -307,10 +388,10 @@ public JSONObject putLength(String key, String compare) {
307388 * @param key
308389 * @param compare <=0, >5 ...
309390 * @param encode
310- * @return
391+ * @return put(key+"{}", SQL.length(key) + compare, encode);
311392 */
312393 public JSONObject putLength (String key , String compare , boolean encode ) {
313- put (key + "{}" , SQL .length (key ) + compare , encode );
394+ put (key + "{}" , SQL .length (key ) + compare , encode );
314395 return this ;
315396 }
316397
@@ -338,16 +419,10 @@ public JSONObject putSearch(String key, String value, int type) {
338419 * @param value
339420 * @param type
340421 * @param encode
341- * @return
422+ * @return put(key+"$", SQL.search(value, type), encode);
342423 */
343424 public JSONObject putSearch (String key , String value , int type , boolean encode ) {
344- if (key == null ) {
345- key = "" ;
346- }
347- if (key .endsWith ("$" ) == false ) {
348- key += "$" ;
349- }
350- put (key , SQL .search (value , type ), encode );
425+ put (key +"$" , SQL .search (value , type ), encode );
351426 return this ;
352427 }
353428
0 commit comments