jsp servlet mysql实现的新闻发布管理系统项目源码（源码+数据库+截图+视频）.rar

package com.artisan.web; import java.io.File; import java.io.IOException; import java.sql.Connection; import java.util.Iterator; import java.util.List; import javax.servlet.ServletException; import javax.servlet.http.HttpServlet; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; import javax.servlet.http.HttpSession; import net.sf.json.JSONObject; import org.apache.commons.fileupload.FileItem; import org.apache.commons.fileupload.FileItemFactory; import org.apache.commons.fileupload.disk.DiskFileItemFactory; import org.apache.commons.fileupload.servlet.ServletFileUpload; import com.artisan.dao.CommentDao; import com.artisan.dao.NewsDao; import com.artisan.dao.NewsTypeDao; import com.artisan.model.Comment; import com.artisan.model.News; import com.artisan.model.NewsType; import com.artisan.model.PageBean; import com.artisan.util.DateUtil; import com.artisan.util.DbUtil; import com.artisan.util.NavUtil; import com.artisan.util.PageUtil; import com.artisan.util.PropertiesUtil; import com.artisan.util.ResponseUtil; import com.artisan.util.StringUtil; public class NewsServlet extends HttpServlet{ /** * */ private static final long serialVersionUID = 1L; DbUtil dbUtil=new DbUtil(); NewsDao newsDao=new NewsDao(); NewsTypeDao newsTypeDao=new NewsTypeDao(); CommentDao commentDao=new CommentDao(); @Override protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { this.doPost(request, response); } @Override protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { request.setCharacterEncoding("utf-8"); String action=request.getParameter("action"); if("list".equals(action)){ this.newsList(request, response); }else if("show".equals(action)){ this.newsShow(request, response); }else if("preSave".equals(action)){ this.newsPreSave(request, response); }else if("save".equals(action)){ this.newsSave(request, response); }else if("backList".equals(action)){ this.newsBackList(request,response); }else if("delete".equals(action)){ this.newsDelete(request,response); } } private void newsList(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { String typeId=request.getParameter("typeId"); String page=request.getParameter("page"); if(StringUtil.isEmpty(page)){ page="1"; } Connection con=null; News s_news=new News(); if(StringUtil.isNotEmpty(typeId)){ s_news.setTypeId(Integer.parseInt(typeId)); } try{ con=dbUtil.getCon(); int total=newsDao.newsCount(con, s_news,null,null); PageBean pageBean=new PageBean(Integer.parseInt(page),Integer.parseInt(PropertiesUtil.getValue("pageSize"))); List<News> newestNewsListWithType=newsDao.newsList(con, s_news, pageBean,null,null); request.setAttribute("newestNewsListWithType", newestNewsListWithType); String typeName = newsTypeDao.getNewsTypeById(con, typeId).getTypeName(); request.setAttribute("navCode", NavUtil.genNewsListNavigation(typeName, typeId)); request.setAttribute("pageCode", PageUtil.getUpAndDownPagation(total, Integer.parseInt(page), Integer.parseInt(PropertiesUtil.getValue("pageSize")), typeId)); request.setAttribute("mainPage", "news/newsList.jsp"); request.setAttribute("title", typeName); request.getRequestDispatcher("foreground/newsTemp.jsp").forward(request, response); }catch(Exception e){ e.printStackTrace(); }finally{ try { dbUtil.closeCon(con); } catch (Exception e) { // TODO Auto-generated catch block e.printStackTrace(); } } } private void newsShow(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { String newsId=request.getParameter("newsId"); Connection con=null; try{ con=dbUtil.getCon(); newsDao.newsClick(con, newsId); News news=newsDao.getNewsById(con, newsId); Comment s_comment=new Comment(); s_comment.setNewsId(Integer.parseInt(newsId)); List<Comment> commentList=commentDao.commentList(con, s_comment,null,null,null); request.setAttribute("commentList", commentList); request.setAttribute("news", news); request.setAttribute("pageCode", this.genUpAndDownPageCode(newsDao.getUpAndDownPageId(con, newsId))); request.setAttribute("navCode", NavUtil.genNewsNavigation(news.getTypeName(), news.getTypeId()+"",news.getTitle())); request.setAttribute("title", news.getTitle()); request.setAttribute("mainPage", "news/newsShow.jsp"); request.getRequestDispatcher("foreground/newsTemp.jsp").forward(request, response); }catch(Exception e){ e.printStackTrace(); }finally{ try { dbUtil.closeCon(con); } catch (Exception e) { // TODO Auto-generated catch block e.printStackTrace(); } } } private String genUpAndDownPageCode(List<News> upAndDownPage){ News upNews=upAndDownPage.get(0); News downNews=upAndDownPage.get(1); StringBuffer pageCode=new StringBuffer(); if(upNews.getNewsId()==-1){ pageCode.append("<p>上一篇：没有了</p>"); }else{ pageCode.append("<p>上一篇：<a href='news?action=show&newsId="+upNews.getNewsId()+"'>"+upNews.getTitle()+"</a></p>"); } if(downNews.getNewsId()==-1){ pageCode.append("<p>下一篇：没有了</p>"); }else{ pageCode.append("<p>下一篇：<a href='news?action=show&newsId="+downNews.getNewsId()+"'>"+downNews.getTitle()+"</a></p>"); } return pageCode.toString(); } private void newsPreSave(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { String newsId=request.getParameter("newsId"); Connection con=null; try{ con=dbUtil.getCon(); if(StringUtil.isNotEmpty(newsId)){ News news=newsDao.getNewsById(con, newsId); request.setAttribute("news", news); } List<NewsType> newsTypeList=newsTypeDao.newsTypeList(con); request.setAttribute("newsTypeList", newsTypeList); if(StringUtil.isNotEmpty(newsId)){ request.setAttribute("navCode", NavUtil.genNewsManageNavigation("新闻管理", "新闻修改")); }else{ request.setAttribute("navCode", NavUtil.genNewsManageNavigation("新闻管理", "新闻添加")); } request.setAttribute("mainPage", "/background/news/newsSave.jsp"); request.getRequestDispatcher("/background/mainTemp.jsp").forward(request, response); }catch(Exception e){ e.printStackTrace(); }finally{ try { dbUtil.closeCon(con); } catch (Exception e) { // TODO Auto-generated catch block e.printStackTrace(); } } } private void newsSave(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { FileItemFactory factory=new DiskFileItemFactory(); ServletFileUpload upload=new ServletFileUpload(factory); List<FileItem> items=null; try { items=upload.parseRequest(request); } catch (Exception e) { // TODO Auto-generated catch block e.printStackTrace(); } Iterator itr=items.iterator(); News news=new News(); while(itr.hasNext()){ FileItem item=(FileItem) itr.next(); if(item.isFormField()){ String fieldName=item.getFieldName(); if("newsId".equals(fieldName)){ if(StringUtil.isNotEmpty(item.getString("utf-8"))){ news.setNewsId(Integer.parseInt(item.getString("utf-8"))); } } if("title".equals(fieldName)){ news.setTitle(item.getString("utf-8")); } if("content".equals(fieldName)){ news.setContent(item.getString("utf-8")); } if("author".equals(fieldName)){ news.setAuthor(item.getString("utf-8")); } if("typeId".equals(fieldName)){ news.setTypeId(Integer.parseInt(item.getString("utf-8"))); } if("isHead".equals(fieldName)