The test framwork use Java5 annotation preparing all Test date and result data. So that developer can prapare test data and result data in src file when developing.When develop work is finished, the test work can start immediately.
SHOW FULL COLUMNS FROM `jrk_downrecords` [ RunTime:0.019363s ]
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.120839s ]
SHOW FULL COLUMNS FROM `jrk_tagrecords` [ RunTime:0.000877s ]
SELECT * FROM `jrk_tagrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 20 [ RunTime:0.002115s ]
SHOW FULL COLUMNS FROM `jrk_member` [ RunTime:0.001492s ]
SELECT `id`,`username`,`userhead`,`usertime` FROM `jrk_member` WHERE `status` = 1 ORDER BY `usertime` DESC LIMIT 10 [ RunTime:0.003021s ]
SHOW FULL COLUMNS FROM `jrk_searchrecords` [ RunTime:0.000810s ]
SELECT * FROM `jrk_searchrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 5 [ RunTime:0.003644s ]
SELECT aid,title,count(aid) as c FROM `jrk_downrecords` GROUP BY `aid` ORDER BY `c` DESC LIMIT 10 [ RunTime:0.015585s ]
SHOW FULL COLUMNS FROM `jrk_articles` [ RunTime:0.001195s ]
UPDATE `jrk_articles` SET `hits` = 2 WHERE `id` = 98281 [ RunTime:0.032965s ]