1 41 package org.mvnforum.phpbb2mvnforum.db; 42 43 import java.sql.Timestamp ; 44 import java.util.Collection ; 45 import java.util.Iterator ; 46 47 import org.w3c.dom.Document ; 48 import org.w3c.dom.Element ; 49 import org.w3c.dom.Node ; 50 51 import net.myvietnam.mvncore.util.StringUtil; 52 53 60 public class PostBean { 61 65 68 public final static int POST_STATUS_DEFAULT = 0; 69 70 73 public final static int POST_STATUS_DISABLED = 1; 74 75 private int postID; 76 private int parentPostID; 77 private int forumID; 78 private int threadID; 79 private int memberID; 80 private String memberName; 81 private String lastEditMemberName; 82 private String postTopic; 83 private String postBody; 84 private Timestamp postCreationDate; 85 private Timestamp postLastEditDate; 86 private String postCreationIP; 87 private String postLastEditIP; 88 private int postEditCount; 89 private int postFormatOption; 90 private int postOption; 91 private int postStatus; 92 private String postIcon; 93 private int postAttachCount; 94 95 public int getPostID() { 96 return postID; 97 } 98 public void setPostID(int postID) { 99 this.postID = postID; 100 } 101 102 public int getParentPostID() { 103 return parentPostID; 104 } 105 public void setParentPostID(int parentPostID) { 106 this.parentPostID = parentPostID; 107 } 108 109 public int getForumID() { 110 return forumID; 111 } 112 public void setForumID(int forumID) { 113 this.forumID = forumID; 114 } 115 116 public int getThreadID() { 117 return threadID; 118 } 119 public void setThreadID(int threadID) { 120 this.threadID = threadID; 121 } 122 123 public int getMemberID() { 124 return memberID; 125 } 126 public void setMemberID(int memberID) { 127 this.memberID = memberID; 128 } 129 130 public String getMemberName() { 131 return memberName; 132 } 133 public void setMemberName(String memberName) { 134 this.memberName = memberName; 135 } 136 137 public String getLastEditMemberName() { 138 return lastEditMemberName; 139 } 140 public void setLastEditMemberName(String lastEditMemberName) { 141 this.lastEditMemberName = StringUtil.getEmptyStringIfNull(lastEditMemberName); 142 } 143 144 public String getPostTopic() { 145 return postTopic; 146 } 147 public void setPostTopic(String postTopic) { 148 this.postTopic = postTopic; 149 } 150 151 public String getPostBody() { 152 return postBody; 153 } 154 public void setPostBody(String postBody) { 155 this.postBody = postBody; 156 } 157 158 public Timestamp getPostCreationDate() { 159 return postCreationDate; 160 } 161 public void setPostCreationDate(Timestamp postCreationDate) { 162 this.postCreationDate = postCreationDate; 163 } 164 165 public Timestamp getPostLastEditDate() { 166 return postLastEditDate; 167 } 168 public void setPostLastEditDate(Timestamp postLastEditDate) { 169 this.postLastEditDate = postLastEditDate; 170 } 171 172 public String getPostCreationIP() { 173 return postCreationIP; 174 } 175 public void setPostCreationIP(String postCreationIP) { 176 this.postCreationIP = postCreationIP; 177 } 178 179 public String getPostLastEditIP() { 180 return postLastEditIP; 181 } 182 public void setPostLastEditIP(String postLastEditIP) { 183 this.postLastEditIP = StringUtil.getEmptyStringIfNull(postLastEditIP); 184 } 185 186 public int getPostEditCount() { 187 return postEditCount; 188 } 189 public void setPostEditCount(int postEditCount) { 190 this.postEditCount = postEditCount; 191 } 192 193 public int getPostFormatOption() { 194 return postFormatOption; 195 } 196 public void setPostFormatOption(int postFormatOption) { 197 this.postFormatOption = postFormatOption; 198 } 199 200 public int getPostOption() { 201 return postOption; 202 } 203 public void setPostOption(int postOption) { 204 this.postOption = postOption; 205 } 206 207 public int getPostStatus() { 208 return postStatus; 209 } 210 public void setPostStatus(int postStatus) { 211 this.postStatus = postStatus; 212 } 213 214 public String getPostIcon() { 215 return postIcon; 216 } 217 public void setPostIcon(String postIcon) { 218 this.postIcon = StringUtil.getEmptyStringIfNull(postIcon); 219 } 220 221 public int getPostAttachCount() { 222 return postAttachCount; 223 } 224 public void setPostAttachCount(int postAttachCount) { 225 this.postAttachCount = postAttachCount; 226 } 227 228 public String getXMLTag() { 229 StringBuffer xml = new StringBuffer (1024); 230 xml.append("<Post"); 231 xml.append(" postID=\"").append(String.valueOf(postID)).append("\""); 232 xml.append(" parentPostID=\"").append(String.valueOf(parentPostID)).append("\""); 233 xml.append(" forumID=\"").append(String.valueOf(forumID)).append("\""); 234 xml.append(" threadID=\"").append(String.valueOf(threadID)).append("\""); 235 xml.append(" memberID=\"").append(String.valueOf(memberID)).append("\""); 236 xml.append(" memberName=\"").append(String.valueOf(memberName)).append("\""); 237 xml.append(" lastEditMemberName=\"").append(String.valueOf(lastEditMemberName)).append("\""); 238 xml.append(" postTopic=\"").append(String.valueOf(postTopic)).append("\""); 239 xml.append(" postBody=\"").append(String.valueOf(postBody)).append("\""); 240 xml.append(" postCreationDate=\"").append(String.valueOf(postCreationDate)).append("\""); 241 xml.append(" postLastEditDate=\"").append(String.valueOf(postLastEditDate)).append("\""); 242 xml.append(" postCreationIP=\"").append(String.valueOf(postCreationIP)).append("\""); 243 xml.append(" postLastEditIP=\"").append(String.valueOf(postLastEditIP)).append("\""); 244 xml.append(" postEditCount=\"").append(String.valueOf(postEditCount)).append("\""); 245 xml.append(" postFormatOption=\"").append(String.valueOf(postFormatOption)).append("\""); 246 xml.append(" postOption=\"").append(String.valueOf(postOption)).append("\""); 247 xml.append(" postStatus=\"").append(String.valueOf(postStatus)).append("\""); 248 xml.append(" postIcon=\"").append(String.valueOf(postIcon)).append("\""); 249 xml.append(" postAttachCount=\"").append(String.valueOf(postAttachCount)).append("\""); 250 xml.append(">"); 251 return xml.toString(); 252 } 253 254 public void getBeanDocument(Document doc, Element element) { 255 Element category = doc.createElement("Category"); 256 element.appendChild(category); 257 258 category.appendChild(getNode(doc, "PostID", String.valueOf(postID))); 259 category.appendChild(getNode(doc, "ParentPostID", String.valueOf(parentPostID))); 260 category.appendChild(getNode(doc, "ForumID", String.valueOf(forumID))); 261 category.appendChild(getNode(doc, "ThreadID", String.valueOf(threadID))); 262 category.appendChild(getNode(doc, "MemberID", String.valueOf(memberID))); 263 category.appendChild(getNode(doc, "MemberName", String.valueOf(memberName))); 264 category.appendChild(getNode(doc, "LastEditMemberName", String.valueOf(lastEditMemberName))); 265 category.appendChild(getNode(doc, "PostTopic", String.valueOf(postTopic))); 266 category.appendChild(getNode(doc, "PostBody", String.valueOf(postBody))); 267 category.appendChild(getNode(doc, "PostCreationDate", String.valueOf(postCreationDate))); 268 category.appendChild(getNode(doc, "PostLastEditDate", String.valueOf(postLastEditDate))); 269 category.appendChild(getNode(doc, "PostCreationIP", String.valueOf(postCreationIP))); 270 category.appendChild(getNode(doc, "PostLastEditIP", String.valueOf(postLastEditIP))); 271 category.appendChild(getNode(doc, "PostEditCount", String.valueOf(postEditCount))); 272 category.appendChild(getNode(doc, "PostFormatOption", String.valueOf(postFormatOption))); 273 category.appendChild(getNode(doc, "PostOption", String.valueOf(postOption))); 274 category.appendChild(getNode(doc, "PostStatus", String.valueOf(postStatus))); 275 category.appendChild(getNode(doc, "PostIcon", String.valueOf(postIcon))); 276 category.appendChild(getNode(doc, "PostAttachCount", String.valueOf(postAttachCount))); 277 } 278 279 public static Node getNode (Document doc, String childName, String childValue ) { 280 Element child = doc.createElement(childName); 281 child.appendChild(doc.createTextNode(childValue)); 282 return child; 283 } 284 285 public String getXML() { 286 StringBuffer xml = new StringBuffer (1024); 287 xml.append("<PostSection>\n"); 288 xml.append(" <Rows>\n"); 289 xml.append(" <Row>\n"); 290 xml.append(" <Column>\n"); 291 xml.append(" <Name>PostID</Name>\n"); 292 xml.append(" <Value>").append(String.valueOf(postID)).append("</Value>\n"); 293 xml.append(" </Column>\n"); 294 xml.append(" <Column>\n"); 295 xml.append(" <Name>ParentPostID</Name>\n"); 296 xml.append(" <Value>").append(String.valueOf(parentPostID)).append("</Value>\n"); 297 xml.append(" </Column>\n"); 298 xml.append(" <Column>\n"); 299 xml.append(" <Name>ForumID</Name>\n"); 300 xml.append(" <Value>").append(String.valueOf(forumID)).append("</Value>\n"); 301 xml.append(" </Column>\n"); 302 xml.append(" <Column>\n"); 303 xml.append(" <Name>ThreadID</Name>\n"); 304 xml.append(" <Value>").append(String.valueOf(threadID)).append("</Value>\n"); 305 xml.append(" </Column>\n"); 306 xml.append(" <Column>\n"); 307 xml.append(" <Name>MemberID</Name>\n"); 308 xml.append(" <Value>").append(String.valueOf(memberID)).append("</Value>\n"); 309 xml.append(" </Column>\n"); 310 xml.append(" <Column>\n"); 311 xml.append(" <Name>MemberName</Name>\n"); 312 xml.append(" <Value>").append(String.valueOf(memberName)).append("</Value>\n"); 313 xml.append(" </Column>\n"); 314 xml.append(" <Column>\n"); 315 xml.append(" <Name>LastEditMemberName</Name>\n"); 316 xml.append(" <Value>").append(String.valueOf(lastEditMemberName)).append("</Value>\n"); 317 xml.append(" </Column>\n"); 318 xml.append(" <Column>\n"); 319 xml.append(" <Name>PostTopic</Name>\n"); 320 xml.append(" <Value>").append(String.valueOf(postTopic)).append("</Value>\n"); 321 xml.append(" </Column>\n"); 322 xml.append(" <Column>\n"); 323 xml.append(" <Name>PostBody</Name>\n"); 324 xml.append(" <Value>").append(String.valueOf(postBody)).append("</Value>\n"); 325 xml.append(" </Column>\n"); 326 xml.append(" <Column>\n"); 327 xml.append(" <Name>PostCreationDate</Name>\n"); 328 xml.append(" <Value>").append(String.valueOf(postCreationDate)).append("</Value>\n"); 329 xml.append(" </Column>\n"); 330 xml.append(" <Column>\n"); 331 xml.append(" <Name>PostLastEditDate</Name>\n"); 332 xml.append(" <Value>").append(String.valueOf(postLastEditDate)).append("</Value>\n"); 333 xml.append(" </Column>\n"); 334 xml.append(" <Column>\n"); 335 xml.append(" <Name>PostCreationIP</Name>\n"); 336 xml.append(" <Value>").append(String.valueOf(postCreationIP)).append("</Value>\n"); 337 xml.append(" </Column>\n"); 338 xml.append(" <Column>\n"); 339 xml.append(" <Name>PostLastEditIP</Name>\n"); 340 xml.append(" <Value>").append(String.valueOf(postLastEditIP)).append("</Value>\n"); 341 xml.append(" </Column>\n"); 342 xml.append(" <Column>\n"); 343 xml.append(" <Name>PostEditCount</Name>\n"); 344 xml.append(" <Value>").append(String.valueOf(postEditCount)).append("</Value>\n"); 345 xml.append(" </Column>\n"); 346 xml.append(" <Column>\n"); 347 xml.append(" <Name>PostFormatOption</Name>\n"); 348 xml.append(" <Value>").append(String.valueOf(postFormatOption)).append("</Value>\n"); 349 xml.append(" </Column>\n"); 350 xml.append(" <Column>\n"); 351 xml.append(" <Name>PostOption</Name>\n"); 352 xml.append(" <Value>").append(String.valueOf(postOption)).append("</Value>\n"); 353 xml.append(" </Column>\n"); 354 xml.append(" <Column>\n"); 355 xml.append(" <Name>PostStatus</Name>\n"); 356 xml.append(" <Value>").append(String.valueOf(postStatus)).append("</Value>\n"); 357 xml.append(" </Column>\n"); 358 xml.append(" <Column>\n"); 359 xml.append(" <Name>PostIcon</Name>\n"); 360 xml.append(" <Value>").append(String.valueOf(postIcon)).append("</Value>\n"); 361 xml.append(" </Column>\n"); 362 xml.append(" <Column>\n"); 363 xml.append(" <Name>PostAttachCount</Name>\n"); 364 xml.append(" <Value>").append(String.valueOf(postAttachCount)).append("</Value>\n"); 365 xml.append(" </Column>\n"); 366 xml.append(" </Row>\n"); 367 xml.append(" </Rows>\n"); 368 xml.append("</PostSection>\n"); 369 return xml.toString(); 370 } 371 372 public static String getXML(Collection objPostBeans) { 373 StringBuffer xml = new StringBuffer (1024); 374 Iterator iterator = objPostBeans.iterator(); 375 xml.append("<PostSection>\n"); 376 xml.append(" <Rows>\n"); 377 while (iterator.hasNext()) { 378 PostBean objPostBean = (PostBean)iterator.next(); 379 xml.append(" <Row>\n"); 380 xml.append(" <Column>\n"); 381 xml.append(" <Name>PostID</Name>\n"); 382 xml.append(" <Value>").append(String.valueOf(objPostBean.postID)).append("</Value>\n"); 383 xml.append(" </Column>\n"); 384 xml.append(" <Column>\n"); 385 xml.append(" <Name>ParentPostID</Name>\n"); 386 xml.append(" <Value>").append(String.valueOf(objPostBean.parentPostID)).append("</Value>\n"); 387 xml.append(" </Column>\n"); 388 xml.append(" <Column>\n"); 389 xml.append(" <Name>ForumID</Name>\n"); 390 xml.append(" <Value>").append(String.valueOf(objPostBean.forumID)).append("</Value>\n"); 391 xml.append(" </Column>\n"); 392 xml.append(" <Column>\n"); 393 xml.append(" <Name>ThreadID</Name>\n"); 394 xml.append(" <Value>").append(String.valueOf(objPostBean.threadID)).append("</Value>\n"); 395 xml.append(" </Column>\n"); 396 xml.append(" <Column>\n"); 397 xml.append(" <Name>MemberID</Name>\n"); 398 xml.append(" <Value>").append(String.valueOf(objPostBean.memberID)).append("</Value>\n"); 399 xml.append(" </Column>\n"); 400 xml.append(" <Column>\n"); 401 xml.append(" <Name>MemberName</Name>\n"); 402 xml.append(" <Value>").append(String.valueOf(objPostBean.memberName)).append("</Value>\n"); 403 xml.append(" </Column>\n"); 404 xml.append(" <Column>\n"); 405 xml.append(" <Name>LastEditMemberName</Name>\n"); 406 xml.append(" <Value>").append(String.valueOf(objPostBean.lastEditMemberName)).append("</Value>\n"); 407 xml.append(" </Column>\n"); 408 xml.append(" <Column>\n"); 409 xml.append(" <Name>PostTopic</Name>\n"); 410 xml.append(" <Value>").append(String.valueOf(objPostBean.postTopic)).append("</Value>\n"); 411 xml.append(" </Column>\n"); 412 xml.append(" <Column>\n"); 413 xml.append(" <Name>PostBody</Name>\n"); 414 xml.append(" <Value>").append(String.valueOf(objPostBean.postBody)).append("</Value>\n"); 415 xml.append(" </Column>\n"); 416 xml.append(" <Column>\n"); 417 xml.append(" <Name>PostCreationDate</Name>\n"); 418 xml.append(" <Value>").append(String.valueOf(objPostBean.postCreationDate)).append("</Value>\n"); 419 xml.append(" </Column>\n"); 420 xml.append(" <Column>\n"); 421 xml.append(" <Name>PostLastEditDate</Name>\n"); 422 xml.append(" <Value>").append(String.valueOf(objPostBean.postLastEditDate)).append("</Value>\n"); 423 xml.append(" </Column>\n"); 424 xml.append(" <Column>\n"); 425 xml.append(" <Name>PostCreationIP</Name>\n"); 426 xml.append(" <Value>").append(String.valueOf(objPostBean.postCreationIP)).append("</Value>\n"); 427 xml.append(" </Column>\n"); 428 xml.append(" <Column>\n"); 429 xml.append(" <Name>PostLastEditIP</Name>\n"); 430 xml.append(" <Value>").append(String.valueOf(objPostBean.postLastEditIP)).append("</Value>\n"); 431 xml.append(" </Column>\n"); 432 xml.append(" <Column>\n"); 433 xml.append(" <Name>PostEditCount</Name>\n"); 434 xml.append(" <Value>").append(String.valueOf(objPostBean.postEditCount)).append("</Value>\n"); 435 xml.append(" </Column>\n"); 436 xml.append(" <Column>\n"); 437 xml.append(" <Name>PostFormatOption</Name>\n"); 438 xml.append(" <Value>").append(String.valueOf(objPostBean.postFormatOption)).append("</Value>\n"); 439 xml.append(" </Column>\n"); 440 xml.append(" <Column>\n"); 441 xml.append(" <Name>PostOption</Name>\n"); 442 xml.append(" <Value>").append(String.valueOf(objPostBean.postOption)).append("</Value>\n"); 443 xml.append(" </Column>\n"); 444 xml.append(" <Column>\n"); 445 xml.append(" <Name>PostStatus</Name>\n"); 446 xml.append(" <Value>").append(String.valueOf(objPostBean.postStatus)).append("</Value>\n"); 447 xml.append(" </Column>\n"); 448 xml.append(" <Column>\n"); 449 xml.append(" <Name>PostIcon</Name>\n"); 450 xml.append(" <Value>").append(String.valueOf(objPostBean.postIcon)).append("</Value>\n"); 451 xml.append(" </Column>\n"); 452 xml.append(" <Column>\n"); 453 xml.append(" <Name>PostAttachCount</Name>\n"); 454 xml.append(" <Value>").append(String.valueOf(objPostBean.postAttachCount)).append("</Value>\n"); 455 xml.append(" </Column>\n"); 456 xml.append(" </Row>\n"); 457 } xml.append(" </Rows>\n"); 459 xml.append("</PostSection>\n"); 460 return xml.toString(); 461 } 462 465 private MemberBean memberBean = null; 466 private Collection attachmentBeans = null; 467 468 public MemberBean getMemberBean() { 469 return memberBean; 470 } 471 public void setMemberBean(MemberBean memberBean) { 472 this.memberBean = memberBean; 473 } 474 475 public Collection getAttachmentBeans() { 476 return attachmentBeans; 477 } 478 public void setAttachmentBeans(Collection attachmentBeans) { 479 this.attachmentBeans = attachmentBeans; 480 } 481 482 } | Popular Tags |