Category

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

Java Books

Development Platform:

Java

ForumTopic.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.  */
  10. import net.acai.forum.*;
  11. import net.acai.database.DBConnect;
  12. import java.sql.ResultSet;
  13. import net.acai.util.*;
  14. import net.acai.filter.*;
  15. public class ForumTopic extends ForumMSG{
  17. String followMSG="-----",followUser="-------",followDateAndTime="-------";
  18. public ForumTopic(){
  19. }
  20. public ForumTopic(int forumRootID){
  21. super();
  22. try{
  23. String sql="select  username,dateandtime,topic,body from bbs.bbs1 where rootid=? and announceid!=? order by announceid desc";
  25. DBConnect dbc=new DBConnect(sql);
  26. dbc.setInt(1,forumRootID);
  27. dbc.setInt(2,forumRootID);
  28. ResultSet rs=dbc.executeQuery();
  29. if(rs.next()){
  30. followUser=rs.getString(1);
  31. followDateAndTime=rs.getString(2);
  32. String followTopic=rs.getString(3);
  33. if(followTopic!=null&&!"".equals(followTopic.trim()))
  34. followMSG=StringUtils.escapeHTMLTags(followTopic);
  35. else{
  36. if(rs.getString(4).length()>24)
  37. followMSG=StringUtils.escapeHTMLTags(rs.getString(4).substring(0,24).replaceAll("\r|\n","").replaceAll(" "," "));
  38. else
  39. followMSG=StringUtils.escapeHTMLTags(rs.getString(4).replaceAll("\r|\n","").replaceAll(" "," "));
  40. }
  41. }
  42. dbc.close();
  43. }
  44. catch(Exception e){
  45. e.printStackTrace();
  46. }
  48. }
  49. public String getNoFilterTopic(){
  51. if(topic!=null&&!"".equals(topic.trim()))
  52. return StringUtils.replace(StringUtils.replace(StringUtils.convertNewlines(StringUtils.escapeHTMLTags(topic))," ","&nbsp;"),"<BR>","");
  53. else{
  55. String tempString="";
  56. if(body.length()>24)
  57. tempString=body.substring(0,24);
  58. else
  59. tempString=body;
  62. return StringUtils.replace(StringUtils.replace(StringUtils.escapeHTMLTags(tempString).replaceAll("\r|\n","&nbsp;")," ","&nbsp;"),"<BR>","");
  65. }
  68. }
  69. public String getTopic(){
  71. if(topic!=null&&!("".equals(topic.trim())))
  72. return (new MyFilter(StringUtils.replace(StringUtils.convertNewlines(StringUtils.escapeHTMLTags(topic))," ","&nbsp;"))).getFilterString();
  73. else{
  74. if(body.length()>24)
  75. return (new MyFilter(StringUtils.replace(StringUtils.convertNewlines(StringUtils.escapeHTMLTags(body.substring(0,24)))," ","&nbsp;"))).getFilterString();
  76. else
  77. return (new MyFilter(StringUtils.replace(StringUtils.convertNewlines(StringUtils.escapeHTMLTags(body))," ","&nbsp;"))).getFilterString();
  79. }
  81. }
  82. public String getFollowMSG(){
  84. return followMSG;
  85. }
  86. public String getFollowUser(){
  87. return followUser;
  88. }
  89. public String getFollowDateAndTime(){
  90. return followDateAndTime;
  91. }
  94. }