JavaWeb新闻管理系统 tomcat idea navicat

package com.news.web; import com.alibaba.fastjson.JSON; import com.news.entity.Comment; import com.news.entity.News; import com.news.service.CommentService; import com.news.service.NewsService; import com.news.service.impl.CommentServiceimpl; import com.news.service.impl.NewsServiceimpl; import com.news.util.page; 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 javax.servlet.ServletException; import javax.servlet.annotation.WebServlet; import javax.servlet.http.HttpServlet; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; import java.io.File; import java.io.IOException; import java.io.PrintWriter; import java.text.DateFormat; import java.text.SimpleDateFormat; import java.util.Arrays; import java.util.Iterator; import java.util.List; @WebServlet(name = "NewsServlet",urlPatterns = "/NewsServlet") public class NewsServlet extends HttpServlet { @Override protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { response.setContentType("text/html;charset=utf-8"); request.setCharacterEncoding("utf-8"); PrintWriter out=response.getWriter(); String opr = request.getParameter("opr"); request.setCharacterEncoding("utf-8"); NewsService newsService=new NewsServiceimpl();//调用业务层 List<News> list=newsService.findAllNews(); CommentService commentService=new CommentServiceimpl(); String contextPath=request.getContextPath(); if("list".equals(opr)){//显示新闻列表 // NewsDao dao=new NewsDaoimpl(); // List<News> allnews=dao.getAllnews(); //// request.setAttribute("list",allnews); //// response.sendRedirect("../newspages/admin.jsp"); // News news=null; // StringBuffer newsJSON=new StringBuffer("["); // for(int i=0;i<list.size();){ // news=list.get(i); // newsJSON.append("{\"nid\":"+news.getNid()+","); // newsJSON.append("\"ntitle\":\""+news.getNtitle().replace("\"","&quot;")+"\","); // newsJSON.append("\"nauthor\":\""+news.getNauthor().replace("\"","&quto;")+"\"}"); // if((++i)==allnews.size()){ // break; // }else { // newsJSON.append(","); // } // newsJSON.append("]"); // out.print(newsJSON); // out.close(); String newsJSON= JSON.toJSONString(list); out.print(newsJSON); }else if("listHtml".equals(opr)){ // List<News> list1 = newsService.findAllNews(); request.setAttribute("list", list); request.getRequestDispatcher("/newspages/showNews.jsp").forward(request, response); // News news=null; // StringBuffer newsLisit=new StringBuffer(""); // for(int i=0;i<list.size();){ // news=list.get(i); // newsLisit.append("<li>"+news.getNtitle()+"<span> 作者：" // + news.getNauthor()+"&nbsp;&nbsp;&nbsp;&nbsp;" // + "<a href='#'>修改</a>&nbsp;&nbsp;&nbsp;&nbsp;" // + "<a href='#' onclick='return clickdel()'>删除</a>" // + "</span></li>" // ); // if((++i)%5==0){ // newsLisit.append("<li class='space'></li>"); // } // } // out.print(newsLisit); }else if("listTitle".equals(opr)) { List<News> list1=null; String pageIndex=request.getParameter("pageIndex");//获得当前页数 if(pageIndex==null){ pageIndex="1"; } int currPageNo=Integer.parseInt(pageIndex);//获得当前页数 if(currPageNo<1) currPageNo=1; page pageObj=new page();//创建分页类对象 pageObj.setCurrPageNO(currPageNo);//设置当前页码 pageObj.setPageSize(10);//设置每页显示条数 newsService.findpageNews(pageObj);//分页查询新闻 list1=pageObj.getNewsList();//获取全部新闻 request.setAttribute("list",list1);//中间的新闻 request.setAttribute("pageObj",pageObj);//封装分页类对象 request.getRequestDispatcher("../index.jsp").forward(request,response); }else if("readNew".equals(opr)){ String nid=request.getParameter("nid"); News news =newsService.findNewsByNid(Integer.parseInt(nid)); List<Comment> comments= commentService.findCommentsByNid(Integer.parseInt(nid)); news.setComments(comments); request.getSession().setAttribute("news",news); response.sendRedirect(contextPath+"/newspages/news_read.jsp"); }else if("addComment".equals(opr)){ String cauthor=request.getParameter("cauthor"); String cnid=request.getParameter("nid"); String cip=request.getParameter("cip"); String ccontent=request.getParameter("ccontent"); Comment comment=new Comment(); comment.setCnid(Integer.parseInt(cnid)); comment.setCcontent(ccontent); comment.setCdate(new java.util.Date()); comment.setCip(cip); comment.setCauthor(cauthor); String result=""; try { commentService.addComment(comment); result="success"; }catch (Exception e){ result="评论添加失败！"; } DateFormat df=new SimpleDateFormat("yyyy-MM-dd HH:mm:ss"); out.print("[{\"result\":\""+result+"\",\"cdate\":\""+df.format(comment.getCdate())+"\"}]"); }else if("toAddNews".equals(opr)){ request.getRequestDispatcher("/newspages/news_add.jsp").forward(request,response); }else if("addNews".equals(opr)){//添加新闻 News news=new News(); String fieldName="";//表单字段元素的name属性值 //请求信息中的内容是否是multipart类型 boolean isMultipart= ServletFileUpload.isMultipartContent(request); //上传文件的存储路径（服务器文件系统上的绝对文件路径） String uploadFilePath = request.getServletContext().getRealPath("upload"); if (isMultipart) { FileItemFactory factory = new DiskFileItemFactory(); ServletFileUpload upload = new ServletFileUpload(factory); upload.setSizeMax(1024*1024*5); //解析form表单中所有文件 try { List<FileItem> items = upload.parseRequest(request); Iterator<FileItem> iter = items.iterator(); FileItem item = null; boolean isUnallowedType = false; // 是否为不允许的类型 File saveFile = null; // 上传并保存的文件 while (iter.hasNext()) { //依次处理每个文件 item = iter.next(); if (item.isFormField()) { //普通表单字段 fieldName = item.getFieldName(); //表单字段的name属性值 if (fieldName.equals("ntid")) { //主题 news.setNtid(Integer.parseInt(item .getString("UTF-8"))); } else if (fieldName.equals("ntitle")) { //标题 new