springboot+shiro+mysql博客管理系统(源码+数据库)

拼搏现实的明天。 2024-03-17 22:48 34阅读 0赞

#### springboot+shiro+mysql博客管理系统 ####

*  一、项目简介
 *  二、技术实现
 *  三、系统功能
 *  四、页面功能
 *  五、代码展示
 *  六、数据库
 *  七、源码地址

## 一、项目简介 ##

本项目是一套基于springboot框架实现的博客管理系统  
包含：项目源码、数据库脚本等，该项目附带全部源码可作为毕设使用。  
项目都经过严格调试，eclipse或者idea 确保可以运行！  
该系统功能完善、界面美观、操作简单、功能齐全、管理便捷，具有很高的实际应用价值

## 二、技术实现 ##

框架：ssm框架，springboot  
前后端：springboot，mybatis，maven，jquery，css  
数据库：mysql5.5及以上版本  
开发工具：jdk8，idea或者eclipse，Navicat

## 三、系统功能 ##

系统分为前台和后台  
登录用户，分为两种类型角色：管理员和普通用户  
1、前台功能包括：  
登录  
注册  
编辑资料  
我的主页  
发表文章  
发表评论  
收藏文章  
通知列表  
文章浏览量统计  
热门文章  
分享  
标签  
最新发布文章等功能  
2、后台功能包括  
仪表盘  
栏目管理  
词频管理  
禁用词管理  
文章管理  
评论管理  
用户管理  
角色管理  
主题管理  
系统配置等功能

## 四、页面功能 ##

**前台功能**  
![在这里插入图片描述][a2821594582b48cf8273d9f1bcf5da9e.png]  
![在这里插入图片描述][26af8faa6f83422ab2217e041ca2f510.png]  
![在这里插入图片描述][1b3217fab60f41e991f158ef8b76864e.png]  
![在这里插入图片描述][b1999314252c4b0db80574debca0a895.png]  
![在这里插入图片描述][3df53a3e922243d5859c71a4750ded66.png]  
![在这里插入图片描述][ab1bd426a80e42fa9f5ede80faac2e77.png]  
![在这里插入图片描述][4f0c821eb7c8406380d0c46180afdd48.png]  
![在这里插入图片描述][72823828e0e14c3e93c6f78b1bf12110.png]  
![在这里插入图片描述][0fcecd8acde54c348d4eec91b23254cb.png]

**后台功能**  
![在这里插入图片描述][224c5e933bc7459b99f46beff33bdc41.png]  
![在这里插入图片描述][02b7f67dfaaf4ed1814c840c0b7a7170.png]  
![在这里插入图片描述][97b46f0e9c2540f9b80e26650cf92daf.png]  
![在这里插入图片描述][37e64830c9b045dca9c05c210c51fa8c.png]  
![在这里插入图片描述][cb310732be1541d2a381f2f5175be834.png]  
![在这里插入图片描述][b3bf7d02036a45ca9e8fb61812106531.png]  
![在这里插入图片描述][f96dfb1d893a412094e47098e9c65d29.png]  
![在这里插入图片描述][7e0d3481fc7d445097cf94ae065a9e83.png]  
![在这里插入图片描述][9fb76b008b764b6da8375b45f47f210d.png]  
![在这里插入图片描述][18d4f36541054eae9436fefacf4e0753.png]

## 五、代码展示 ##

package com.mtons.mblog.web.controller.admin;
    
    import com.mtons.mblog.base.lang.Consts;
    import com.mtons.mblog.base.lang.Result;
    import com.mtons.mblog.modules.data.AccountProfile;
    import com.mtons.mblog.modules.data.PostVO;
    import com.mtons.mblog.modules.service.ChannelService;
    import com.mtons.mblog.modules.service.PostService;
    import com.mtons.mblog.web.controller.BaseController;
    import org.apache.commons.lang3.StringUtils;
    import org.springframework.beans.factory.annotation.Autowired;
    import org.springframework.data.domain.Page;
    import org.springframework.data.domain.Pageable;
    import org.springframework.data.domain.Sort;
    import org.springframework.stereotype.Controller;
    import org.springframework.ui.ModelMap;
    import org.springframework.web.bind.ServletRequestUtils;
    import org.springframework.web.bind.annotation.RequestMapping;
    import org.springframework.web.bind.annotation.RequestMethod;
    import org.springframework.web.bind.annotation.RequestParam;
    import org.springframework.web.bind.annotation.ResponseBody;
    
    import javax.servlet.http.HttpServletRequest;
    import java.util.List;
    
    /**
     * @author langhsu
     *
     */
    @Controller("adminPostController")
    @RequestMapping("/admin/post")
    public class PostController extends BaseController {
        
    	@Autowired
    	private PostService postService;
    	@Autowired
    	private ChannelService channelService;
    	
    	@RequestMapping("/list")
    	public String list(String title, ModelMap model, HttpServletRequest request) {
        
    		long id = ServletRequestUtils.getLongParameter(request, "id", Consts.ZERO);
    		int channelId = ServletRequestUtils.getIntParameter(request, "channelId", Consts.ZERO);
    
    		Pageable pageable = wrapPageable(Sort.by(Sort.Direction.DESC, "weight", "created"));
    		Page<PostVO> page = postService.paging4Admin(pageable, channelId, title);
    		model.put("page", page);
    		model.put("title", title);
    		model.put("id", id);
    		model.put("channelId", channelId);
    		model.put("channels", channelService.findAll(Consts.IGNORE));
    		return "/admin/post/list";
    	}
    	
    	/**
    	 * 跳转到文章编辑方法
    	 * @param id
    	 * @param model
    	 * @return
    	 */
    	@RequestMapping(value = "/view", method = RequestMethod.GET)
    	public String toUpdate(Long id, ModelMap model) {
        
    		String editor = siteOptions.getValue("editor");
    		if (null != id && id > 0) {
        
    			PostVO view = postService.get(id);
    			if (StringUtils.isNoneBlank(view.getEditor())) {
        
    				editor = view.getEditor();
    			}
    			model.put("view", view);
    		}
    		model.put("editor", editor);
    		model.put("channels", channelService.findAll(Consts.IGNORE));
    		return "/admin/post/view";
    	}
    	
    	/**
    	 * 更新文章方法
    	 * @author LBB
    	 * @return
    	 */
    	@RequestMapping(value = "/update", method = RequestMethod.POST)
    	public String subUpdate(PostVO post) {
        
    		if (post != null) {
        
    			if (post.getId() > 0) {
        
    				postService.update(post);
    			} else {
        
    				AccountProfile profile = getProfile();
    				post.setAuthorId(profile.getId());
    				postService.post(post);
    			}
    		}
    		return "redirect:/admin/post/list";
    	}
    
    	@RequestMapping("/featured")
    	@ResponseBody
    	public Result featured(Long id, HttpServletRequest request) {
        
    		Result data = Result.failure("操作失败");
    		int featured = ServletRequestUtils.getIntParameter(request, "featured", Consts.FEATURED_ACTIVE);
    		if (id != null) {
        
    			try {
        
    				postService.updateFeatured(id, featured);
    				data = Result.success();
    			} catch (Exception e) {
        
    				data = Result.failure(e.getMessage());
    			}
    		}
    		return data;
    	}
    
    	@RequestMapping("/weight")
    	@ResponseBody
    	public Result weight(Long id, HttpServletRequest request) {
        
    		Result data = Result.failure("操作失败");
    		int weight = ServletRequestUtils.getIntParameter(request, "weight", Consts.FEATURED_ACTIVE);
    		if (id != null) {
        
    			try {
        
    				postService.updateWeight(id, weight);
    				data = Result.success();
    			} catch (Exception e) {
        
    				data = Result.failure(e.getMessage());
    			}
    		}
    		return data;
    	}
    	
    	@RequestMapping("/delete")
    	@ResponseBody
    	public Result delete(@RequestParam("id") List<Long> id) {
        
    		Result data = Result.failure("操作失败");
    		if (id != null) {
        
    			try {
        
    				postService.delete(id);
    				data = Result.success();
    			} catch (Exception e) {
        
    				data = Result.failure(e.getMessage());
    			}
    		}
    		return data;
    	}
    }

package com.mtons.mblog.web.controller.admin;
    
    import com.mtons.mblog.base.lang.Result;
    import com.mtons.mblog.modules.entity.Permission;
    import com.mtons.mblog.modules.entity.Role;
    import com.mtons.mblog.modules.service.PermissionService;
    import com.mtons.mblog.modules.service.RoleService;
    import com.mtons.mblog.web.controller.BaseController;
    import org.springframework.beans.factory.annotation.Autowired;
    import org.springframework.data.domain.Page;
    import org.springframework.data.domain.Pageable;
    import org.springframework.stereotype.Controller;
    import org.springframework.ui.ModelMap;
    import org.springframework.web.bind.annotation.GetMapping;
    import org.springframework.web.bind.annotation.RequestMapping;
    import org.springframework.web.bind.annotation.RequestParam;
    import org.springframework.web.bind.annotation.ResponseBody;
    
    import java.util.HashSet;
    import java.util.List;
    
    /**
     * @author - langhsu on 2018/2/11
     */
    @Controller
    @RequestMapping("/admin/role")
    public class RoleController extends BaseController {
        
    	@Autowired
        private RoleService roleService;
    	@Autowired
    	private PermissionService permissionService;
    
    	@GetMapping("/list")
    	public String paging(String name, ModelMap model) {
        
    		Pageable pageable = wrapPageable();
    		Page<Role> page = roleService.paging(pageable, name);
    		model.put("name", name);
    		model.put("page", page);
    		return "/admin/role/list";
    	}
    
    	@RequestMapping("/view")
    	public String view(Long id, ModelMap model) {
        
    		if (id != null && id > 0) {
        
    			Role role = roleService.get(id);
    			model.put("view", role);
    		}
    
            model.put("permissions", permissionService.tree());
            return "/admin/role/view";
    	}
    	
    	@RequestMapping("/update")
    	public String update(Role role, @RequestParam(value = "perms", required=false) List<Long> perms, ModelMap model) {
        
    		Result data;
    
    		HashSet<Permission> permissions = new HashSet<>();
    		if(perms != null && perms.size() > 0){
        
    
                for(Long pid: perms){
        
                    Permission p = new Permission();
                    p.setId(pid);
    				permissions.add(p);
                }
            }
            
            if (Role.ADMIN_ID == role.getId()) {
        
    			data = Result.failure("管理员角色不可编辑");
            } else {
        
                roleService.update(role, permissions);
                data = Result.success();
            }
            model.put("data", data);
            return "redirect:/admin/role/list";
    	}
    	
    	@RequestMapping("/activate")
    	@ResponseBody
    	public Result activate(Long id, Boolean active) {
        
    		Result ret = Result.failure("操作失败");
    		if (id != null && id != Role.ADMIN_ID) {
        
    			roleService.activate(id, active);
    			ret = Result.success();
    		}
    		return ret;
    	}
    	
    	@RequestMapping("/delete")
    	@ResponseBody
    	public Result delete(@RequestParam("id") Long id) {
        
    		Result ret;
    		if (Role.ADMIN_ID == id) {
        
    			ret = Result.failure("管理员不能操作");
            }else if(roleService.delete(id)){
        
            	ret = Result.success();
            }else{
        
            	ret = Result.failure("该角色不能被操作");
            }
    		return ret;
    	}
    }

/*
    +--------------------------------------------------------------------------
    |   Mblog [#RELEASE_VERSION#]
    |   ========================================
    |   Copyright (c) 2014, 2015 mtons. All Rights Reserved
    |   http://www.mtons.com
    |
    +---------------------------------------------------------------------------
    */
    package com.mtons.mblog.web.controller.admin;
    
    import com.mtons.mblog.base.lang.Result;
    import com.mtons.mblog.base.lang.Consts;
    import com.mtons.mblog.modules.data.UserVO;
    import com.mtons.mblog.modules.entity.Role;
    import com.mtons.mblog.modules.service.RoleService;
    import com.mtons.mblog.modules.service.UserRoleService;
    import com.mtons.mblog.modules.service.UserService;
    import com.mtons.mblog.web.controller.BaseController;
    import org.springframework.beans.factory.annotation.Autowired;
    import org.springframework.data.domain.Page;
    import org.springframework.data.domain.Pageable;
    import org.springframework.stereotype.Controller;
    import org.springframework.ui.ModelMap;
    import org.springframework.web.bind.annotation.*;
    
    import java.util.ArrayList;
    import java.util.List;
    import java.util.Map;
    import java.util.Set;
    
    /**
     * @author langhsu
     *
     */
    @Controller("adminUserController")
    @RequestMapping("/admin/user")
    public class UserController extends BaseController {
        
    	@Autowired
    	private UserService userService;
    
    	@Autowired
    	private RoleService roleService;
    
    	@Autowired
    	private UserRoleService userRoleService;
    
    	@RequestMapping("/list")
    	public String list(String name, ModelMap model) {
        
    		Pageable pageable = wrapPageable();
    		Page<UserVO> page = userService.paging(pageable, name);
    
    		List<UserVO> users = page.getContent();
    		List<Long> userIds = new ArrayList<>();
    
    		users.forEach(item -> {
        
    			userIds.add(item.getId());
    		});
    
    		Map<Long, List<Role>> map = userRoleService.findMapByUserIds(userIds);
    		users.forEach(item -> {
        
    			item.setRoles(map.get(item.getId()));
    		});
    
    		model.put("name", name);
    		model.put("page", page);
    		return "/admin/user/list";
    	}
    
    	@RequestMapping("/view")
    	public String view(Long id, ModelMap model) {
        
    		UserVO view = userService.get(id);
    		view.setRoles(userRoleService.listRoles(view.getId()));
    		model.put("view", view);
    		model.put("roles", roleService.list());
    		return "/admin/user/view";
    	}
    
    	@PostMapping("/update_role")
    //	@RequiresPermissions("user:role")
    	public String postAuthc(Long id, @RequestParam(value = "roleIds", required=false) Set<Long> roleIds, ModelMap model) {
        
    		userRoleService.updateRole(id, roleIds);
    		model.put("data", Result.success());
    		return "redirect:/admin/user/list";
    	}
    
    	@RequestMapping(value = "/pwd", method = RequestMethod.GET)
    //	@RequiresPermissions("user:pwd")
    	public String pwsView(Long id, ModelMap model) {
        
    		UserVO ret = userService.get(id);
    		model.put("view", ret);
    		return "/admin/user/pwd";
    	}
    
    	@RequestMapping(value = "/pwd", method = RequestMethod.POST)
    //	@RequiresPermissions("user:pwd")
    	public String pwd(Long id, String newPassword, ModelMap model) {
        
    		UserVO ret = userService.get(id);
    		model.put("view", ret);
    
    		try {
        
    			userService.updatePassword(id, newPassword);
    			model.put("data", Result.successMessage("修改成功"));
    		} catch (IllegalArgumentException e) {
        
    			model.put("data", Result.failure(e.getMessage()));
    		}
    		return "/admin/user/pwd";
    	}
    
    	@RequestMapping("/open")
    //	@RequiresPermissions("user:open")
    	@ResponseBody
    	public Result open(Long id) {
        
    		userService.updateStatus(id, Consts.STATUS_NORMAL);
    		return Result.success();
    	}
    
    	@RequestMapping("/close")
    //	@RequiresPermissions("user:close")
    	@ResponseBody
    	public Result close(Long id) {
        
    		userService.updateStatus(id, Consts.STATUS_CLOSED);
    		return Result.success();
    	}
    }

package com.mtons.mblog.shiro;
    
    import com.mtons.mblog.base.lang.Consts;
    import com.mtons.mblog.modules.data.AccountProfile;
    import com.mtons.mblog.modules.data.UserVO;
    import com.mtons.mblog.modules.entity.Role;
    import com.mtons.mblog.modules.service.UserRoleService;
    import com.mtons.mblog.modules.service.UserService;
    import org.apache.shiro.SecurityUtils;
    import org.apache.shiro.authc.*;
    import org.apache.shiro.authc.credential.AllowAllCredentialsMatcher;
    import org.apache.shiro.authz.AuthorizationInfo;
    import org.apache.shiro.authz.SimpleAuthorizationInfo;
    import org.apache.shiro.realm.AuthorizingRealm;
    import org.apache.shiro.session.Session;
    import org.apache.shiro.subject.PrincipalCollection;
    import org.springframework.beans.factory.annotation.Autowired;
    
    import java.util.List;
    
    public class AccountRealm extends AuthorizingRealm {
        
        @Autowired
        private UserService userService;
        @Autowired
        private UserRoleService userRoleService;
    
        public AccountRealm() {
        
            super(new AllowAllCredentialsMatcher());
            setAuthenticationTokenClass(UsernamePasswordToken.class);
        }
    
        @Override
        protected AuthorizationInfo doGetAuthorizationInfo(PrincipalCollection principals) {
        
            AccountProfile profile = (AccountProfile) SecurityUtils.getSubject().getPrincipal();
            if (profile != null) {
        
                UserVO user = userService.get(profile.getId());
                if (user != null) {
        
                    SimpleAuthorizationInfo info = new SimpleAuthorizationInfo();
                    List<Role> roles = userRoleService.listRoles(user.getId());
    
                    //赋予角色
                    roles.forEach(role -> {
        
                        info.addRole(role.getName());
    
                        //赋予权限
                        role.getPermissions().forEach(permission -> info.addStringPermission(permission.getName()));
                    });
                    return info;
                }
            }
            return null;
        }
    
        @Override
        protected AuthenticationInfo doGetAuthenticationInfo(AuthenticationToken token) throws AuthenticationException {
        
            UsernamePasswordToken upToken = (UsernamePasswordToken) token;
            AccountProfile profile = getAccount(userService, token);
    
            if (null == profile) {
        
                throw new UnknownAccountException(upToken.getUsername());
            }
    
            if (profile.getStatus() == Consts.STATUS_CLOSED) {
        
                throw new LockedAccountException(profile.getName());
            }
    
            SimpleAuthenticationInfo info = new SimpleAuthenticationInfo(profile, token.getCredentials(), getName());
            Session session = SecurityUtils.getSubject().getSession();
            session.setAttribute("profile", profile);
            return info;
        }
    
        protected AccountProfile getAccount(UserService userService, AuthenticationToken token) {
        
            UsernamePasswordToken upToken = (UsernamePasswordToken) token;
            return userService.login(upToken.getUsername(), String.valueOf(upToken.getPassword()));
        }
    }

## 六、数据库 ##

**一共22张表**  
![在这里插入图片描述][57eaf46118754df5982c732a95eacdd2.png]  
![在这里插入图片描述][05b698f8f32e4798a5cc50dbb36e65b7.png]

## 七、源码地址 ##

[https://download.csdn.net/download/weixin\_43860634/88066645][https_download.csdn.net_download_weixin_43860634_88066645]

[a2821594582b48cf8273d9f1bcf5da9e.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/14/0b0dc9e315704ddeb4dee6fb8817934b.png
[26af8faa6f83422ab2217e041ca2f510.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/14/bf3299a501ef4b869dc81fb740bae90f.png
[1b3217fab60f41e991f158ef8b76864e.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/14/39daf30fada04b738dceba2036bf8aaa.png
[b1999314252c4b0db80574debca0a895.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/14/628a384fa7cd46299799064529210048.png
[3df53a3e922243d5859c71a4750ded66.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/14/33027141480243c18c356e49cade20c8.png
[ab1bd426a80e42fa9f5ede80faac2e77.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/14/f611209b43e647318720c9ceb100ff73.png
[4f0c821eb7c8406380d0c46180afdd48.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/14/086d513166304b0aa052bc638fd17e12.png
[72823828e0e14c3e93c6f78b1bf12110.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/14/1a25f609b2cd4a88bc065913af74e5df.png
[0fcecd8acde54c348d4eec91b23254cb.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/14/1ff3cea6622746c192d70eb1f9b53ff9.png
[224c5e933bc7459b99f46beff33bdc41.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/14/3308e3de915c4cbcba26eff5fad550fb.png
[02b7f67dfaaf4ed1814c840c0b7a7170.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/14/5e4f51ef0a0b4f7589f3dc103039bce7.png
[97b46f0e9c2540f9b80e26650cf92daf.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/14/9ebf5370da094c5f8b59e0a7d360dfb6.png
[37e64830c9b045dca9c05c210c51fa8c.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/14/52e9cb4840ca443081514a95a24af965.png
[cb310732be1541d2a381f2f5175be834.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/14/d4025dca71d0401d875a91ff1692aa22.png
[b3bf7d02036a45ca9e8fb61812106531.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/14/81911dcfa44a44e0998265e08b3ee97d.png
[f96dfb1d893a412094e47098e9c65d29.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/14/5164598b54b943ae9fc442c6810d1f69.png
[7e0d3481fc7d445097cf94ae065a9e83.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/14/b114af13dad44fb3825df563ebc98bb2.png
[9fb76b008b764b6da8375b45f47f210d.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/14/5ea77c207e2e42fdb80d0aedefa43921.png
[18d4f36541054eae9436fefacf4e0753.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/14/8e28e8c9b2224a05a3d5e28507faf9ec.png
[57eaf46118754df5982c732a95eacdd2.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/14/bd5b500989254d5084f7a5dd43260476.png
[05b698f8f32e4798a5cc50dbb36e65b7.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/14/b2fcd83eae234cbfbab1082970eae828.png
[https_download.csdn.net_download_weixin_43860634_88066645]: https://download.csdn.net/download/weixin_43860634/88066645