学生网上考勤系统
jsp源码+mysql数据库
记录学生到课情况的好软件,非常适合在校老师使用,请大家来下载-students online attendance system jsp source mysql database records of students to classes and the good software is very suitable for teachers to use in school, please download
SHOW FULL COLUMNS FROM `jrk_downrecords` [ RunTime:0.004744s ]
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.076400s ]
SHOW FULL COLUMNS FROM `jrk_tagrecords` [ RunTime:0.001064s ]
SELECT * FROM `jrk_tagrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 20 [ RunTime:0.001130s ]
SHOW FULL COLUMNS FROM `jrk_member` [ RunTime:0.000981s ]
SELECT `id`,`username`,`userhead`,`usertime` FROM `jrk_member` WHERE `status` = 1 ORDER BY `usertime` DESC LIMIT 10 [ RunTime:0.003114s ]
SHOW FULL COLUMNS FROM `jrk_searchrecords` [ RunTime:0.000899s ]
SELECT * FROM `jrk_searchrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 5 [ RunTime:0.003709s ]
SELECT aid,title,count(aid) as c FROM `jrk_downrecords` GROUP BY `aid` ORDER BY `c` DESC LIMIT 10 [ RunTime:0.016728s ]
SHOW FULL COLUMNS FROM `jrk_articles` [ RunTime:0.001198s ]
UPDATE `jrk_articles` SET `hits` = 2 WHERE `id` = 313487 [ RunTime:0.011968s ]