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

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

运行环境

Java≥8、MySQL≥5.7、Tomcat≥8

开发工具

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

适用

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

功能说明

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

注意:本项目前端页面是HTML,不是JSP

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

        try {
            return JSON.toJSONString(object, SerializerFeature.WriteMapNullValue);
        } catch (Exception e) {  
            e.printStackTrace();  
        }  
        return null;  
    }

    public static String getJson(HttpServletRequest request) {
        BufferedReader reader = null;
        StringBuilder builder = new StringBuilder();
        try {
            reader = request.getReader();
            String line = reader.readLine();
            while (line != null) {
                builder.append(line);
                line = reader.readLine();
            }
            reader.close();
        } catch (IOException e) {
            e.printStackTrace();
        }
        return builder.toString();
    }

}  

/**
 */
public class BaseServlet extends HttpServlet {

    @Override

}

/**
 */
@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);

/**
 */
public class BaseServlet extends HttpServlet {

    @Override
    public void service(HttpServletRequest req, HttpServletResponse res) throws ServletException, IOException {

        String methodName = req.getParameter("method");
            if (methodName != null || !"".equals(methodName)) {
                try {
                    Method method = this.getClass().getMethod(methodName, HttpServletRequest.class, HttpServletResponse.class);
                    System.out.println(method.toString());
                    method.invoke(this, req, res);
                } catch (NoSuchMethodException e) {
                    e.printStackTrace();
                } catch (IllegalAccessException e) {
                    e.printStackTrace();
                } catch (InvocationTargetException e) {
                    e.printStackTrace();
                }
            }
    }
}

     */
    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");
        Integer userId = (Integer) request.getSession().getAttribute("userId");
        if (userId == null){
            ServletResp.resp(response, CommonResult.unauthorized());
            //return;
        }
        // 根据角色
        int count = 0;
        article.setEditorId(userId);
        article.setRole(role);
        if (role == Role.Admin.getRoleCode()){
             article.setIsCheck(1);
             count = cmsArticleService.add(article);
        }else{
            // 用户需要审核才可以发布
            article.setIsCheck(0);
            count = cmsArticleService.add(article);
        }

        if (count != 0){
            ServletResp.resp(response, CommonResult.success());
        }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());
        }
    }

    /**
     * (客户端)查询该分类下可以显示的文章列表
     * @param request
     * @param response
     */
    public void getArticleListByCatelogyId(HttpServletRequest request, HttpServletResponse response){
     * @param request
     * @param response
     * @throws ServletException
     * @throws IOException
     */
    public void getSearchResult(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        String title = request.getParameter("title");
        List<Map<String, Object>> searchResult = new CmsArticleDaoImpl().getSearchResult(title);
        if (searchResult != null){
            ServletResp.resp(response, CommonResult.success(searchResult));
        }else {
            ServletResp.resp(response, CommonResult.failed());
        }
    }

}

 */
@WebServlet("/category/*")
public class CategoryServlet extends BaseServlet {

    private CmsCategoryService cmsCategoryService = new CmsCategoryServiceImpl();

    public void getCategoryCanUse(HttpServletRequest request, HttpServletResponse response){

        List<Category> allCategoryCanUse = cmsCategoryService.getAllCategoryCanUse();
        if (allCategoryCanUse != null) {
            ServletResp.resp(response, CommonResult.success(allCategoryCanUse));
        }else {
            ServletResp.resp(response, CommonResult.failed());
        }

    }

}

//@WebFilter("/*")
public class EncodingFilter implements Filter {

	@Override
	public void init(FilterConfig filterConfig) throws ServletException {

	}

	@Override
	public void doFilter(ServletRequest request, ServletResponse response, FilterChain chain) throws IOException, ServletException {
		//编码设置
		request.setCharacterEncoding("utf-8");
		response.setCharacterEncoding("utf-8");
        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());
        }
    }

    /**
     * (管理端)删除文章
     * @param request
     * @param 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());
        }
    }

    /**
     * (客户端)跳转客户端投稿
     * @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);
    }

    /**
     * (管理端)更新状态
     * @param request
     * @param response
     * @throws ServletException
     * @throws IOException
     */
    public void changeCheck(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        String reqBody = JsonUtils.getJson(request);
        Article article = JsonUtils.fromJson(reqBody, Article.class);
    public static String getJson(HttpServletRequest request) {
        BufferedReader reader = null;
        StringBuilder builder = new StringBuilder();
        try {
            reader = request.getReader();
            String line = reader.readLine();
            while (line != null) {
                builder.append(line);
                line = reader.readLine();
            }
            reader.close();
        } catch (IOException e) {
            e.printStackTrace();
        }
        return builder.toString();
    }

}  

/**
 */
public class BaseServlet extends HttpServlet {

    @Override
    public void service(HttpServletRequest req, HttpServletResponse res) throws ServletException, IOException {

        String methodName = req.getParameter("method");
            if (methodName != null || !"".equals(methodName)) {
                try {
                    Method method = this.getClass().getMethod(methodName, HttpServletRequest.class, HttpServletResponse.class);
                    System.out.println(method.toString());
                    method.invoke(this, req, res);
                } catch (NoSuchMethodException e) {
                    e.printStackTrace();
                } catch (IllegalAccessException e) {
            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("登录失败,账号密码有误!"));
        }

    }

    public void toLogin(HttpServletRequest request, HttpServletResponse response) throws IOException, ServletException {
        request.getRequestDispatcher("front/page/login/login.html").forward(request, response);
    }

    public void toIndex(HttpServletRequest request, HttpServletResponse response) throws IOException, ServletException {
        Integer role = (Integer) request.getSession().getAttribute("role");
        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("注销成功"));
    }


/**
 */
@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");
        }
            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");
        Integer userId = (Integer) request.getSession().getAttribute("userId");
        if (userId == null){
            ServletResp.resp(response, CommonResult.unauthorized());
            //return;
        }
        // 根据角色
        int count = 0;
        article.setEditorId(userId);
        article.setRole(role);
        if (role == Role.Admin.getRoleCode()){
             article.setIsCheck(1);
             count = cmsArticleService.add(article);
        }else{
            // 用户需要审核才可以发布
            article.setIsCheck(0);
            count = cmsArticleService.add(article);
        }

        if (count != 0){
            ServletResp.resp(response, CommonResult.success());
        }else {
            ServletResp.resp(response, CommonResult.failed());
        }
    }

        //创建对象
        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();
        }
    }
}

/**
 * 评论模块
        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");
        Integer userId = (Integer) request.getSession().getAttribute("userId");
        if (userId == null){
            ServletResp.resp(response, CommonResult.unauthorized());
            //return;
        }
        // 根据角色
        int count = 0;
        article.setEditorId(userId);
        article.setRole(role);
        if (role == Role.Admin.getRoleCode()){
             article.setIsCheck(1);
             count = cmsArticleService.add(article);
        }else{
            // 用户需要审核才可以发布
            article.setIsCheck(0);
            count = cmsArticleService.add(article);
        }

        if (count != 0){
            ServletResp.resp(response, CommonResult.success());
            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());
            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", "/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("文件上传失败"));
        }
    }

    /**
     * (客户端)搜索功能
     * @param request
     * @param response
     * @throws ServletException
     * @throws IOException
     */
    public void getSearchResult(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        String title = request.getParameter("title");
        List<Map<String, Object>> searchResult = new CmsArticleDaoImpl().getSearchResult(title);
        if (searchResult != null){
            ServletResp.resp(response, CommonResult.success(searchResult));
        }else {
            ServletResp.resp(response, CommonResult.failed());
        }
    }


        List<Category> allCategoryCanUse = cmsCategoryService.getAllCategoryCanUse();
        if (allCategoryCanUse != null) {
            ServletResp.resp(response, CommonResult.success(allCategoryCanUse));
        }else {
            ServletResp.resp(response, CommonResult.failed());
        }

    }

}

//@WebFilter("/*")
public class EncodingFilter implements Filter {

	@Override
	public void init(FilterConfig filterConfig) throws ServletException {

	}

	@Override
	public void doFilter(ServletRequest request, ServletResponse response, FilterChain chain) throws IOException, ServletException {
		//编码设置
		request.setCharacterEncoding("utf-8");
		response.setCharacterEncoding("utf-8");
		response.setContentType("text/html;charset=utf-8");
		chain.doFilter(request, response);
	}

	@Override
	public void destroy() {

	}
}


/**
 */
@WebServlet("/category/*")
public class CategoryServlet extends BaseServlet {

    private CmsCategoryService cmsCategoryService = new CmsCategoryServiceImpl();

    public void getCategoryCanUse(HttpServletRequest request, HttpServletResponse response){

        List<Category> allCategoryCanUse = cmsCategoryService.getAllCategoryCanUse();
        if (allCategoryCanUse != null) {
            ServletResp.resp(response, CommonResult.success(allCategoryCanUse));
        }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);
        if (allComments!=null){
            ServletResp.resp(response, CommonPage.success(allComments));
        }else{
            ServletResp.resp(response, CommonResult.failed());
        }

        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("登录失败,账号密码有误!"));
        }

    }

    public void toLogin(HttpServletRequest request, HttpServletResponse response) throws IOException, ServletException {
        request.getRequestDispatcher("front/page/login/login.html").forward(request, response);
    }

    public void toIndex(HttpServletRequest request, HttpServletResponse response) throws IOException, ServletException {
        Integer role = (Integer) request.getSession().getAttribute("role");
        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("注销成功"));

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

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

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

抵扣说明:

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

余额充值