for(var i=0;i<document.form1.select1.length;i++) { if(document.form1.select1[i].selected ) { window.alert(document.form1.select1[i].selected) var rsXML1=new ActiveXObject("ADODB.Recordset"); var xDOM1= new ActiveXObject("MSXML.DOMDocument"); var sSQL1 sConn= "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=d:\\bs.mdb"; sSQL1="insert into bmc_cet(xymc) values('"+document.form1.select1[i].text+"')"; rsXML1.Open(sSQL1, sConn);
for(var i=0;i<document.form1.select1.length;i++) { if(document.form1.select1[i].selected ) { window.alert(document.form1.select1[i].selected) var rsXML1=new ActiveXObject("ADODB.Recordset"); var xDOM1= new ActiveXObject("MSXML.DOMDocument"); var sSQL1 sConn= "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=d:\\bs.mdb"; sSQL1="insert into bmc_cet(xymc) values('"+document.form1.select1[i].text+"')"; rsXML1.Open(sSQL1, sConn);
<option value=1>1</option>
<option value=2>2</option>
<option value=3>3</option>
</select>
这是我的程序,可是我试了一下,选中的项就是加不到数据库里,不知道为什么???
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>列表</title>
</head><body>
<form name="form1" method="post" action="">
<script> document.write(" <select name="select"><option selected>西安</option><option>北京</option><option>上海</option></select>");
for(var i=0;i<document.form1.select1.length;i++)
{
if(document.form1.select1[i].selected )
{
window.alert(document.form1.select1[i].selected)
var rsXML1=new ActiveXObject("ADODB.Recordset");
var xDOM1= new ActiveXObject("MSXML.DOMDocument");
var sSQL1
sConn= "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=d:\\bs.mdb";
sSQL1="insert into bmc_cet(xymc) values('"+document.form1.select1[i].text+"')";
rsXML1.Open(sSQL1, sConn);
}
}
</script> </form>
</body>
</html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>列表</title>
</head><body>
<form name="form1" method="post" action="">
<script> document.write(" <select name='select1'><option selected>西安</option><option>北京</option><option>上海</option></select>");
for(var i=0;i<document.form1.select1.length;i++)
{
if(document.form1.select1[i].selected )
{
window.alert(document.form1.select1[i].selected)
var rsXML1=new ActiveXObject("ADODB.Recordset");
var xDOM1= new ActiveXObject("MSXML.DOMDocument");
var sSQL1
sConn= "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=d:\\bs.mdb";
sSQL1="insert into bmc_cet(xymc) values('"+document.form1.select1[i].text+"')";
rsXML1.Open(sSQL1, sConn);
}
}
</script> </form>
</body>
</html>