52,797
社区成员
发帖
与我相关
我的任务
分享
<Table width="500" border="1">
<Thead>
<Tr>
<Td>商品编号</Td><Td>商品名称</Td><Td>规格</Td><Td>型号</Td><Td>数量</Td>
</Tr>
</Thead>
<Tbody>
<Tr>
<Td>00001</Td><Td>大宝</Td><Td>瓶装</Td><Td>00215</Td><Td>10</Td>
<Td>00001</Td><Td>飘柔</Td><Td>瓶装</Td><Td>00215</Td><Td>10</Td>
<Td>00001</Td><Td>海飞丝</Td><Td>瓶装</Td><Td>00215</Td><Td>10</Td>
</Tr>
</Tbody>
</Table>
<Table width="500" border="1">
<Thead>
<Tr>
<Td>商品编号</Td><Td>商品名称</Td><Td>规格</Td><Td>型号</Td><Td>数量</Td>
</Tr>
</Thead>
<Tbody id="tbodyData">
<Tr>
<Td>00001</Td><Td>大宝</Td><Td>瓶装</Td><Td>00215</Td><Td>10</Td> </Tr>
<Tr><Td>00001</Td><Td>飘柔</Td><Td>瓶装</Td><Td>00215</Td><Td>10</Td> </Tr>
<Tr><Td>00001</Td><Td>海飞丝1</Td><Td>瓶装</Td><Td>00215</Td><Td>10</Td> </Tr>
<Tr><Td>00001</Td><Td>海飞丝2</Td><Td>瓶装</Td><Td>00215</Td><Td>10</Td> </Tr>
<Tr><Td>00001</Td><Td>海飞丝3</Td><Td>瓶装</Td><Td>00215</Td><Td>10</Td>
</Tr>
</Tbody>
<tr><td colspan="5" align="center"><input type="button" onclick="SendData()" value="发送数据"/></td></tr>
</Table>
<script>
function $(id){return document.getElementById(id);}
function createObj()
{
var o=null;
if(typeof(XMLHttpRequest)!="undefined") return new XMLHttpRequest();
if(window.ActiveXObject){
var MSXML=["MSXML2.XMLHttp.5.0","MSXML2.XMLHttp.4.0","MSXML2.XMLHttp.3.0","MSXML2.XMLHttp","Microsoft.XMLHTTP"];
for(var i=0;i<MSXML.length;i++){
try{
o= new ActiveXObject(MSXML[i]);return o;
}
catch(e){}
}
}
return null;
}
//以一定数据格式收集数据,格式为“商品编号,商品名称,规格,型号,数量|商品编号,商品名称,规格,型号,数量"这种,就是每个产品的信息
用逗号分隔,每个产品用|号分隔
function CollectData(){
var data="";
var d=$("tbodyData");
//注意要编码下数据,防止出现乱码
for(var i=0;i<d.rows.length;i++)
data+=d.rows[i].cells[0].innerHTML+","+escape(d.rows[i].cells[1].innerHTML)+","+escape(d.rows[i].cells[2].innerHTML)
+","+d.rows[i].cells[3].innerHTML+","+d.rows[i].cells[4].innerHTML+"|";
if(data!="")data=data.substr(0,data.length-1);//去掉最好一个|
return data;
}
function SendData(){
var data=CollectData();
var o=createObj();
o.open("post","db.asp",true);
o.onreadystatechange=function(){
if(o.readyState==4){
if(o.status==200)alert("插入成功!");//成功
else alert("发生错误!\n\n"+o.responseText);//错误
}
}
o.setRequestHeader("content-type","application/x-www-form-urlencoded");//注意要设置头
o.send("data="+data);//发送收集的数据
}
</script>
data=request.form("data")'这个就是你接收到的数据,然后按上面的格式分析你的数据
pro=split(data,"|")
for i=0 to ubound(pro)
info=split(pro(i),",")
'下面为你的插入数据库代码,这里只是显示数据而已
response.write "商品编号"&info(0)&vbnewline
response.write "商品名称"&info(1)&vbnewline
response.write "规格"&info(2)&vbnewline
response.write "型号"&info(3)&vbnewline
response.write "数量"&info(4)&vbnewline
resposne.write "<hr>"
next