基于SSM框架的旅游网站

介绍：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);

巴特西

基于SSM框架的旅游网站

最新文章

热门文章