Java项目：JSP+Servlet实现的在线商城系统（源码+数据库脚本）.rar

/* SQLyog Ultimate v13.1.1 (64 bit) MySQL - 5.7.33 : Database - online_flw_shop ********************************************************************* */ /*!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*/`online_flw_shop` /*!40100 DEFAULT CHARACTER SET utf8 */; USE `online_flw_shop`; /*Table structure for table `easybuy_comment` */ DROP TABLE IF EXISTS `easybuy_comment`; CREATE TABLE `easybuy_comment` ( `EC_ID` int(10) NOT NULL AUTO_INCREMENT, `EC_CONTENT` varchar(200) NOT NULL, `EC_CREATE_TIME` datetime NOT NULL, `EC_REPLY` varchar(200) DEFAULT NULL, `EC_REPLY_TIME` datetime DEFAULT NULL, `EC_NICK_NAME` varchar(10) NOT NULL, PRIMARY KEY (`EC_ID`) ) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8; /*Data for the table `easybuy_comment` */ insert into `easybuy_comment`(`EC_ID`,`EC_CONTENT`,`EC_CREATE_TIME`,`EC_REPLY`,`EC_REPLY_TIME`,`EC_NICK_NAME`) values (12,'通用的项目','2018-12-19 14:37:54','',NULL,'通用的项目'); /*Table structure for table `easybuy_news` */ DROP TABLE IF EXISTS `easybuy_news`; CREATE TABLE `easybuy_news` ( `EN_ID` int(10) NOT NULL AUTO_INCREMENT, `EN_TITLE` varchar(40) NOT NULL, `EN_CONTENT` varchar(1000) NOT NULL, `EN_CREATE_TIME` datetime NOT NULL, PRIMARY KEY (`EN_ID`) ) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8; /*Data for the table `easybuy_news` */ insert into `easybuy_news`(`EN_ID`,`EN_TITLE`,`EN_CONTENT`,`EN_CREATE_TIME`) values (8,'通用商城项目','结合你的课题，更新分类、商品名、图片等，都可以自行演绎。','2018-04-24 13:24:49'); /*Table structure for table `easybuy_order` */ DROP TABLE IF EXISTS `easybuy_order`; CREATE TABLE `easybuy_order` ( `EO_ID` int(10) NOT NULL AUTO_INCREMENT, `EO_USER_ID` varchar(10) NOT NULL, `EO_USER_NAME` varchar(20) DEFAULT NULL, `EO_USER_ADDRESS` varchar(200) DEFAULT NULL, `EO_CREATE_TIME` datetime NOT NULL, `EO_COST` decimal(10,2) NOT NULL, `EO_STATUS` decimal(6,0) NOT NULL, `EO_TYPE` decimal(6,0) NOT NULL, PRIMARY KEY (`EO_ID`) ) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8; /*Data for the table `easybuy_order` */ insert into `easybuy_order`(`EO_ID`,`EO_USER_ID`,`EO_USER_NAME`,`EO_USER_ADDRESS`,`EO_CREATE_TIME`,`EO_COST`,`EO_STATUS`,`EO_TYPE`) values (8,'刘小文','刘小文','上海市宛平西路','2022-03-30 03:09:22',4.00,1,1); /*Table structure for table `easybuy_order_detail` */ DROP TABLE IF EXISTS `easybuy_order_detail`; CREATE TABLE `easybuy_order_detail` ( `EOD_ID` int(10) NOT NULL AUTO_INCREMENT, `EO_ID` decimal(10,0) NOT NULL, `EP_ID` decimal(10,0) NOT NULL, `EOD_QUANTITY` decimal(6,0) NOT NULL, `EOD_COST` decimal(10,2) NOT NULL, PRIMARY KEY (`EOD_ID`) ) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8; /*Data for the table `easybuy_order_detail` */ insert into `easybuy_order_detail`(`EOD_ID`,`EO_ID`,`EP_ID`,`EOD_QUANTITY`,`EOD_COST`) values (11,8,25,1,4.00), (12,8,22,1,23.00); /*Table structure for table `easybuy_product` */ DROP TABLE IF EXISTS `easybuy_product`; CREATE TABLE `easybuy_product` ( `EP_ID` int(10) NOT NULL AUTO_INCREMENT, `EP_NAME` varchar(128) NOT NULL, `EP_DESCRIPTION` varchar(512) DEFAULT NULL, `EP_PRICE` decimal(10,2) NOT NULL, `EP_STOCK` decimal(10,0) NOT NULL, `EPC_ID` decimal(10,0) DEFAULT NULL, `EPC_CHILD_ID` decimal(10,0) DEFAULT NULL, `EP_FILE_NAME` varchar(200) DEFAULT NULL, PRIMARY KEY (`EP_ID`) ) ENGINE=InnoDB AUTO_INCREMENT=34 DEFAULT CHARSET=utf8; /*Data for the table `easybuy_product` */ insert into `easybuy_product`(`EP_ID`,`EP_NAME`,`EP_DESCRIPTION`,`EP_PRICE`,`EP_STOCK`,`EPC_ID`,`EPC_CHILD_ID`,`EP_FILE_NAME`) values (20,'厄瓜多尔皇家蓝色恋人玫瑰','厄瓜多尔皇家蓝色恋人玫瑰',16.00,19,16,20,'meigui.png'), (21,'西伯利亚百合','西伯利亚百合',27.00,22,16,21,'baihe.png'), (22,'康乃馨','康乃馨',23.00,44,16,22,'kangnaixin.png'), (24,'黄乒乓 S 菊花','黄乒乓 S 菊花',32.00,32,16,23,'juhua.png'), (25,'泰国鲜切叶热带新鲜的绿叶','泰国鲜切叶热带新鲜的绿叶',4.00,322,17,24,'taiguolvye.png'), (26,'八角枫叶','八角枫叶',33.00,32,17,25,'bajiaofengye.png'), (27,'栀子叶','栀子叶',12.00,323,17,26,'zhiziye.png'), (28,'绿萝吊兰不含盆','绿萝吊兰不含盆',32.00,3223,18,27,'lvluo.png'); /*Table structure for table `easybuy_product_category` */ DROP TABLE IF EXISTS `easybuy_product_category`; CREATE TABLE `easybuy_product_category` ( `EPC_ID` int(10) NOT NULL AUTO_INCREMENT, `EPC_NAME` varchar(20) NOT NULL, `EPC_PARENT_ID` decimal(10,0) NOT NULL, PRIMARY KEY (`EPC_ID`) ) ENGINE=InnoDB AUTO_INCREMENT=33 DEFAULT CHARSET=utf8; /*Data for the table `easybuy_product_category` */ insert into `easybuy_product_category`(`EPC_ID`,`EPC_NAME`,`EPC_PARENT_ID`) values (16,'切花',0), (17,'切叶',0), (18,'绿植',0), (19,'盆花',0), (20,'玫瑰',16), (21,'百合',16), (22,'康乃馨',16), (23,'菊花',16), (24,'巴西叶',17), (25,'八角叶',17), (26,'栀子叶',17), (27,'绿萝',18), (28,'发财树',18), (29,'吊兰',18), (30,'蝴蝶兰',19), (31,'石斛兰',19), (32,'君子兰',19); /*Table structure for table `easybuy_shop` */ DROP TABLE IF EXISTS `easybuy_shop`; CREATE TABLE `easybuy_shop` ( `es_id` int(11) NOT NULL AUTO_INCREMENT, `es_ep_file_name` varchar(128) DEFAULT NULL, `es_ep_name` varchar(64) DEFAULT NULL, `es_ep_price` decimal(10,0) DEFAULT NULL, `es_eod_quantity` int(11) DEFAULT NULL, `es_ep_stock` int(11) DEFAULT NULL, `es_ep_id` int(11) DEFAULT NULL, `es_eu_user_id` varchar(64) DEFAULT NULL, `es_valid` int(11) DEFAULT NULL, PRIMARY KEY (`es_id`) ) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8; /*Data for the table `easybuy_shop` */ insert into `easybuy_shop`(`es_id`,`es_ep_file_name`,`es_ep_name`,`es_ep_price`,`es_eod_quantity`,`es_ep_stock`,`es_ep_id`,`es_eu_user_id`,`es_valid`) values (12,'kangnaixin.png','康乃馨',23,1,45,22,'刘小文',2), (13,'taiguolvye.png','泰国鲜切叶热带新鲜的绿叶',4,1,323,25,'刘小文',2); /*Table structure for table `easybuy_user` */ DROP TABLE IF EXISTS `easybuy_user`; CREATE TABLE `easybuy_user` ( `EU_USER_ID` varchar(32) NOT NULL, `EU_USER_NAME` varchar(20) NOT NULL, `EU_PASSWORD` varchar(20) NOT NULL, `EU_SEX` varchar(1) NOT NULL, `EU_BIRTHDAY` datetime DEFAULT NULL, `EU_IDENTITY_CODE` varchar(60) DEFAULT NULL, `EU_EMAIL` varchar(80) DEFAULT NULL, `EU_MOBILE` varchar(11) DEFAULT NULL, `EU_ADDRESS` varchar(200) DEFAULT NULL, `EU_STATUS` decimal(6,0) NOT NULL, PRIMARY KEY (`EU_USER_ID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*Data for the table `easybuy_user` */ insert into `easybuy_user`(`EU_USER_ID`,`EU_USER_NAME`,`EU_PASSWORD`,`EU_SEX`,`EU_BIRTHDAY`,`EU_IDENTITY_CODE`,`EU_EMAIL`,`EU_MOBILE`,`EU_ADDRESS`,`EU_STATUS`) values ('admin','admin','123456','T','2018-04-11 00:00:00',NULL,'admin@sina.com','13888889999','上海市宛平西路',2), ('刘小文','刘小文','123456','T','2018-12-13 00:00:00',NULL,'llqqxf@163.com','13666666666','上海市宛平西路',1); /*!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 */;