简易的花店销售系统--课设jsp+ssh+jdbc（内含完整的源码+sql文件+演示视频）

/* SQLyog 企业版 - MySQL GUI v8.14 MySQL - 5.5.40 : Database - supermarket ********************************************************************* */ /*!40101 SET NAMES utf8 */; /*!40101 SET SQL_MODE=''*/; /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; CREATE DATABASE /*!32312 IF NOT EXISTS*/`supermarket` /*!40100 DEFAULT CHARACTER SET utf8 */; USE `supermarket`; /*Table structure for table `cart` */ DROP TABLE IF EXISTS `cart`; CREATE TABLE `cart` ( `id` int(11) NOT NULL AUTO_INCREMENT, `productid` int(11) DEFAULT NULL, `productname` varchar(255) DEFAULT NULL, `productnumber` int(11) DEFAULT NULL, `productprice` double DEFAULT NULL, `totalprice` double DEFAULT NULL, `productimgurl` varchar(255) DEFAULT NULL, `members_id` int(11) DEFAULT NULL, PRIMARY KEY (`id`), KEY `FK2E7B2070C2EA4B` (`members_id`), CONSTRAINT `FK2E7B2070C2EA4B` FOREIGN KEY (`members_id`) REFERENCES `members` (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=23 DEFAULT CHARSET=utf8; /*Data for the table `cart` */ /*Table structure for table `members` */ DROP TABLE IF EXISTS `members`; CREATE TABLE `members` ( `id` int(11) NOT NULL AUTO_INCREMENT, `uuid` varchar(255) DEFAULT NULL, `name` varchar(255) DEFAULT NULL, `pwd` varchar(255) DEFAULT NULL, `gender` varchar(255) DEFAULT NULL, `phone` varchar(255) DEFAULT NULL, `idcard` varchar(255) DEFAULT NULL, `address` varchar(255) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8; /*Data for the table `members` */ insert into `members`(`id`,`uuid`,`name`,`pwd`,`gender`,`phone`,`idcard`,`address`) values (1,'a20adca5-0c37-4f1b-8a75-22dbc6dfb93a','admin','admin','男','13520204592','41022178542222','中国'),(2,'1f7c3202-76d3-457f-aaf6-af2a29e7200e','root','root','女','13507001472','410221199605894541','江西省南昌市青山湖区华东交通大学北区42#'); /*Table structure for table `orderone` */ DROP TABLE IF EXISTS `orderone`; CREATE TABLE `orderone` ( `id` int(11) NOT NULL AUTO_INCREMENT, `uuid` varchar(255) DEFAULT NULL, `ordertime` varchar(255) DEFAULT NULL, `totalprice` double DEFAULT NULL, `status` int(11) DEFAULT NULL, `members_id` int(11) DEFAULT NULL, PRIMARY KEY (`id`), KEY `FK49923C5870C2EA4B` (`members_id`), CONSTRAINT `FK49923C5870C2EA4B` FOREIGN KEY (`members_id`) REFERENCES `members` (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=137 DEFAULT CHARSET=utf8; /*Data for the table `orderone` */ insert into `orderone`(`id`,`uuid`,`ordertime`,`totalprice`,`status`,`members_id`) values (119,'99a937db-55ec-4cb4-af61-0352939d22a6','2017-06-24 11:23:07',1495,1,NULL),(120,'329f71b2-0572-4cf9-be52-151ccfae460a','2017-06-24 11:43:41',598,3,NULL),(121,'2146b96f-9acc-4abb-a436-2e793c6e9b71','2017-06-24 11:45:25',299,2,NULL),(123,'971e8a6c-a038-4fad-9b88-a49713ab58ca','2017-06-24 12:21:41',299,-1,NULL),(124,'70c3e7be-2eb8-444e-aa64-bcefbfbdcc42','2017-06-24 12:22:02',299,2,NULL),(125,'bf0d97c6-d488-4ee2-8021-7bae2e24c442','2017-06-24 12:28:58',598,1,NULL),(126,'37e55f2f-e573-4fc8-8fb5-d24f413f753a','2017-06-24 12:45:28',299,1,NULL),(127,'0f8e6d56-7083-46ea-a641-ce9e4acae2f8','2017-06-24 01:13:58',299,2,NULL),(128,'0205d6c9-2657-4261-8896-5149593ca8f4','2017-06-24 01:23:47',299,-1,NULL),(129,'b41ab6f8-326d-486d-9dfe-0ff36dd6be48','2017-06-24 02:26:08',1196,2,NULL),(130,'f5760de2-a2ee-40a1-b9e4-4c73747efb3d','2017-06-24 02:49:37',299,2,NULL),(131,'daaa9ae4-bf5e-44a6-8888-d37c8f8d31ad','2017-06-24 04:13:35',299,2,NULL),(132,'b443b17b-694e-4618-b70f-4959d597b383','2017-06-24 07:15:51',299,0,NULL),(133,'87544dc6-3593-491d-a8a5-900d8e0bac66','2017-06-26 08:37:00',299,1,2),(134,'5a74bc40-2bce-44d1-8708-8e8f0b4bcf2a','2017-06-26 08:37:13',299,0,2),(135,'e49005a6-62aa-4734-98cf-95e01775f490','2017-06-26 08:38:18',299,0,2),(136,'4a8e295b-bc72-4221-9a68-75eeb5e04d32','2017-06-26 08:38:29',299,1,2); /*Table structure for table `ordertwo` */ DROP TABLE IF EXISTS `ordertwo`; CREATE TABLE `ordertwo` ( `id` int(11) NOT NULL AUTO_INCREMENT, `productid` varchar(255) DEFAULT NULL, `productname` varchar(255) DEFAULT NULL, `productnumber` int(11) DEFAULT NULL, `productprice` double DEFAULT NULL, `totalprice` double DEFAULT NULL, `orderone_id` int(11) DEFAULT NULL, PRIMARY KEY (`id`), KEY `FK4992503E54F09DA9` (`orderone_id`), CONSTRAINT `FK4992503E54F09DA9` FOREIGN KEY (`orderone_id`) REFERENCES `orderone` (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=23 DEFAULT CHARSET=utf8; /*Data for the table `ordertwo` */ insert into `ordertwo`(`id`,`productid`,`productname`,`productnumber`,`productprice`,`totalprice`,`orderone_id`) values (1,'1','花多',2,299,598,119),(2,'2','***鲜花***',3,299,897,119),(3,'1','花多',1,299,299,120),(4,'2','***鲜花***',1,299,299,120),(5,'2','***鲜花***',1,299,299,121),(6,'2','***鲜花***',1,299,299,123),(7,'2','***鲜花***',1,299,299,124),(8,'1','花多',1,299,299,125),(9,'3','***鲜花***',1,299,299,125),(10,'2','***鲜花***',1,299,299,126),(11,'2','***鲜花***',1,299,299,127),(12,'2','***鲜花***',1,299,299,128),(13,'1','花多',1,299,299,129),(14,'3','***鲜花***',1,299,299,129),(15,'2','***鲜花***',2,299,598,129),(16,'2','***鲜花***',1,299,299,130),(17,'1','花多',1,299,299,131),(18,'2','***鲜花***',1,299,299,132),(19,'1','花多',1,299,299,133),(20,'3','***鲜花***',1,299,299,134),(21,'1','花多',1,299,299,135),(22,'3','***鲜花***',1,299,299,136); /*Table structure for table `product` */ DROP TABLE IF EXISTS `product`; CREATE TABLE `product` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(255) DEFAULT NULL, `price` double DEFAULT NULL, `remainnumber` int(11) DEFAULT NULL, `salenumber` int(11) DEFAULT NULL, `imgurl` varchar(255) DEFAULT NULL, `description` varchar(255) DEFAULT NULL, `category` varchar(255) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8; /*Data for the table `product` */ insert into `product`(`id`,`name`,`price`,`remainnumber`,`salenumber`,`imgurl`,`description`,`category`) values (1,'花多',299,101,0,'5aa3aced-acc6-49e5-8603-f314d06da4a06.png','暂无描述','秋花'),(2,'***鲜花***',299,100,0,'d4550b52-9f27-4162-83bc-261cdfa49ad58.png','暂无描述','夏花'),(3,'***鲜花***',299,100,0,'f0fe7acc-bf45-424e-bf4b-baa396933ea64.png','暂无描述','夏花'); /*!40101 SET SQL_MODE=@OLD_SQL_MODE */; /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */; /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;