ASPµÝ¹éÎÞ¼«Ï޲˵¥Ê÷
dataurl=Server.MapPath("menutree.mdb")'Êý¾Ý¿âµØÖ·
dim conn,strQuery,rs
set conn = server.CreateObject("adodb.connection")
conn.Open "PROVIDER=MICROSOFT.JET.OLEDB.4.0;DATA SOURCE="&dataurl
strQuery="select * from menufun"
set rs=server.createobject("adodb.recordset")
rs.open strQuery,conn,1,1
allnum=rs.RecordCount
'È¡µÃ×î´óµÄ²ãÊýMaxLevel
MaxLevel=1
for i=1 to allnum
if rs("PartLevel")>MaxLevel then
MaxLevel=rs("PartLevel")
else
MaxLevel=MaxLevel
end if
rs.movenext
next
rs.close
set rs=nothing
%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>ToumhÎÞ¼«Ï޲˵¥Ê÷</title>
<style type="text/css">
<!--
td {
font-size: 12px;
}
-->
</style>
<script language="javascript">
<!--
function divshow(cmy1,cmy2,cmy3)
//Õ¹¿ª/ºÏ²¢²Ëµ¥º¯Êý
{
if(document.all("div"+cmy1+cmy2+cmy3).style.display==""){
document.all("div"+cmy1+cmy2+cmy3).style.display="none"
}else{
document.all("div"+cmy1+cmy2+cmy3).style.display=""
}
}
//-->
</script>
</head>
<body bgcolor="#6699CC" topmargin="0">
<table border="0" cellpadding="0" cellspacing="0">
<tr onClick="javascript:divshow(1,0,1);" style="cursor:hand"><TD><img src="images/admin.gif">ToumhÎÞ¼«Ï޲˵¥Ê÷</TD></tr>
<%
dim toumh(10) '¶¨ÒåÓÃÓÚ´æ·Å²Ëµ¥Ç°ÏÔʾÊ÷ͼƬµÄÊý×飬Èç¹ûÓ¦ÓÃʱµÄ×î´ó¼¶Êý´óÓÚÊ®£¬ÇëÀ©´óÊý×éάÊý
call menutree(1,0,MaxLevel,1)'Ê״ε÷Óò˵¥Êä³öº¯Êý
'µÚÒ»¸ö²ÎÊý£º²Ëµ¥µÄ¼¶Êý
'µÚ¶þ¸ö²ÎÊý£º¸¸²Ëµ¥µÄID£¬Ò»¼¶²Ëµ¥Ä¬ÈÏΪÁã
'µÚÈý¸ö²ÎÊý£º²Ëµ¥µÄ×î´ó¼¶Êý
'µÚËĸö²ÎÊý£ºÓÃÓÚÇø·Ö²ãµÄÃû³Æ£¬·½±ãʵÏֲ˵¥µÄÕ¹¿ªºÏ²¢
%>
</table>
<%
'funno ²Ëµ¥µÄ¼¶Êý
'funcid ¸¸²Ëµ¥µÄID£¬Ò»¼¶²Ëµ¥¸¸¼¶IDֵΪ0
'MaxLevel ²Ëµ¥µÄ×î´ó¼¶Êý
'divno ÓÃÓÚÇø·Ö²ãµÄÃû³Æ£¬·½±ãʵÏֲ˵¥µÄÕ¹¿ªºÏ²¢
'menutree() ÊýÐβ˵¥Êä³öº¯Êý
function menutree(funno,funcid,MaxLevel,divno)
dim rsfun,numfun,funcidfun
strQuery1="select * from menufun where sup_funcid='"&funcid&
Ïà¹ØÎĵµ£º
ÒÔmysql5.1ΪÀý
ÏÈÏÂÔØmysql-connector-odbc²¢°²×°
1¡¢Ö±½ÓÁ¬½Ó
conn.asp
<%
strconnection="driver={mysql odbc 5.1 driver};database=test1;server=localhost;uid=root;password=root"
set conn = server.createobject("adodb.connection")
conn.open strconnection
%>
2¡¢DSNÁ¬½Ó
ÐèÒªÏÈÔÚÊý¾ÝÔ´ (OD ......
´æ´¢½ø³Ì¾ÍÊÇ×÷Ϊ¿ÉÖ´ÐжÔÏó´æ·ÅÔÚÊý¾Ý¿âÖеÄÒ»¸ö»ò¶à¸öSQLÃüÁî¡£
¶¨Òå×ÜÊǺܳéÏó¡£´æ´¢½ø³ÌÆäʵ¾ÍÊÇÄÜÍê³ÉÒ»¶¨²Ù×÷µÄÒ»×éSQLÓï¾ä£¬Ö»²»¹ýÕâ×éÓï¾äÊÇ·ÅÔÚÊý¾Ý¿âÖеÄ(ÕâÀïÎÒÃÇ̸ֻSQL SERVER)¡£Èç¹ûÎÒÃÇͨ¹ý´´½¨´æ´¢½ø³ÌÒÔ¼°ÔÚASPÖе÷Óô洢½ø³Ì£¬¾Í¿ÉÒÔ±ÜÃ⽫SQLÓï¾äͬASP´úÂë»ìÔÓÔÚÒ»Æð¡£ÕâÑù×öµÄºÃ´¦ÖÁÉÙÓÐÈý¸ö£º
µÚÒ»¡ ......
Èç¹ûÓû§Ê¹ÓõÄä¯ÀÀÆ÷Ö§³Ö¶¯Ì¬ HTML (DHTML)£¬Ôò ASP.NET ÑéÖ¤¿Ø¼þ¿ÉÒÔʹÓÿͻ§¶Ë½Å±¾À´Ö´ÐÐÑéÖ¤¡£ÒòΪÕâÖֿؼþ¿ÉÒÔÌṩ¼°Ê±·´À¡£¨ÎÞÐèµ½·þÎñÆ÷µÄÍù·µ¹ý³Ì£©£¬ËùÒÔÓû§»á¸Ð¾õµ½Ò³µÄÐÔÄÜÓÐËù¸ÄÉÆ¡£
ÔÚ´ó¶àÊýÇé¿öÏ£¬ÎÞÐè¶ÔÒ³»òÑéÖ¤¿Ø¼þ×÷³öÈκθü¸Ä±ã¿ÉʹÓÿͻ§¶ËÑéÖ¤¡£¿Ø¼þ½«×Ô¶¯¼ì²âä¯À ......
ÑéÖ¤¿ÉÒÔÈ·±£Óû§ÊäÈë·ûºÏÄúÖ¸¶¨µÄÌõ¼þ¡£ÔÚ´ó¶àÊýÇé¿öÏ£¬ÕâÒ»²Ù×÷±È½Ï¼òµ¥¡£µ«ÓÐʱ¶ÔÊäÈë½øÐÐÑéÖ¤»áÒýÈëÌØÊâµÄÌõ¼þ¡£Á˽âÕâЩÌõ¼þÊÇʲô¡¢ÑéÖ¤ÈçºÎÖ´ÐÐÒÔ¼°ÓÐÄÄЩ¿ÉÄܵÄÑéÖ¤½á¹ûÊǷdz£ÖØÒªµÄ¡£
Ò»¡¢Óë¿Õ°××ֶεĶԱÈ
Èç¹û×Ö¶ÎΪ¿Õ°×£¬Ôò³ý RequiredFieldValidator ¿Ø¼þÖ®ÍâµÄ ......
µ±´íÎóÐÅÏ¢³öÏÖÔÚÒ³ÉÏʱ£¬Ëü³ÉΪҳ²¼¾ÖµÄÒ»²¿·Ö¡£ÄúÐèÒªÉè¼ÆÒ³µÄ²¼¾ÖÒÔ·ÅÖÿÉÄܳöÏÖµÄÈκδíÎóÎı¾¡£
Èç¹ûÑéÖ¤ÔÚ·þÎñÆ÷ÉÏÖ´ÐУ¬Ôò³ý·Ç³öÏÖ´íÎ󣬷ñÔòÑéÖ¤¿Ø¼þ²»»á³ÊÏÖµ½Ò³£¬²¢Òò´Ë²»»áÕ¼ÓÃÈκοռ䡣Èç¹û³öÏÖ´íÎó£¬Ò³½«ÔÚÍù·µÆÚ¼äÖØÐ´´½¨£¬²¢½«´íÎóÎı¾Ìí¼Óµ½Ò³¡£
Èç¹ûÓû§¾ßÓÐÖ§³Ö¶¯Ì ......