这是我前年编写的“教职工工资发放系统”,应用VB连接SQLSEVER编程,现在已经在我们学校试运行,效果还不错,有兴趣地来看看哦-This is my year of preparation, "the staff payroll system," VB link SQLSEVER programming, is now in trial operation of our school, the results were pretty good. interested to see flash open her cloak
SHOW FULL COLUMNS FROM `jrk_downrecords` [ RunTime:0.003193s ]
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.091361s ]
SHOW FULL COLUMNS FROM `jrk_tagrecords` [ RunTime:0.002197s ]
SELECT * FROM `jrk_tagrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 20 [ RunTime:0.002279s ]
SHOW FULL COLUMNS FROM `jrk_member` [ RunTime:0.003311s ]
SELECT `id`,`username`,`userhead`,`usertime` FROM `jrk_member` WHERE `status` = 1 ORDER BY `usertime` DESC LIMIT 10 [ RunTime:0.004081s ]
SHOW FULL COLUMNS FROM `jrk_searchrecords` [ RunTime:0.002038s ]
SELECT * FROM `jrk_searchrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 5 [ RunTime:0.003553s ]
SELECT aid,title,count(aid) as c FROM `jrk_downrecords` GROUP BY `aid` ORDER BY `c` DESC LIMIT 10 [ RunTime:0.015546s ]
SHOW FULL COLUMNS FROM `jrk_articles` [ RunTime:0.002836s ]
UPDATE `jrk_articles` SET `hits` = 1 WHERE `id` = 264154 [ RunTime:0.001400s ]