基于java SSM框架的旅游网站设计开发(含源文件)

欢迎添加微信互相交流学习哦！

项目源码：https://gitee.com/oklongmm/biye

效果截图：

数据库表：

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);