栏目分类:
子分类:
返回
名师互学网用户登录
快速导航关闭
当前搜索
当前分类
子分类
实用工具
热门搜索
名师互学网 > IT > 软件开发 > 后端开发 > Java

Java毕设

Java 更新时间: 发布时间: IT归档 最新发布 模块sitemap 名妆网 法律咨询 聚返吧 英语巴士网 伯小乐 网商动力

Java毕设

基于SSM的个人博客网站的设计与实现

文章目录
  • 1 项目介绍
  • 2 环境技术
  • 3 项目截图
  • 4 数据库
  • 5 关键代码
  • 6 项目源码和论文

1 项目介绍

本系统是基于SSM的个人网站博客系统,主要包含以下模块:
博客管理、用户管理、撰写博客、分类管理、标签管理、评论管理、随笔管理、个人中心

2 环境技术

IDEA、JDK8、Maven3.6、MySQL、Spring、SpringMVC、MyBatis、ruoyi、SpringBoot、Vue、Element、Node.js

3 项目截图








4 数据库

5 关键代码
@Service
@PropertySource("classpath:/image.properties")
public class BlogServiceImpl implements BlogService {

    @Value("${image.preUrl}")
    private String preUrl;      // = "http://image.jt.com";

    @Autowired
    private BlogMapper blogMapper;
    @Autowired
    private UserMapper userMapper;
    @Autowired
    private TypeMapper typeMapper;
    @Autowired
    private TagMapper tagMapper;
    @Autowired
    private CommentMapper commentMapper;
    @Autowired
    private BlogTagMapper blogTagMapper;


    @Override
    public PageResult getBlogs(PageResult pageResult) {

        //1.定义分页对象
        IPage page = new Page<>(pageResult.getPageNum(),pageResult.getPageSize());
        //2.定义条件构造器 指定动态查询Sql
        boolean flag = StringUtils.hasLength(pageResult.getQuery());
        QueryWrapper queryWrapper = new QueryWrapper<>();
        queryWrapper.like(flag, "title",pageResult.getQuery());

        //3.进行分页查询
        page = blogMapper.selectPage(page,queryWrapper);

        HashSet set = new HashSet<>();
        for (Blog record : page.getRecords()) {
            set.add(record.getUserId());
        }
        QueryWrapper queryWrapperUser = new QueryWrapper<>();
        queryWrapperUser.in("id",set);
        List users = userMapper.selectList(queryWrapperUser);
        List all = typeMapper.getAll();

        for (User user : users) {
            user.setAvatar(preUrl + user.getAvatar());
        }

        for (Blog record : page.getRecords()) {
            for (User user : users) {
                if (user.getId().equals(record.getUserId())) {
                    record.setUser(user);
                    record.setAvatar(user.getAvatar());
                }
            }
            for (Type type : all) {
                if (record.getTypeId().equals(type.getId())) {
                    record.setType(type);
                }
            }
            record.setFirstPicture(preUrl+record.getFirstPicture());
        }
        //4.从封装后的分页对象中获取数据
        pageResult.setTotal(page.getTotal())
                .setRows(page.getRecords());
        return pageResult;
    }

    @Override
    public List getNewBlog() {
        //1.定义分页对象
        PageResult pageResult = new PageResult();
        pageResult.setPageNum(1).setPageSize(5);
        IPage page = new Page<>(pageResult.getPageNum(),pageResult.getPageSize());
        //2.定义条件构造器 指定动态查询Sql
        boolean flag = StringUtils.hasLength(pageResult.getQuery());
        QueryWrapper queryWrapper = new QueryWrapper<>();
        queryWrapper.orderByDesc(true,"create_time");
        pageResult.setTotal(page.getTotal())
                .setRows(page.getRecords());
        //3.进行分页查询
        page = blogMapper.selectPage(page,queryWrapper);
        return page.getRecords();
    }

    @Override
    public PageResult getBlogBytypeId(Long typeId) {

        //1.定义分页对象
        PageResult pageResult = new PageResult();
        pageResult.setPageNum(1).setPageSize(999);
        IPage page = new Page<>(pageResult.getPageNum(),pageResult.getPageSize());

        QueryWrapper queryWrapper = new QueryWrapper<>();
        queryWrapper.eq("type_id",typeId);
        queryWrapper.orderByDesc(true,"create_time");
        page = blogMapper.selectPage(page,queryWrapper);
        List blogs = page.getRecords();
        HashSet set = new HashSet<>();
        for (Blog record : blogs) {
            set.add(record.getUserId());
        }
        if (set != null && set.size() > 0){
        QueryWrapper queryWrapperUser = new QueryWrapper<>();
            queryWrapperUser.in("id",set);
            List users = userMapper.selectList(queryWrapperUser);
            List all = typeMapper.getAll();
            for (Blog record : blogs) {
                for (User user : users) {
                    if (user.getId().equals(record.getUserId())) {
                        record.setUser(user);
                        record.setAvatar(user.getAvatar());
                    }
                }
                for (Type type : all) {
                    if (record.getTypeId().equals(type.getId())) {
                        record.setType(type);
                    }
                }
                record.setFirstPicture(preUrl + record.getFirstPicture());
            }
        }
        pageResult.setTotal(page.getTotal())
                .setRows(blogs);
        return pageResult;
    }

    @Override
    public PageResult getBlogBytag(Long tagId) {

//        QueryWrapper queryWrapperUserTag = new QueryWrapper<>();
//        queryWrapperUserTag.eq("tag_id",tagId);
//        List tags = tagMapper.selectList(queryWrapperUserTag);
//        Set BlogsIds = new HashSet<>();
//        for (Tag tag : tags) {
//            BlogsIds        }

        //1.定义分页对象
        PageResult pageResult = new PageResult();
        pageResult.setPageNum(1).setPageSize(999);
        IPage page = new Page<>(pageResult.getPageNum(),pageResult.getPageSize());
        QueryWrapper blogTagQueryWrapper = new QueryWrapper<>();
        blogTagQueryWrapper.eq("tags_id",tagId)
                .or()
                .like("tags_id","%,"+tagId)
                .or()
                .like("tags_id",tagId+",%")
                .or()
                .like("tags_id","%,"+tagId+",%");
        List tagsId = blogTagMapper.selectList(blogTagQueryWrapper);
        Set blogIds = new HashSet<>();
        List blogs = new ArrayList<>();
        for (BlogTag blogTag : tagsId) {
            blogIds.add(blogTag.getBlogId());
        }
        if (blogIds != null && blogIds.size() > 0) {
            QueryWrapper queryWrapper = new QueryWrapper<>();
            queryWrapper.in("id",blogIds);
            queryWrapper.orderByDesc(true,"create_time");
            page = blogMapper.selectPage(page,queryWrapper);
            blogs = page.getRecords();

            HashSet set = new HashSet<>();
            for (Blog record : blogs) {
                set.add(record.getUserId());
            }
            if (set != null && set.size() > 0) {
                QueryWrapper queryWrapperUser = new QueryWrapper<>();
                queryWrapperUser.in("id", set);
                List users = userMapper.selectList(queryWrapperUser);
                List all = typeMapper.getAll();
                for (Blog record : blogs) {
                    for (User user : users) {
                        if (user.getId().equals(record.getUserId())) {
                            record.setUser(user);
                            record.setAvatar(user.getAvatar());
                        }
                    }
                    for (Type type : all) {
                        if (record.getTypeId().equals(type.getId())) {
                            record.setType(type);
                        }
                    }
                    record.setFirstPicture(preUrl + record.getFirstPicture());
                }
            }
        }
        pageResult.setTotal(page.getTotal())
                .setRows(blogs);

        return pageResult;
    }

    @Override
    public Blog getBlogById(Long blogId) {
        Blog blog = blogMapper.selectById(blogId);
        User user = userMapper.selectById(blog.getUserId());
        Type type = typeMapper.selectById(blog.getTypeId());
        QueryWrapper queryWrapperComment = new QueryWrapper<>();
        queryWrapperComment.eq("blog_id",blogId);
        List comments = commentMapper.selectList(queryWrapperComment);
        for (Comment comment : comments) {
            for (Comment comment1 : comments) {
                if (comment.getParentCommentId().equals(comment1.getId())) {
                    comment.setParentComment(comment1);
                }
            }
        }
        blog.setFirstPicture(preUrl + blog.getFirstPicture());
        blog.setUser(user);
        blog.setType(type);
        blog.setComments(comments);
        return blog;
    }

    @Override
    public void insertBlog(Blog blog) {
        if (blog.getType() != null) {
            blog.setTypeId(blog.getType().getId());
        }
        if (blog.getType() != null) {
            blog.setUserId(blog.getUser().getId());
        }
        blogMapper.insert(blog);

        blogTagMapper.insert(new BlogTag(blog.getId(),blog.getTagIds()));

    }

    @Override
    public PageResult getBlogList(PageResult pageResult, String typeId,String userId) {
        //1.定义分页对象
        IPage page = new Page<>(pageResult.getPageNum(),pageResult.getPageSize());
        //2.定义条件构造器 指定动态查询Sql
        boolean flag = StringUtils.hasLength(pageResult.getQuery());
        QueryWrapper queryWrapper = new QueryWrapper<>();
        queryWrapper.like(flag, "title",pageResult.getQuery());
        if (typeId!=null) {
            queryWrapper.eq("type_id", typeId);
        }
        if (userId !=null) {
            User user1 = userMapper.selectById(userId);
            if ("0".equals(user1.getType())) {
                queryWrapper.eq("user_id", userId);
            }
        }
        queryWrapper.orderByDesc("create_time");
        //3.进行分页查询
        page = blogMapper.selectPage(page,queryWrapper);

        HashSet set = new HashSet<>();
        for (Blog record : page.getRecords()) {
            set.add(record.getUserId());
        }
        List users = new ArrayList<>();
        List all = new ArrayList<>();
        if(set != null && set.size() > 0) {
            QueryWrapper queryWrapperUser = new QueryWrapper<>();
            queryWrapperUser.in("id", set);
            users.addAll(userMapper.selectList(queryWrapperUser));
            all.addAll(typeMapper.getAll());
        }
        for (Blog record : page.getRecords()) {
            for (User user : users) {
                if (user.getId().toString().equals(record.getUserId().toString())) {
                    record.setUser(user);
                    record.setAvatar(user.getAvatar());
                }
            }
            for (Type type : all) {
                if (record.getTypeId().equals(type.getId())) {
                    record.setType(type);
                }
            }
            BlogTag blogTag = blogTagMapper.selectById(record.getId());
            record.setFirstPicture(preUrl+record.getFirstPicture());
            if (blogTag == null){
                continue;
            }
            List blogTags = Arrays.asList(blogTag.getTagsId().split(","));
            ArrayList tagIds = new ArrayList<>();
            List tags = null;
            if(tagIds != null && blogTags.size() > 0) {
                QueryWrapper tagQueryWrapper = new QueryWrapper<>();
                tagQueryWrapper.in("id",blogTags);
                tags = tagMapper.selectList(tagQueryWrapper);
                tags.stream().filter(t -> tagIds.contains(t.getId().toString())).collect(Collectors.toList());
            }
            record.setTags(tags);

        }
        //4.从封装后的分页对象中获取数据
        pageResult.setTotal(page.getTotal())
                .setRows(page.getRecords());
        return pageResult;
    }

    @Override
    public void updateBlog(Blog blog) {
        if (blog.getType() != null) {
            blog.setTypeId(blog.getType().getId());
        }
        if (blog.getType() != null) {
            blog.setUserId(blog.getUser().getId());
        }
        if (blog.getTagIds() != null) {
            int i = blogTagMapper.updateById(new BlogTag(blog.getId(), blog.getTagIds()));
            if (i == 0) {
                blogTagMapper.insert(new BlogTag(blog.getId(), blog.getTagIds()));
            }
        }
        blogMapper.updateById(blog);

    }

    @Override
    public void deletBlogById(Long id) {
        blogMapper.deleteById(id);
    }
}
6 项目源码和论文



转载请注明:文章转载自 www.mshxw.com
本文地址:https://www.mshxw.com/it/980890.html
我们一直用心在做
关于我们 文章归档 网站地图 联系我们

版权所有 (c)2021-2022 MSHXW.COM

ICP备案号:晋ICP备2021003244-6号