1756jsp农产品销售管理系统Myeclipse开发mysql数据库C2C模式java编程计算机网页项目沙箱支付源码

/* Navicat MySQL Data Transfer Source Server : localhost Source Server Version : 50067 Source Host : localhost:3306 Source Database : jspshop Target Server Type : MYSQL Target Server Version : 50067 File Encoding : 65001 Date: 2021-10-24 10:21:20 */ 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` int(40) default NULL COMMENT '数量', `jg` varchar(40) default NULL COMMENT '价格', `shj` varchar(40) default NULL COMMENT '时间', `zt` varchar(40) default NULL COMMENT '状态', `hy` varchar(40) default NULL COMMENT '会员', `sj` varchar(40) default NULL COMMENT '商家', PRIMARY KEY (`ddmxid`) ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=gb2312; -- ---------------------------- -- Records of ddmx -- ---------------------------- INSERT INTO `ddmx` VALUES ('1', 'order202110222103000006', '1', '2', '22', '2021-10-22 20:20:05', '已评价', '123', 'gys'); INSERT INTO `ddmx` VALUES ('2', 'order202110240945000020', '1', '1', '22', '2021-09-24 09:44:43', '已评价', '123', 'gys'); INSERT INTO `ddmx` VALUES ('3', 'order202110241010000042', '1', '1', '22', '2021-10-24 10:10:38', '购物车', '123', 'gys'); -- ---------------------------- -- 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 '订单流水', `hy` 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 '总价', `sj` varchar(40) default NULL COMMENT '商家', `ydh` varchar(40) default NULL COMMENT '运单号', PRIMARY KEY (`ddid`) ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=gb2312; -- ---------------------------- -- Records of dingdan -- ---------------------------- INSERT INTO `dingdan` VALUES ('1', 'order202110222103000006', '123', '2021-10-22 21:03:062', '完成', '123', '123213', '123', '44', 'gys', '12312312'); INSERT INTO `dingdan` VALUES ('2', 'order202110240945000020', '123', '2021-10-24 09:45:20', '完成', '1231', '23123', '123123', '22', 'gys', '12312312'); INSERT INTO `dingdan` VALUES ('3', 'order202110241010000042', '123', '2021-10-24 10:10:42', '待发货', '123123123', '123123', '123123', '22', 'gys', ''); -- ---------------------------- -- 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 gonggao -- ---------------------------- DROP TABLE IF EXISTS `gonggao`; CREATE TABLE `gonggao` ( `ggid` int(11) NOT NULL auto_increment, `bt` varchar(40) default NULL COMMENT '标题', `nr` varchar(4000) default NULL COMMENT '内容', `fbsj` varchar(40) default NULL COMMENT '发布时间', PRIMARY KEY (`ggid`) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=gb2312; -- ---------------------------- -- Records of gonggao -- ---------------------------- INSERT INTO `gonggao` VALUES ('1', '系统公告', '的', '2021-10-20 11:09:23'); -- ---------------------------- -- Table structure for gys -- ---------------------------- DROP TABLE IF EXISTS `gys`; CREATE TABLE `gys` ( `gysid` int(11) NOT NULL auto_increment, `yhm` varchar(40) default NULL COMMENT '用户名', `mm` varchar(40) default NULL COMMENT '密码', `xm` varchar(40) default NULL COMMENT '姓名', `zt` varchar(40) default NULL COMMENT '主图', `js` varchar(4000) default NULL COMMENT '介绍', `rzsj` varchar(40) default NULL COMMENT '入住时间', `szd` varchar(40) default NULL COMMENT '所在地', PRIMARY KEY (`gysid`) ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=gb2312; -- ---------------------------- -- Records of gys -- ---------------------------- INSERT INTO `gys` VALUES ('1', 'gys', 'gys', '淘宝旺铺', '1634453786163.jpg', '淘宝旺铺淘宝旺铺淘宝旺铺', '2021-10-17 14:56:18', '上海'); INSERT INTO `gys` VALUES ('2', 'null', 'null', '啦啦店铺', '', '', '2021-10-23 17:58:30', '北京'); INSERT INTO `gys` VALUES ('3', 'gys2', 'gys2', '啦啦店铺', '1635041219657.jpg', '阿道夫', '2021-10-24 10:06:32', '济南'); -- ---------------------------- -- Table structure for huiyuan -- ---------------------------- DROP TABLE IF EXISTS `huiyuan`; CREATE TABLE `huiyuan` ( `hyid` 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 (`hyid`) ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=gb2312; -- ---------------------------- -- Records of huiyuan -- ---------------------------- INSERT INTO `huiyuan` VALUES ('1', '123', '123', '123', '123', '123123'); INSERT INTO `huiyuan` VALUES ('2', '333', '333', '333', '1231231', '23123'); -- ---------------------------- -- Table structure for liuyan -- ---------------------------- DROP TABLE IF EXISTS `liuyan`; CREATE TABLE `liuyan` ( `lyid` int(11) NOT NULL auto_increment, `ly` varchar(4000) default NULL COMMENT '留言', `yh` varchar(40) default NULL COMMENT '用户', `shj` varchar(40) default NULL COMMENT '时间', `zt` varchar(40) default NULL COMMENT '状态', `sj` varchar(40) default NULL COMMENT '商家', `hf` varchar(4000) default NULL COMMENT '回复', PRIMARY KEY (`lyid`) ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=gb2312; -- ---------------------------- -- Records of liuyan -- ---------------------------- INSERT INTO `liuyan` VALUES ('1', '123123', '123', '2021-10-23 14:50:23', '已回复', 'gys', '13212231'); INSERT INTO `liuyan` VALUES ('2', '21234234234', '123', '2021-10-24 10:10:11', '未回复', 'gys2', ''); -- ---------------------------- -- Table structure for lx -- ---------------------------- DROP TABLE IF EXISTS `lx`; CREATE TABLE `lx` ( `lx` varchar(255) character set gb2312 collate gb2312_bin default NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- ---------------------------- -- Records of lx -- ---------------------------- INSERT INTO `lx` VALUES ('种类'); INSERT INTO `lx` VALUES ('期限'); -- ---------------------------- -- Table structure for lyb -- ---------------------------- DROP TABLE IF EXISTS `lyb`; CREATE TABLE `lyb` ( `lybid` int(11) NOT NULL auto_increment, `ly` varchar(4000) default NULL COMMENT '留言', `sj` varchar(40) default NULL COMMENT '商家', `shj` varchar(40) default NULL COMMENT '时间', `zt` varchar(40) default NULL COMMENT '状态', `hf` varchar(40) default NULL COMMENT '回复', PRIMARY KEY (`lybid`) ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=gb2312; -- ---------------------------- -- Records of lyb -- ---------------------------- INSERT INTO `lyb` VALUES ('1', '按时发发', 'gys', '2021-10