介绍：spring+springmvc+mybatis三大框架，mysql数据库

功能结构图：

效果截图：








数据库表：

CREATE TABLE t_admin (
id int(11) NOT NULL AUTO_INCREMENT,
username varchar(100) DEFAULT NULL,
password varchar(100) DEFAULT NULL,
PRIMARY KEY (id)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

---

– Records of t_admin

---

INSERT INTO t_admin VALUES (‘1’, ‘admin’, ‘111’);

---

– Table structure for t_contact

---

DROP TABLE IF EXISTS t_contact;
CREATE TABLE t_contact (
id int(11) NOT NULL AUTO_INCREMENT,
customerId int(11) DEFAULT NULL COMMENT ‘用户’,
phone varchar(100) DEFAULT NULL COMMENT ‘联系方式’,
content text COMMENT ‘内容’,
insertDate datetime DEFAULT NULL COMMENT ‘日期’,
PRIMARY KEY (id)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8 COMMENT=‘建议’;

---

– Records of t_contact

---

INSERT INTO t_contact VALUES (‘1’, ‘2’, ‘1123’, ‘123123123’, ‘2020-02-13 08:15:15’);
INSERT INTO t_contact VALUES (‘2’, ‘2’, ‘149999999’, ‘sdfasdfasdfasdfasdf’, ‘2020-02-15 09:51:57’);
INSERT INTO t_contact VALUES (‘3’, ‘2’, ‘123123’, ‘2312312跌幅达士大夫撒’, ‘2020-02-10 15:14:26’);
INSERT INTO t_contact VALUES (‘4’, ‘8’, ‘1381111111111111’, ‘1三大法师的发’, ‘2020-02-12 10:47:37’);
INSERT INTO t_contact VALUES (‘5’, ‘2’, null, null, ‘2020-02-11 08:11:09’);
INSERT INTO t_contact VALUES (‘6’, ‘2’, ‘13811111111’, ‘阿达撒发的说法三’, ‘2020-02-13 02:50:51’);
INSERT INTO t_contact VALUES (‘7’, ‘2’, ‘2222’, ‘222’, ‘2020-02-11 01:49:15’);
INSERT INTO t_contact VALUES (‘8’, null, ‘13811111111’, ‘阿斯顿发的说法’, ‘2020-02-14 15:22:20’);
INSERT INTO t_contact VALUES (‘9’, null, ‘13811111111’, ‘的说法是发生’, ‘2020-02-13 07:33:25’);
INSERT INTO t_contact VALUES (‘10’, ‘13’, ‘138111111111’, ‘111’, ‘2020-02-11 22:47:47’);

---

– Table structure for t_customer

---

DROP TABLE IF EXISTS t_customer;
CREATE TABLE t_customer (
id int(11) NOT NULL AUTO_INCREMENT,
username varchar(100) DEFAULT NULL COMMENT ‘账号’,
password varchar(100) DEFAULT NULL COMMENT ‘密码’,
customerName varchar(100) DEFAULT NULL COMMENT ‘姓名’,
sex varchar(100) DEFAULT NULL COMMENT ‘性别’,
address varchar(100) DEFAULT NULL COMMENT ‘地址’,
phone varchar(100) DEFAULT NULL COMMENT ‘手机’,
account int(11) DEFAULT NULL COMMENT ‘账户’,
jf int(11) DEFAULT NULL COMMENT ‘积分’,
headPic varchar(50) DEFAULT NULL COMMENT ‘头像’,
status varchar(50) DEFAULT NULL,
PRIMARY KEY (id)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8 COMMENT=‘客户’;

---

– Records of t_customer

---

INSERT INTO t_customer VALUES (‘2’, ‘c1’, ‘111’, ‘小明’, ‘男’, ‘上海市政府大楼’, ‘13811111111’, ‘3374’, ‘20300’, ‘upload/20200217/158194362417952.jpg’, null);
INSERT INTO t_customer VALUES (‘3’, ‘c2’, ‘111’, ‘李四’, ‘女’, ‘上海市政府大楼’, ‘13811111111’, null, null, ‘upload/20191205/157555434951579.jpg’, null);
INSERT INTO t_customer VALUES (‘4’, ‘c3’, ‘111’, ‘王五’, ‘女’, ‘上海市政府大楼’, ‘13811111111’, null, null, ‘upload/20191205/157555434951579.jpg’, null);
INSERT INTO t_customer VALUES (‘5’, ‘c4’, ‘111’, ‘赵柳’, ‘男’, ‘上海市政府大楼’, ‘13811111111’, ‘-1464’, ‘21200’, ‘upload/20191205/157555434951579.jpg’, null);
INSERT INTO t_customer VALUES (‘6’, ‘c5’, ‘111’, ‘黑漆’, ‘男’, ‘上海市政府大楼’, ‘13811111111’, ‘-2453’, ‘20211’, ‘upload/20191205/157555434951579.jpg’, null);
INSERT INTO t_customer VALUES (‘7’, ‘c6’, ‘111’, ‘小红’, ‘男’, ‘上海市政府大楼’, ‘13811111111’, null, null, ‘upload/20191205/157555434951579.jpg’, null);