利用脚本语言组件,java程序,在数据库读取dtree的节点信息,然后在jsp利用循环动态装载节点,即可实现网页的树形结构-The use of scripting language component, java program, the database read dtree node information, and then in the jsp using dynamic loading cycle node, you can realize the page tree structure
SHOW FULL COLUMNS FROM `jrk_downrecords` [ RunTime:0.001123s ]
SELECT `a`.`aid`,`a`.`title`,`a`.`create_time`,`m`.`username` FROM `jrk_downrecords` `a` INNER JOIN `jrk_member` `m` ON `a`.`uid`=`m`.`id` WHERE `a`.`status` = 1 GROUP BY `a`.`aid` ORDER BY `a`.`create_time` DESC LIMIT 10 [ RunTime:0.069857s ]
SHOW FULL COLUMNS FROM `jrk_tagrecords` [ RunTime:0.002555s ]
SELECT * FROM `jrk_tagrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 20 [ RunTime:0.001311s ]
SHOW FULL COLUMNS FROM `jrk_member` [ RunTime:0.000984s ]
SELECT `id`,`username`,`userhead`,`usertime` FROM `jrk_member` WHERE `status` = 1 ORDER BY `usertime` DESC LIMIT 10 [ RunTime:0.003318s ]
SHOW FULL COLUMNS FROM `jrk_searchrecords` [ RunTime:0.000947s ]
SELECT * FROM `jrk_searchrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 5 [ RunTime:0.004089s ]
SELECT aid,title,count(aid) as c FROM `jrk_downrecords` GROUP BY `aid` ORDER BY `c` DESC LIMIT 10 [ RunTime:0.023744s ]
SHOW FULL COLUMNS FROM `jrk_articles` [ RunTime:0.004935s ]
UPDATE `jrk_articles` SET `hits` = 2 WHERE `id` = 42737 [ RunTime:0.023527s ]