Here is some code using java 6 to get you started: JSONObject jo = new JSONObject(); jo.put("firstName", "John"); jo.put("lastName", ... ... <看更多>

The values can be any of these types: Boolean , JSONArray , JSONObject , Number , String , or the JSONObject.NULL object . The constructor can convert a ... ... <看更多>

... <看更多>

First we create some test data.. CREATE TEMP TABLE foo AS SELECT jsonb_build_object( 'name', md5(x::text), 'IDS', ARRAY[ trunc(random()*10)+1, ... ... <看更多>