基于javaweb+mysql的springboot协同过滤算法新闻管理系统(java+springboot+mybatis+jquery+html+jsp+mysql)
私信源码获取及调试交流
运行环境
Java≥8、MySQL≥5.7
开发工具
eclipse/idea/myeclipse/sts等均可配置运行
适用
课程设计,大作业,毕业设计,项目练习,学习演示等
功能说明
基于javaweb的SpringBoot协同过滤算法新闻管理系统(java+springboot+mybatis+jquery+html+jsp+mysql)
项目介绍
本项目新闻推荐管理系统;
前台:
登录、首页、全部新闻、系统公告、热点资讯、个人账户、个人收藏
后台: (1)网站管理 (2)用户管理 (3)内容管理 (4)模块管理 (5)个人管理
技术栈
java+SpringBoot+MyBatis+JQuery+HTML+JSP+mysql
使用说明
- 使用Navicat或者其它工具,在mysql中创建对应名称的数据库,并导入项目的sql文件; 2. 使用IDEA/Eclipse/MyEclipse导入项目,导入成功后请执行maven clean;maven install命令,然后运行; 3. 将项目中application.properties配置文件中的数据库配置改为自己的配置; 4. 运行项目,在浏览器中输入http://localhost:8080 访问
List<News> newsList = newsDao.queryAll();
request.setAttribute("list", newsList);
return "listnews";
@RequestMapping("/toeditnews")
public String toeditnews(){
News news = newsDao.queryByid(Integer.parseInt(request.getParameter("id")));
request.setAttribute("v", news);
List<Category> categoryList = categoryDao.queryAll();
request.setAttribute("categoryList", categoryList);
return "editnews";
@RequestMapping("/queryByType")
public String queryByType(){
String categoryid = request.getParameter("categoryid");
News news = new News();
news.setCategoryid(Integer.parseInt(categoryid));
news.setContent(content);
news.setPbdate(new Date());
news.setId(Integer.parseInt(request.getParameter("id")));
news.setTitle(title);
newsDao.edit(news);
return "redirect:listforadmin";
@RequestMapping("/del")
public String del(){
newsDao.deleteById(Integer.parseInt(request.getParameter("id")));
length = length / 60;
length = length * 27 + 10;
request.setAttribute("length", length);
request.setAttribute("v", detail);
List<Category> categoryList = categoryDao.queryAll();
List<Comments> commentsList = commentsDao.getByNewsId(news.getId());
request.setAttribute("commentsList", commentsList);
request.setAttribute("contentstr", content);
request.setAttribute("categoryList",
categoryList.stream().filter(x -> x.getState().equals("1")).collect(Collectors.toList()));
return "detailnews";
@RequestMapping("/search")
public String search(){
return "reg";
} else {
usersDao.reg(username, account, password, email);
request.setAttribute("error", "注册成功!");
return "reg";
@RequestMapping("/listforadmin")
public String listforadmin() {
List<Users> list = usersDao.getUsers();
request.setAttribute("list", list);
return "listusers";
@RequestMapping("/del")
public String del(Integer id) {
usersDao.del(id);
List<Category> categoryList = categoryDao.queryAll();
request.setAttribute("categoryList",
categoryList.stream().filter(x -> x.getState().equals("1")).collect(Collectors.toList()));
return "typenews";
@RequestMapping("/detail")
public String detail(){
//测试
String id = request.getParameter("id");
if(id.contains(".jsp"))
id= request.getParameter("id").replaceAll(".jsp","");
@RequestMapping("/toeditnews")
public String toeditnews(){
News news = newsDao.queryByid(Integer.parseInt(request.getParameter("id")));
request.setAttribute("v", news);
List<Category> categoryList = categoryDao.queryAll();
request.setAttribute("categoryList", categoryList);
return "editnews";
@RequestMapping("/queryByType")
public String queryByType(){
String categoryid = request.getParameter("categoryid");
public String loginadmin() {
String username = request.getParameter("username");
String password = request.getParameter("password");
Users users = usersDao.login(username, password);
if (users != null) {
request.getSession().setAttribute("loginUsers", users);
return "admin_index";
} else {
request.setAttribute("msg", "登录失败,账号密码不匹配");
return "admin_login";
@RequestMapping("/userlogin")
public String userlogin() {
String userName = request.getParameter("username");
request.setAttribute("error", "注册失败,密码与确认密码不一致!");
return "reg";
} else {
boolean isSuccess = usersDao.isReg(account);
if (!isSuccess) {
request.setAttribute("error", "注册失败,该用户名已存在!");
return "reg";
} else {
usersDao.reg(username, account, password, email);
request.setAttribute("error", "注册成功!");
@RequestMapping("/publish")
public String publish(){
String title = request.getParameter("title");
String content = request.getParameter("content");
String categoryid = request.getParameter("categoryid");
Users users = (Users) request.getSession().getAttribute("loginUsers");
Integer usersId = users.getId();
Integer deptid = users.getDeptid();
News news = new News();
news.setCategoryid(Integer.parseInt(categoryid));
news.setClicks(0);
public class CategoryController {
@Autowired
private HttpServletRequest request;
private CategoryDao categoryDao=new CategoryDao();
@RequestMapping("/listforadmin")
public String listforadmin(){
List<Category> categoryList = categoryDao.queryAll();
request.setAttribute("list", categoryList);
return "listcategory";
@RequestMapping("/show")
public String show(){
List<Category> categoryList = categoryDao.queryAll();
categoryList=categoryList.stream().filter(x->x.getState().equals("1")).collect(Collectors.toList());
public String userreg() {
String username = request.getParameter("username");
String password = request.getParameter("password");
String account = request.getParameter("account");
String email = request.getParameter("email");
String password2 = request.getParameter("password2");
if (!password.equals(password2)) {
request.setAttribute("error", "注册失败,密码与确认密码不一致!");
return "reg";
} else {
boolean isSuccess = usersDao.isReg(account);
if (!isSuccess) {
request.setAttribute("error", "注册失败,该用户名已存在!");
return "reg";
x.setTitle(title);
return x;
}).collect(Collectors.toList());
request.setAttribute("list",newsList
);
List<Category> categoryList = categoryDao.queryAll();
request.setAttribute("categoryList",
categoryList.stream().filter(x -> x.getState().equals("1")).collect(Collectors.toList()));
return "searchnews";
类别管理控制层:
@Controller
@Autowired
private HttpServletRequest request;
@RequestMapping("/loginadmin")
public String loginadmin() {
String username = request.getParameter("username");
String password = request.getParameter("password");
Users users = usersDao.login(username, password);
if (users != null) {
request.getSession().setAttribute("loginUsers", users);
return "admin_index";
@RequestMapping("UsersServlet")
public class UsersController {
private UsersDao usersDao = new UsersDao();
@Autowired
private HttpServletRequest request;
@RequestMapping("/loginadmin")
public String loginadmin() {
String username = request.getParameter("username");
String password = request.getParameter("password");
Users users = usersDao.login(username, password);
if (users != null) {
request.getSession().setAttribute("loginUsers", users);
request.setAttribute("list", categoryList);
return "listcategory";
@RequestMapping("/show")
public String show(){
List<Category> categoryList = categoryDao.queryAll();
categoryList=categoryList.stream().filter(x->x.getState().equals("1")).collect(Collectors.toList());
if(categoryList.size()>=5)
request.setAttribute("list", categoryDao.queryAll());
request.setAttribute("msg","设置栏目显示失败,前台栏目最多显示5个");
return "listcategory";
}else {
categoryDao.show(Integer.parseInt(request.getParameter("id")));
return "redirect:listforadmin";
public String edit(){
String title = request.getParameter("title");
String content = request.getParameter("content");
String categoryid = request.getParameter("categoryid");
News news = new News();
news.setCategoryid(Integer.parseInt(categoryid));
news.setContent(content);
news.setPbdate(new Date());
news.setId(Integer.parseInt(request.getParameter("id")));
news.setTitle(title);
newsDao.edit(news);
return "redirect:listforadmin";
@RequestMapping("/del")
public String listforadmin(){
List<Category> categoryList = categoryDao.queryAll();
request.setAttribute("list", categoryList);
return "listcategory";
@RequestMapping("/show")
public String show(){
List<Category> categoryList = categoryDao.queryAll();
categoryList=categoryList.stream().filter(x->x.getState().equals("1")).collect(Collectors.toList());
if(categoryList.size()>=5)
request.setAttribute("list", categoryDao.queryAll());
request.setAttribute("msg","设置栏目显示失败,前台栏目最多显示5个");