KickJava   Java API By Example, From Geeks To Geeks.

Java > Open Source Codes > org > mvnforum > phpbb2mvnforum > db > PostBean


1 /*
2  * $Header: /cvsroot/mvnforum/mvnforum/contrib/phpbb2mvnforum/src/org/mvnforum/phpbb2mvnforum/db/PostBean.java,v 1.2 2006/04/15 03:57:15 minhnn Exp $
3  * $Author: minhnn $
4  * $Revision: 1.2 $
5  * $Date: 2006/04/15 03:57:15 $
6  *
7  * ====================================================================
8  *
9  * Copyright (C) 2002-2006 by MyVietnam.net
10  *
11  * All copyright notices regarding mvnForum MUST remain
12  * intact in the scripts and in the outputted HTML.
13  * The "powered by" text/logo with a link back to
14  * http://www.mvnForum.com and http://www.MyVietnam.net in
15  * the footer of the pages MUST remain visible when the pages
16  * are viewed on the internet or intranet.
17  *
18  * This program is free software; you can redistribute it and/or modify
19  * it under the terms of the GNU General Public License as published by
20  * the Free Software Foundation; either version 2 of the License, or
21  * any later version.
22  *
23  * This program is distributed in the hope that it will be useful,
24  * but WITHOUT ANY WARRANTY; without even the implied warranty of
25  * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
26  * GNU General Public License for more details.
27  *
28  * You should have received a copy of the GNU General Public License
29  * along with this program; if not, write to the Free Software
30  * Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA
31  *
32  * Support can be obtained from support forums at:
33  * http://www.mvnForum.com/mvnforum/index
34  *
35  * Correspondence and Marketing Questions can be sent to:
36  * info at MyVietnam net
37  *
38  * @author: Minh Nguyen
39  * @author: Mai Nguyen
40  */

41 package org.mvnforum.phpbb2mvnforum.db;
42
43 import java.sql.Timestamp JavaDoc;
44 import java.util.Collection JavaDoc;
45 import java.util.Iterator JavaDoc;
46
47 import org.w3c.dom.Document JavaDoc;
48 import org.w3c.dom.Element JavaDoc;
49 import org.w3c.dom.Node JavaDoc;
50
51 import net.myvietnam.mvncore.util.StringUtil;
52
53 /*
54  * Included columns: PostID, ParentPostID, ForumID, ThreadID, MemberID,
55  * MemberName, LastEditMemberName, PostTopic, PostBody, PostCreationDate,
56  * PostLastEditDate, PostCreationIP, PostLastEditIP, PostEditCount, PostFormatOption,
57  * PostOption, PostStatus, PostIcon, PostAttachCount
58  * Excluded columns:
59  */

60 public class PostBean {
61     /*************************************************************************
62      * NOTE: below constants MUST NOT be changed IN ALL CASES,
63      * or it will break the compatibility
64      *************************************************************************/

65     /**
66      * The default value mean post is enable and normal
67      */

68     public final static int POST_STATUS_DEFAULT = 0;
69
70     /**
71      * The disable post is invisible for normal user and visible to moderator
72      */

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 JavaDoc memberName;
81     private String JavaDoc lastEditMemberName;
82     private String JavaDoc postTopic;
83     private String JavaDoc postBody;
84     private Timestamp JavaDoc postCreationDate;
85     private Timestamp JavaDoc postLastEditDate;
86     private String JavaDoc postCreationIP;
87     private String JavaDoc postLastEditIP;
88     private int postEditCount;
89     private int postFormatOption;
90     private int postOption;
91     private int postStatus;
92     private String JavaDoc 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 JavaDoc getMemberName() {
131         return memberName;
132     }
133     public void setMemberName(String JavaDoc memberName) {
134         this.memberName = memberName;
135     }
136
137     public String JavaDoc getLastEditMemberName() {
138         return lastEditMemberName;
139     }
140     public void setLastEditMemberName(String JavaDoc lastEditMemberName) {
141         this.lastEditMemberName = StringUtil.getEmptyStringIfNull(lastEditMemberName);
142     }
143
144     public String JavaDoc getPostTopic() {
145         return postTopic;
146     }
147     public void setPostTopic(String JavaDoc postTopic) {
148         this.postTopic = postTopic;
149     }
150
151     public String JavaDoc getPostBody() {
152         return postBody;
153     }
154     public void setPostBody(String JavaDoc postBody) {
155         this.postBody = postBody;
156     }
157
158     public Timestamp JavaDoc getPostCreationDate() {
159         return postCreationDate;
160     }
161     public void setPostCreationDate(Timestamp JavaDoc postCreationDate) {
162         this.postCreationDate = postCreationDate;
163     }
164
165     public Timestamp JavaDoc getPostLastEditDate() {
166         return postLastEditDate;
167     }
168     public void setPostLastEditDate(Timestamp JavaDoc postLastEditDate) {
169         this.postLastEditDate = postLastEditDate;
170     }
171
172     public String JavaDoc getPostCreationIP() {
173         return postCreationIP;
174     }
175     public void setPostCreationIP(String JavaDoc postCreationIP) {
176         this.postCreationIP = postCreationIP;
177     }
178
179     public String JavaDoc getPostLastEditIP() {
180         return postLastEditIP;
181     }
182     public void setPostLastEditIP(String JavaDoc 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 JavaDoc getPostIcon() {
215         return postIcon;
216     }
217     public void setPostIcon(String JavaDoc 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 JavaDoc getXMLTag() {
229         StringBuffer JavaDoc xml = new StringBuffer JavaDoc(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 JavaDoc doc, Element JavaDoc element) {
255         Element JavaDoc 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 JavaDoc getNode (Document JavaDoc doc, String JavaDoc childName, String JavaDoc childValue ) {
280         Element JavaDoc child = doc.createElement(childName);
281         child.appendChild(doc.createTextNode(childValue));
282         return child;
283     }
284
285     public String JavaDoc getXML() {
286         StringBuffer JavaDoc xml = new StringBuffer JavaDoc(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 JavaDoc getXML(Collection JavaDoc objPostBeans) {
373         StringBuffer JavaDoc xml = new StringBuffer JavaDoc(1024);
374         Iterator JavaDoc 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         }//while
458
xml.append(" </Rows>\n");
459         xml.append("</PostSection>\n");
460         return xml.toString();
461     }
462     /************************************************
463      * Customized methods come below
464      ************************************************/

465     private MemberBean memberBean = null;
466     private Collection JavaDoc 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 JavaDoc getAttachmentBeans() {
476         return attachmentBeans;
477     }
478     public void setAttachmentBeans(Collection JavaDoc attachmentBeans) {
479         this.attachmentBeans = attachmentBeans;
480     }
481
482 } //end of class PostBean
483
Popular Tags