How to use the ASP to implement the "directory tree" management of the website

xiaoxiao2021-03-06  61

Use the ASP to implement the directory tree database structure of the website (two tables in total) 1. TBLCATEGORY field name Type Root Binary Description Tree Corpher or Open (Roots of Directory) ID Auto Number Keyword Sort Integer Recognizes the integer of this field content (if root is open state sort is 0) Represents the order of the displayed directory Name Text (255) You can include an identifier HREF TEXT (255) in HTML to allow empty 2. TBLPAGESID Auto No. Sort Integer Keyword Name Text (255) HREF TEXT (255)

3.default.htm JavaScript Tree Control Template </ title> </ head> <frameset cols = "210, *">? <Frame src = "Tree.asp" Name = "" TOC ">? <frame src =" "main.htm" "name =" "BaseFRM"> </ frameset> </ html></p> <p>4.main.htm <head> <title> </ title> </ head> <body> <h2> start page </ h2> </ body> </ html></p> <p>5.Tree.aspset conn = server.createObject ("adoDb.connection") SET RS = Server.createObject ("AdoDb.Recordset") Conn.open "" Driver = Microsoft Access Driver (* .mdb); DBQ = "" & Server.mappath ("" Toc.mdb ")</p> <p>strsql = "" SELECT tblCategory.Root, tblCategory. [ID], tblCategory.Sort AS CatSort, tblPages.sort AS LinkSort, tblCategory. [Name] AS CatName, tblCategory.HREF AS CatURL, tblPages. [Name] AS LinkName, tblPages . = TBLPAGES. [ID] = TBLPAGES. [ID] ORDER BY TBLCATE.ROOT ASC, TBLCATEGORT, TBLPAGES.SORT ""</p> <p>RS.Open Strsql, CONN, 2, 2</p> <p>If NOT RS.EOF THEN RS.MOVEFIRSTCURRENTID = "" ""%> <html> <head> <link rel = "" stylesheet "" href = "" ftie4style.css "> <! - infrastructure code for the Tree -> <script src = "" ftiens4.js "> </ script> <! - execution of the code try-> <script> usextLinks = 1 <% do while not rs.eof IF RS ("Root") = true kil> folderstree = GFLD ("" <% = rs ("" "" "")%> "", "" <% = rs ("" "" ")% > "" "" <% Else%> AUX1 = insfld (Folderstree, GFLD ("" <% = rs ("" "" "")%> "", "" <% = rs ("" "" "")%> "")) <% Currentid = rs ("ID") savedid = rs ("ID") Do while currentid = SavedIDIDIDIDIDID r r = ("" "" "" ") <>" "" "THEN%> INSDOC (AUX1, GLNK (0," "<% = RS (" "" "" "" ")%>" "" "" "" "" "" "" "" ")%>" ") < % End if rs.movenext if not rs.eof kilns = rs ("ID") loop end if if currentid = "" "" "" "" "" " S.MOVENEXT loop%> </ script> <script> initializedocument () </ script> <base target = "" BASEFRM "> <title> </ title> </ head> <</p></div><div class="text-center mt-3 text-grey"> 转载请注明原文地址:https://www.9cbs.com/read-88509.html</div><div class="plugin d-flex justify-content-center mt-3"></div><hr><div class="row"><div class="col-lg-12 text-muted mt-2"><i class="icon-tags mr-2"></i><span class="badge border border-secondary mr-2"><h2 class="h6 mb-0 small"><a class="text-secondary" href="tag-2.html">9cbs</a></h2></span></div></div></div></div><div class="card card-postlist border-white shadow"><div class="card-body"><div class="card-title"><div class="d-flex justify-content-between"><div><b>New Post</b>(<span class="posts">0</span>) </div><div></div></div></div><ul class="postlist list-unstyled"> </ul></div></div><div class="d-none threadlist"><input type="checkbox" name="modtid" value="88509" checked /></div></div></div></div></div><footer class="text-muted small bg-dark py-4 mt-3" id="footer"><div class="container"><div class="row"><div class="col">CopyRight © 2020 All Rights Reserved </div><div class="col text-right">Processed: <b>0.038</b>, SQL: <b>9</b></div></div></div></footer><script src="./lang/en-us/lang.js?2.2.0"></script><script src="view/js/jquery.min.js?2.2.0"></script><script src="view/js/popper.min.js?2.2.0"></script><script src="view/js/bootstrap.min.js?2.2.0"></script><script src="view/js/xiuno.js?2.2.0"></script><script src="view/js/bootstrap-plugin.js?2.2.0"></script><script src="view/js/async.min.js?2.2.0"></script><script src="view/js/form.js?2.2.0"></script><script> var debug = DEBUG = 0; var url_rewrite_on = 1; var url_path = './'; var forumarr = {"1":"Tech"}; var fid = 1; var uid = 0; var gid = 0; xn.options.water_image_url = 'view/img/water-small.png'; </script><script src="view/js/wellcms.js?2.2.0"></script><a class="scroll-to-top rounded" href="javascript:void(0);"><i class="icon-angle-up"></i></a><a class="scroll-to-bottom rounded" href="javascript:void(0);" style="display: inline;"><i class="icon-angle-down"></i></a></body></html><script> var forum_url = 'list-1.html'; var safe_token = 'bBrDd8cLtgrDQ1_2FlqZPOIQUFO6tSr3QfRnRSyOGaHE9SDZ_2BD8GimtGjjlqyzsDRkN5_2FiKhJaYSeYFWIa'; var body = $('body'); body.on('submit', '#form', function() { var jthis = $(this); var jsubmit = jthis.find('#submit'); jthis.reset(); jsubmit.button('loading'); var postdata = jthis.serializeObject(); $.xpost(jthis.attr('action'), postdata, function(code, message) { if(code == 0) { location.reload(); } else { $.alert(message); jsubmit.button('reset'); } }); return false; }); function resize_image() { var jmessagelist = $('div.message'); var first_width = jmessagelist.width(); jmessagelist.each(function() { var jdiv = $(this); var maxwidth = jdiv.attr('isfirst') ? first_width : jdiv.width(); var jmessage_width = Math.min(jdiv.width(), maxwidth); jdiv.find('img, embed, iframe, video').each(function() { var jimg = $(this); var img_width = this.org_width; var img_height = this.org_height; if(!img_width) { var img_width = jimg.attr('width'); var img_height = jimg.attr('height'); this.org_width = img_width; this.org_height = img_height; } if(img_width > jmessage_width) { if(this.tagName == 'IMG') { jimg.width(jmessage_width); jimg.css('height', 'auto'); jimg.css('cursor', 'pointer'); jimg.on('click', function() { }); } else { jimg.width(jmessage_width); var height = (img_height / img_width) * jimg.width(); jimg.height(height); } } }); }); } function resize_table() { $('div.message').each(function() { var jdiv = $(this); jdiv.find('table').addClass('table').wrap('<div class="table-responsive"></div>'); }); } $(function() { resize_image(); resize_table(); $(window).on('resize', resize_image); }); var jmessage = $('#message'); jmessage.on('focus', function() {if(jmessage.t) { clearTimeout(jmessage.t); jmessage.t = null; } jmessage.css('height', '6rem'); }); jmessage.on('blur', function() {jmessage.t = setTimeout(function() { jmessage.css('height', '2.5rem');}, 1000); }); $('#nav li[data-active="fid-1"]').addClass('active'); </script>