图书管理系统,.net2003+sql2000,分为三个模块,用户端,操作员端,系统管理员端.基本上是用自定义控件dll来完成,内含完整sql语句,包括存储过程.-library management system. Net2003 MACHINE, divided into three modules, client, terminal operators, system administrators end. basically OCX dll is to be performed includes complete sql statement, including storage process.
SHOW FULL COLUMNS FROM `jrk_downrecords` [ RunTime:0.001372s ]
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.110415s ]
SHOW FULL COLUMNS FROM `jrk_tagrecords` [ RunTime:0.001327s ]
SELECT * FROM `jrk_tagrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 20 [ RunTime:0.001781s ]
SHOW FULL COLUMNS FROM `jrk_member` [ RunTime:0.001483s ]
SELECT `id`,`username`,`userhead`,`usertime` FROM `jrk_member` WHERE `status` = 1 ORDER BY `usertime` DESC LIMIT 10 [ RunTime:0.005234s ]
SHOW FULL COLUMNS FROM `jrk_searchrecords` [ RunTime:0.001305s ]
SELECT * FROM `jrk_searchrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 5 [ RunTime:0.007693s ]
SELECT aid,title,count(aid) as c FROM `jrk_downrecords` GROUP BY `aid` ORDER BY `c` DESC LIMIT 10 [ RunTime:0.023614s ]
SHOW FULL COLUMNS FROM `jrk_articles` [ RunTime:0.001625s ]
UPDATE `jrk_articles` SET `hits` = 2 WHERE `id` = 156064 [ RunTime:0.020406s ]
