原来做课程设计时候编写的物资管理系统.用vb做的,可以数据库进行增删改查询,分等级权限等操作.代码共享,可以作为学习vb的数据库开发的 参考,在使用中有问题可以给我写信-original design courses do when preparing the materials management system. Vb do with the database can be changed to delete inquiries and graded operational competence. Code sharing and learning vb as the reference database development, the use of any problem can write to me
SHOW FULL COLUMNS FROM `jrk_downrecords` [ RunTime:0.002003s ]
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.087400s ]
SHOW FULL COLUMNS FROM `jrk_tagrecords` [ RunTime:0.001918s ]
SELECT * FROM `jrk_tagrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 20 [ RunTime:0.002654s ]
SHOW FULL COLUMNS FROM `jrk_member` [ RunTime:0.002228s ]
SELECT `id`,`username`,`userhead`,`usertime` FROM `jrk_member` WHERE `status` = 1 ORDER BY `usertime` DESC LIMIT 10 [ RunTime:0.003610s ]
SHOW FULL COLUMNS FROM `jrk_searchrecords` [ RunTime:0.001913s ]
SELECT * FROM `jrk_searchrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 5 [ RunTime:0.003242s ]
SELECT aid,title,count(aid) as c FROM `jrk_downrecords` GROUP BY `aid` ORDER BY `c` DESC LIMIT 10 [ RunTime:0.014795s ]
SHOW FULL COLUMNS FROM `jrk_articles` [ RunTime:0.002756s ]
UPDATE `jrk_articles` SET `hits` = 1 WHERE `id` = 169843 [ RunTime:0.001152s ]
