<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"
<HTML
<HEAD
<TITLE New Document </TITLE
<META NAME="Generator" CONTENT="EditPlus"
<META NAME="Author" CONTENT="飞鱼"
<META NAME="Keywords" CONTENT="飞鱼"
<META NAME="Description" CONTENT="树型菜单"
<style type="text/css"
*{font-size:12px;}
</style
</HEAD
<BODY
<script
var Request =
{
QueryString: new ThunderBirdRequestQueryString(),
Cookies: new ThunderBirdRequestCookies()
}
function ThunderBirdRequestQueryString()
{
this.Current = document.location.search;
this.count = 0;
this.Item = new Array();
this.item = function (strKey)
{
if ( typeof(this.Item[strKey]) != "undefined" )
{
return this.Item[strKey];
}
else
{
return "";
}
}
ThunderBirdRequestOnInit(/([^?&][a-z\d]*)=([^#&]*)/gim, this.Current, this.count, this.Item);
}
function ThunderBirdRequestCookies()
{
this.Current = document.cookie;
this.count = 0;
this.Item = new Array();
this.item = function (strKey)
{
if ( typeof(this.Item[strKey]) != "undefined" )
{
return this.Item[strKey];
}
else
{
return "";
}
}
ThunderBirdRequestOnInit(/([^?&][a-z\d]*)=([^#&;]*)/gim, this.Current, this.count, this.Item);
}
function ThunderBirdRequestOnInit(RegExpRule, Current, count, Item)
{
if ( Current != "" )
{
while ( RegExpRule.exec(Current) != null )
{
Item[RegExp.$1] = RegExp.$2;
Item[count] = RegExp.$2;
count += 1;
}
}
}
var conn=new ActiveXObject("adodb.connection")
var connstr="provider=Microsoft.jet.oledb.4.0;data source=test.mdb"
try
{
conn.open(connstr)
}
catch (e)
{
var cat=new ActiveXObject("adox.catalog")
var catstr="provider=Microsoft.jet.oledb.4.0;data source=test.mdb"
cat.create(catstr)
cat=null;
var conn=new ActiveXObject("adodb.connection")
var connstr="provider=Microsoft.jet.oledb.4.0;data source=test.mdb"
conn.open(connstr)
conn.execute("create table test(id int identity(1,1),code varchar(250),title varchar(250),info MEMO,type yesno default true,countNum int default 0)")
conn.execute("insert into test(code,title,info)values('0001','asp','')")
conn.execute("insert into test(code,title,info,type,countNum)values('00010001','asp1','',false,3)")
conn.execute("insert into test(code,title,info)values('00010002','asp2','')")
conn.execute("insert into test(code,title,info)values('000100020001','asp21','')")
conn.execute("insert into test(code,title,info)values('000100020002','asp22','')")
conn.execute("insert into test(code,title,info)values('0002','xml','')")
conn.execute("insert into test(code,title,info,type,countNum)values('00020001','xml1','',false,20)")
conn.execute("insert into test(code,title,info)values('00020002','xml2','')")
conn.execute("insert into test(code,title,info)values('000200020001','xml21','')")
conn.execute("insert into test(code,title,info)values('00020003','xml3','')")
}
/*rs=conn.execute("select id,username,userpwd from test")
ary_rs=new VBArray(rs.GetRows())
alert(ary_rs.getItem(1,1))
*/
id=Request.QueryString.Item["classid"]
if(typeof(id)!="undefined"){
Column=conn.execute("select code from test where id="+id);
if(!Column.eof){ColumnCode=Column(0)+"";
}
else{
id=1;
ColumnCode="0001";
}
}
else
{
id=1;
ColumnCode="0001";
}
document.write(SiteColumnNav(id,ColumnCode))
function SiteColumnNav(ColumnId,ColumnCode)
{ var TempArray,TempStr
var i,StepLen,SourCode
SourCode=ColumnCode.substr(0,4)
SQL="Select [Id],Code,Title,Info,[Type],CountNum From [test] Where Left(Code,4) Like '"+SourCode+"' Or Len(Code)=4 Order By Code"
Rs=conn.Execute(SQL)
conn=null;
TempStr="<table border=\"0\" cellpadding=\"0\" cellspacing=\"0\" align=\"center\" width=\"98%\""
if(!(Rs.eof||Rs.bof)){
TempArray=new VBArray(Rs.GetRows())
for(i=0;i<TempArray.ubound(2)+1;i++){
StepLen=((TempArray.getItem(1,i)).length/4)*2-2
TempStr+="<tr<td align=\"left\" height=\"22\" "
if((TempArray.getItem(1,i)).length4){
TempStr+="├"
TempStr+=string(StepLen,"-")
}
if(parseFloat(TempArray.getItem(0,i))==parseFloat(ColumnId)){
TempStr+="<img src=\"http://tea.lamking.com/temp/icon2.gif\" align=absmiddle"
}
else
{
TempStr+="<img src=\"http://tea.lamking.com/temp/icon.gif\" align=absmiddle"
}
if(!TempArray.getItem(4,i)) TempStr+="[专题] "
TempStr+="<a href=\"?classid="+TempArray.getItem(0,i)+"\""+TempArray.getItem(2,i)
TempStr+="</a <font color=aaaaaa("+TempArray.getItem(5,i)+")</font"
TempStr+="</td"
TempStr+="</tr"
}
}
TempStr+="</table"
return TempStr
}
function string(l,str)
{
for(var k=0,tmp="";k<l;k++){tmp+=str}
return tmp;
}
</script
</BODY
</HTML
