本连天工具的源码有服务器端和客户端程序两部分组成,整体采用java平台开发,多线程开发,并使用 SQL 2000管理数据库系统!-grievances of the tools have the source code server and client program consists of two parts, the overall use of java platform, multithreaded development, and the use of SQL 2000 database management system!
SHOW FULL COLUMNS FROM `jrk_downrecords` [ RunTime:0.001123s ]
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.061747s ]
SHOW FULL COLUMNS FROM `jrk_tagrecords` [ RunTime:0.001147s ]
SELECT * FROM `jrk_tagrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 20 [ RunTime:0.001052s ]
SHOW FULL COLUMNS FROM `jrk_member` [ RunTime:0.000858s ]
SELECT `id`,`username`,`userhead`,`usertime` FROM `jrk_member` WHERE `status` = 1 ORDER BY `usertime` DESC LIMIT 10 [ RunTime:0.002991s ]
SHOW FULL COLUMNS FROM `jrk_searchrecords` [ RunTime:0.000760s ]
SELECT * FROM `jrk_searchrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 5 [ RunTime:0.003599s ]
SELECT aid,title,count(aid) as c FROM `jrk_downrecords` GROUP BY `aid` ORDER BY `c` DESC LIMIT 10 [ RunTime:0.014768s ]
SHOW FULL COLUMNS FROM `jrk_articles` [ RunTime:0.001253s ]
UPDATE `jrk_articles` SET `hits` = 2 WHERE `id` = 42832 [ RunTime:0.017734s ]