基于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

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

}

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

/**
 * 评论模块
 */
@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);
        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);

  
    /** 
     * 生成json 
     *  
     * @param object 
     * @return 
     */  
    public static String toJson(Object object) {
        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 {

        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 {
            ServletResp.resp(response, CommonResult.failed());
        }
    }

    /**
     * （管理端|客户端）查看文章详情
     * @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;

            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){
        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());
        }
    }

    /**
     * （管理端）删除文章
     * @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);

    /**
     * 普通用户注册
     * @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{
            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();
        }
    }
}

     */
    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("/admin/*")
public class LoginServlet  extends BaseServlet{

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

/**
 */
@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){
            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 {
            ServletResp.resp(response, CommonResult.failed());
        }
    }

    /**
     * （管理端|客户端）查看文章详情
     * @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())){

        }
    }

    /**
     * (管理端)获取统计数据
     * @param request
     * @param response
     * @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
     * @throws IOException
     */
    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());
            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);

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

    }

}

//@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() {

	}
}

/**
 */

    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 {

    /**
     * （客户端）跳转客户端投稿
     * @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);
        int count = cmsArticleService.changeCheck(article);
        if (count != 0){
            ServletResp.resp(response, CommonResult.success());
        }else {
            ServletResp.resp(response, CommonResult.failed());
        }
    }

    /**
     * (管理端)获取统计数据
     * @param request
     * @param response
     * @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());
        }
    }

    /**
     * 上传文件

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

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

        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");
        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);
        }

            ServletResp.resp(response, CommonResult.success());
        }else {
            ServletResp.resp(response, CommonResult.failed());
        }
    }

    /**
     * (管理端)获取统计数据
     * @param request
     * @param response
     * @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
     * @throws IOException
     */
    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());
            System.out.println(filename);
            SimpleDateFormat sdf = new SimpleDateFormat("yyyyMMddHHmmss");
            String finalname  = sdf.format(new Date()) + str;
            System.out.println("filePath + finalname = " + filePath + finalname);