28,391
社区成员
发帖
与我相关
我的任务
分享
目前获得的JSON 数据格式
[ {"id":"46","xingming":"安淑秋","peixunmc":"1456","kstime":"2014-6-19","px_fenshu":12,"_id":1,"_uid":1,"_state":"modified"},
{"id":"47","xingming":"程彦辉","peixunmc":"1456","kstime":"2014-6-19","px_fenshu":23,"_id":2,"_uid":2,"_state":"modified"},
{"id":"48","xingming":"王利伟","peixunmc":"1456","kstime":"2014-6-19","px_fenshu":33,"_id":3,"_uid":3,"_state":"modified"} ]
<!--#include file="../include/URLDecode.jsp"-->
<script language="JScript" runat="Server">
function toObject(json) {
eval("var o=" + json);
return o;
}
</script>
<%
Dim json
json =Request("submitData")
rows=URLDecode(json)
if right(rows,1)="]" then
rows=left(rows,len(rows)-1)
end if
if left(rows,1)="[" then
rows=right(rows,len(rows)-1)
end if
Set json = toObject(rows)
set rs=server.createobject("ADODB.recordset")
sqlsave = "select * from hr_Training_records"
rs.Open sqlsave,conn,1,3
rs.addNew
rs("peixunneirong") =json.id
rs.update
rs.close
set rs = nothing