基于SSM的个人博客网站的设计与实现
- 1 项目介绍
- 2 环境技术
- 3 项目截图
- 4 数据库
- 5 关键代码
- 6 项目源码和论文
本系统是基于SSM的个人网站博客系统,主要包含以下模块:
博客管理、用户管理、撰写博客、分类管理、标签管理、评论管理、随笔管理、个人中心
IDEA、JDK8、Maven3.6、MySQL、Spring、SpringMVC、MyBatis、ruoyi、SpringBoot、Vue、Element、Node.js
3 项目截图
@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 项目源码和论文



