52,782
社区成员
发帖
与我相关
我的任务
分享<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
"http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>无标题文档</title>
</head>
<body>
<script type="text/javascript" language="JavaScript" src="ajax/ajax_func.js">
</script>
<SCRIPT LANGUAGE="JavaScript">
<!--
function clear(o){
l=o.length;
for (i = 0; i< l; i++){
o.options[1]=null;
}
}
function change()
{
var prov=document.getElementById("prov").value;
if (prov=="")
{
return false;
}send_request("get","prov.asp?id="+prov,null,"xml",chuli);}
function chuli()
{
if(http_request.readyState == 4)
{
if(http_request.status==200)
{ var oj=document.getElementById("city");
clear(oj);
var doc = http_request.responseXML;
var num=doc.getElementsByTagName("num")[0].firstChild.data;
for (i=0;i<num;i++)
{
var city=doc.getElementsByTagName("city")[i].firstChild.data;
oj.add(new Option(city,city));
}
}
else
{
alert("你请求的页面异常!");
}
}
}
//-->
</SCRIPT>
<FORM METHOD=POST ACTION="" name="myform"> <select name="prov" onchange="change();" id="prov">
<option value="">省份</option>
<option value="北京市">北京市</option>
<option value="天津市">天津市</option>
<option value="河北省">河北省</option>
<option value="山西省">山西省</option>
<option value="内蒙古">内蒙古</option>
<option value="辽宁省">辽宁省</option>
<option value="吉林省">吉林省</option>
<option value="黑龙江省">黑龙江省</option>
<option value="上海市">上海市</option>
<option value="江苏省">江苏省</option>
<option value="浙江省">浙江省</option>
<option value="安徽省">安徽省</option>
<option value="福建省">福建省</option>
<option value="台湾">台湾</option>
<option value="江西省">江西省</option>
<option value="山东省">山东省</option>
<option value="河南省">河南省</option>
<option value="湖北省">湖北省</option>
<option value="湖南省">湖南省</option>
<option value="广东省">广东省</option>
<option value="香港特别行政区">香港特别行政区</option>
<option value="澳门特别行政区">澳门特别行政区</option>
<option value="广西壮族自治区">广西壮族自治区</option>
<option value="海南省">海南省</option>
<option value="重庆市">重庆市</option>
<option value="四川省">四川省</option>
<option value="贵州省">贵州省</option>
<option value="云南省">云南省</option>
<option value="西藏自治区">西藏自治区</option>
<option value="陕西省">陕西省</option>
<option value="甘肃省">甘肃省</option>
<option value="青海省">青海省</option>
<option value="宁夏回族自治区">宁夏回族自治区</option>
<option value="新疆维吾尔族自治区">新疆维吾尔族自治区</option> </select>
<SELECT NAME="city" id="city">
<OPTION VALUE="" >城市</option>
</SELECT></FORM>
</body>
</html>
<%@LANGUAGE="JAVASCRIPT" CODEPAGE="936"%>
<%
// 用connection打开数据库
function kaiconn() {
var conn = Server.CreateObject("ADODB.Connection");
conn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=E:\\XXXXX\\date\\supernews.mdb";
conn.Open();
return conn;
}
// 清空数据
function QingKong(rs) {
if (rs == null) return;
if (rs.State == 1) rs.Close();
}
// 关闭connection连接的数据库
function guanconn(conn) {
if (conn == null) return;
if (conn.State == 1) conn.Close();
}
// 弹出对话框,及页面转向。
function outmsg(massage, adress) {
Response.Write("<script type='text/javascript'><!--\r\n")
Response.Write("alert(unescape(\"" + escape(massage) + "\"));");
Response.Write("location.href = unescape(\"" + escape(adress) + "\");");
Response.Write("--></script>");
}
function excapeSQL(x) {
return "'" + x.replace(/\'/g, "''") + "'";
}
%>
<?xml version="1.0" encoding="gb2312" ?>
<!--#include file="inc/function.asp"-->
<%
Response.ContentType ="text/xml";
Response.Charset = "GB2312";
Response.Buffer = true;
var t = new Date();
t.setDate(t.getDate()-1);
Response.ExpiresAbsolute = t.getVarDate();
Response.Expires = 0;
Response.CacheControl = "no-cache";
Response.AddHeader("Pragma", "No-Cache");
var prov;
prov=Request.QueryString("id"); //这里感觉取不到值
if(prov=""){
outmsg("非法登入");
Response.End();
}
var conn = kaiconn();
var sql = "select count(*) as num from tb_city where city_prov=" + excapeSQL(prov); // 改成city_prov='山西省'"; 就可以正常显示了
var rs = conn.Execute(sql);
var num = rs("num").Value;
QingKong(rs);
%>
<citys>
<num><%=num%></num>
<%
sql = "select city_city from tb_city where city_prov=" + excapeSQL(prov); // 改成city_prov='山西省'"; 就可以正常显示了
rs.Open(sql, conn, 0, 1);
while (!rs.EOF) {
%><city><%=rs("city_city").Value%></city><%
rs.MoveNext();
}
QingKong(rs);
guanconn(conn);
delete rs;
delete conn;
CollectGarbage();
%>
</citys>
var http_request = false;
function send_request(method,url,content,responseType,callback){
http_request = false;
if(window.XMLHttpRequest){
http_request = new XMLHttpRequest();
if(http_request.overrideMimetype){
http_request.overrideMimetype("text/xml");
}
}
else if (window.ActiveXObject) {
try{
http_request = new ActiveXObject("Msxml.XMLHTTP");
}catch(E){
try{
http_request = new ActiveXObject("Microsoft.XMLHTTP");
}catch(E){}
}
}
if (!http_request){
window.alert("不能创建XMLHttpRequest对象实例!");
}
if(responseType.toLowerCase()=="text"){
http_request.onreadystatechange = callback;
}
else if (responseType.toLowerCase()=="xml"){
http_request.onreadystatechange = callback;
}
else{
window.alert("响应类别参数错误!");
return false;
}
if(method.toLowerCase()=="get"){
http_request.open(method,url,true);
}
else if (method.toLowerCase()=="post"){
http_request.open(method,url,true);
http_request.setRequestHeader("Content-Type","application/x-www-form-urlencoded");
}
else {
window.alert("http请求类别参数错误!");
return false;
}
http_request.send(content);
}
function processTextResponse(){
if(http_request.readyState==4){
if (http_request.state == 200){
alert("Text文档响应。");
}else{
alert("您所请求的页面有异常!");
}
}
}
function processXMLResponse(){
if(http_request.readyState==4){
if (http_request.state == 200){
alert("XML文档响应。");
}else{
alert("您所请求的页面有异常!");
}
}
}