Category

Development Platform
Home > E-Books > Java Books > View Code
ForumNewsManager.java
Package: 第4章 BBS论坛系统.rar　[view]
Upload User: yuyunping
Upload Date: 2013-03-21
Package Size: 1844k
Code Size: 2k
Category:

Java Books

Development Platform:

Java

ForumNewsManager.java：Code Content
  1. package net.acai.forum;
  2. /**
  3.  * Title:        清清网络
  4.  * Description:
  5.  * Copyright:    Copyright (c) 2002
  6.  * Company:      www.SuperSpace.com
  7.  * @author:       SuperSpace
  8.  * @version 1.0
  9.  */
  12. import net.acai.forum.ForumNewsNotFoundException;
  13. import net.acai.database.*;
  14. import java.util.Vector;
  15. import java.sql.*;
  16. public class ForumNewsManager{
  18. public static ForumNews getForumNews(int forumID)
  19. throws ForumNewsNotFoundException{
  20. try{
  21. ForumNews temp=new ForumNews(forumID);
  22. return temp;
  23. }
  24. catch(Exception e)
  25. {
  26. throw new ForumNewsNotFoundException();
  27. }
  30. }
  31. public static ForumNews getSignalForumNews(int newsID) throws Exception{
  34. DBConnect dbc=new DBConnect("select * from bbs.bbsnews where id="+newsID);
  35. ResultSet rs=dbc.executeQuery();
  36. rs.next();
  37. ForumNews forumNews=new ForumNews();
  39. forumNews.setId(rs.getInt(1));
  40. forumNews.setBoardid(rs.getInt(2));
  41. forumNews.setTitle(rs.getString(3));
  42. forumNews.setContent(rs.getString(4));
  43. forumNews.setUserName(rs.getString(5));
  44. forumNews.setAddTime(rs.getString(6));
  46. return forumNews;
  47. }
  48. public static Vector getForumNewsVector() throws Exception{
  49. DBConnect dbc=new DBConnect("select * from bbs.bbsnews  order by id desc");
  50. ResultSet rs=dbc.executeQuery();
  51. Vector forumNewsVector=new Vector();
  52. while(rs.next()){
  53. ForumNews forumNews=new ForumNews();
  55. forumNews.setId(rs.getInt(1));
  56. forumNews.setBoardid(rs.getInt(2));
  57. forumNews.setTitle(rs.getString(3));
  58. forumNews.setContent(rs.getString(4));
  59. forumNews.setUserName(rs.getString(5));
  60. forumNews.setAddTime(rs.getString(6));
  63. forumNewsVector.add(forumNews);
  65. }
  66. dbc.close();
  67. return forumNewsVector;
  68. }
  69. public static Vector getForumNewsVector(int forumID) throws Exception{
  70. DBConnect dbc=new DBConnect("select * from bbs.bbsnews where boardID="+forumID+" order by id desc");
  71. ResultSet rs=dbc.executeQuery();
  72. Vector forumNewsVector=new Vector();
  73. while(rs.next()){
  74. ForumNews forumNews=new ForumNews();
  76. forumNews.setId(rs.getInt(1));
  77. forumNews.setBoardid(rs.getInt(2));
  78. forumNews.setTitle(rs.getString(3));
  79. forumNews.setContent(rs.getString(4));
  80. forumNews.setUserName(rs.getString(5));
  81. forumNews.setAddTime(rs.getString(6));
  84. forumNewsVector.add(forumNews);
  86. }
  87. dbc.close();
  88. return forumNewsVector;
  89. }
  91. }