A basic project providing a simple, yet sufficient example on how to implement and use RESTful web services in Java, thus reducing the time needed to have your application up and running. Requires Apache Maven to build, test or deploy.
SHOW FULL COLUMNS FROM `jrk_downrecords` [ RunTime:0.001963s ]
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.087713s ]
SHOW FULL COLUMNS FROM `jrk_tagrecords` [ RunTime:0.001484s ]
SELECT * FROM `jrk_tagrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 20 [ RunTime:0.001797s ]
SHOW FULL COLUMNS FROM `jrk_member` [ RunTime:0.001461s ]
SELECT `id`,`username`,`userhead`,`usertime` FROM `jrk_member` WHERE `status` = 1 ORDER BY `usertime` DESC LIMIT 10 [ RunTime:0.004675s ]
SHOW FULL COLUMNS FROM `jrk_searchrecords` [ RunTime:0.001277s ]
SELECT * FROM `jrk_searchrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 5 [ RunTime:0.005385s ]
SELECT aid,title,count(aid) as c FROM `jrk_downrecords` GROUP BY `aid` ORDER BY `c` DESC LIMIT 10 [ RunTime:0.020272s ]
SHOW FULL COLUMNS FROM `jrk_articles` [ RunTime:0.001540s ]
UPDATE `jrk_articles` SET `hits` = 2 WHERE `id` = 49242 [ RunTime:0.016152s ]
