This document will show you how to create such an application from the beginning some of the powerful features of struts Studio. You will design,
stub code, code, compile, and run the application all from inside Struts Studio
SHOW FULL COLUMNS FROM `jrk_downrecords` [ RunTime:0.001962s ]
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.066962s ]
SHOW FULL COLUMNS FROM `jrk_tagrecords` [ RunTime:0.002670s ]
SELECT * FROM `jrk_tagrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 20 [ RunTime:0.001218s ]
SHOW FULL COLUMNS FROM `jrk_member` [ RunTime:0.000968s ]
SELECT `id`,`username`,`userhead`,`usertime` FROM `jrk_member` WHERE `status` = 1 ORDER BY `usertime` DESC LIMIT 10 [ RunTime:0.003279s ]
SHOW FULL COLUMNS FROM `jrk_searchrecords` [ RunTime:0.000884s ]
SELECT * FROM `jrk_searchrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 5 [ RunTime:0.003941s ]
SELECT aid,title,count(aid) as c FROM `jrk_downrecords` GROUP BY `aid` ORDER BY `c` DESC LIMIT 10 [ RunTime:0.014814s ]
SHOW FULL COLUMNS FROM `jrk_articles` [ RunTime:0.001096s ]
UPDATE `jrk_articles` SET `hits` = 2 WHERE `id` = 532104 [ RunTime:0.013668s ]