基于javaweb+mysql的ssm新闻发布管理系统(java+ssm+jsp+bootstrap+jquery+mysql)
私信源码获取及调试交流
运行环境
Java≥8、MySQL≥5.7、Tomcat≥8
开发工具
eclipse/idea/myeclipse/sts等均可配置运行
适用
课程设计,大作业,毕业设计,项目练习,学习演示等
功能说明
基于javaweb+mysql的SSM新闻发布管理系统(java+ssm+jsp+bootstrap+jquery+mysql)
项目介绍
本项目分为前后台,分为管理员与普通用户角色,前台为普通用户登录,后台为管理员登录;
用户角色包含以下功能: 新闻搜索,查看新闻,用户首页,评论新闻等功能。
管理员角色包含以下功能: 分类管理,新闻管理,管理员登录,评论管理等功能。
环境需要
1.运行环境:最好是java jdk 1.8,我们在这个平台上运行的。其他版本理论上也可以。 2.IDE环境:IDEA,Eclipse,Myeclipse都可以。推荐IDEA; 3.tomcat环境:Tomcat 7.x,8.x,9.x版本均可 4.硬件环境:windows 7/8/10 1G内存以上;或者 Mac OS; 5.数据库:MySql 5.7版本; 6.是否Maven项目:否;
技术栈
- 后端:Spring+SpringMVC+Mybatis 2. 前端:JSP+CSS+JavaScript+jquery+bootstrap
使用说明
- 使用Navicat或者其它工具,在mysql中创建对应名称的数据库,并导入项目的sql文件; 2. 使用IDEA/Eclipse/MyEclipse导入项目,Eclipse/MyEclipse导入时,若为maven项目请选择maven; 若为maven项目,导入成功后请执行maven clean;maven install命令,然后运行; 3. 将项目中config/db.properties配置文件中的数据库配置改为自己的配置; 4. 运行项目,输入http://localhost:8080/News 登录
@Autowired
private NewsService newsService;
@Autowired
private CommentService commentService;
/**
* 新闻评论列表页面
*
* @param model
* @return
*/
@RequestMapping(value = "/list", method = RequestMethod.GET)
public ModelAndView list(ModelAndView model) {
Map<String, Object> queryMap = new HashMap<String, Object>();
queryMap.put("offset", 0);
queryMap.put("pageSize", 999);
model.addObject("newsList", newsService.findList(queryMap));
model.setViewName("comment/list");
return model;
}
/**
* 新闻评论添加
*
* @param newsCategory
* @return
*/
@RequestMapping(value = "/add", method = RequestMethod.POST)
@ResponseBody
public Map<String, String> add(Comment comment) {
// 去除敏感信息
CommentController.minganInfo(comment);
Map<String, String> ret = new HashMap<String, String>();
if (comment == null) {
ret.put("type", "error");
ret.put("msg", "请填写正确的评论信息!");
return ret;
}
if (comment.getNewsId() == null) {
@Autowired
private LogService logService;
/**
* 系统首页
* @param model
* @return
*/
@RequestMapping(value="/index",method=RequestMethod.GET)
public ModelAndView index(ModelAndView model){
Map<String, Object> queryMap = new HashMap<String, Object>();
queryMap.put("offset", 0);
queryMap.put("pageSize", 10);
model.addObject("newsCategoryList", newsCategoryService.findAll());
model.addObject("newsList", newsService.findList(queryMap));
model.setViewName("home/index/index");
return model;
}
/**
* 获取网站基本信息
* @return
*/
@RequestMapping(value="/get_site_info",method=RequestMethod.POST)
@ResponseBody
public Map<String, Object> getSiteInfo(){
Map<String, Object> retMap = new HashMap<String, Object>();
retMap.put("type", "success");
Map<String, Object> queryMap = new HashMap<String, Object>();
queryMap.put("offset", 0);
queryMap.put("pageSize", 99999);
retMap.put("totalArticle", newsService.getTotal(queryMap));
return retMap;
}
private long getDays(String data){
SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd");
Date startDate = null;
try {
startDate = sdf.parse(data);
} catch (ParseException e) {
// TODO Auto-generated catch block
/**
* 新闻评论控制器
*
*
*/
@RequestMapping("/admin/comment")
@Controller
public class CommentController {
@Autowired
private NewsService newsService;
@Autowired
private CommentService commentService;
/**
* 新闻评论列表页面
*
* @param model
* @return
*/
@RequestMapping(value = "/list", method = RequestMethod.GET)
public ModelAndView list(ModelAndView model) {
Map<String, Object> queryMap = new HashMap<String, Object>();
queryMap.put("offset", 0);
queryMap.put("pageSize", 999);
model.addObject("newsList", newsService.findList(queryMap));
model.setViewName("comment/list");
return model;
}
/**
* 新闻评论添加
*
* @param newsCategory
* @return
*/
@RequestMapping(value = "/add", method = RequestMethod.POST)
@ResponseBody
public Map<String, String> add(Comment comment) {
// 去除敏感信息
CommentController.minganInfo(comment);
Map<String, String> ret = new HashMap<String, String>();
if (comment == null) {
ret.put("type", "error");
ret.put("msg", "请填写正确的评论信息!");
return ret;
}
ret.put("msg", "请填写正确的用户信息!");
return ret;
}
if(StringUtils.isEmpty(user.getUsername())){
ret.put("type", "error");
ret.put("msg", "请填写用户名!");
return ret;
}
if(StringUtils.isEmpty(user.getPassword())){
ret.put("type", "error");
ret.put("msg", "请填写密码!");
return ret;
}
if(user.getRoleId() == null){
ret.put("type", "error");
ret.put("msg", "请选择所属角色!");
return ret;
}
if(isExist(user.getUsername(), 0l)){
ret.put("type", "error");
ret.put("msg", "该用户名已经存在,请重新输入!");
return ret;
}
if(userService.add(user) <= 0){
ret.put("type", "error");
ret.put("msg", "用户添加失败,请联系管理员!");
return ret;
}
ret.put("type", "success");
ret.put("msg", "角色添加成功!");
return ret;
}
/**
* 编辑用户
* @param user
* @return
*/
@RequestMapping(value="/edit",method=RequestMethod.POST)
@ResponseBody
public Map<String, String> edit(User user){
Map<String, String> ret = new HashMap<String, String>();
if(user == null){
/**
* 前台新闻控制器
*
*/
@RequestMapping("/news")
@Controller
public class HomeNewsController {
@Autowired
private NewsCategoryService newsCategoryService;
@Autowired
private NewsService newsService;
@Autowired
private CommentService commentService;
/**
* 查看新闻详情
* @param model
* @param id
* @return
*/
@RequestMapping(value="/detail",method=RequestMethod.GET)
public ModelAndView detail(ModelAndView model,Long id){
model.addObject("newsCategoryList", newsCategoryService.findAll());
News news = newsService.find(id);
model.addObject("news", news);
model.addObject("title", news.getTitle());
model.addObject("tags", news.getTags().split(","));
model.setViewName("home/news/detail");
//查看数加1
newsService.updateViewNumber(id);
// 去除敏感信息
NewsController.minganInfo(news);
ret.put("type", "success");
ret.put("msg", "修改成功!");
return ret;
}
/**
* 删除新闻
*
* @param id
* @return
*/
@RequestMapping(value = "/delete", method = RequestMethod.POST)
@ResponseBody
public Map<String, String> delete(Long id) {
Map<String, String> ret = new HashMap<String, String>();
if (id == null) {
ret.put("type", "error");
ret.put("msg", "请选择要删除的信息!");
return ret;
}
try {
if (newsService.delete(id) <= 0) {
ret.put("type", "error");
ret.put("msg", "删除失败,请联系管理员!");
return ret;
}
} catch (Exception e) {
ret.put("type", "error");
ret.put("msg", "该新闻下有评论信息,不可删除!");
return ret;
}
ret.put("type", "success");
ret.put("msg", "删除成功!");
return ret;
}
/**
* 分页模糊搜索查询列表
*
* @param name
* @param page
* @return
*/
@RequestMapping(value = "/list", method = RequestMethod.POST)
public ModelAndView list(ModelAndView model){
model.setViewName("/role/list");
return model;
}
/**
* 获取角色列表
* @param page
* @param name
* @return
*/
@RequestMapping(value="/list",method=RequestMethod.POST)
@ResponseBody
public Map<String, Object> getList(Page page,
@RequestParam(name="name",required=false,defaultValue="") String name
){
Map<String, Object> ret = new HashMap<String, Object>();
Map<String, Object> queryMap = new HashMap<String, Object>();
queryMap.put("name", name);
queryMap.put("offset", page.getOffset());
queryMap.put("pageSize", page.getRows());
ret.put("rows", roleService.findList(queryMap));
ret.put("total", roleService.getTotal(queryMap));
return ret;
}
/**
* 角色添加
* @param role
* @return
*/
@RequestMapping(value="/add",method=RequestMethod.POST)
@ResponseBody
public Map<String, String> add(Role role){
Map<String, String> ret = new HashMap<String, String>();
if(role == null){
ret.put("type", "error");
ret.put("msg", "请填写正确的角色信息!");
return ret;
}
if(StringUtils.isEmpty(role.getName())){
ret.put("type", "error");
ret.put("msg", "请填写角色名称!");
return ret;
}
if(roleService.add(role) <= 0){
@RequestParam(name="keyword",required=false,defaultValue="") String keyword,
Page page
) throws UnsupportedEncodingException{
Map<String, Object> queryMap = new HashMap<String, Object>();
queryMap.put("offset", 0);
queryMap.put("pageSize", 10);
queryMap.put("title", new String(keyword.getBytes("UTF-8"),"UTF-8"));
model.addObject("newsCategoryList", newsCategoryService.findAll());
model.addObject("newsList", newsService.findList(queryMap));
model.addObject("title", new String(keyword.getBytes("UTF-8"),"UTF-8") + "关键字下的新闻信息");
model.addObject("keyword", new String(keyword.getBytes("UTF-8"),"UTF-8"));
model.setViewName("home/news/search_list");
return model;
}
/**
* 分页加载搜索列表
* @param page
* @param keyword
* @return
* @throws UnsupportedEncodingException
*/
@RequestMapping(value="/get_search_list",method=RequestMethod.POST)
@ResponseBody
public Map<String, Object> getSearchList(Page page,
@RequestParam(name="keyword",required=false,defaultValue="") String keyword
) throws UnsupportedEncodingException{
Map<String, Object> ret = new HashMap<String, Object>();
Map<String, Object> queryMap = new HashMap<String, Object>();
queryMap.put("offset", page.getOffset());
queryMap.put("pageSize", page.getRows());
queryMap.put("title", new String(keyword.getBytes("UTF-8"),"UTF-8"));
ret.put("type", "success");
ret.put("newsList", newsService.findList(queryMap));
return ret;
}
/**
* 添加评论
* @param comment
* @return
*/
@RequestMapping(value="/comment_news",method=RequestMethod.POST)
@ResponseBody
public Map<String, Object> commentNews(Comment comment){
Map<String, Object> ret = new HashMap<String, Object>();
if(comment == null){
ret.put("type", "error");
ret.put("msg", "请填写完整的评论信息!");
return ret;
}
){
Map<String, Object> ret = new HashMap<String, Object>();
Map<String, Object> queryMap = new HashMap<String, Object>();
queryMap.put("username", username);
queryMap.put("roleId", roleId);
queryMap.put("sex", sex);
queryMap.put("offset", page.getOffset());
queryMap.put("pageSize", page.getRows());
ret.put("rows", userService.findList(queryMap));
ret.put("total", userService.getTotal(queryMap));
return ret;
}
/**
* 添加用户
* @param user
* @return
*/
@RequestMapping(value="/add",method=RequestMethod.POST)
@ResponseBody
public Map<String, String> add(User user){
Map<String, String> ret = new HashMap<String, String>();
if(user == null){
ret.put("type", "error");
ret.put("msg", "请填写正确的用户信息!");
return ret;
}
if(StringUtils.isEmpty(user.getUsername())){
ret.put("type", "error");
ret.put("msg", "请填写用户名!");
return ret;
}
if(StringUtils.isEmpty(user.getPassword())){
ret.put("type", "error");
ret.put("msg", "请填写密码!");
return ret;
}
if(user.getRoleId() == null){
ret.put("type", "error");
ret.put("msg", "请选择所属角色!");
return ret;
}
if(isExist(user.getUsername(), 0l)){
ret.put("type", "error");
ret.put("msg", "该用户名已经存在,请重新输入!");
return ret;
}
if(userService.add(user) <= 0){
ret.put("type", "error");
ret.put("msg", "用户添加失败,请联系管理员!");
}
//说明用户名密码及验证码都正确
//此时需要查询用户的角色权限
Role role = roleService.find(findByUsername.getRoleId());
List<Authority> authorityList = authorityService.findListByRoleId(role.getId());//根据角色获取权限列表
String menuIds = "";
for(Authority authority:authorityList){
menuIds += authority.getMenuId() + ",";
}
if(!StringUtils.isEmpty(menuIds)){
menuIds = menuIds.substring(0,menuIds.length()-1);
}
// System.out.println("menuIds:"+menuIds);
// menuIds="1,5,13";
List<Menu> userMenus = menuService.findListByIds(menuIds);
//把角色信息、菜单信息放到session中
request.getSession().setAttribute("admin", findByUsername);
request.getSession().setAttribute("role", role);
request.getSession().setAttribute("userMenus", userMenus);
ret.put("type", "success");
ret.put("msg", "登录成功!");
logService.add("用户名为{"+user.getUsername()+"},角色为{"+role.getName()+"}的用户登录成功!");
return ret;
}
/**
* 后台退出注销功能
* @param request
* @return
*/
@RequestMapping(value="/logout",method=RequestMethod.GET)
public String logout(HttpServletRequest request){
HttpSession session = request.getSession();
session.setAttribute("admin", null);
session.setAttribute("role", null);
request.getSession().setAttribute("userMenus", null);
return "redirect:login";
}
/**
* 修改密码页面
* @param model
* @return
*/
@RequestMapping(value="/edit_password",method=RequestMethod.GET)
public ModelAndView editPassword(ModelAndView model){
model.setViewName("system/edit_password");
return model;
}
@RequestMapping(value="/edit_password",method=RequestMethod.POST)
@ResponseBody
/**
* 新闻添加页面
*
* @param model
* @return
*/
@RequestMapping(value = "/add", method = RequestMethod.GET)
public ModelAndView add(ModelAndView model) {
model.addObject("newsCategoryList", newsCategoryService.findAll());
model.setViewName("news/add");
return model;
}
/**
* 新闻添加
*
* @param news
* @return
*/
@RequestMapping(value = "/add", method = RequestMethod.POST)
@ResponseBody
public Map<String, String> add(News news) {
Map<String, String> ret = new HashMap<String, String>();
if (news == null) {
ret.put("type", "error");
ret.put("msg", "请填写正确的信息!");
return ret;
}
if (StringUtils.isEmpty(news.getTitle())) {
ret.put("type", "error");
ret.put("msg", "新闻标题不能为空!");
return ret;
}
if (news.getCategoryId() == null) {
ret.put("type", "error");
ret.put("msg", "请选择新闻分类!");
return ret;
}
if (StringUtils.isEmpty(news.getAbstrs())) {
ret.put("type", "error");
ret.put("msg", "新闻摘要不能为空!");
}
User user = (User)request.getSession().getAttribute("admin");
if(!user.getPassword().equals(oldpassword)){
ret.put("type", "error");
ret.put("msg", "原密码错误!");
return ret;
}
user.setPassword(newpassword);
if(userService.editPassword(user) <= 0){
ret.put("type", "error");
ret.put("msg", "密码修改失败,请联系管理员!");
return ret;
}
ret.put("type", "success");
ret.put("msg", "密码修改成功!");
logService.add("用户名为{"+user.getUsername()+"},的用户成功修改密码!");
return ret;
}
/**
* 本系统所有的验证码均采用此方法
* @param vcodeLen
* @param width
* @param height
* @param cpachaType:用来区别验证码的类型,传入字符串
* @param request
* @param response
*/
@RequestMapping(value="/get_cpacha",method=RequestMethod.GET)
public void generateCpacha(
@RequestParam(name="vl",required=false,defaultValue="4") Integer vcodeLen,
@RequestParam(name="w",required=false,defaultValue="100") Integer width,
@RequestParam(name="h",required=false,defaultValue="30") Integer height,
@RequestParam(name="type",required=true,defaultValue="loginCpacha") String cpachaType,
HttpServletRequest request,
HttpServletResponse response){
CpachaUtil cpachaUtil = new CpachaUtil(vcodeLen, width, height);
String generatorVCode = cpachaUtil.generatorVCode();
request.getSession().setAttribute(cpachaType, generatorVCode);
BufferedImage generatorRotateVCodeImage = cpachaUtil.generatorRotateVCodeImage(generatorVCode, true);
try {
ImageIO.write(generatorRotateVCodeImage, "gif", response.getOutputStream());
} catch (IOException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}
/**
* 分页模糊搜索查询列表
*
* @param name
* @param page
* @return
*/
@RequestMapping(value = "/list", method = RequestMethod.POST)
@ResponseBody
public Map<String, Object> getList(
@RequestParam(name = "nickname", required = false, defaultValue = "") String nickname,
@RequestParam(name = "content", required = false, defaultValue = "") String content,
Page page) {
Map<String, Object> ret = new HashMap<String, Object>();
Map<String, Object> queryMap = new HashMap<String, Object>();
queryMap.put("nickname", nickname);
queryMap.put("content", content);
queryMap.put("offset", page.getOffset());
queryMap.put("pageSize", page.getRows());
ret.put("rows", commentService.findList(queryMap));
ret.put("total", commentService.getTotal(queryMap));
return ret;
}
/**
* 去除敏感信息
*
* @param news
* @return
*/
public static Comment minganInfo(Comment comment) {
// 去除敏感昵称
if (SensitiveWord.checkSenstiveWord(comment.getNickname())) {
comment.setNickname(SensitiveWord.filterInfoAfter(comment
.getNickname()));
}
// 去除敏感正文
if (SensitiveWord.checkSenstiveWord(comment.getContent())) {
comment.setContent(SensitiveWord.filterInfoAfter(comment
.getContent()));
}
return comment;
}
}
/**
* 前台页面首页控制器
*
*/
@RequestMapping("/index")
@Controller
public class IndexController {
@Autowired
private NewsCategoryService newsCategoryService;
@Autowired
private UserService userService;
@Autowired
private NewsService newsService;
@Autowired
private LogService logService;
/**
* 系统首页
* @param model
* @return
*/
@RequestMapping(value="/index",method=RequestMethod.GET)
public ModelAndView index(ModelAndView model){
Map<String, Object> queryMap = new HashMap<String, Object>();
queryMap.put("offset", 0);
queryMap.put("pageSize", 10);
model.addObject("newsCategoryList", newsCategoryService.findAll());
model.addObject("newsList", newsService.findList(queryMap));
model.setViewName("home/index/index");
return model;
}
/**
* 日志管理控制器
*
*/
@RequestMapping("/admin/log")
@Controller
public class LogController {
@Autowired
private LogService logService;
/**
* 日志列表页面
* @param model
* @return
*/
@RequestMapping(value="/list",method=RequestMethod.GET)
public ModelAndView list(ModelAndView model){
model.setViewName("log/list");
return model;
}
/**
* 获取日志列表
* @param page
* @param content
* @param roleId
* @param sex
* @return
*/
@RequestMapping(value="/list",method=RequestMethod.POST)
@ResponseBody
public Map<String, Object> getList(Page page,
@RequestParam(name="content",required=false,defaultValue="") String content
){
Map<String, Object> ret = new HashMap<String, Object>();
Map<String, Object> queryMap = new HashMap<String, Object>();
queryMap.put("content", content);
queryMap.put("offset", page.getOffset());
queryMap.put("pageSize", page.getRows());
comment.setContent(SensitiveWord.filterInfoAfter(comment
.getContent()));
}
return comment;
}
}
/**
* 菜单管理控制器
*
*/
@RequestMapping("/admin/menu")
@Controller
public class MenuController {
@Autowired
private MenuService menuService;
if(photo == null){
ret.put("type", "error");
ret.put("msg", "选择要上传的文件!");
return ret;
}
if(photo.getSize() > 1024*1024*1024){
ret.put("type", "error");
ret.put("msg", "文件大小不能超过10M!");
return ret;
}
//获取文件后缀
String suffix = photo.getOriginalFilename().substring(photo.getOriginalFilename().lastIndexOf(".")+1,photo.getOriginalFilename().length());
if(!"jpg,jpeg,gif,png".toUpperCase().contains(suffix.toUpperCase())){
ret.put("type", "error");
ret.put("msg", "请选择jpg,jpeg,gif,png格式的图片!");
return ret;
}
String savePath = request.getServletContext().getRealPath("/") + "/resources/upload/";
File savePathFile = new File(savePath);
if(!savePathFile.exists()){
//若不存在改目录,则创建目录
savePathFile.mkdir();
}
String filename = new Date().getTime()+"."+suffix;
try {
//将文件保存至指定目录
photo.transferTo(new File(savePath+filename));
}catch (Exception e) {
// TODO Auto-generated catch block
ret.put("type", "error");
ret.put("msg", "保存文件异常!");
e.printStackTrace();
return ret;
}
ret.put("type", "success");
ret.put("msg", "照片上传成功!");
ret.put("filepath",request.getServletContext().getContextPath() + "/resources/upload/" + filename );
return ret;
}
/**
* 判断该用户名是否存在
* @param username
* @param id
* @return
*/
private boolean isExist(String username,Long id){
User user = userService.findByUsername(username);
if(user == null)return false;
if(user.getId().longValue() == id.longValue())return false;
}
/**
* 获取用户列表
* @param page
* @param username
* @param roleId
* @param sex
* @return
*/
@RequestMapping(value="/list",method=RequestMethod.POST)
@ResponseBody
public Map<String, Object> getList(Page page,
@RequestParam(name="username",required=false,defaultValue="") String username,
@RequestParam(name="roleId",required=false) Long roleId,
@RequestParam(name="sex",required=false) Integer sex
){
Map<String, Object> ret = new HashMap<String, Object>();
Map<String, Object> queryMap = new HashMap<String, Object>();
queryMap.put("username", username);
queryMap.put("roleId", roleId);
queryMap.put("sex", sex);
queryMap.put("offset", page.getOffset());
queryMap.put("pageSize", page.getRows());
ret.put("rows", userService.findList(queryMap));
ret.put("total", userService.getTotal(queryMap));
return ret;
}
/**
* 添加用户
* @param user
* @return
*/
@RequestMapping(value="/add",method=RequestMethod.POST)
@ResponseBody
public Map<String, String> add(User user){
Map<String, String> ret = new HashMap<String, String>();
if(user == null){
ret.put("type", "error");