This is a collection of some utilities that might help in performing various operations simply, ensuring java made easier for developers.
Licensed under GNU GPLv2 by Gowtham Gutha, provided with no warranties. Violation of rights will lead to legal proceedings via the Free Software Foundation Inc, US.
SHOW FULL COLUMNS FROM `jrk_downrecords` [ RunTime:0.001994s ]
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.086420s ]
SHOW FULL COLUMNS FROM `jrk_tagrecords` [ RunTime:0.002290s ]
SELECT * FROM `jrk_tagrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 20 [ RunTime:0.002054s ]
SHOW FULL COLUMNS FROM `jrk_member` [ RunTime:0.002172s ]
SELECT `id`,`username`,`userhead`,`usertime` FROM `jrk_member` WHERE `status` = 1 ORDER BY `usertime` DESC LIMIT 10 [ RunTime:0.004121s ]
SHOW FULL COLUMNS FROM `jrk_searchrecords` [ RunTime:0.001945s ]
SELECT * FROM `jrk_searchrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 5 [ RunTime:0.003251s ]
SELECT aid,title,count(aid) as c FROM `jrk_downrecords` GROUP BY `aid` ORDER BY `c` DESC LIMIT 10 [ RunTime:0.014723s ]
SHOW FULL COLUMNS FROM `jrk_articles` [ RunTime:0.002466s ]
UPDATE `jrk_articles` SET `hits` = 1 WHERE `id` = 48346 [ RunTime:0.001145s ]
