前台的代码
<table id="datas" border="1" cellspacing="0" style="border-collapse: collapse">
<tr>
<th>
商品编号</th>
<th>
商品名称</th>
<th>
生产日期</th>
<th>
是否过期</th>
</tr>
<tr id="template">
<td id="bianhao">
</td>
<td id="mingcheng">
</td>
<td id="riqi">
</td>
<td id="guoqi">
</td>
</tr>
</table>
后台的代码
<?xml version="1.0" ?>
<!DOCTYPE FTCS SYSTEM "futuretense_cs.dtd">
<FTCS Version="1.1">
<!-- Commodity/Action/testAjaxCRUD_commodity
-
- INPUT
-
- OUTPUT
-
-->
<IF COND="Variables.crud=R"><THEN>
<EXECSQL LIST="listShangPin" TABLE="cm_shangpinxinxi" SQL="
SELECT
id
shangpinbianhao
shangpinmingcheng
shengchanriqi
shifouguoqi
from cm_shangpinxinxi
where status!='VO'
AND id='Variables.xml_id'
"/>
<IF COND="listShangPin.#numRows!=0"><THEN>
<LOOP LIST="listShangPin">
[{
xml_shangpinbianhao:'<CSVAR NAME="listShangPin.shangpinbianhao"/>',
xml_shangpinmingcheng:'<CSVAR NAME="listShangPin.shangpinmingcheng"/>',
xml_shengchanriqi:'<CSVAR NAME="listShangPin.shengchanriqi"/>',
xml_shifouguoqi:'<CSVAR NAME="listShangPin.shifouguoqi"/>',
xml_id:'<CSVAR NAME="listShangPin.id"/>'
}]
</THEN></IF>
</THEN></IF>
</FTCS>
.js代码
$(document).ready(function(){
$.ajax({
type:"get",
dataType:"json",
url:"ContentServer?pagename=Commodity/Page/testAjaxCRUD_commodity",
success:function(msg){
var data=msg.table;
$.each(data,function(i,n){
alert(123);
var row=$("#remplate").clone();
row.find("#bianhao").text(listShangPin.shangpinbianhao);
row.find("mingcheng").text(listShangPin.shangpinminfcheng);
row.find("riqi").text(listShangPin.shengchanriqi);
row.find("guoqi").text(xml_shifouguoqi);
})
}
})
})
我要ajax访问后台是把数据库里的返回到前台显示,该怎么写,我这么写对吗,谁能知道我一下啊,我现在真的是一头雾水。