比如:<SCRIPT LANGUAGE="JavaScript">
<!--
//第一组
var Beijing = new Array(
"0" , "东城区",
"1" , "西城区",) ;
//第二组
var Shanghai = new Array(
"0" , "黄浦区",
"1" , "卢湾区",
"2" , "徐汇区",) ;
//第N组
//-->
</SCRIPT>
我怎么把上面的数组循环读出并插入数据库:insert into xselect(parentid,description) values(1,'"&东城区&"')"
insert into xselect(parentid,description) values(1,'"&西城区&"')"
insert into xselect(parentid,description) values(2,'"&黄浦区&"')"
insert into xselect(parentid,description) values(2,'"&卢湾区&"')"
insert into xselect(parentid,description) values(2,'"&徐汇区&"')"
................
insert into xselect(parentid,description) values(n,'"&XXXXX&"')"
<!--
//第一组
var Beijing = new Array(
"0" , "东城区",
"1" , "西城区",) ;
//第二组
var Shanghai = new Array(
"0" , "黄浦区",
"1" , "卢湾区",
"2" , "徐汇区",) ;
//第N组
//-->
</SCRIPT>
我怎么把上面的数组循环读出并插入数据库:insert into xselect(parentid,description) values(1,'"&东城区&"')"
insert into xselect(parentid,description) values(1,'"&西城区&"')"
insert into xselect(parentid,description) values(2,'"&黄浦区&"')"
insert into xselect(parentid,description) values(2,'"&卢湾区&"')"
insert into xselect(parentid,description) values(2,'"&徐汇区&"')"
................
insert into xselect(parentid,description) values(n,'"&XXXXX&"')"
var sql;
for (i = 0; i < Beijing.length; i++)
{
sql = sql + "insert into xselect(parentid,description) values(1,'&" + Beijing[i] + "&'";
}
for (i = 0; i < Shanghai.length; i++)
{
sql = sql + "insert into xselect(parentid,description) values(1,'&" + Shanghai[i] + "&'";
}2、然后把sql传回服务器端。
window.location.href = "xxx.aspx?sql=" + sql;
或者
window.open"xxx.aspx?sql=" + sql,"_self");
或者
在页面里定义一个hidden变量
<form id="yyy" name="yyy" method="post">
<input type="hidden" name="sql" value="">
</form>
document.yyy.sql = sql;
from.submit();由于你的sql中存在&符号,所以,只能是用第三种方法。3、在服务器端接收
string sql = Request.Request.Form["sql"];匆忙中写的,没有测试,可能会有语法错误,望谅解。
<!--
//第一组
var Beijing = new Array(
"0" , "东城区",
"1" , "西城区",) ;
//第二组
var Shanghai = new Array(
"0" , "黄浦区",
"1" , "卢湾区",
"2" , "徐汇区",) ;
//第N组
//-->
</SCRIPT>
这个脚本里面有34组,我要一次行插入数据库后方便以后调用的,谢谢楼上兄弟指点
大家如果有数据库版的身份城市三级下拉菜单也给我共享一个^_^,谢谢