1813 jsp篮球鞋在线商城系统Myeclipse开发mysql数据库web结构java编程计算机网页项目源码

/* Navicat MySQL Data Transfer Source Server : localhost Source Server Version : 50067 Source Host : localhost:3306 Source Database : jspbkshop Target Server Type : MYSQL Target Server Version : 50067 File Encoding : 65001 Date: 2022-04-08 14:57:52 */ SET FOREIGN_KEY_CHECKS=0; -- ---------------------------- -- Table structure for ddmx -- ---------------------------- DROP TABLE IF EXISTS `ddmx`; CREATE TABLE `ddmx` ( `ddmxid` int(11) NOT NULL auto_increment, `dd` varchar(40) default NULL COMMENT '订单', `sp` varchar(40) default NULL COMMENT '商品', `sl` varchar(40) default NULL COMMENT '数量', `jg` varchar(40) default NULL COMMENT '价格', `sj` varchar(40) default NULL COMMENT '时间', `zt` varchar(40) default NULL COMMENT '状态', `yh` varchar(40) default NULL COMMENT '用户', PRIMARY KEY (`ddmxid`) ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=gb2312; -- ---------------------------- -- Records of ddmx -- ---------------------------- INSERT INTO `ddmx` VALUES ('1', 'order202204081152000027', '1', '1', '150', null, '完成', '123'); INSERT INTO `ddmx` VALUES ('2', 'order202204081152000027', '1', '1', '150', null, '完成', '123'); INSERT INTO `ddmx` VALUES ('3', '', '1', '1', '150', null, '购物车', '123'); -- ---------------------------- -- Table structure for dingdan -- ---------------------------- DROP TABLE IF EXISTS `dingdan`; CREATE TABLE `dingdan` ( `ddid` int(11) NOT NULL auto_increment, `ddls` varchar(40) default NULL COMMENT '订单流水', `yh` varchar(40) default NULL COMMENT '用户', `gmsj` varchar(40) default NULL COMMENT '购买时间', `zt` varchar(40) default NULL COMMENT '状态', `shdz` varchar(40) default NULL COMMENT '收货地址', `dh` varchar(40) default NULL COMMENT '电话', `shr` varchar(40) default NULL COMMENT '收货人', `zj` int(40) default NULL COMMENT '总价', PRIMARY KEY (`ddid`) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=gb2312; -- ---------------------------- -- Records of dingdan -- ---------------------------- INSERT INTO `dingdan` VALUES ('1', 'order202204081152000027', '123', '2022-04-08 11:52:27', '未处理', '123123', '123123', '123213', '300'); -- ---------------------------- -- Table structure for gly -- ---------------------------- DROP TABLE IF EXISTS `gly`; CREATE TABLE `gly` ( `glyid` int(11) NOT NULL auto_increment, `yhm` varchar(40) default NULL COMMENT '用户名', `mm` varchar(40) default NULL COMMENT '密码', `xm` varchar(40) default NULL COMMENT '姓名', PRIMARY KEY (`glyid`) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=gb2312; -- ---------------------------- -- Records of gly -- ---------------------------- INSERT INTO `gly` VALUES ('1', 'admin', 'admin', 'admin'); -- ---------------------------- -- Table structure for leibie -- ---------------------------- DROP TABLE IF EXISTS `leibie`; CREATE TABLE `leibie` ( `lbid` int(11) NOT NULL auto_increment, `lb` varchar(40) default NULL COMMENT '类别', PRIMARY KEY (`lbid`) ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=gb2312; -- ---------------------------- -- Records of leibie -- ---------------------------- INSERT INTO `leibie` VALUES ('1', '比赛'); INSERT INTO `leibie` VALUES ('2', '室外'); -- ---------------------------- -- Table structure for shangpin -- ---------------------------- DROP TABLE IF EXISTS `shangpin`; CREATE TABLE `shangpin` ( `spid` int(11) NOT NULL auto_increment, `spmc` varchar(40) default NULL COMMENT '商品名称', `lb` varchar(40) default NULL COMMENT '类别', `js` varchar(4000) default NULL COMMENT '介绍', `tp` varchar(40) default NULL COMMENT '图片', `jg` varchar(40) default NULL COMMENT '价格', `yh` varchar(40) default NULL COMMENT '用户', `cd` varchar(40) default NULL COMMENT '产地', `pp` varchar(40) default NULL COMMENT '品牌', `scrq` varchar(40) default NULL COMMENT '生产日期', PRIMARY KEY (`spid`) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=gb2312; -- ---------------------------- -- Records of shangpin -- ---------------------------- INSERT INTO `shangpin` VALUES ('1', '比赛篮球鞋', '比赛', '比赛篮球鞋', '1649342643475.jpeg', '150', 'admin', '上海', '斯伯丁', '2022-04-07'); -- ---------------------------- -- Table structure for wuliu -- ---------------------------- DROP TABLE IF EXISTS `wuliu`; CREATE TABLE `wuliu` ( `wlid` int(11) NOT NULL auto_increment, `dd` varchar(40) default NULL COMMENT '订单', `qsd` varchar(40) default NULL COMMENT '起始地', `qssj` varchar(40) default NULL COMMENT '起始时间', `mdd` varchar(40) default NULL COMMENT '目的地', `mdsj` varchar(40) default NULL COMMENT '目的时间', `zt` varchar(40) default NULL COMMENT '状态', PRIMARY KEY (`wlid`) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=gb2312; -- ---------------------------- -- Records of wuliu -- ---------------------------- INSERT INTO `wuliu` VALUES ('1', 'order202204081152000027', '北京', '2022-04-15', '上海', '2022-04-16', '运输中'); -- ---------------------------- -- Table structure for yonghu -- ---------------------------- DROP TABLE IF EXISTS `yonghu`; CREATE TABLE `yonghu` ( `yhid` int(11) NOT NULL auto_increment, `yhm` varchar(40) default NULL COMMENT '用户名', `mm` varchar(40) default NULL COMMENT '密码', `xm` varchar(40) default NULL COMMENT '姓名', `lxdh` varchar(40) default NULL COMMENT '联系电话', `lxdz` varchar(40) default NULL COMMENT '联系地址', PRIMARY KEY (`yhid`) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=gb2312; -- ---------------------------- -- Records of yonghu -- ---------------------------- INSERT INTO `yonghu` VALUES ('1', '123', '123', '123', '123123123', '12312312');