网上订餐系统,基于servlet开发,实现餐品信息的显示、查询、订购等功能。采用连接池技术、WebService技术等。本项目仅供参考。-Online reservations, please system, servlet-based development and achieving the display of menu items of information, inquiry, ordering and other functions. Using connection pool technology, WebService technology. The project is for reference only.
SHOW FULL COLUMNS FROM `jrk_downrecords` [ RunTime:0.001836s ]
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.078865s ]
SHOW FULL COLUMNS FROM `jrk_tagrecords` [ RunTime:0.000941s ]
SELECT * FROM `jrk_tagrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 20 [ RunTime:0.001117s ]
SHOW FULL COLUMNS FROM `jrk_member` [ RunTime:0.000847s ]
SELECT `id`,`username`,`userhead`,`usertime` FROM `jrk_member` WHERE `status` = 1 ORDER BY `usertime` DESC LIMIT 10 [ RunTime:0.003095s ]
SHOW FULL COLUMNS FROM `jrk_searchrecords` [ RunTime:0.000804s ]
SELECT * FROM `jrk_searchrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 5 [ RunTime:0.003598s ]
SELECT aid,title,count(aid) as c FROM `jrk_downrecords` GROUP BY `aid` ORDER BY `c` DESC LIMIT 10 [ RunTime:0.014969s ]
SHOW FULL COLUMNS FROM `jrk_articles` [ RunTime:0.001210s ]
UPDATE `jrk_articles` SET `hits` = 2 WHERE `id` = 222183 [ RunTime:0.013855s ]