记录程序记录的程序源码，操作Access数据库。 有导入导出数据、填加、修改、删除记录等主要操作。 同时有最小化到托盘区的功能。-Recording procedures source records, operation Access database. There are import and export data, filling increases, modify or delete records and other major operations. At the same time minimizing the functions of the tray.
SHOW FULL COLUMNS FROM `jrk_downrecords` [ RunTime:0.003969s ]
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.087818s ]
SHOW FULL COLUMNS FROM `jrk_tagrecords` [ RunTime:0.002258s ]
SELECT * FROM `jrk_tagrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 20 [ RunTime:0.002119s ]
SHOW FULL COLUMNS FROM `jrk_member` [ RunTime:0.002303s ]
SELECT `id`,`username`,`userhead`,`usertime` FROM `jrk_member` WHERE `status` = 1 ORDER BY `usertime` DESC LIMIT 10 [ RunTime:0.003714s ]
SHOW FULL COLUMNS FROM `jrk_searchrecords` [ RunTime:0.001972s ]
SELECT * FROM `jrk_searchrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 5 [ RunTime:0.003207s ]
SELECT aid,title,count(aid) as c FROM `jrk_downrecords` GROUP BY `aid` ORDER BY `c` DESC LIMIT 10 [ RunTime:0.015624s ]
SHOW FULL COLUMNS FROM `jrk_articles` [ RunTime:0.002591s ]
UPDATE `jrk_articles` SET `hits` = 1 WHERE `id` = 108228 [ RunTime:0.001276s ]
