1
tmp.xml
<?xml version="1.0" encoding="UTF-8"?>
<select>
<option id="1810" value="1810">罗湖</option>
<option id="1809" value="1809">福田</option>
<option id="1855" value="1855">布吉</option>
<option id="1811" value="1811">南山</option>
<option id="1814" value="1814">盐田</option>
<option id="1812" value="1812">宝安</option>
<option id="1813" value="1813">龙岗区</option>
<option id='1810_6118' value='6118'>火车站</option>
<option id='1810_2678' value='2678'>人民南</option>
<option id='1810_1826' value='1826'>东门</option>
<option id='1810_6132' value='6132'>洪湖</option>
<option id='1810_6125' value='6125'>田贝</option>
<option id='1810_6119' value='6119'>罗湖区委</option>
<option id='1810_6120' value='6120'>文锦渡</option>
<option id='1810_2675' value='2675'>黄贝岭</option>
<option id='1810_6121' value='6121'>留医部</option>
<option id='1810_1827' value='1827'>翠竹</option>
<option id='1810_6131' value='6131'>东湖</option>
</select>
2
<html>
<body>
<script type="text/javascript">
try //Internet Explorer
{
xmlDoc=new ActiveXObject("Microsoft.XMLDOM");
}
catch(e)
{
try //Firefox, Mozilla, Opera, etc.
{
xmlDoc=document.implementation.createDocument("","",null);
}
catch(e) {alert(e.message)}
}
try
{
xmlDoc.async=false;
xmlDoc.load("/tmp.xml");
document.write("xmlDoc is loaded, ready for use");
document.write("<br />");
document.write("<br />");
var strs;
var tags = xmlDoc.getElementsByTagName("option");
var sql="insert into city_address(id,address,parent_id) values(";
for(var i =0 ; i<tags.length; i++){
strs=tags[i].getAttribute("id").split("_");
if(strs.length >1){
document.write(sql+strs[1]+",'"+tags[i].childNodes[0].nodeValue+"',"+strs[0]+");");
}else{
document.write(sql+strs[0]+",'"+tags[i].childNodes[0].nodeValue+"',null);");
}
document.write("<br />");
}
}
catch(e) {alert(e.message)}
</script>
</body>
</html>
3
4