JavaWeb开发购物商场系统项目.zip

/* Navicat MySQL Data Transfer Source Server : root Source Server Version : 50641 Source Host : localhost:3306 Source Database : ouoshop Target Server Type : MYSQL Target Server Version : 50641 File Encoding : 65001 Date: 2019-06-19 16:58:22 */ SET FOREIGN_KEY_CHECKS=0; -- ---------------------------- -- Table structure for `admin` -- ---------------------------- DROP TABLE IF EXISTS `admin`; CREATE TABLE `admin` ( `id` varchar(30) NOT NULL COMMENT '管理员编号', `name` varchar(30) DEFAULT NULL COMMENT '管理员账号', `pwd` varchar(30) DEFAULT NULL COMMENT '密码', PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='管理员表'; -- ---------------------------- -- Records of admin -- ---------------------------- INSERT INTO `admin` VALUES ('1', '张三', '123456'); -- ---------------------------- -- Table structure for `cart` -- ---------------------------- DROP TABLE IF EXISTS `cart`; CREATE TABLE `cart` ( `ccid` int(11) NOT NULL AUTO_INCREMENT COMMENT '购物车编号', `images` varchar(100) DEFAULT NULL COMMENT '图片地址', `aid` int(11) NOT NULL COMMENT '用户编号', `bid` int(11) NOT NULL COMMENT '商品编号', `ccount` int(11) NOT NULL COMMENT '商品数量', `money` decimal(18,2) DEFAULT NULL COMMENT '金额', PRIMARY KEY (`ccid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='购物车表'; -- ---------------------------- -- Records of cart -- ---------------------------- -- ---------------------------- -- Table structure for `comment` -- ---------------------------- DROP TABLE IF EXISTS `comment`; CREATE TABLE `comment` ( `ccid` int(30) NOT NULL AUTO_INCREMENT COMMENT '评论编号', `aid` int(30) DEFAULT NULL COMMENT '评论者编号', `bid` int(30) DEFAULT NULL COMMENT '评论商品编号', `content` varchar(300) DEFAULT NULL COMMENT '评论内容', `time` datetime DEFAULT NULL COMMENT '评论时间', PRIMARY KEY (`ccid`) ) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8 COMMENT='评论表'; -- ---------------------------- -- Records of comment -- ---------------------------- INSERT INTO `comment` VALUES ('1', '1001', '23846', '6666', '2019-06-19 15:55:17'); INSERT INTO `comment` VALUES ('11', '1001', '218439', '9364564', '2019-06-19 04:25:26'); INSERT INTO `comment` VALUES ('12', '1001', '218439', '4444444444', '2019-06-19 04:25:33'); INSERT INTO `comment` VALUES ('13', '1001', '218438', '66666666', '2019-06-19 04:13:55'); -- ---------------------------- -- Table structure for `dingdan` -- ---------------------------- DROP TABLE IF EXISTS `dingdan`; CREATE TABLE `dingdan` ( `orderid` int(11) NOT NULL AUTO_INCREMENT COMMENT '订单编号', `orderdate` datetime DEFAULT NULL COMMENT '下单时间', `orderstate` int(11) DEFAULT NULL COMMENT '订单状态', `aid` int(11) DEFAULT NULL COMMENT '下单人的编号', PRIMARY KEY (`orderid`) ) ENGINE=InnoDB AUTO_INCREMENT=10019 DEFAULT CHARSET=utf8 COMMENT='订单表'; -- ---------------------------- -- Records of dingdan -- ---------------------------- INSERT INTO `dingdan` VALUES ('10012', '2019-06-16 11:22:52', '1', '1001'); INSERT INTO `dingdan` VALUES ('10013', '2019-06-16 11:46:40', '1', '1001'); INSERT INTO `dingdan` VALUES ('10015', '2019-06-16 11:57:06', '2', '1001'); INSERT INTO `dingdan` VALUES ('10018', '2019-06-18 10:56:56', '1', '1001'); -- ---------------------------- -- Table structure for `dingdanxqb` -- ---------------------------- DROP TABLE IF EXISTS `dingdanxqb`; CREATE TABLE `dingdanxqb` ( `odid` int(11) NOT NULL AUTO_INCREMENT COMMENT '订单详情编号', `orderid` int(11) NOT NULL COMMENT '订单号', `bid` int(11) NOT NULL COMMENT '商品编号', `mycount` int(11) NOT NULL COMMENT '购买数量', `total` decimal(18,2) NOT NULL COMMENT '订单详情总金额', PRIMARY KEY (`odid`) ) ENGINE=InnoDB AUTO_INCREMENT=1020 DEFAULT CHARSET=utf8 COMMENT='订单详情表'; -- ---------------------------- -- Records of dingdanxqb -- ---------------------------- INSERT INTO `dingdanxqb` VALUES ('1010', '10011', '218426', '1', '78.00'); INSERT INTO `dingdanxqb` VALUES ('1011', '10012', '218427', '2', '336.00'); INSERT INTO `dingdanxqb` VALUES ('1012', '10012', '218433', '2', '2696.00'); INSERT INTO `dingdanxqb` VALUES ('1013', '10012', '218428', '2', '676.00'); INSERT INTO `dingdanxqb` VALUES ('1014', '10013', '218429', '2', '108.00'); INSERT INTO `dingdanxqb` VALUES ('1015', '10014', '218430', '2', '76.00'); INSERT INTO `dingdanxqb` VALUES ('1016', '10015', '218430', '2', '76.00'); INSERT INTO `dingdanxqb` VALUES ('1017', '10016', '218432', '1', '209.00'); INSERT INTO `dingdanxqb` VALUES ('1018', '10017', '218431', '1', '30.00'); INSERT INTO `dingdanxqb` VALUES ('1019', '10018', '218433', '1', '1348.00'); -- ---------------------------- -- Table structure for `fenlei` -- ---------------------------- DROP TABLE IF EXISTS `fenlei`; CREATE TABLE `fenlei` ( `cid` varchar(20) NOT NULL COMMENT '分类编号', `cname` varchar(30) DEFAULT NULL COMMENT '分类名称', `caddress` varchar(100) DEFAULT NULL COMMENT '所连接地址', PRIMARY KEY (`cid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='分类表'; -- ---------------------------- -- Records of fenlei -- ---------------------------- INSERT INTO `fenlei` VALUES ('1', '书籍', 'shuji.jsp'); INSERT INTO `fenlei` VALUES ('2', '女鞋', 'nvxie.jsp'); INSERT INTO `fenlei` VALUES ('3', '手机数码', 'shouji.jsp'); INSERT INTO `fenlei` VALUES ('4', '男装', 'nanzhuang.jsp'); INSERT INTO `fenlei` VALUES ('5', '生活家电', 'jiadian.jsp'); INSERT INTO `fenlei` VALUES ('6', '首页', 'index.jsp'); -- ---------------------------- -- Table structure for `goods` -- ---------------------------- DROP TABLE IF EXISTS `goods`; CREATE TABLE `goods` ( `bid` int(30) NOT NULL AUTO_INCREMENT COMMENT '商品编号', `name` varchar(30) DEFAULT NULL COMMENT '商品名称', `price` decimal(18,2) DEFAULT NULL COMMENT '商品价格', `image` varchar(100) DEFAULT NULL COMMENT '商品图片', `state` varchar(20) DEFAULT NULL COMMENT '商品状态', `number` decimal(18,2) DEFAULT NULL COMMENT '商品库存', `fenlei` varchar(30) DEFAULT NULL, `images` varchar(30) DEFAULT NULL COMMENT '商品详情对应的相关图片', PRIMARY KEY (`bid`) ) ENGINE=InnoDB AUTO_INCREMENT=218441 DEFAULT CHARSET=utf8 COMMENT='商品表'; -- ---------------------------- -- Records of goods -- ---------------------------- INSERT INTO `goods` VALUES ('218426', '休闲鞋2019夏季新款韩版百搭跑步板鞋ins学生鞋', '78.00', '../images/nvxie3.jpg', '上架', '65.00', '女鞋', null); INSERT INTO `goods` VALUES ('218427', '运动鞋女ins潮鞋百搭跑步鞋子学生休闲韩版夏季透气女鞋', '168.00', '../images/nvxie2.jpg', '上架', '66.00', '女鞋', null); INSERT INTO `goods` VALUES ('218428', '骆驼运动鞋女夏季透气跑步鞋女鞋子2019新款鞋轻便跑鞋', '338.00', '../images/nvxie1.jpg', '上架', '98.00', '女鞋', null); INSERT INTO `goods` VALUES ('218429', '正版 三命通会 三命通会上下册 四柱八字命理书籍 古书籍 ', '54.00', '../images/shuji3.jpg', '上架', '44.00', '书籍', null); INSERT INTO `goods` VALUES ('218430', '有钱人和你想的不一样 哈维艾克 财商财富', '38.00', '../images/shuji2.jpg', '上架', '6.00', '书籍', null); INSERT INTO `goods` VALUES ('218431', '小孩大冰继你坏我不好吗好的阿弥陀佛么么哒乖摸摸头作品', '30.00', '../images/shuji1.jpg', '上架', '95.00', '书籍', null); INSERT INTO `goods` VALUES ('218432', 'Coolpad/酷派手机安卓大屏智能老人机', '209.00', '../images/shouji3.jpg', '上架', '56.00', '手机数码', null); INSERT INTO `goods` VALUES ('218433', 'vivo Z3全面屏高通骁龙710处理器闪充智能学生手机', '