This is an cloud application using GAE written in Java,that any education institute can use in order the student to watch in a broadcasting way videos that can comment. These videos can be uploaded by the students and teachers. Only teacher can edit or delete the videos, so can administrate the application in order the content to be the wright one.
SHOW FULL COLUMNS FROM `jrk_downrecords` [ RunTime:0.001025s ]
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.083582s ]
SHOW FULL COLUMNS FROM `jrk_tagrecords` [ RunTime:0.004924s ]
SELECT * FROM `jrk_tagrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 20 [ RunTime:0.002237s ]
SHOW FULL COLUMNS FROM `jrk_member` [ RunTime:0.001498s ]
SELECT `id`,`username`,`userhead`,`usertime` FROM `jrk_member` WHERE `status` = 1 ORDER BY `usertime` DESC LIMIT 10 [ RunTime:0.005394s ]
SHOW FULL COLUMNS FROM `jrk_searchrecords` [ RunTime:0.001010s ]
SELECT * FROM `jrk_searchrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 5 [ RunTime:0.006707s ]
SELECT aid,title,count(aid) as c FROM `jrk_downrecords` GROUP BY `aid` ORDER BY `c` DESC LIMIT 10 [ RunTime:0.024314s ]
SHOW FULL COLUMNS FROM `jrk_articles` [ RunTime:0.001573s ]
UPDATE `jrk_articles` SET `hits` = 2 WHERE `id` = 96364 [ RunTime:0.016305s ]
