在不刷新页面的情况下调用远程asp脚本- ASP

当前位置: 首页 > 图文教程 > 网络编程 > ASP > 在不刷新页面的情况下调用远程asp脚本

ASP: asp OpenTextFile文本读取与写入实例代码; 在ASP编程中nothing代表什么意思?; asp之让Session永不过期; ASP获取ACCESS数据库表名及结构的代码; 推荐一篇不错的新手asp编程的基本法则; 最简洁的asp多重查询的解决方案; ASP 判断是否有中文的代码; asp.net常用函数收藏; asp下几种常用排序算法; asp获取数据库中表名和字段名的代码; 简单的asp采集代码教程; asp生成带有样式的word文件方法; 实用301转向到另一域名相应页面的asp代码; asp伪继承初探_实例代码; asp代理采集的核心函数代码; js table排序类代码; ASP UTF-8页面乱码+GB2312转UTF-8 +生成UTF-8格式的文件(编码); Asp生成RSS的类_给网站加上RSS; utf-8 网页不显示+utf-8网页乱码的通用解决方法; asp截取指定英汉混合字符串_支持中文

No. « ‹ 78 79 80 81 › »

技术文章搜索

关键字

ASP 中的在不刷新页面的情况下调用远程asp脚本

出处:互联网 整理: 软晨网（RuanChen.com） 发布: 2009-09-13 浏览: 137 ::

收藏到网摘: n/a

1.请在sql server 中建一数据库 name:house 在house中运行下列脚本
if exists (select * from sysobjects where id = object_id(N´[dbo].[City]´) and OBJECTPROPERTY(id, N´IsUserTable´) = 1)
drop table [dbo].[City]
GO
if exists (select * from sysobjects where id = object_id(N´[dbo].[Area]´) and OBJECTPROPERTY(id, N´IsUserTable´) = 1)
drop table [dbo].[Area]
GO
CREATE TABLE [dbo].[City] (
[id] [int] IDENTITY (1, 1) NOT NULL ,
[name] [nvarchar] (10) NULL
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[Area] (
[id] [int] IDENTITY (1, 1) NOT NULL ,
[CityId] [int] NULL ,
[name] [nvarchar] (20) NULL
) ON [PRIMARY]
GO
INSERT INTO City (id,name) Values(1,"广州")
INSERT INTO City (id,name) Values(2,"上海")
INSERT INTO City (id,name) Values(3,"北京")
INSERT INTO Area (id,CityId,name) Values(1,1,"天河")
INSERT INTO Area (id,CityId,name) Values(2,1,"白云")
INSERT INTO Area (id,CityId,name) Values(3,2,"虹口")
INSERT INTO Area (id,CityId,name) Values(4,2,"宝山")
INSERT INTO Area (id,CityId,name) Values(5,2,"静安")
INSERT INTO Area (id,CityId,name) Values(6,3,"海淀")
INSERT INTO Area (id,CityId,name) Values(7,3,"朝阳")
2.建立文件
建立文件CityData.asp
<%@ LANGUAGE=VBSCRIPT %>
<% RSDispatch %>
<SCRIPT RUNAT=SERVER Language=javascript>


function Description()
{
this.GetAreaAsArray = DoGetData;
}
public_description = new Description();

function DoGetData(cityId)
{
var sql,rst,strText,conn,i,j
conn = new ActiveXObject("ADODB.Connection");
conn.ConnectionString = connstr;
conn.ConnectionTimeout = 30;
conn.Open();
sql = "Select name,id from area where cityid=´" + cityId + "´";
rst = new ActiveXObject("ADODB.Recordset");
rst.CursorLocation = 3;
rst.Open(sql,conn);
i = 0;
j = 0;
strText = new Array();
if (rst.RecordCount >= 1)
{
for(var i=0;i<rst.RecordCount;++i)
{
strText[j++] = rst.Fields("name").Value;
strText[j++] = rst.Fields("id").Value;
rst.movenext();
}
}
else
{
strText[j++] = "没有";
strText[j++] = 1;
}
rst.close();
conn.close();
return strText;
}
</SCRIPT>
建立文件jsconn.asp
<SCRIPT RUNAT=SERVER Language=javascript>
var connstr = "driver={SQL Server}; server=202.0.0.108;uid=sa;pwd=;database=house";
</SCRIPT>
建立文件pub.asp
<%
Function OpenOrGet_Database
Dim SessionName, conn
const connstr = "driver={SQL Server}; server=202.0.0.108;uid=sa;pwd=;database=house"
SessionName = "House"
If Not IsObject(Session(SessionName)) Then
Set conn = Server.CreateObject("ADODB.Connection")
conn.Open connstr
Set Session(SessionName) = conn
End If
Set OpenOrGet_Database = Session(SessionName)
End Function

%>
建立文件sql_pub.asp
<%

´取出城市资料
Function SelectCity()
Dim Conn, Sql, Rs, ArrCity, TmpArr(1,0)
Set Conn = OpenOrGet_Database
Set Rs = Server.CreateObject("ADODB.Recordset")
Sql = "Select distinct name,id from City"
Rs.Open Sql,Conn,3
if Rs.Eof then
TmpArr(0,0) = "城市"
TmpArr(1,0) = 0
Rs.Close
SelectCity = TmpArr
else
ArrCity = RS.GetRows()
Rs.Close
SelectCity = ArrCity
end if
End Function
´根据传来的CityId取出相应的地区资料
Function SelectArea(CityId)
Dim Conn, Sql, Rs, ArrArea, TmpArr(1,0)
Set Conn = OpenOrGet_Database
Set Rs = Server.CreateObject("ADODB.Recordset")
Sql =" Select name,id from Area where CityId=" & CityId & " order by id "
Rs.Open Sql,Conn,3
if Rs.Eof then
TmpArr(0,0) = "地区"
TmpArr(1,0) = 0
Rs.Close
SelectArea = TmpArr
else
ArrArea = RS.GetRows()
Rs.Close
SelectArea = ArrArea
end if
End Function

%>
建立文件test.asp
<%@ LANGUAGE="VBSCRIPT" %>
<%option explicit%>


<%
Dim arrCity, arrArea, strPathInfo, strServerName, strServerPort, i, TmpStr
strPathInfo = Request.ServerVariables("PATH_INFO")
strServerName = Request.ServerVariables("SERVER_NAME")
strServerPort = Request.ServerVariables("SERVER_PORT")
if len(strServerPort) = 0 then
strServerPort = ""
else
strServerPort = ":" + strServerPort
end if
strPathInfo = "http://" & strServerName & strServerPort & ""
arrCity = SelectCity()
arrArea = SelectArea(arrCity(1,0))

%>
<html>
<head>
<title>Untitled Document</title>
<meta http-equiv="目录类型" content="文本/html; 字符集=gb2312">
</head>
<script language="JavaScript" src="<%=strPathInfo%>/_ScriptLibrary/rs.htm"></script>
<script language="JavaScript">
RSEnableRemoteScripting("<%=strPathInfo%>/_ScriptLibrary");
</script>
<body bgcolor="#FFFFFF">
<form method="post" name="select">
<font color="#222200">
<select name="City" size="1" onChange="JavaScript: Choosesection(this.form.Area,this.form.City)">
<option value=0 selected>--选择城市--</option>
<%for i = LBound(arrCity,2) To UBound(arrCity,2)
TmpStr = "<option value=" & arrCity(1,i) & ""
TmpStr = TmpStr & ">" & arrCity(0,i) & "</option>"
Response.Write(TmpStr)
Next
%>
</select>
</font><font color="#222200">
<select name="Area" size=1>
<option value=0>--选择镇区--</option>
<%For i = LBound(arrArea,2) To UBound(arrArea,2)
if arrArea(1,i)<>0 then
%>
<option value=<%=arrArea(1,i)%>><%=arrArea(0,i)%></option>
<% end if
Next%>
</select>
</font>
</form>
<script language="JavaScript">
var serverURL = "<%=strPathInfo%>";
var pageURL = "/CityData.asp";
function Choosesection(oArea,oCity)
{
for(var i=oArea.options.length-1;i>0;--i)
{oArea.options.remove(i) }
var CityId = oCity.options(oCity.selectedIndex).value;
var objResult = RSExecute(serverURL+pageURL, "GetAreaAsArray", CityId);
var j=0
if (objResult.return_value.length>0)
{
for (var i=0; i<objResult.return_value.length/2;++i)
{
sName = objResult.return_value[j++];
sId = objResult.return_value[j++];
var oOption = document.createElement(´OPTION´);
oOption.text = sName;
oOption.value = sId;
oArea.options.add(oOption);
}
}
}
</script>
</body>
</html>

ASP 中的 在不刷新页面的情况下调用远程asp脚本

评论 (0) All

ASP 中的在不刷新页面的情况下调用远程asp脚本