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

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

一、项目简述
功能: 用户的登录注册,新闻的分类查询,评论留言,投稿,新闻的后台管理,发布,审核,投稿管理以及汇总统计等等。

二、项目运行
环境配置: Jdk1.8 + Tomcat8.5 + mysql + Eclispe (IntelliJ IDEA,Eclispe,MyEclispe,Sts 都支持)

项目技术: Jsp + Jdbc + Servlert + html+ css + JavaScript + JQuery + Ajax + Fileupload

请添加图片描述
请添加图片描述
请添加图片描述

适用

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

            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");
        }
    }
}
用户登录控制器:
/**
 * 用户登录控制器
 */
@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");
            ServletResp.resp(response, CommonResult.failed("注册失败"));
        }else{
            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("用户名已存在"));
        if (role == null){
            response.sendRedirect("admin?method=toLogin");
            return;
        }
        if (Role.Admin.getRoleCode()!=role || role == null){
            response.sendRedirect("admin?method=toLogin");
            return;
        }
        request.getRequestDispatcher("front/index.html").forward(request, response);
    }
    public void doLogOut(HttpServletRequest request, HttpServletResponse response) throws IOException, ServletException {
        request.getSession().removeAttribute("userName");
        request.getSession().removeAttribute("userId");
        request.getSession().removeAttribute("role");
        ServletResp.resp(response, CommonResult.success("注销成功"));
    }
    public void toRegist(HttpServletRequest request, HttpServletResponse response) throws IOException, ServletException {
        request.getRequestDispatcher("front/page/login/regist.html").forward(request, response);
    }
    /**
     * 普通用户注册
     * @param request
    public void uploadFile(HttpServletRequest request,HttpServletResponse response) throws IOException {
        SmartUpload su=new SmartUpload();
        try{
            su.initialize(this.getServletConfig(), request,response);
            su.upload();
            File file = su.getFiles().getFile(0);
            String filePath  =
                    request.getSession().getServletContext().getRealPath("/")+ "upload\\";
            java.io.File path = new java.io.File(filePath);
            if (!path.exists()){
                System.out.println("文件夹不存在,创建文件夹");
                path.mkdir();
            }
            String filename = file.getFileName();
            String str = filename.substring(filename.lastIndexOf("."), filename.length());
     * @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("用户名已存在"));
        }
    }
            String filename = file.getFileName();
            String str = filename.substring(filename.lastIndexOf("."), filename.length());
            System.out.println(filename);
            SimpleDateFormat sdf = new SimpleDateFormat("yyyyMMddHHmmss");
            String finalname  = sdf.format(new Date()) + str;
            System.out.println("filePath + finalname = " + filePath + finalname);
            file.saveAs(filePath + finalname , File.SAVEAS_PHYSICAL);
            Map<String,Object> map = new HashMap<>();
            map.put("title",filename);
            map.put("src", "http://localhost:8008/news/upload/"+finalname);
            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("评论失败"));
            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);
        if (allComments!=null){
            ServletResp.resp(response, CommonPage.success(allComments));
        }else{
            ServletResp.resp(response, CommonResult.failed());
        }
    }
    /**
     * 更新评论
     * @param request
     * @param response
     */
    public void updateComment(HttpServletRequest request, HttpServletResponse response){
    public void delete(HttpServletRequest request, HttpServletResponse response){
        String newsIdStr = request.getParameter("newsId");
        Integer newsId = Integer.valueOf(newsIdStr);
        int count = cmsArticleService.delete(newsId);
        if (count != 0){
            ServletResp.resp(response, CommonResult.success("删除成功"));
        }else {
            ServletResp.resp(response, CommonResult.failed());
        }
    }
    /**
        request.getSession().setAttribute("code", text);
        //向浏览器输出图片
        try {
            VerifyCode.output(bi, response.getOutputStream());
        } catch (IOException e) {
            e.printStackTrace();
        }
    }
}
评论模块:
/**
 * 评论模块
 */
@WebServlet("/comment/*")
public class CommentServlet extends BaseServlet {
    /**
     * (客户端)获取文章评论
     * @param request
     * @param response
    /**
     * 普通用户注册
     * @param request
     * @param response
     */
    public void doRegist(HttpServletRequest request, HttpServletResponse response)  {
        String reqBody = JsonUtils.getJson(request);
        User user = JsonUtils.fromJson(reqBody, User.class);
        int result = userDao.regist(user);
        if (result == 0){
            ServletResp.resp(response, CommonResult.failed("注册失败"));
        }else{
    }
}
文章控制器:
/**
 * 文章控制器
 */
@WebServlet("/article/*")
public class ArticleServlet extends BaseServlet {
    private CmsArticleService cmsArticleService = new CmsArticleServiceImpl();
    /**
     * (管理端)分页获取文章
     * @param request
     * @param response
     */
    public void getAllArticle(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){
        }else {
            ServletResp.resp(response, CommonResult.failed());
        }
    }
}
文章控制器:
/**
 * 文章控制器
 */
@WebServlet("/article/*")
public class ArticleServlet extends BaseServlet {
    private CmsArticleService cmsArticleService = new CmsArticleServiceImpl();
    /**
     * (管理端)分页获取文章
     * @param request
        List<Comment> commentList = new CmsCommentDaoImpl().getComments(articleId);
        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);
        List<Comment> commentList = new CmsCommentDaoImpl().getComments(articleId);
        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);
    public void delete(HttpServletRequest request, HttpServletResponse response){
        String newsIdStr = request.getParameter("newsId");
        Integer newsId = Integer.valueOf(newsIdStr);
        int count = cmsArticleService.delete(newsId);
        if (count != 0){
            ServletResp.resp(response, CommonResult.success("删除成功"));
        }else {
            ServletResp.resp(response, CommonResult.failed());
        }
    }
    /**
     * (客户端)跳转客户端投稿
     * @param request
     * @param response
     * @throws ServletException
            String str = filename.substring(filename.lastIndexOf("."), filename.length());
            System.out.println(filename);
            SimpleDateFormat sdf = new SimpleDateFormat("yyyyMMddHHmmss");
            String finalname  = sdf.format(new Date()) + str;
            System.out.println("filePath + finalname = " + filePath + finalname);
            file.saveAs(filePath + finalname , File.SAVEAS_PHYSICAL);
            Map<String,Object> map = new HashMap<>();
            map.put("title",filename);
            map.put("src", "http://localhost:8008/news/upload/"+finalname);
            int result = new CmsArticleDaoImpl().uploadFile(map);
            if (result == 1) {
                ServletResp.resp(response, CommonResult.result(0, "文件上传成功", map));
            }
        }
        catch(Exception e)
        {
            e.printStackTrace();
            ServletResp.resp(response, CommonResult.failed("文件上传失败"));
        String reqBody = JsonUtils.getJson(request);
        Article article = JsonUtils.fromJson(reqBody, Article.class);
        int count = cmsArticleService.update(article);
        if (count != 0){
            ServletResp.resp(response, CommonResult.success());
        }else {
            ServletResp.resp(response, CommonResult.failed());
        }
    }
    /**
     * (客户端)查询该分类下可以显示的文章列表
     * @param request
     * @param response
     */
    public void getArticleListByCatelogyId(HttpServletRequest request, HttpServletResponse response){
        String categoryIdStr = request.getParameter("categoryId");
        Integer categoryId = Integer.valueOf(categoryIdStr);
        Map<String,Object> map = cmsArticleService.getArticleListByCatelogyId(categoryId);
        if (map != null){
        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){
        }else {
            ServletResp.resp(response, CommonResult.failed());
        }
    }
    /**
     * (管理端)更新文章
     * @param request
     * @param response
     */
    public void update(HttpServletRequest request, HttpServletResponse response){
        String reqBody = JsonUtils.getJson(request);
        Article article = JsonUtils.fromJson(reqBody, Article.class);
        int count = cmsArticleService.update(article);
        if (count != 0){
            ServletResp.resp(response, CommonResult.success());
        }else {
            ServletResp.resp(response, CommonResult.failed());
        }
    }
        if (count != 0){
            ServletResp.resp(response, CommonResult.success("删除成功"));
        }else {
            ServletResp.resp(response, CommonResult.failed());
        }
    }
    /**
     * (客户端)跳转客户端投稿
     * @param request
     * @param response
     * @throws ServletException
     * @throws IOException
     */
    public void toPostNews(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
      response.sendRedirect("postNewsDetail.html");
        //request.getRequestDispatcher("front/page/news/postNewsDetail.html").forward(request, response);
    public void getAllArticle(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<Article> allArticleInfo = cmsArticleService.getAllArticleInfo(pageNum, pageSize);
        if (allArticleInfo != null){
            String success = CommonPage.success(allArticleInfo);
            ServletResp.resp(response, success);
        }else {
     * (客户端)查询该分类下可以显示的文章列表
     * @param request
     * @param response
     */
    public void getArticleListByCatelogyId(HttpServletRequest request, HttpServletResponse response){
        String categoryIdStr = request.getParameter("categoryId");
        Integer categoryId = Integer.valueOf(categoryIdStr);
        Map<String,Object> map = cmsArticleService.getArticleListByCatelogyId(categoryId);
        if (map != null){
            ServletResp.resp(response, CommonResult.success(map));
        }else {
            ServletResp.resp(response, CommonResult.failed());
        }
    }
 * 评论模块
 */
@WebServlet("/comment/*")
public class CommentServlet extends BaseServlet {
    /**
     * (客户端)获取文章评论
     * @param request
     * @param response
     */
    public void getComments(HttpServletRequest request, HttpServletResponse response){
        String idStr = request.getParameter("articleId");
        Integer articleId = Integer.valueOf(idStr);
        List<Comment> commentList = new CmsCommentDaoImpl().getComments(articleId);
     * @throws ServletException
     * @throws IOException
     */
    public void getTotalData(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        String reqBody = JsonUtils.getJson(request);
        Article article = JsonUtils.fromJson(reqBody, Article.class);
        Map<String, Object> totalData = new CmsArticleDaoImpl().getTotalData();
        if (totalData != null){
            ServletResp.resp(response, CommonResult.success(totalData));
        }else {
            ServletResp.resp(response, CommonResult.failed());
        }
    }
    /**
     * 上传文件
     * @param request
     * @param response
        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);

  • 0
    点赞
  • 3
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值