图书借阅管理系统可以有效地管理图书资源,控制图书借阅的流程,对图书馆或阅览室的管理有很大的帮助。
后台数据库使用SQL Server,前台开发工具使用Visual Basic。-borrow books can be an effective management system to manage library resources, control the flow of books to borrow, Reading Room of the library or in the management of great help. Background database using SQL Server, future development tools to use Visual Basic.
SHOW FULL COLUMNS FROM `jrk_downrecords` [ RunTime:0.001785s ]
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.092453s ]
SHOW FULL COLUMNS FROM `jrk_tagrecords` [ RunTime:0.000908s ]
SELECT * FROM `jrk_tagrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 20 [ RunTime:0.001108s ]
SHOW FULL COLUMNS FROM `jrk_member` [ RunTime:0.000983s ]
SELECT `id`,`username`,`userhead`,`usertime` FROM `jrk_member` WHERE `status` = 1 ORDER BY `usertime` DESC LIMIT 10 [ RunTime:0.003873s ]
SHOW FULL COLUMNS FROM `jrk_searchrecords` [ RunTime:0.000843s ]
SELECT * FROM `jrk_searchrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 5 [ RunTime:0.003685s ]
SELECT aid,title,count(aid) as c FROM `jrk_downrecords` GROUP BY `aid` ORDER BY `c` DESC LIMIT 10 [ RunTime:0.020546s ]
SHOW FULL COLUMNS FROM `jrk_articles` [ RunTime:0.001694s ]
UPDATE `jrk_articles` SET `hits` = 2 WHERE `id` = 140960 [ RunTime:0.027221s ]