基于javaweb的SpringBoot旅游推荐系统旅游信息管理系统(java+springboot+maven+vue+elementui+mysql)

运行环境

Java≥8、MySQL≥5.7、Node.js≥14

开发工具

后端：eclipse/idea/myeclipse/sts等均可配置运行
前端：WebStorm/VSCode/HBuilderX等均可

❗没学过node.js的不要搞前后端分离项目

适用

课程设计，大作业，毕业设计，项目练习，学习演示等

功能说明

基于javaweb的SpringBoot旅游推荐系统旅游信息管理系统(java+springboot+maven+vue+elementui+mysql)

/TravelSystem

管理员：
admin 123456

用户：
a1 123456
a2 123456
a3 123456

后端启动类：StartApplication
前端启动命令：npm run serve

/**
* 前端列表
*/
@IgnoreAuth
@RequestMapping("/list")
public R list(@RequestParam Map<String, Object> params, HttpServletRequest request){
    logger.debug("list方法:,,Controller:{},,params:{}",this.getClass().getName(),JSONObject.toJSONString(params));

    // 没有指定排序字段就默认id倒序
    if(StringUtil.isEmpty(String.valueOf(params.get("orderBy")))){
        params.put("orderBy","id");
    }
    PageUtils page = forumService.queryPage(params);

    //字典表数据转换
    List<ForumView> list =(List<ForumView>)page.getList();
    for(ForumView c:list)
        dictionaryService.dictionaryConvert(c, request); //修改对应字典表字段
    return R.ok().put("data", page);
}

/**
* 前端详情
*/
@RequestMapping("/detail/{id}")
public R detail(@PathVariable("id") Long id, HttpServletRequest request){
    logger.debug("detail方法:,,Controller:{},,id:{}",this.getClass().getName(),id);
    ForumEntity forum = forumService.selectById(id);
        if(forum !=null){


            //entity转view
            ForumView view = new ForumView();
            BeanUtils.copyProperties( forum , view );//把实体数据重构到view中

            //级联表
                YonghuEntity yonghu = yonghuService.selectById(forum.getYonghuId());
            if(yonghu != null){
                BeanUtils.copyProperties( yonghu , view ,new String[]{ "id", "createDate"});//把级联的数据添加到view中,并排除id和创建时间字段
                view.setYonghuId(yonghu.getId());
            }
                UsersEntity users = usersService.selectById(forum.getUsersId());
            if(users != null){
                view.setUsersId(users.getId());
                view.setUusername(users.getUsername());
                view.setUpassword(users.getPassword());
                view.setUrole(users.getRole());
                view.setUaddtime(users.getAddtime());
            }
            //修改对应字典表字段

@Autowired
private TokenService tokenService;
@Autowired
private DictionaryService dictionaryService;

//级联表service



/**
* 后端列表
*/
@RequestMapping("/page")
public R page(@RequestParam Map<String, Object> params, HttpServletRequest request){
    logger.debug("page方法:,,Controller:{},,params:{}",this.getClass().getName(),JSONObject.toJSONString(params));
    String role = String.valueOf(request.getSession().getAttribute("role"));
    if(false)
        return R.error(511,"永不会进入");
    else if("用户".equals(role))
        params.put("yonghuId",request.getSession().getAttribute("userId"));
    params.put("yonghuDeleteStart",1);params.put("yonghuDeleteEnd",1);
    if(params.get("orderBy")==null || params.get("orderBy")==""){
        params.put("orderBy","id");
    }
    PageUtils page = yonghuService.queryPage(params);

    //字典表数据转换
    List<YonghuView> list =(List<YonghuView>)page.getList();
    for(YonghuView c:list){
        //修改对应字典表字段
        dictionaryService.dictionaryConvert(c, request);
    }
    return R.ok().put("data", page);
}

/**
* 后端详情
*/
@RequestMapping("/info/{id}")
public R info(@PathVariable("id") Long id, HttpServletRequest request){
    logger.debug("info方法:,,Controller:{},,id:{}",this.getClass().getName(),id);
    YonghuEntity yonghu = yonghuService.selectById(id);
    if(yonghu !=null){
        //entity转view
        YonghuView view = new YonghuView();
        BeanUtils.copyProperties( yonghu , view );//把实体数据重构到view中

        //修改对应字典表字段
        dictionaryService.dictionaryConvert(view, request);

     * 批量上传
     */
    @RequestMapping("/batchInsert")
    public R save( String fileName){
        logger.debug("batchInsert方法:,,Controller:{},,fileName:{}",this.getClass().getName(),fileName);
        try {
            List<NewsEntity> newsList = new ArrayList<>();//上传的东西
            Map<String, List<String>> seachFields= new HashMap<>();//要查询的字段
            Date date = new Date();
            int lastIndexOf = fileName.lastIndexOf(".");
            if(lastIndexOf == -1){
                return R.error(511,"该文件没有后缀");
            }else{
                String suffix = fileName.substring(lastIndexOf);
                if(!".xls".equals(suffix)){
                    return R.error(511,"只支持后缀为xls的excel文件");
                }else{
                    URL resource = this.getClass().getClassLoader().getResource("static/upload/" + fileName);//获取文件路径
                    File file = new File(resource.getFile());
                    if(!file.exists()){
                        return R.error(511,"找不到上传文件，请联系管理员");
                    }else{
                        List<List<String>> dataList = PoiUtil.poiImport(file.getPath());//读取xls文件
                        dataList.remove(0);//删除第一行，因为第一行是提示
                        for(List<String> data:dataList){
                            //循环
                            NewsEntity newsEntity = new NewsEntity();
//                            newsEntity.setNewsName(data.get(0));                    //公告标题 要改的
//                            newsEntity.setNewsTypes(Integer.valueOf(data.get(0)));   //公告类型 要改的
//                            newsEntity.setNewsPhoto("");//照片
//                            newsEntity.setInsertTime(date);//时间
//                            newsEntity.setNewsContent("");//照片
//                            newsEntity.setCreateTime(date);//时间
                            newsList.add(newsEntity);


                            //把要查询是否重复的字段放入map中
                        }

                        //查询是否重复
                        newsService.insertBatch(newsList);
                        return R.ok();
                    }
                }
            }
        }catch (Exception e){
            return R.error(511,"批量插入数据异常，请联系管理员");
        }
    }

 * 后端接口
 * @email
*/
@RestController
@Controller
@RequestMapping("/lvyouluxianLiuyan")
public class LvyouluxianLiuyanController {
    private static final Logger logger = LoggerFactory.getLogger(LvyouluxianLiuyanController.class);

    @Autowired
    private LvyouluxianLiuyanService lvyouluxianLiuyanService;


    @Autowired
    private TokenService tokenService;
    @Autowired
    private DictionaryService dictionaryService;

    //级联表service
    @Autowired
    private LvyouluxianService lvyouluxianService;
    @Autowired
    private YonghuService yonghuService;



    /**
    * 后端列表
    */
    @RequestMapping("/page")
    public R page(@RequestParam Map<String, Object> params, HttpServletRequest request){
        logger.debug("page方法:,,Controller:{},,params:{}",this.getClass().getName(),JSONObject.toJSONString(params));
        String role = String.valueOf(request.getSession().getAttribute("role"));
        if(false)
            return R.error(511,"永不会进入");
        else if("用户".equals(role))
            params.put("yonghuId",request.getSession().getAttribute("userId"));
        if(params.get("orderBy")==null || params.get("orderBy")==""){
            params.put("orderBy","id");
        }
        PageUtils page = lvyouluxianLiuyanService.queryPage(params);

        //字典表数据转换
        List<LvyouluxianLiuyanView> list =(List<LvyouluxianLiuyanView>)page.getList();
        for(LvyouluxianLiuyanView c:list){
            //修改对应字典表字段
            dictionaryService.dictionaryConvert(c, request);
        }
        return R.ok().put("data", page);
    }

    logger.info("sql语句:"+queryWrapper.getSqlSegment());
    LvyouluxianEntity lvyouluxianEntity = lvyouluxianService.selectOne(queryWrapper);
    if("".equals(lvyouluxian.getLvyouluxianPhoto()) || "null".equals(lvyouluxian.getLvyouluxianPhoto())){
            lvyouluxian.setLvyouluxianPhoto(null);
    }
    if(lvyouluxianEntity==null){
        lvyouluxianService.updateById(lvyouluxian);//根据id更新
        return R.ok();
    }else {
        return R.error(511,"表中有相同数据");
    }
}

/**
* 删除
*/
@RequestMapping("/delete")
public R delete(@RequestBody Integer[] ids){
    logger.debug("delete:,,Controller:{},,ids:{}",this.getClass().getName(),ids.toString());
    lvyouluxianService.deleteBatchIds(Arrays.asList(ids));
    return R.ok();
}


/**
 * 批量上传
 */
@RequestMapping("/batchInsert")
public R save( String fileName){
    logger.debug("batchInsert方法:,,Controller:{},,fileName:{}",this.getClass().getName(),fileName);
    try {
        List<LvyouluxianEntity> lvyouluxianList = new ArrayList<>();//上传的东西
        Map<String, List<String>> seachFields= new HashMap<>();//要查询的字段
        Date date = new Date();
        int lastIndexOf = fileName.lastIndexOf(".");
        if(lastIndexOf == -1){
            return R.error(511,"该文件没有后缀");
        }else{
            String suffix = fileName.substring(lastIndexOf);
            if(!".xls".equals(suffix)){
                return R.error(511,"只支持后缀为xls的excel文件");
            }else{
                URL resource = this.getClass().getClassLoader().getResource("static/upload/" + fileName);//获取文件路径
                File file = new File(resource.getFile());
                if(!file.exists()){
                    return R.error(511,"找不到上传文件，请联系管理员");
                }else{
                    List<List<String>> dataList = PoiUtil.poiImport(file.getPath());//读取xls文件
                    dataList.remove(0);//删除第一行，因为第一行是提示

---

项目链接：
https://javayms.github.io?id=330925580706201qc
https://javayms.pages.dev?id=330925580706201qc