用struts实现的文章系统,专门为学习struts和j2ee开发者所学习的源码,带有详细的安装说明,程序没有bug,大家可以放心使用!无解压密码-with struts achieve the article, devoted to the study and struts and creates developers are learning the source code with detailed installation instructions, procedures no bug, we can be assured use! Without extracting passwords!
SHOW FULL COLUMNS FROM `jrk_downrecords` [ RunTime:0.000983s ]
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.074397s ]
SHOW FULL COLUMNS FROM `jrk_tagrecords` [ RunTime:0.000935s ]
SELECT * FROM `jrk_tagrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 20 [ RunTime:0.001163s ]
SHOW FULL COLUMNS FROM `jrk_member` [ RunTime:0.001115s ]
SELECT `id`,`username`,`userhead`,`usertime` FROM `jrk_member` WHERE `status` = 1 ORDER BY `usertime` DESC LIMIT 10 [ RunTime:0.003253s ]
SHOW FULL COLUMNS FROM `jrk_searchrecords` [ RunTime:0.000834s ]
SELECT * FROM `jrk_searchrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 5 [ RunTime:0.003770s ]
SELECT aid,title,count(aid) as c FROM `jrk_downrecords` GROUP BY `aid` ORDER BY `c` DESC LIMIT 10 [ RunTime:0.018108s ]
SHOW FULL COLUMNS FROM `jrk_articles` [ RunTime:0.001219s ]
UPDATE `jrk_articles` SET `hits` = 2 WHERE `id` = 291380 [ RunTime:0.020317s ]