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

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

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

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

适用

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

        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
     * @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

        }
    }
    /**
     * （客户端）搜索功能
     * @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("/admin/*")

        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 {

            }
            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);
            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("文件上传失败"));
        }

/**
 * 用户登录控制器
 */
@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);

     * @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());
        }
    }
}
用户登录控制器：
/**
 * 用户登录控制器
 */

        }
        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
     * @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("注册失败"));

        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
     * @param response
     */
    public void doRegist(HttpServletRequest request, HttpServletResponse response)  {

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

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