基于jsp+servlet的网上书店

/* Navicat MySQL Data Transfer Source Server : localhost_3306 Source Server Version : 50709 Source Host : localhost:3306 Source Database : book_store Target Server Type : MYSQL Target Server Version : 50709 File Encoding : 65001 Date: 2018-06-27 17:06:11 */ SET FOREIGN_KEY_CHECKS=0; -- ---------------------------- -- Table structure for admin_message -- ---------------------------- DROP TABLE IF EXISTS `admin_message`; CREATE TABLE `admin_message` ( `message_id` int(11) NOT NULL AUTO_INCREMENT, `message` varchar(255) DEFAULT NULL, `date` varchar(255) DEFAULT NULL, PRIMARY KEY (`message_id`) ) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of admin_message -- ---------------------------- INSERT INTO `admin_message` VALUES ('1', 'sfaasfdsadfg', '2018-06-05 11:33:01'); INSERT INTO `admin_message` VALUES ('2', 'gdfgdgd', '2018-06-05 11:33:33'); INSERT INTO `admin_message` VALUES ('3', 'qqqqq', '2018-06-05 11:49:40'); INSERT INTO `admin_message` VALUES ('4', '2', '2018-06-14 07:45:28'); INSERT INTO `admin_message` VALUES ('5', '哈哈哈哈', '2018-06-15 08:17:41'); -- ---------------------------- -- Table structure for grade -- ---------------------------- DROP TABLE IF EXISTS `grade`; CREATE TABLE `grade` ( `product_id` int(11) NOT NULL, `user_id` int(11) NOT NULL, `grade` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of grade -- ---------------------------- -- ---------------------------- -- Table structure for message -- ---------------------------- DROP TABLE IF EXISTS `message`; CREATE TABLE `message` ( `message_id` int(11) NOT NULL AUTO_INCREMENT, `message` varchar(255) DEFAULT NULL, `date` varchar(255) DEFAULT NULL, PRIMARY KEY (`message_id`) ) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of message -- ---------------------------- INSERT INTO `message` VALUES ('1', 'asda', '2018-06-04 03:28:12'); INSERT INTO `message` VALUES ('2', 'asdadsadsdfs', '2018-06-04 03:28:35'); INSERT INTO `message` VALUES ('3', '哈哈', '2018-06-04 04:50:33'); INSERT INTO `message` VALUES ('4', '张伟豪', '2018-06-04 04:51:07'); INSERT INTO `message` VALUES ('5', 'xzddds', '2018-06-05 11:24:12'); INSERT INTO `message` VALUES ('6', 'adasda', '2018-06-05 11:30:18'); INSERT INTO `message` VALUES ('7', '123', '2018-06-14 10:26:29'); INSERT INTO `message` VALUES ('8', '12345', '2018-06-15 08:16:53'); INSERT INTO `message` VALUES ('9', '1234', '2018-06-15 08:32:41'); INSERT INTO `message` VALUES ('10', 'iiiii', '2018-06-15 09:10:15'); -- ---------------------------- -- Table structure for orderitem -- ---------------------------- DROP TABLE IF EXISTS `orderitem`; CREATE TABLE `orderitem` ( `order_id` varchar(100) NOT NULL, `user_id` int(100) DEFAULT NULL, `product_id` int(100) DEFAULT NULL, `grade` int(100) NOT NULL, `buynum` int(11) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of orderitem -- ---------------------------- INSERT INTO `orderitem` VALUES ('dd6f0790-aa4f-45df-aa0d-7fdaf30d602b', '4', '1', '0', '1'); INSERT INTO `orderitem` VALUES ('dd6f0790-aa4f-45df-aa0d-7fdaf30d602b', '4', '2', '0', '1'); INSERT INTO `orderitem` VALUES ('dd6f0790-aa4f-45df-aa0d-7fdaf30d602b', '4', '3', '0', '1'); INSERT INTO `orderitem` VALUES ('ba95465f-62f0-4d94-8017-9e2913ef43d0', '4', '1', '0', '1'); INSERT INTO `orderitem` VALUES ('470b2926-f9a7-4edf-aa1e-e32ff7c7d9dc', '0', '1', '0', '1'); INSERT INTO `orderitem` VALUES ('362dad43-66bb-499a-aa6c-542afdb3d5a7', '3', '1', '0', '1'); -- ---------------------------- -- Table structure for orders -- ---------------------------- DROP TABLE IF EXISTS `orders`; CREATE TABLE `orders` ( `id` varchar(100) NOT NULL, `money` double DEFAULT NULL, `receiveAddress` varchar(255) DEFAULT NULL, `receiveName` varchar(20) DEFAULT NULL, `receivePhone` varchar(20) DEFAULT NULL, `paystate` int(11) DEFAULT NULL, `orderTime` timestamp NOT NULL DEFAULT '2016-01-01 00:00:00', `user_id` int(11) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of orders -- ---------------------------- INSERT INTO `orders` VALUES ('14acce8e-19fb-497f-9a1d-7aa88ed36b93', '4', '', '', '', '0', '2018-06-14 08:22:32', '4'); INSERT INTO `orders` VALUES ('1be4e546-0a16-4c50-84ab-d60acafe9ca4', '6', '213', '123', '123', '0', '2018-06-15 09:37:38', '3'); INSERT INTO `orders` VALUES ('2b176262-c1a5-4536-abfe-aa10a5ad38bc', '33', 'ff', 'ff', 'ff', '0', '2018-06-15 09:42:10', '3'); INSERT INTO `orders` VALUES ('362dad43-66bb-499a-aa6c-542afdb3d5a7', '33', 'd', 'd', 'd', '0', '2018-06-15 09:52:15', '3'); INSERT INTO `orders` VALUES ('470b2926-f9a7-4edf-aa1e-e32ff7c7d9dc', '33', 'gg', 'gg', 'gg', '0', '2018-06-15 09:49:46', '3'); INSERT INTO `orders` VALUES ('5ff31191-e5c8-49f3-9b00-b1dcae83f7be', '6', '3', '3', '3', '0', '2018-06-14 07:18:34', '4'); INSERT INTO `orders` VALUES ('6e8de22f-cc16-49f5-86f9-a7c24dbf416d', '33', 'tt', 'tt', 'tt', '0', '2018-06-15 09:46:22', '3'); INSERT INTO `orders` VALUES ('87c3500d-3d63-47b0-bd8b-eca2394f9b25', '4', '1', '1', '1', '0', '2018-06-14 07:43:15', '2'); INSERT INTO `orders` VALUES ('8ce213cb-1745-4fc7-83f6-3e5fd7624d58', '33', 'rr', 'rr', 'rr', '0', '2018-06-15 09:43:41', '3'); INSERT INTO `orders` VALUES ('92eaf52b-1c3a-48b2-80e8-020b67a1c927', '1', '0', '0', '0', '0', '2018-06-14 07:07:25', '4'); INSERT INTO `orders` VALUES ('9a367251-78a6-4a2d-997d-ea24e1cdd792', '1', '7', '7', '7', '0', '2018-06-14 07:31:26', '123'); INSERT INTO `orders` VALUES ('a399b2fe-f52b-4170-94a1-9c6b5ab0e5bb', '1', '2', '2', '2', '0', '2018-06-14 07:20:15', '2'); INSERT INTO `orders` VALUES ('a604ed89-82f8-4a03-9ed3-ba5df7211c13', '3', '4', '4', '4', '0', '2018-06-14 07:46:51', '3'); INSERT INTO `orders` VALUES ('ba95465f-62f0-4d94-8017-9e2913ef43d0', '1', '1', '1', '1', '0', '2018-06-08 11:39:48', '4'); INSERT INTO `orders` VALUES ('d30a3b0e-3eee-48f9-858b-66df03fd0bfc', '37', 'eee', 'ee', 'e', '0', '2018-06-15 09:40:48', '3'); INSERT INTO `orders` VALUES ('d6dbb9a9-a26e-4246-a797-ebb20ee1abe1', '1', '55', '55', '5', '0', '2018-06-14 07:13:55', '4'); INSERT INTO `orders` VALUES ('dd6f0790-aa4f-45df-aa0d-7fdaf30d602b', '6', '2', '2', '2', '0', '2018-06-08 10:08:24', '4'); -- ---------------------------- -- Table structure for products -- ---------------------------- DROP TABLE IF EXISTS `products`; CREATE TABLE `products` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(40) DEFAULT NULL, `price` double DEFAULT '0', `category` varchar(40) DEFAULT NULL, `num` int(11) DEFAULT NULL, `imgurl` varchar(100) DEFAULT NULL, `description` varchar(255) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of products -- ---------------------------- INSERT INTO `products` VALUES ('1', 'book1', '33', '原版', '60', '/bookstore/img/class-book1.jpg', 'asfsdf'); INSERT INTO `products` VALUES ('2', 'book2', '2', '生活', '-1', '/bookstore/img/class-book2.jpg', ''); INSERT INTO `products` VALUES ('3', 'book3', '3', '计算机', '-4', '/bookstore/img/class-book3.jpg', ''); INSERT INTO `products` VALUES ('4', 'book4', '4', '外语', '-1', '/bookstore/img/class-book4.jpg', ''); INSERT INTO `products` VALUES ('5', 'book5', '5', '经营', '3', '/bookstore/img/class-book5.jpg', ''); INSERT INTO `products` VALUES ('6', 'book6', '6', '励志', '3', '/bookstore/img/class-book6.jpg', ''); INSERT INTO `products` VALUES ('7', 'book7', '7', '文学', '6', '/bookstore/img/class-book7.jpg', ''); -- ---------------------------- -- Table structure for remonend_book -- --------------------