server2.asp

管理登录system 管理员：admin 密码：admin888 数据库链接文件： conn.asp 内容数据库前台链接文件 systemconn.asp 内容数据库后台链接文件 sy

<%@ Language=javascript%>
<%
Response.contentType="text/xml"
Response.expires=0
/*变量定义*/
var conn,rs;
var ResponseXml,NodeId,level,otype

NodeId=Request.Querystring("id")
level=Session("level")

String.prototype.EncodeHTML=function()
{
	var str=this;
	str=str.replace(/\x26/g,"&#38;");
	str=str.replace(/\x3c/g,"&#60;");
	str=str.replace(/\x3e/g,"&#62;");
	str=str.replace(/\x22/g,"&#34;");
	str=str.replace(/\x27/g,"&#39;");
	str=str.replace(/\x20/g,"&#160;");
	str=str.replace(/\x13x10/g,"");
	return str;
}

ResponseXml="<?xml version='1.0' encoding='gb2312'?>\r\n"
ResponseXml+="<xml>\r\n"

if(!isNaN(parseInt(NodeId))){


if(isNaN(parseInt(level)))level=1

connm = Server.CreateObject("ADODB.Connection")
connm.Open("Provider=Microsoft.Jet.OLEDB.4.0;Data Source="+Server.mappath("Database/Content.mdb")+";Persist Security Info=False")
rs = Server.CreateObject("ADODB.Recordset")
rs.open("select *,(select count(*) from deeptree where parentid = T.id and level>="+level+") as children from deeptree T where parentid="+NodeId+" and level>="+level,connm,1,3)

if(!rs.eof){
	while(!rs.eof){
	ResponseXml+="<TreeNode id='"+String(rs("id"))+"'>\r\n"
	ResponseXml+="<NodeText>"+String(rs("content")).EncodeHTML()+"</NodeText>\r\n"
	ResponseXml+="<title></title>\r\n"
	ResponseXml+="<NodeUrl>"+(String(rs("link"))!="null"?String(rs("link")).EncodeHTML():"")+"</NodeUrl>\r\n"
	ResponseXml+="<child>"+String(rs("children"))+"</child>\r\n"
	ResponseXml+="<target></target>\r\n"
	ResponseXml+="</TreeNode>\r\n"
	rs.movenext
	}
}
}

rs=null
connm=null

ResponseXml+="</xml>"
Response.write(ResponseXml)
%>