最新JAVA-WEB项目新闻发布管理系统第四篇.doc

《最新JAVA-WEB项目新闻发布管理系统第四篇.doc》由会员分享，可在线阅读，更多相关《最新JAVA-WEB项目新闻发布管理系统第四篇.doc（39页珍藏版）》请在淘文阁 - 分享文档赚钱的网站上搜索。

1、Four short words sum up what has lifted most successful individuals above the crowd: a little bit more.-author-dateJAVA-WEB项目新闻发布管理系统第四篇JAVA-WEB项目新闻发布管理系统第四篇下面实现前台首页，新闻分类（体育新闻，科技新闻等），新闻列表分页。1、首页的jsp代码；java view plaincopyprint?1. 2. 3. 4. 5. 新闻主页6. 7. 8. 9. 10. 11. 12. 13. 14. 15. 16. 17. 18. 19. 20.

2、 21. 22. 23. 24. 25. 26. 27. 28. 29. 30. 31. 32. 33. 34. 新闻主页 2、新闻分类，新闻分页的实现： java view plaincopyprint?1. packagecom.news.action;2. 3. importjava.io.IOException;4. 5. importjavax.servlet.ServletException;6. importjavax.servlet.http.HttpServletRequest;7. importjavax.servlet.http.HttpServletResponse;8

3、. 9. importcom.news.domain.News;10. importcom.news.domain.PageBean;11. importcom.news.domain.QueryInfo;12. importcom.news.service.FrontNewsService;13. importcom.news.utils.WebUtils;14. 15. publicclassFrontNewsActionextendsBaseAction16. publicvoidfindAllNews(HttpServletRequestrequest,HttpServletRespo

4、nseresponse)throwsException17. try18. /synchronized(this) 19. QueryInfoinfo=WebUtils.request2bean(request,QueryInfo.class);20. FrontNewsServiceservice=newFrontNewsService();21. Stringcid=request.getParameter(category_id);22. intcategory_id=0;23. if(cid!=null)24. category_id=Integer.parseInt(cid);25.

5、 26. PageBeanbean=service.pageQuery(info,category_id);27. System.out.println(大小是：+bean.getList().size();28. Stringjsp_Page=/news_jsps/News_All.jsp;29. System.out.println(category_id);30. if(category_id=1)31. jsp_Page=/news_jsps/News_Technology.jsp;32. elseif(category_id=2)33. jsp_Page=/news_jsps/New

6、s_Sports.jsp;34. elseif(category_id=3)35. jsp_Page=/news_jsps/News_Popular.jsp;36. 37. request.setAttribute(pagebean,bean);38. request.getRequestDispatcher(jsp_Page).forward(request,response);39. / 40. 41. catch(Exceptione)42. e.printStackTrace();43. request.setAttribute(message,查看新闻列表失败！);44. reque

7、st.getRequestDispatcher(/message.jsp).forward(request,response);45. 46. 47. publicvoidfindNewsById(HttpServletRequestrequest,HttpServletResponseresponse)throwsException48. try49. Stringnews_id=request.getParameter(news_id);50. FrontNewsServiceservice=newFrontNewsService();51. Newsnews=service.findNe

8、wsById(Integer.parseInt(news_id);52. request.setAttribute(news,news);53. request.getRequestDispatcher(/news_jsps/News_Information.jsp).forward(request,response);54. catch(Exceptione)55. e.printStackTrace();56. request.setAttribute(message,查看新闻失败！);57. request.getRequestDispatcher(/message.jsp).forwa

9、rd(request,response);58. 59. 60. package com.news.action;import java.io.IOException;import javax.servlet.ServletException;import javax.servlet.http.HttpServletRequest;import javax.servlet.http.HttpServletResponse;import com.news.domain.News;import com.news.domain.PageBean;import com.news.domain.Quer

10、yInfo;import com.news.service.FrontNewsService;import com.news.utils.WebUtils;public class FrontNewsAction extends BaseActionpublic void findAllNews(HttpServletRequest request,HttpServletResponse response) throws Exceptiontry/synchronized (this) QueryInfo info=WebUtils.request2bean(request, QueryInf

11、o.class);FrontNewsService service=new FrontNewsService();String cid=request.getParameter(category_id);int category_id=0;if(cid!=null)category_id=Integer.parseInt(cid);PageBean bean= service.pageQuery(info,category_id);System.out.println(大小是：+bean.getList().size();String jsp_Page=/news_jsps/News_All.

12、jsp;System.out.println(category_id);if(category_id=1)jsp_Page=/news_jsps/News_Technology.jsp;else if(category_id=2)jsp_Page=/news_jsps/News_Sports.jsp;else if(category_id=3)jsp_Page=/news_jsps/News_Popular.jsp;request.setAttribute(pagebean, bean);request.getRequestDispatcher(jsp_Page).forward(reques

13、t, response);/catch (Exception e) e.printStackTrace();request.setAttribute(message, 查看新闻列表失败！);request.getRequestDispatcher(/message.jsp).forward(request, response);public void findNewsById(HttpServletRequest request,HttpServletResponse response) throws ExceptiontryString news_id=request.getParamete

14、r(news_id); FrontNewsService service=new FrontNewsService();News news= service.findNewsById(Integer.parseInt(news_id);request.setAttribute(news, news);request.getRequestDispatcher(/news_jsps/News_Information.jsp).forward(request, response);catch (Exception e) e.printStackTrace();request.setAttribute

15、(message, 查看新闻失败！);request.getRequestDispatcher(/message.jsp).forward(request, response);service层： java view plaincopyprint?1. packagecom.news.service;2. 3. importcom.news.dao.FrontNewsDao;4. importcom.news.domain.News;5. importcom.news.domain.PageBean;6. importcom.news.domain.QueryInfo;7. importcom

16、.news.domain.QueryResult;8. 9. publicclassFrontNewsService10. 11. FrontNewsDaodao=newFrontNewsDao();12. publicPageBeanpageQuery(QueryInfoqueryInfo,intcategory_id)throwsException13. 14. /调用dao获得页面数据 15. QueryResultqr=dao.pageQuery(queryInfo.getStartindex(),queryInfo.getPagesize(),category_id);16. /把获

17、得页面数据封装到pagebean里面 17. PageBeanpagebean=newPageBean();18. pagebean.setList(qr.getList();19. pagebean.setTotalrecord(qr.getTotalrecord();20. pagebean.setCurrentpage(queryInfo.getCurrentpage();21. pagebean.setPagesize(queryInfo.getPagesize();22. returnpagebean;23. 24. publicNewsfindNewsById(intnews_id

18、)throwsException25. returndao.findNewsById(news_id);26. 27. package com.news.service;import com.news.dao.FrontNewsDao;import com.news.domain.News;import com.news.domain.PageBean;import com.news.domain.QueryInfo;import com.news.domain.QueryResult;public class FrontNewsService FrontNewsDao dao=new Fro

19、ntNewsDao();public PageBean pageQuery(QueryInfo queryInfo,int category_id) throws Exception/调用dao获得页面数据QueryResult qr= dao.pageQuery(queryInfo.getStartindex(), queryInfo.getPagesize(),category_id);/把获得页面数据封装到pagebean里面PageBean pagebean=new PageBean();pagebean.setList(qr.getList();pagebean.setTotalre

20、cord(qr.getTotalrecord();pagebean.setCurrentpage(queryInfo.getCurrentpage();pagebean.setPagesize(queryInfo.getPagesize();return pagebean;public News findNewsById(int news_id) throws Exception returndao.findNewsById(news_id);dao层： java view plaincopyprint?1. packagecom.news.dao;2. 3. importjava.sql.C

21、onnection;4. importjava.sql.PreparedStatement;5. importjava.sql.ResultSet;6. importjava.util.ArrayList;7. importjava.util.HashMap;8. importjava.util.LinkedList;9. importjava.util.List;10. importjava.util.Map;11. 12. importnet.sf.json.JSONArray;13. 14. importmons.dbutils.DbUtils;15. 16. importcom.new

22、s.domain.Category;17. importcom.news.domain.News;18. importcom.news.domain.QueryResult;19. importcom.news.utils.JdbcUtils;20. 21. publicclassFrontNewsDao22. publicQueryResultpageQuery(intstartindex,intpagesize,intcategory_id)throwsException23. 24. Connectionconn=null;25. PreparedStatementst=null;26.

23、 ResultSetrs=null;27. QueryResultqr=newQueryResult();28. try29. conn=JdbcUtils.getConnection();30. Stringsql=select*fromtb_newsorderbyiddesclimit?,?;31. System.out.println(分类id：+category_id);32. if(category_id0)33. sql=select*fromtb_newswherecategory_id=?orderbyiddesclimit?,?;34. 35. st=conn.prepare

24、Statement(sql);36. if(category_id0)37. st.setInt(1,category_id);38. st.setInt(2,startindex);39. st.setInt(3,pagesize);40. else41. st.setInt(1,startindex);42. st.setInt(2,pagesize);43. 44. rs=st.executeQuery();45. Listlist=newLinkedList();46. while(rs.next()47. 48. Newsn=newNews();49. n.setTitle(rs.g

25、etString(title);50. n.setContent(rs.getString(content);51. n.setNews_id(rs.getInt(id);52. n.setDate(rs.getDate(date);53. n.setCategory(newCategory(rs.getInt(category_id),null);54. list.add(n);55. 56. if(category_id0)57. sql=selectcount(*)fromtb_newswherecategory_id=?;58. else59. sql=selectcount(*)fr

26、omtb_news;60. 61. st=conn.prepareStatement(sql);62. if(category_id0)63. st.setInt(1,category_id);64. 65. rs=st.executeQuery();66. if(rs.next()67. 68. qr.setTotalrecord(rs.getInt(1);69. 70. qr.setList(list);71. returnqr;72. catch(Exceptione)73. /TODOAuto-generatedcatchblock 74. thrownewException(e);7

27、5. finally76. DbUtils.closeQuietly(conn,st,rs);77. 78. 79. publicNewsfindNewsById(intnews_id)throwsException80. Connectionconn=null;81. PreparedStatementst=null;82. ResultSetrs=null;83. try84. conn=JdbcUtils.getConnection();85. Stringsql=select*fromtb_newswhereid=?;86. st=conn.prepareStatement(sql);87. st.setInt(1,news_id);88. rs=st.executeQuery();89. Newsn=newNews();90. if(rs.next()91. 92. 93. n.setTitle(rs.getString(title);94. n.setContent(rs.getString(content);95. n.setNews_id(rs.getInt(id);96. n.setDate(r