java Web会员管理系统用eclipse定制开发mysql数据库BS模式java编程jdbc项目源码

/* Navicat MySQL Data Transfer Source Server : localhost Source Server Version : 50067 Source Host : localhost:3306 Source Database : jsphygl Target Server Type : MYSQL Target Server Version : 50067 File Encoding : 65001 Date: 2023-02-11 18:19:32 */ 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 '价格', `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', 'order202302111620000052', '1', '1', '20', '340025'); INSERT INTO `ddmx` VALUES ('2', 'order202302111747000006', '1', '1', '20', '340025'); INSERT INTO `ddmx` VALUES ('3', 'order202302111747000046', '1', '1', '20', '340025'); -- ---------------------------- -- Table structure for dingdan -- ---------------------------- DROP TABLE IF EXISTS `dingdan`; CREATE TABLE `dingdan` ( `ddid` int(11) NOT NULL auto_increment, `ddh` varchar(40) default NULL COMMENT '订单号', `hy` varchar(40) default NULL COMMENT '会员', `gmsj` varchar(40) default NULL COMMENT '购买时间', `zje` int(40) default NULL COMMENT '总金额', `zt` varchar(40) default NULL COMMENT '状态', `sm` varchar(4000) default NULL COMMENT '说明', PRIMARY KEY (`ddid`) ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=gb2312; -- ---------------------------- -- Records of dingdan -- ---------------------------- INSERT INTO `dingdan` VALUES ('1', 'order202302111620000052', '340025', '2023-02-11 16:20:52', '20', '已反馈', '123123'); INSERT INTO `dingdan` VALUES ('2', 'order202302111747000006', '340025', '2023-02-11 17:47:06', '20', '未处理', '2222'); INSERT INTO `dingdan` VALUES ('3', 'order202302111747000046', '340025', '2023-02-11 17:47:46', '20', '已反馈', '123213'); -- ---------------------------- -- Table structure for fankui -- ---------------------------- DROP TABLE IF EXISTS `fankui`; CREATE TABLE `fankui` ( `fkid` int(11) NOT NULL auto_increment, `sp` varchar(40) default NULL COMMENT '商品', `hy` varchar(40) default NULL COMMENT '会员', `dd` varchar(40) default NULL COMMENT '订单', `fknr` varchar(4000) default NULL COMMENT '反馈内容', `sj` varchar(40) default NULL COMMENT '时间', PRIMARY KEY (`fkid`) ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=gb2312; -- ---------------------------- -- Records of fankui -- ---------------------------- INSERT INTO `fankui` VALUES ('1', '1', '340025', 'order202302111620000052', '挺好的', '2023-02-11 17:35:26'); INSERT INTO `fankui` VALUES ('2', '1', '340025', 'order202302111747000046', '1232132', '2023-02-11 17:53:23'); -- ---------------------------- -- 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 huiyuan -- ---------------------------- DROP TABLE IF EXISTS `huiyuan`; CREATE TABLE `huiyuan` ( `hyid` int(11) NOT NULL auto_increment, `kh` varchar(40) default NULL COMMENT '卡号', `mm` varchar(40) default NULL COMMENT '密码', `xm` varchar(40) default NULL COMMENT '姓名', `csrq` varchar(40) default NULL COMMENT '出生日期', `xb` varchar(40) default NULL COMMENT '性别', `sjh` varchar(40) default NULL COMMENT '手机号', `zz` varchar(40) default NULL COMMENT '住址', `cwhysj` varchar(40) default NULL COMMENT '成为会员时间', `zhsysj` varchar(40) default NULL COMMENT '最后使用时间', `jf` int(40) default NULL COMMENT '积分', PRIMARY KEY (`hyid`) ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=gb2312; -- ---------------------------- -- Records of huiyuan -- ---------------------------- INSERT INTO `huiyuan` VALUES ('1', '340025', '123', '123', '2023-02-17', '男', '12312312312', '3213123', '2023-02-11 09:34:25', '2023-02-11 09:34:25', '1000'); INSERT INTO `huiyuan` VALUES ('2', '110027', '123', '123', '2023-02-17', '男', '123123123', '123123', '2023-02-11 18:11:36', '2023-02-11 18:18:43', '1000'); -- ---------------------------- -- Table structure for jfdh -- ---------------------------- DROP TABLE IF EXISTS `jfdh`; CREATE TABLE `jfdh` ( `jfdhid` int(11) NOT NULL auto_increment, `sp` varchar(40) default NULL COMMENT '商品', `hy` varchar(40) default NULL COMMENT '会员', `dhsj` varchar(40) default NULL COMMENT '兑换时间', `dhjf` varchar(40) default NULL COMMENT '兑换积分', `sl` varchar(40) default NULL COMMENT '数量', PRIMARY KEY (`jfdhid`) ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=gb2312; -- ---------------------------- -- Records of jfdh -- ---------------------------- INSERT INTO `jfdh` VALUES ('1', '1', '340025', '2023-02-11 17:39:53', '2000', '1'); INSERT INTO `jfdh` VALUES ('2', '1', '110027', '2023-02-11 18:18:48', '2000', '1'); -- ---------------------------- -- 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 '商品名称', `sl` int(40) default NULL COMMENT '数量', `je` varchar(40) default NULL COMMENT '金额', `tp` varchar(40) default NULL COMMENT '图片', `js` varchar(4000) default NULL COMMENT '介绍', `bzq` varchar(40) default NULL COMMENT '保质期', `jf` int(40) default NULL COMMENT '积分', PRIMARY KEY (`spid`) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=gb2312; -- ---------------------------- -- Records of shangpin -- ---------------------------- INSERT INTO `shangpin` VALUES ('1', '一个玩具', '10', '20', '1676081974119.jpg', '一个玩具一个玩具一个玩具', '2025-02-20', '2000');