自己编写的一个程序,开发简单的员工工资信息管理系统,适用与初学JAVA者,实现对选工信息的查询,修改,添加和删除的功能。-I have written a program to develop a simple, wages and salaries of information management systems, application and JAVA beginner who realize information on the mode of election workers to access, modify, add and delete functions.
SHOW FULL COLUMNS FROM `jrk_downrecords` [ RunTime:0.001641s ]
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.103062s ]
SHOW FULL COLUMNS FROM `jrk_tagrecords` [ RunTime:0.001155s ]
SELECT * FROM `jrk_tagrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 20 [ RunTime:0.002319s ]
SHOW FULL COLUMNS FROM `jrk_member` [ RunTime:0.001191s ]
SELECT `id`,`username`,`userhead`,`usertime` FROM `jrk_member` WHERE `status` = 1 ORDER BY `usertime` DESC LIMIT 10 [ RunTime:0.003698s ]
SHOW FULL COLUMNS FROM `jrk_searchrecords` [ RunTime:0.000984s ]
SELECT * FROM `jrk_searchrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 5 [ RunTime:0.003206s ]
SELECT aid,title,count(aid) as c FROM `jrk_downrecords` GROUP BY `aid` ORDER BY `c` DESC LIMIT 10 [ RunTime:0.014608s ]
SHOW FULL COLUMNS FROM `jrk_articles` [ RunTime:0.001338s ]
UPDATE `jrk_articles` SET `hits` = 1 WHERE `id` = 46944 [ RunTime:0.001327s ]