This project is a web application based on the JEE specifications. We use the JEE framework to implement our project in the Java programming language using the Eclipse IDE. To store persistent data we connect to the DERBY DB
SHOW FULL COLUMNS FROM `jrk_downrecords` [ RunTime:0.001346s ]
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.129348s ]
SHOW FULL COLUMNS FROM `jrk_tagrecords` [ RunTime:0.001487s ]
SELECT * FROM `jrk_tagrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 20 [ RunTime:0.002018s ]
SHOW FULL COLUMNS FROM `jrk_member` [ RunTime:0.001353s ]
SELECT `id`,`username`,`userhead`,`usertime` FROM `jrk_member` WHERE `status` = 1 ORDER BY `usertime` DESC LIMIT 10 [ RunTime:0.003469s ]
SHOW FULL COLUMNS FROM `jrk_searchrecords` [ RunTime:0.000865s ]
SELECT * FROM `jrk_searchrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 5 [ RunTime:0.004390s ]
SELECT aid,title,count(aid) as c FROM `jrk_downrecords` GROUP BY `aid` ORDER BY `c` DESC LIMIT 10 [ RunTime:0.016647s ]
SHOW FULL COLUMNS FROM `jrk_articles` [ RunTime:0.001029s ]
UPDATE `jrk_articles` SET `hits` = 2 WHERE `id` = 95320 [ RunTime:0.023559s ]