SQL查询编码 jqeuery或js对json数据进行查询

SQL查询编码

select CUS_ID from 表 where CUS_ID in (select a.CUS_ID from 表 as a,表 as b where a.CUS_ID=b.CUS_ID and a.CUS=甲 and b.CUS=乙 and a.time>b.time)
-------------------------------------------------------
SELECT a.CUS_ID
FROM COUST AS a ,COUST AS b
WHERE (a.CUS = 甲) AND (b.CUS = 乙) and a.CUS_ID = b.CUS_ID AND a.TIME > b.TIME
UNION
SELECT CUS_ID FROM COUST
WHERE (CUS_ID IN
(SELECT CUS_ID FROM COUST AS COUST_1 GROUP BY CUS_ID HAVING (COUNT(CUS_ID) = 1))) AND (CUS = 甲)

jqeuery或js对json数据进行查询

使用JSON数据格式，如string str={
layer1：{a：a’,b:b},
layer2:{a:a2,b:b2}
}
拼接类似的字符串json，通过AJax调用，就是后台respone过来，在页面的AJAX中使用eva()或者parseJson装换成json对象。
如 var obj=eval("(" str ")")记住eva转换json必须要加上"(" xx ")"
obj.layer1.a
obj.layer1.b