基于ssm的机场网上订票系统设计与实现-计算机毕业设计源码+LW文档
开发语言：Java
框架：ssm
JDK版本：JDK1.8
服务器：tomcat7
数据库：mysql 5.7（一定要5.7版本）
数据库工具：Navicat11
开发软件：eclipse/myeclipse/idea
Maven包：Maven3.3.9
浏览器：谷歌浏览器
数据库脚本：
DROP TABLE IF EXISTS `chat`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `chat` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`userid` bigint(20) NOT NULL COMMENT '用户id',
`adminid` bigint(20) DEFAULT NULL COMMENT '管理员id',
`ask` longtext COMMENT '提问',
`reply` longtext COMMENT '回复',
`isreply` int(11) DEFAULT NULL COMMENT '是否回复',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=57 DEFAULT CHARSET=utf8 COMMENT='在线留言';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `chat`
--
LOCK TABLES `chat` WRITE;
/*!40000 ALTER TABLE `chat` DISABLE KEYS */;
INSERT INTO `chat` VALUES (51,'2022-02-27 13:29:35',1,1,'提问1','回复1',1),(52,'2022-02-27 13:29:35',2,2,'提问2','回复2',2),(53,'2022-02-27 13:29:35',3,3,'提问3','回复3',3),(54,'2022-02-27 13:29:35',4,4,'提问4','回复4',4),(55,'2022-02-27 13:29:35',5,5,'提问5','回复5',5),(56,'2022-02-27 13:29:35',6,6,'提问6','回复6',6);
/*!40000 ALTER TABLE `chat` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `config`
--
DROP TABLE IF EXISTS `config`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `config` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
`name` varchar(100) NOT NULL COMMENT '配置参数名称',
`value` varchar(100) DEFAULT NULL COMMENT '配置参数值',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COMMENT='配置文件';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `config`
--
LOCK TABLES `config` WRITE;
/*!40000 ALTER TABLE `config` DISABLE KEYS */;
INSERT INTO `config` VALUES (1,'picture1','upload/picture1.jpg'),(2,'picture2','upload/picture2.jpg'),(3,'picture3','upload/picture3.jpg');
/*!40000 ALTER TABLE `config` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `dingpiaoxinxi`
--
DROP TABLE IF EXISTS `dingpiaoxinxi`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `dingpiaoxinxi` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`dingdanbianhao` varchar(200) DEFAULT NULL COMMENT '订单编号',
`hangbanbianhao` varchar(200) DEFAULT NULL COMMENT '航班编号',
`hangkonggongsi` varchar(200) DEFAULT NULL COMMENT '航空公司',
`chufadi` varchar(200) DEFAULT NULL COMMENT '出发地',
`mudedi` varchar(200) DEFAULT NULL COMMENT '目的地',
`feixingfangshi` varchar(200) DEFAULT NULL COMMENT '飞行方式',
`chufashijian` datetime DEFAULT NULL COMMENT '出发时间',
`piaojia` float DEFAULT NULL COMMENT '票价',
`shuliang` int(11) NOT NULL COMMENT '数量',
`zongjine` float DEFAULT NULL COMMENT '总金额',
`yonghuzhanghao` varchar(200) DEFAULT NULL COMMENT '用户账号',
`yonghuxingming` varchar(200) DEFAULT NULL COMMENT '用户姓名',
`lianxidianhua` varchar(200) DEFAULT NULL COMMENT '联系电话',
`shenfenzhenghao` varchar(200) DEFAULT NULL COMMENT '身份证号',
`goupiaoriqi` date DEFAULT NULL COMMENT '购票日期',
`ispay` varchar(200) DEFAULT '未支付' COMMENT '是否支付',
PRIMARY KEY (`id`),
UNIQUE KEY `dingdanbianhao` (`dingdanbianhao`)
) ENGINE=InnoDB AUTO_INCREMENT=37 DEFAULT CHARSET=utf8 COMMENT='订票信息';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `dingpiaoxinxi`
--
LOCK TABLES `dingpiaoxinxi` WRITE;
/*!40000 ALTER TABLE `dingpiaoxinxi` DISABLE KEYS */;
INSERT INTO `dingpiaoxinxi` VALUES (31,'2022-02-27 13:29:35','1111111111','航班编号1','航空公司1','出发地1','目的地1','飞行方式1','2022-02-27 21:29:35',1,1,1,'用户账号1','用户姓名1','联系电话1','身份证号1','2022-02-27','未支付'),(32,'2022-02-27 13:29:35','2222222222','航班编号2','航空公司2','出发地2','目的地2','飞行方式2','2022-02-27 21:29:35',2,2,2,'用户账号2','用户姓名2','联系电话2','身份证号2','2022-02-27','未支付'),(33,'2022-02-27 13:29:35','3333333333','航班编号3','航空公司3','出发地3','目的地3','飞行方式3','2022-02-27 21:29:35',3,3,3,'用户账号3','用户姓名3','联系电话3','身份证号3','2022-02-27','未支付'),(34,'2022-02-27 13:29:35','4444444444','航班编号4','航空公司4','出发地4','目的地4','飞行方式4','2022-02-27 21:29:35',4,4,4,'用户账号4','用户姓名4','联系电话4','身份证号4','2022-02-27','未支付'),(35,'2022-02-27 13:29:35','5555555555','航班编号5','航空公司5','出发地5','目的地5','飞行方式5','2022-02-27 21:29:35',5,5,5,'用户账号5','用户姓名5','联系电话5','身份证号5','2022-02-27','未支付'),(36,'2022-02-27 13:29:35','6666666666','航班编号6','航空公司6','出发地6','目的地6','飞行方式6','2022-02-27 21:29:35',6,6,6,'用户账号6','用户姓名6','联系电话6','身份证号6','2022-02-27','未支付');
/*!40000 ALTER TABLE `dingpiaoxinxi` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `discussjipiaoxinxi`
--
DROP TABLE IF EXISTS `discussjipiaoxinxi`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `discussjipiaoxinxi` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`refid` bigint(20) NOT NULL COMMENT '关联表id',
`userid` bigint(20) NOT NULL COMMENT '用户id',
`nickname` varchar(200) DEFAULT NULL COMMENT '用户名',
`content` longtext NOT NULL COMMENT '评论内容',
`reply` longtext COMMENT '回复内容',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=87 DEFAULT CHARSET=utf8 COMMENT='机票信息评论表';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `discussjipiaoxinxi`
--
LOCK TABLES `discussjipiaoxinxi` WRITE;
/*!40000 ALTER TABLE `discussjipiaoxinxi` DISABLE KEYS */;
INSERT INTO `discussjipiaoxinxi` VALUES (81,'2022-02-27 13:29:36',1,1,'用户名1','评论内容1','回复内容1'),(82,'2022-02-27 13:29:36',2,2,'用户名2','评论内容2','回复内容2'),(83,'2022-02-27 13:29:36',3,3,'用户名3','评论内容3','回复内容3'),(84,'2022-02-27 13:29:36',4,4,'用户名4','评论内容4','回复内容4'),(85,'2022-02-27 13:29:36',5,5,'用户名5','评论内容5','回复内容5'),(86,'2022-02-27 13:29:36',6,6,'用户名6','评论内容6','回复内容6');
/*!40000 ALTER TABLE `discussjipiaoxinxi` ENABLE KEYS */;
UNLOCK TABLES;
业务逻辑代码：
/**
* 用户
* 后端接口
* @author
* @date 2022-02-27 21:28:50
*/
@RestController
@RequestMapping("/yonghu")
public class YonghuController {
@Autowired
private YonghuService yonghuService;
@Autowired
private TokenService tokenService;
/**
* 登录
*/
@IgnoreAuth
@RequestMapping(value = "/login")
public R login(String username, String password, String captcha, HttpServletRequest request) {
YonghuEntity user = yonghuService.selectOne(new EntityWrapper<YonghuEntity>().eq("yonghuzhanghao", username));
if(user==null || !user.getMima().equals(password)) {
return R.error("账号或密码不正确");
}
String token = tokenService.generateToken(user.getId(), username,"yonghu", "用户" );
return R.ok().put("token", token);
}
/**
* 注册
*/
@IgnoreAuth
@RequestMapping("/register")
public R register(@RequestBody YonghuEntity yonghu){
//ValidatorUtils.validateEntity(yonghu);
YonghuEntity user = yonghuService.selectOne(new EntityWrapper<YonghuEntity>().eq("yonghuzhanghao", yonghu.getYonghuzhanghao()));
if(user!=null) {
return R.error("注册用户已存在");
}
Long uId = new Date().getTime();
yonghu.setId(uId);
yonghuService.insert(yonghu);
return R.ok();
}
/**
* 退出
*/
@RequestMapping("/logout")
public R logout(HttpServletRequest request) {
request.getSession().invalidate();
return R.ok("退出成功");
}
/**
* 获取用户的session用户信息
*/
@RequestMapping("/session")
public R getCurrUser(HttpServletRequest request){
Long id = (Long)request.getSession().getAttribute("userId");
YonghuEntity user = yonghuService.selectById(id);
return R.ok().put("data", user);
}
/**
* 密码重置
*/
@IgnoreAuth
@RequestMapping(value = "/resetPass")
public R resetPass(String username, HttpServletRequest request){
YonghuEntity user = yonghuService.selectOne(new EntityWrapper<YonghuEntity>().eq("yonghuzhanghao", username));
if(user==null) {
return R.error("账号不存在");
}
user.setMima("123456");
yonghuService.updateById(user);
return R.ok("密码已重置为：123456");
}
/**
* 后端列表
*/
@RequestMapping("/page")
public R page(@RequestParam Map<String, Object> params,YonghuEntity yonghu,
HttpServletRequest request){
EntityWrapper<YonghuEntity> ew = new EntityWrapper<YonghuEntity>();
PageUtils page = yonghuService.queryPage(params, MPUtil.sort(MPUtil.between(MPUtil.likeOrEq(ew, yonghu), params), params));
return R.ok().put("data", page);
}
/**
* 前端列表
*/
@IgnoreAuth
@RequestMapping("/list")
public R list(@RequestParam Map<String, Object> params,YonghuEntity yonghu,
HttpServletRequest request){
EntityWrapper<YonghuEntity> ew = new EntityWrapper<YonghuEntity>();
PageUtils page = yonghuService.queryPage(params, MPUtil.sort(MPUtil.between(MPUtil.likeOrEq(ew, yonghu), params), params));
return R.ok().put("data", page);
}
/**
* 列表
*/
@RequestMapping("/lists")
public R list( YonghuEntity yonghu){
EntityWrapper<YonghuEntity> ew = new EntityWrapper<YonghuEntity>();
ew.allEq(MPUtil.allEQMapPre( yonghu, "yonghu"));
return R.ok().put("data", yonghuService.selectListView(ew));
}
/**
* 查询
*/
@RequestMapping("/query")
public R query(YonghuEntity yonghu){
EntityWrapper< YonghuEntity> ew = new EntityWrapper< YonghuEntity>();
ew.allEq(MPUtil.allEQMapPre( yonghu, "yonghu"));
YonghuView yonghuView = yonghuService.selectView(ew);
return R.ok("查询用户成功").put("data", yonghuView);
}
/**
* 后端详情
*/
@RequestMapping("/info/{id}")
public R info(@PathVariable("id") Long id){
YonghuEntity yonghu = yonghuService.selectById(id);
return R.ok().put("data", yonghu);
}
