使用JSP和Java Bean来构建一个网上书店。第一部分是普通程序，用于客户在网上选购图书，第二部分是管理程序，用于在服务器端处理客户的定单。-use JSP and Java Bean to build an online bookstore. The first part of the normal procedures for online customers to purchase books, the second part of the management process for the server-side processing of customer orders.
SHOW FULL COLUMNS FROM `jrk_downrecords` [ RunTime:0.004248s ]
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.110965s ]
SHOW FULL COLUMNS FROM `jrk_tagrecords` [ RunTime:0.010056s ]
SELECT * FROM `jrk_tagrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 20 [ RunTime:0.002192s ]
SHOW FULL COLUMNS FROM `jrk_member` [ RunTime:0.002217s ]
SELECT `id`,`username`,`userhead`,`usertime` FROM `jrk_member` WHERE `status` = 1 ORDER BY `usertime` DESC LIMIT 10 [ RunTime:0.003928s ]
SHOW FULL COLUMNS FROM `jrk_searchrecords` [ RunTime:0.002216s ]
SELECT * FROM `jrk_searchrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 5 [ RunTime:0.003283s ]
SELECT aid,title,count(aid) as c FROM `jrk_downrecords` GROUP BY `aid` ORDER BY `c` DESC LIMIT 10 [ RunTime:0.018237s ]
SHOW FULL COLUMNS FROM `jrk_articles` [ RunTime:0.003094s ]
UPDATE `jrk_articles` SET `hits` = 1 WHERE `id` = 42988 [ RunTime:0.001266s ]
