是用java和jsp实现的bbs论坛系统。 有注册登陆模块,浏览功能模块,发帖回帖模块,帖子管理模块,论坛设置功能模块,管理版块功能模块,用户管理模块。-jsp and bulletin board forums to achieve the system. Registered landing module, browsing module, posting replies module, posting management module, the Forum set up functional modules, management plate functional modules, user management module.
文 件 列 表
第4章 BBS论坛系统 web WEB-INF classes com microsoft jdbc base database dat.dat database
SHOW FULL COLUMNS FROM `jrk_downrecords` [ RunTime:0.001100s ]
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.081955s ]
SHOW FULL COLUMNS FROM `jrk_tagrecords` [ RunTime:0.002718s ]
SELECT * FROM `jrk_tagrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 20 [ RunTime:0.001287s ]
SHOW FULL COLUMNS FROM `jrk_member` [ RunTime:0.000985s ]
SELECT `id`,`username`,`userhead`,`usertime` FROM `jrk_member` WHERE `status` = 1 ORDER BY `usertime` DESC LIMIT 10 [ RunTime:0.004258s ]
SHOW FULL COLUMNS FROM `jrk_searchrecords` [ RunTime:0.000794s ]
SELECT * FROM `jrk_searchrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 5 [ RunTime:0.003905s ]
SELECT aid,title,count(aid) as c FROM `jrk_downrecords` GROUP BY `aid` ORDER BY `c` DESC LIMIT 10 [ RunTime:0.015414s ]
SHOW FULL COLUMNS FROM `jrk_articles` [ RunTime:0.001215s ]
UPDATE `jrk_articles` SET `hits` = 2 WHERE `id` = 42833 [ RunTime:0.021999s ]