Java源码社

基于javaweb的JSP+Servlet在线新闻平台系统(java+html+jdbc+mysql)

更新于

运行环境

Java≥8、MySQL≥5.7、Tomcat≥8

开发工具

eclipse/idea/myeclipse/sts等均可配置运行

适用

课程设计，大作业，毕业设计，项目练习，学习演示等

功能说明

090023112402

110023112402

120023112402

基于javaweb的JSP+Servlet在线新闻平台系统(java+html+jdbc+mysql)

注意：本项目前端页面是HTML，不是JSP

功能： 用户的登录注册，新闻的分类查询，评论留言，投稿，新闻的后台管理，发布，审核，投稿管理以及汇总统计等等。

普通用户也可以投稿新闻，管理后台审核后可以显示

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
    }else {
        ServletResp.resp(response, CommonResult.failed());
    }
}


/**
 * （客户端）添加文章评论
 * @param request
 * @param response
 */
public void addComment(HttpServletRequest request, HttpServletResponse response){
    String reqBody = JsonUtils.getJson(request);
    Comment comment = JsonUtils.fromJson(reqBody, Comment.class);
    String userName = (String) request.getSession().getAttribute("userName");
    Integer userId = (Integer) request.getSession().getAttribute("userId");
    Integer role = (Integer) request.getSession().getAttribute("role");
    if (userId == null || Role.Admin.getRoleCode()==role){
        ServletResp.resp(response, CommonResult.unauthorized());
    }
    comment.setUsername(userName);
    comment.setUserId(userId);
    int result = new CmsCommentDaoImpl().doComment(comment);
    if (result == 1){
        ServletResp.resp(response, CommonResult.success("评论成功，审核通过后显示"));
    }else {
        ServletResp.resp(response, CommonResult.failed("评论失败"));
    }
}

/**
 * （管理端）获取等待审核的评论
 * @param request
 * @param response
 */
public void getCommentWaitCheck(HttpServletRequest request, HttpServletResponse response) throws IOException {
    Integer role = (Integer) request.getSession().getAttribute("role");
    if (Role.Admin.getRoleCode()!=role){
        response.sendRedirect("admin?method=toLogin");
    }
    String pageNumStr = request.getParameter("page");
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
            ServletResp.resp(response, CommonResult.success("注册成功"));
        }
    }

    /**
     * 检查用户名是否重复
     * @param request
     * @param response
     */
    public void checkUsername(HttpServletRequest request, HttpServletResponse response){
            String userName = request.getParameter("userName");
        int result = userDao.checkUsername(userName);
        if (result == 1){
            ServletResp.resp(response, CommonResult.success("用户名可用"));
        }else {
            ServletResp.resp(response, CommonResult.failed("用户名已存在"));
        }
    }

    public void getCode(HttpServletRequest request, HttpServletResponse response){
        //创建对象
        VerifyCode vc = new VerifyCode();
        //获取图片对象
        BufferedImage bi = vc.getImage();
        //获得图片的文本内容
        String text = vc.getText();
        // 将系统生成的文本内容保存到session中
        request.getSession().setAttribute("code", text);
        //向浏览器输出图片
        try {
            VerifyCode.output(bi, response.getOutputStream());
        } catch (IOException e) {
            e.printStackTrace();
        }
    }
}
package com.news.servlet;


1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
 * @param request
 * @param response
 */
public void getArticleById(HttpServletRequest request, HttpServletResponse response) {
    String articleIdStr = request.getParameter("articleId");
    Integer articleId = Integer.valueOf(articleIdStr);
    Article article = cmsArticleService.getArticleById(articleId);
    System.out.println("request.getSession().getAttribute(\"role\") = " + request.getSession().getAttribute("role"));
    if (article != null){
        if(article.getIsShow() == 1 || request.getSession().getAttribute("role").equals(Role.Admin.getRoleCode())){
            ServletResp.resp(response, CommonResult.success(article));
        }else {
            ServletResp.resp(response, CommonResult.failed("文章不见了，去看看其他文章吧"));
        }

    }else {
        ServletResp.resp(response, CommonResult.failed("文章不存在"));
    }
}

/**
 * （管理端）获取投稿文章
 * @param request
 * @param response
 */
public void getArticleByUser(HttpServletRequest request, HttpServletResponse response){
    String pageNumStr = request.getParameter("page");
    String pageSizeStr = request.getParameter("limit");
    if (pageNumStr == null || pageSizeStr == null){
        ServletResp.resp(response, CommonResult.validateFailed());
    }
    int pageSize = Integer.valueOf(pageSizeStr);
    int pageNum = Integer.valueOf(pageNumStr);
    pageNum = (pageNum-1) * pageSize;

    List<Article> allArticleInfo = cmsArticleService.getArticleByUser(pageNum, pageSize);
    if (allArticleInfo != null){
        String success = CommonPage.success(allArticleInfo);
        ServletResp.resp(response, success);
    }else {
        ServletResp.resp(response, CommonResult.failed());
    }
}

/**
 * （客户端|管理端）添加（投稿）文章
 * @param request
 * @param response
 */
public void add(HttpServletRequest request, HttpServletResponse response){
    String reqBody = JsonUtils.getJson(request);
    Article article = JsonUtils.fromJson(reqBody, Article.class);
    String userName = (String)request.getSession().getAttribute("userName");
    Integer role = (Integer) request.getSession().getAttribute("role");
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
    if (commentList!=null){
        ServletResp.resp(response, CommonPage.success(commentList));
    }else {
        ServletResp.resp(response, CommonResult.failed());
    }
}


/**
 * （客户端）添加文章评论
 * @param request
 * @param response
 */
public void addComment(HttpServletRequest request, HttpServletResponse response){
    String reqBody = JsonUtils.getJson(request);
    Comment comment = JsonUtils.fromJson(reqBody, Comment.class);
    String userName = (String) request.getSession().getAttribute("userName");
    Integer userId = (Integer) request.getSession().getAttribute("userId");
    Integer role = (Integer) request.getSession().getAttribute("role");
    if (userId == null || Role.Admin.getRoleCode()==role){
        ServletResp.resp(response, CommonResult.unauthorized());
    }
    comment.setUsername(userName);
    comment.setUserId(userId);
    int result = new CmsCommentDaoImpl().doComment(comment);
    if (result == 1){
        ServletResp.resp(response, CommonResult.success("评论成功，审核通过后显示"));
    }else {
        ServletResp.resp(response, CommonResult.failed("评论失败"));
    }
}

/**
 * （管理端）获取等待审核的评论
 * @param request
 * @param response
 */
public void getCommentWaitCheck(HttpServletRequest request, HttpServletResponse response) throws IOException {
    Integer role = (Integer) request.getSession().getAttribute("role");
    if (Role.Admin.getRoleCode()!=role){
        response.sendRedirect("admin?method=toLogin");
    }
    String pageNumStr = request.getParameter("page");
    String pageSizeStr = request.getParameter("limit");
    if (pageNumStr == null || pageSizeStr == null){
        ServletResp.resp(response, CommonResult.validateFailed());
    }
    int pageSize = Integer.valueOf(pageSizeStr);
    int pageNum = Integer.valueOf(pageNumStr);
    pageNum = (pageNum-1) * pageSize;
    List<Map<String,Object>> allComments = new CmsCommentDaoImpl().getCommentWaitCheck(pageNum,pageSize);
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43

/**
 */
@WebServlet("/admin/*")
public class LoginServlet  extends BaseServlet{

    private UmsUserServiceImpl umsUserService = new UmsUserServiceImpl();
    private UmsUserDaoImpl userDao = new UmsUserDaoImpl();
    public void doLogin(HttpServletRequest request, HttpServletResponse response) throws IOException {
        int  userId = 0;
        String userName = request.getParameter("userName");
        String passWord = request.getParameter("passWord");
        String roleStr = request.getParameter("role");
        String code = request.getParameter("code");
        Integer role = Integer.valueOf(roleStr);
        if (role == Role.Admin.getRoleCode()){
            Admin admin = new Admin();
            admin.setUserName(userName);
            admin.setPassWord(passWord);
            userId = umsUserService.login(admin);
        }else if (role == Role.User.getRoleCode()){
            User user = new User();
            user.setUserName(userName);
            user.setPassWord(passWord);
            userId = umsUserService.userLogin(user);
        }
        String codeSession = (String) request.getSession().getAttribute("code");
        System.out.println("验证码"+codeSession);
        if (!codeSession.equalsIgnoreCase(code)){
            ServletResp.resp(response, CommonResult.failed("验证码有误"));
            return;
        }

        if (userId != 0){
             request.getSession().setAttribute("userName", userName);
             request.getSession().setAttribute("role", role);
            request.getSession().setAttribute("userId", userId);
             ServletResp.resp(response, CommonResult.success());
        }else {
            ServletResp.resp(response, CommonResult.failed("登录失败，账号密码有误!"));
        }

    }

项目链接：
https://javayms.github.io?id=551422272105200bx
https://javayms.pages.dev?id=551422272105200bx