解析json的函数

求一个解析json的函数
已知传过来的json字符为“{"jsons":
[{"date":"星期一","con":[{"dtype":"早点","dcon":"豆浆,花生酥","dorder":"1"},
{"dtype":"餐前水果","dcon":"苹果","dorder":"2"},
{"dtype":"午餐","dcon":"肉饼蒸蛋,韭菜虾皮,红烧南瓜,青菜豆腐汤","dorder":"3"},
{"dtype":"午点","dcon":"盐水花生","dorder":"4"},
{"dtype":"晚餐","dcon":"糖醋小排,茭白炒开洋,炒青菜,紫菜汤","dorder":"5"},
{"dtype":"晚点","dcon":"水果","dorder":"6"},
{"dtype":"","dcon":"","dorder":"7"}]},
{"date":"星期二","con":[{"dtype":"早点","dcon":"豆浆,甜玉米","dorder":"1"},
{"dtype":"餐前水果","dcon":"青瓜","dorder":"2"},
{"dtype":"午餐","dcon":"牛肉炒饭,冬瓜虾皮汤","dorder":"3"},
{"dtype":"午点","dcon":"八宝粥","dorder":"4"},
{"dtype":"晚餐","dcon":"红烧鸡腿,土豆丝,肉末扁豆,青菜香菇汤","dorder":"5"},
{"dtype":"晚点","dcon":"糕点","dorder":"6"},
{"dtype":"","dcon":"","dorder":"7"}]},
{"date":"星期三","con":[
{"dtype":"早点","dcon":"豆浆,萨其马","dorder":"1"},
{"dtype":"餐前水果","dcon":"雪莲","dorder":"2"},
{"dtype":"午餐","dcon":"本鸡菌煲,椒盐日本豆腐,炒生菜,土豆咸菜汤","dorder":"3"},
{"dtype":"午点","dcon":"黑糥米球","dorder":"4"},
{"dtype":"晚餐","dcon":"红烧鸡腿,土豆丝,肉末扁豆,青菜香菇汤","dorder":"5"},
{"dtype":"晚点","dcon":"水果","dorder":"6"},
{"dtype":"","dcon":"","dorder":"7"}]},
{"date":"星期四","con":[
{"dtype":"早点","dcon":"豆浆,迷你红薯","dorder":"1"},
{"dtype":"餐前水果","dcon":"香蕉","dorder":"2"},
{"dtype":"午餐","dcon":"炸响铃,肉丝四季豆,炒黄鳝丝","dorder":"3"},
{"dtype":"午点","dcon":"华夫饼干","dorder":"4"},
{"dtype":"晚餐","dcon":"花菜炒肉片,炒三丝,红烧素鸡,番茄蛋花汤","dorder":"5"},
{"dtype":"晚点","dcon":"糕点","dorder":"6"},
{"dtype":"","dcon":"","dorder":"7"}]},
{"date":"星期五","con":[
{"dtype":"早点","dcon":"鲜牛奶,青菜猪肉末粥,干炒河粉,糖醋花生米","dorder":"1"},
{"dtype":"餐前水果","dcon":"西瓜","dorder":"2"},
{"dtype":"午餐","dcon":"盐水对虾,肉末茄子,包心菜,紫菜汤","dorder":"3"},
{"dtype":"午点","dcon":"玉米","dorder":"4"},
{"dtype":"晚餐","dcon":"甲鱼菌煲,娃娃菜,红烧萝卜,肉丝榨菜汤","dorder":"5"},
{"dtype":"晚点","dcon":"水果","dorder":"6"},
{"dtype":"","dcon":"","dorder":"7"}]},
{"date":"星期六","con":[
{"dtype":"早餐","dcon":"","dorder":"1"},
{"dtype":"上午餐","dcon":"","dorder":"2"},
{"dtype":"午餐","dcon":"","dorder":"3"},
{"dtype":"下午餐","dcon":"","dorder":"4"},
{"dtype":"晚餐","dcon":"","dorder":"5"},
{"dtype":"","dcon":"","dorder":"6"},
{"dtype":"","dcon":"","dorder":"7"}]},
{"date":"星期日","con":[
{"dtype":"早餐","dcon":"","dorder":"1"},
{"dtype":"上午餐","dcon":"","dorder":"2"},
{"dtype":"午餐","dcon":"","dorder":"3"},
{"dtype":"下午餐","dcon":"","dorder":"4"},
{"dtype":"晚餐","dcon":"","dorder":"5"},
{"dtype":"","dcon":"","dorder":"6"},
{"dtype":"","dcon":"","dorder":"7"}]} ]}”，有二层结构，代表一个星期的餐谱

求：解析第一层结构，分别得到一周七天的数据
结果：date            con
            星期一       内容字符串
            星期二       内容字符串
           。。。        。。。。。
          星期七         内容字符串
------解决思路----------------------
SQL不好处理这个，让程序来处理要好很多
------解决思路----------------------
在程序中处理吧,   很多工具都有JSON的解析类了,而且, 效率估计也比你放SQL里面来解析来的高吧.
------解决思路----------------------
http://blog.csdn.net/fengyarongaa/article/details/7097520