Java项目:旅游网站管理系统设计和实现(java+springboot+jsp+mysql+spring)
运行环境:java jdk 1.8IDE环境：IDEAtomcat环境：Tomcat 7.x,8.x,9.x版本均可主要功能说明：管理员角色包含以下功能：管理员登录,用户管理,旅游路线管理,旅游景点管理,酒店管理,旅游攻略管理,车票管理,订单管理,数据分析等功能。用户角色包含以下功能：用户注册,用户登录,旅游路线预定,旅游景区预定,餐饮住宿,车票预定,旅游保险预定,旅游攻略,我的订单查看,个人资料
·
源码获取：博客首页 "资源" 里下载！
运行环境: java jdk 1.8
IDE环境： IDEA
tomcat环境： Tomcat 7.x,8.x,9.x版本均可
主要功能说明：
管理员角色包含以下功能：管理员登录,用户管理,旅游路线管理,旅游景点管理,酒店管理,旅游攻略管理,车票管理,订单管理,数据分析等功能。
用户角色包含以下功能：用户注册,用户登录,旅游路线预定,旅游景区预定,餐饮住宿,车票预定,旅游保险预定,旅游攻略,我的订单查看,个人资料管理等功能。
用了技术框架： HTML+CSS+JavaScript+jsp+mysql+Spring+Springboot+mybatis+maven+layui
所用的数据库： Mysql数据库
主要功能截图：
用户端：
注册和登录
首页功能菜单展示：
线路管理
旅游景点查看和预订等、预订完成在我的订单查看付款
餐饮查看和预订等、预订完成在我的订单查看付款
车票查看和预订等、预订完成在我的订单查看付款
保险查看和预订等、预订完成在我的订单查看付款
旅游攻略
注意事项：
后台管理员功能：
数据分析：
星级景点业务：
/**
* @Author: yy
*/
@Controller
@CrossOrigin
@RequestMapping("/travel")
public class RecomTravelController {
@Autowired
private ScenicService scenicService;
@Autowired
private ScenicDao scenicDao;
@Autowired
private HotelService hotelService;
@Autowired
private HotelDao hotelDao;
/**
*查询星级
* @return
*/
@ResponseBody
@RequestMapping(value = "/star",method = RequestMethod.POST)
public Result judgeStar(String id,String start){
System.out.println(id+"===="+start);
Optional<Scenic> s = scenicDao.findById(id);
if (s.isPresent()){
Scenic scenic = s.get();
int valuestar = (Integer.valueOf(start)+Integer.valueOf(scenic.getStart()))/2;
scenic.setStart(valuestar);
scenicDao.save(scenic);
System.out.println("数据不为空！");
return new Result(true,1,"","");
}else {
System.out.println("数据为空！");
return new Result(false,0,"","");
}
}
/**
*查询星级
* @return
*/
@ResponseBody
@RequestMapping(value = "/hotel",method = RequestMethod.POST)
public Result judgeHotelStar(Long id,String start){
Hotel scenic = hotelService.findById(id);
if (scenic!=null){
int valuestar = (Integer.valueOf(start)+Integer.valueOf(scenic.getStar()))/2;
scenic.setStar(valuestar);
hotelDao.save(scenic);
System.out.println("数据不为空！");
return new Result(true,1,"","");
}else {
System.out.println("数据为空！");
return new Result(false,0,"","");
}
}
/**
* 查询单个景点
* @param model
* @param id
* @return
*/
@RequestMapping("/oneAttr")
public String One_attr(Model model,Long id){
Scenic scenic=scenicService.findById(id);
model.addAttribute("oneAttr",scenic);
return "page/product";
}
/**
* 景点模糊查询分页
* @param model
* @param start
* @param limit
* @param search_key
* @return
*/
@RequestMapping("/search_attrs")
public String search_attrs(Model model,@RequestParam(value = "start" ,defaultValue = "0")Integer start,
@RequestParam(value = "limit" ,defaultValue = "6")Integer limit,
@RequestParam String search_key){
start=start<0?0:start;
Sort sort=new Sort(Sort.Direction.DESC,"id");
Pageable pageable=PageRequest.of(start,limit,sort);
Specification specification=new Specification() {
@Override
public Predicate toPredicate(Root root, CriteriaQuery criteriaQuery, CriteriaBuilder criteriaBuilder) {
List<Predicate> scenics=new ArrayList<>();
if (StringUtils.isNotBlank(search_key)){
scenics.add( criteriaBuilder.like(root.get("name"),"%"+search_key+"%"));
}
return criteriaBuilder.and(scenics.toArray(new Predicate[scenics.size()]));
}
};
Page<Scenic> page=scenicDao.findAll(specification,pageable);
model.addAttribute("name",search_key);
model.addAttribute("attrs",page);
model.addAttribute("number",page.getNumber());
model.addAttribute("numberOfElements",page.getNumberOfElements());
model.addAttribute("size",page.getSize());
model.addAttribute("totalElements",page.getTotalElements());
model.addAttribute("totalPages",page.getTotalPages());
model.addAttribute("first",page.isFirst());
model.addAttribute("last",page.isLast());
return "page/travel";
}
@RequestMapping("/local")
public String localRefresh(Model model,Long id) {
Scenic scenic=scenicService.findById(id);
System.out.println(scenic.toString());
List<Hotel> hotels=hotelService.findByCountryLike(scenic.getContry());
Collections.sort(hotels, new Comparator<Hotel>() {
@Override
public int compare(Hotel o1, Hotel o2) {
if (o1.getStar()<o2.getStar()){
return 2;
}
if (o1.getStar().equals(o2.getStar()) ){
return 1;
}
return -1;
}
});
if (hotels.size()>=4){
List newList=hotels.subList(0,3);
model.addAttribute("scenics",newList);
System.out.println("个数："+newList.size());
}else {
model.addAttribute("scenics",hotels);
System.out.println("个数2："+hotels.size());
}
return "page/product::table_refresh";
}
}
订单控制层：
/**
* 控制器层
* @author yy
*
*/
@Controller
@CrossOrigin
@RequestMapping("/orders")
public class OrdersController {
@Autowired
private OrdersService ordersService;
@Autowired
private HotelOrdersService hotel_ordersService;
@Autowired
private HotelService hotelService;
@Autowired
private ScenicService scenicService;
/**
* 查询全部数据
* @return
*/
@ResponseBody
@RequestMapping(value = "/list",method= RequestMethod.GET)
public Result findAll(){
List<Orders> all = ordersService.findAll();
return new Result(true, StatusCode.OK,"查询成功",all,all.size());
}
/**
* 查询全部订单
* @return
*/
@ResponseBody
@RequestMapping(value = "/allorders",method = RequestMethod.POST)
public String findAllOrders(HttpSession session, Model model) throws ParseException {
User user= (User) session.getAttribute("user");
model.addAttribute("orders",ordersService.findOrders(user.getId().toString()));
return "index_header::table_refresh";
}
/**
* 查询全部订单
* @return
*/
@ResponseBody
@RequestMapping(value = "/allorder",method = RequestMethod.POST)
public List<Orders> findAllOrder(HttpSession session) throws ParseException {
User user= (User) session.getAttribute("user");
return ordersService.findOrders(user.getId().toString());
}
/**
* 查询全部订单
* @return
*/
@ResponseBody
@RequestMapping(value = "/allorderhotel",method = RequestMethod.POST)
public List<HotelOrders> findAllOrderHotel(HttpSession session){
User user= (User) session.getAttribute("user");
List<HotelOrders> hotel_orders=hotel_ordersService.hotel_orders(user.getId());
return hotel_orders;
}
/**
* 根据ID查询
* @param id ID
* @return
*/
@ResponseBody
@RequestMapping(value="/{id}",method= RequestMethod.GET)
public Result findById(@PathVariable Long id){
return new Result(true,StatusCode.OK,"查询成功",ordersService.findById(id));
}
/**
* 分页+多条件查询
* @param searchMap 查询条件封装
* @param page 页码
* @param size 页大小
* @return 分页结果
*/
@ResponseBody
@RequestMapping(value="/search/{page}/{size}",method=RequestMethod.POST)
public Result findSearch(@RequestBody Map searchMap , @PathVariable int page, @PathVariable int size){
Page<Orders> pageList = ordersService.findSearch(searchMap, page, size);
return new Result(true,StatusCode.OK,"查询成功", new PageResult<Orders>(pageList.getTotalElements(), pageList.getContent()) );
}
/**
* 根据条件查询
* @param searchMap
* @return
*/
@ResponseBody
@RequestMapping(value="/search",method = RequestMethod.POST)
public Result findSearch( @RequestBody Map searchMap){
return new Result(true,StatusCode.OK,"查询成功",ordersService.findSearch(searchMap));
}
/**
* 订单添加操作
* @param orders
*/
@ResponseBody
@RequestMapping(value ="/add",method=RequestMethod.POST)
public Result add(Orders orders, HttpSession session){
//获取数量
User user = (User) session.getAttribute("user");
if (user == null){
return new Result(false,StatusCode.ACCESSERROR,"请登录");
}
return ordersService.add(orders,user.getId(),orders.getId(),orders.getQty());
}
/**
* 修改
* @param
*/
@ResponseBody
@RequestMapping(value="/{id}",method= RequestMethod.PUT)
public Result update(@PathVariable Long id){
ordersService.updateStatus(id);
return new Result(true,StatusCode.OK,"修改成功");
}
/**
* 删除
* @param id
*/
@ResponseBody
@RequestMapping(value="/{id}",method= RequestMethod.DELETE)
public Result delete(@PathVariable Long id ){
ordersService.deleteById(id);
return new Result(true,StatusCode.OK,"删除成功");
}
@RequestMapping(value = "/ordersList")
public String ordersList(){
return "admin/ordersmanage/orderslist";
}
/**
* 酒店评分
* @param hotel
* @return
*/
@ResponseBody
@PostMapping("/hotelOrderStar")
public Result hotelOrderStar(Hotel hotel,@RequestParam("orderId")Long orderId){
Long id = hotel.getId();
Hotel newHotel = hotelService.findById(id);
if(newHotel==null){
return new Result(false,StatusCode.ERROR,"未找到该酒店!");
}
Integer currentStar = hotel.getStar();
Integer totalStar = newHotel.getStar();
if(currentStar<0){
return new Result(false,StatusCode.ERROR,"请选择评分!");
}
Integer commentCount = newHotel.getCommentCount();
commentCount=commentCount+1;
totalStar=currentStar+totalStar;
int avgStar = totalStar / commentCount;
hotel.setCommentCount(commentCount);
hotel.setStar(avgStar);
Integer hotel1 = hotelService.updateStar(hotel);
hotel_ordersService.updateStarStatus(orderId);
if(hotel1==null){
return new Result(false,StatusCode.ERROR,"评分更新失败!");
}
return new Result(true,StatusCode.OK,"评价成功!");
}
/**
* 景点评分
* @param scenic
* @return
*/
@ResponseBody
@PostMapping("/travelOrderStar")
public Result travelOrderStar(Scenic scenic,@RequestParam("orderId")Long orderId){
Long id = scenic.getId();
Scenic newScenic = scenicService.findById(id);
if(newScenic==null){
return new Result(false,StatusCode.ERROR,"未找到该景点!");
}
Integer totalStar = newScenic.getStart();
Integer currentStar = scenic.getStart();
if(currentStar<0){
return new Result(false,StatusCode.ERROR,"请选择评分!");
}
Integer commentCount = newScenic.getCommentCount();
commentCount=commentCount+1;
totalStar=currentStar+totalStar;
int avgStar = totalStar / commentCount;
scenic.setCommentCount(commentCount);
scenic.setStart(avgStar);
Integer scenic1 = scenicService.updateStar(scenic);
ordersService.updateStarStatus(orderId);
if(scenic1==null){
return new Result(false,StatusCode.ERROR,"评分更新失败!");
}
return new Result(true,StatusCode.OK,"评价成功!");
}
}
酒店信息控制层：
/**
* 控制器层
* @author yy
*
*/
@Controller
@CrossOrigin
@RequestMapping("/hotel")
public class HotelController {
@Autowired
private HotelService hotelService;
@Autowired
private ScenicService scenicService;
/**
* 查询全部酒店信息
* @return
*/
@ResponseBody
@RequestMapping(value = "/list",method= RequestMethod.GET)
public Result findAll(){
List<Hotel> all = hotelService.findAll();
return new Result(true, StatusCode.OK,"查询成功",all,all.size());
}
/**
* 根据ID查询
* @param id ID
* @return
*/
@ResponseBody
@RequestMapping(value="/{id}",method= RequestMethod.GET)
public Result findById(@PathVariable Long id){
return new Result(true,StatusCode.OK,"查询成功",hotelService.findById(id));
}
/**
* 酒店添加操作
* @param hotel
*/
@ResponseBody
@RequestMapping(value = "/add",method=RequestMethod.POST)
public Result add(Hotel hotel){
if(StringUtils.isEmpty(hotel.getName())){
return new Result(false,StatusCode.ERROR,"请填写酒店名称");
}
if(StringUtils.isEmpty(hotel.getImg())){
return new Result(false,StatusCode.ERROR,"请上传酒店封面图片");
}
if(StringUtils.isEmpty(hotel.getAddr())){
return new Result(false,StatusCode.ERROR,"请填写酒店地址");
}
if(StringUtils.isEmpty(hotel.getMiaoshu())){
return new Result(false,StatusCode.ERROR,"请填写酒店描述");
}
hotel.setCommentCount(0);
hotel.setStar(0);
if(hotelService.add(hotel)==null){
return new Result(false,StatusCode.ERROR,"酒店添加失败");
}
return new Result(true,StatusCode.OK,"添加成功");
}
/**
* 分页+多条件查询
* @param searchMap 查询条件封装
* @param page 页码
* @param size 页大小
* @return 分页结果
*/
@ResponseBody
@RequestMapping(value="/search/{page}/{size}",method=RequestMethod.POST)
public Result findSearch(@RequestBody Map searchMap , @PathVariable int page, @PathVariable int size){
Page<Hotel> pageList = hotelService.findSearch(searchMap, page, size);
return new Result(true,StatusCode.OK,"查询成功", new PageResult<Hotel>(pageList.getTotalElements(), pageList.getContent()) );
}
/**
* 根据条件查询
* @param searchMap
* @return
*/
@ResponseBody
@RequestMapping(value="/search",method = RequestMethod.POST)
public Result findSearch( @RequestBody Map searchMap){
return new Result(true,StatusCode.OK,"查询成功",hotelService.findSearch(searchMap));
}
/**
* 修改
* @param hotel
*/
@ResponseBody
@RequestMapping(value="/edit",method= RequestMethod.PUT)
public Result update(Hotel hotel){
Hotel hotelById = hotelService.findById(hotel.getId());
if(hotelById==null){
return new Result(false,StatusCode.ERROR,"该酒店信息不存在");
}
if(StringUtils.isEmpty(hotel.getName())){
return new Result(false,StatusCode.ERROR,"请填写酒店名称");
}
BeanUtils.copyProperties(hotel,hotelById,"id","img","miaoshu","day","startdate","addr","commentCount");
if(hotelService.update(hotelById)==null){
return new Result(false,StatusCode.ERROR,"酒店编辑失败");
}
return new Result(true,StatusCode.OK,"修改成功");
}
/**
* 删除
* @param id
*/
@ResponseBody
@RequestMapping(value="/{id}",method= RequestMethod.DELETE)
public Result delete(@PathVariable String id ){
hotelService.deleteById(id);
return new Result(true,StatusCode.OK,"删除成功");
}
/**
* 酒店列表跳转路径
* @return
*/
@RequestMapping(value = "/hotelList")
public String hotelList(){
return "admin/hotelmanage/hotelList";
}
@RequestMapping(value = "/hotelAdd")
public String hotelAdd(){
return "admin/hotelmanage/hotelAdd";
}
/**
* 查询单个酒店
* @param model
* @param id
* @return
*/
@RequestMapping("/oneAttr")
public String One_attr(Model model, Long id){
Hotel scenic=hotelService.findById(id);
model.addAttribute("oneAttr",scenic);
return "page/hotelDetail";
}
@RequestMapping("/local")
public String localRefresh(Model model,Long id) {
Hotel hotel=hotelService.findById(id);
// Sort sort=new Sort(Sort.Direction.DESC,"star");
System.out.println("1111"+hotel.toString());
List<Scenic> scenics=scenicService.findByCountryLike(hotel.getAddr());
System.out.println("2222"+scenics.toString());
Collections.sort(scenics, new Comparator<Scenic>() {
@Override
public int compare(Scenic o1, Scenic o2) {
if (o1.getStart()<o2.getStart()){
return 2;
}
if (o1.getStart().equals(o2.getStart()) ){
return 1;
}
return -1;
}
});
if (scenics.size()>=4){
List newList=scenics.subList(0,3);
model.addAttribute("scenics",newList);
}else {
model.addAttribute("scenics",scenics);
}
return "page/hotelDetail::table_refresh";
}
}
源码获取：博客首页 "资源" 里下载！
腾讯云面向开发者汇聚海量精品云计算使用和开发经验，营造开放的云计算技术生态圈。
更多推荐
6
0- 0
已为社区贡献111条内容
所有评论(0)