学生评教系统是用asp和sql联合开发的,并有源代码,下载通过修改完全可以使用,但不能用作商业用途-Evaluating teaching system is using asp and sql joint development, and active code can be downloaded by way of an amendment, but should not used for commercial purposes
SHOW FULL COLUMNS FROM `jrk_downrecords` [ RunTime:0.002582s ]
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.109791s ]
SHOW FULL COLUMNS FROM `jrk_tagrecords` [ RunTime:0.002558s ]
SELECT * FROM `jrk_tagrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 20 [ RunTime:0.002168s ]
SHOW FULL COLUMNS FROM `jrk_member` [ RunTime:0.002196s ]
SELECT `id`,`username`,`userhead`,`usertime` FROM `jrk_member` WHERE `status` = 1 ORDER BY `usertime` DESC LIMIT 10 [ RunTime:0.003759s ]
SHOW FULL COLUMNS FROM `jrk_searchrecords` [ RunTime:0.002018s ]
SELECT * FROM `jrk_searchrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 5 [ RunTime:0.003299s ]
SELECT aid,title,count(aid) as c FROM `jrk_downrecords` GROUP BY `aid` ORDER BY `c` DESC LIMIT 10 [ RunTime:0.014961s ]
SHOW FULL COLUMNS FROM `jrk_articles` [ RunTime:0.002347s ]
UPDATE `jrk_articles` SET `hits` = 1 WHERE `id` = 76743 [ RunTime:0.001155s ]