groupsbean.java

easy to use, easy to setup bulletin board (forum)

/*
 * Copyright (C) 2002 by MyVietnam.net
 *
 * This program is free software; you can redistribute it and/or
 * modify it under the terms of the GNU General Public License
 * as published by the Free Software Foundation; either version 2
 * of the License, or any later version.
 *
 * All copyright notices regarding mvnForum
 * must remain intact in the scripts and in the outputted HTML
 * The "powered by" text/logo with a link back to
 * http://www.mvnForum.com and http://www.MyVietnam.net in the footer of the pages MUST
 * remain visible when the pages are viewed on the internet or intranet.
 *
 * This program is distributed in the hope that it will be useful,
 * but WITHOUT ANY WARRANTY; without even the implied warranty of
 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
 * GNU General Public License for more details.
 *
 * You should have received a copy of the GNU General Public License
 * along with this program; if not, write to the Free Software
 * Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA  02111-1307, USA.
 *
 * Support can be obtained from support forums at:
 * http://www.mvnForum.com/mvnforum/index
 *
 * Correspondence and Marketing Questions can be sent to:
 * [e-mail]
 *
 * @author: Minh Nguyen  [e-mail]
 * @author: Mai  Nguyen  [e-mail]
 */
package net.myvietnam.mvnplugin.mvnforum.db;

import java.sql.*;
import java.util.Collection;//for xml support
import java.util.Iterator;//for xml support

/*
 * Included columns: GroupID, GroupOwnerID, GroupOwnerName, GroupName, GroupDesc,
 *                   GroupOption, GroupCreationDate, GroupModifiedDate
 * Excluded columns:
 */
public class GroupsBean {
    private int groupID;
    private int groupOwnerID;
    private String groupOwnerName;
    private String groupName;
    private String groupDesc;
    private int groupOption;
    private Timestamp groupCreationDate;
    private Timestamp groupModifiedDate;

    public int getGroupID() {
        return groupID;
    }
    public void setGroupID(int groupID) {
        this.groupID = groupID;
    }

    public int getGroupOwnerID() {
        return groupOwnerID;
    }
    public void setGroupOwnerID(int groupOwnerID) {
        this.groupOwnerID = groupOwnerID;
    }

    public String getGroupOwnerName() {
        return groupOwnerName;
    }
    public void setGroupOwnerName(String groupOwnerName) {
        this.groupOwnerName = groupOwnerName;
    }

    public String getGroupName() {
        return groupName;
    }
    public void setGroupName(String groupName) {
        this.groupName = groupName;
    }

    public String getGroupDesc() {
        return groupDesc;
    }
    public void setGroupDesc(String groupDesc) {
        this.groupDesc = groupDesc;
    }

    public int getGroupOption() {
        return groupOption;
    }
    public void setGroupOption(int groupOption) {
        this.groupOption = groupOption;
    }

    public Timestamp getGroupCreationDate() {
        return groupCreationDate;
    }
    public void setGroupCreationDate(Timestamp groupCreationDate) {
        this.groupCreationDate = groupCreationDate;
    }

    public Timestamp getGroupModifiedDate() {
        return groupModifiedDate;
    }
    public void setGroupModifiedDate(Timestamp groupModifiedDate) {
        this.groupModifiedDate = groupModifiedDate;
    }

    public String getXML() {
        StringBuffer xml = new StringBuffer(1024);
        xml.append("<GroupsSection>\n");
        xml.append("  <Rows>\n");
        xml.append("    <Row>\n");
        xml.append("      <Column>\n");
        xml.append("        <Name>GroupID</Name>\n");
        xml.append("        <Value>").append(String.valueOf(groupID)).append("</Value>\n");
        xml.append("      </Column>\n");
        xml.append("      <Column>\n");
        xml.append("        <Name>GroupOwnerID</Name>\n");
        xml.append("        <Value>").append(String.valueOf(groupOwnerID)).append("</Value>\n");
        xml.append("      </Column>\n");
        xml.append("      <Column>\n");
        xml.append("        <Name>GroupOwnerName</Name>\n");
        xml.append("        <Value>").append(String.valueOf(groupOwnerName)).append("</Value>\n");
        xml.append("      </Column>\n");
        xml.append("      <Column>\n");
        xml.append("        <Name>GroupName</Name>\n");
        xml.append("        <Value>").append(String.valueOf(groupName)).append("</Value>\n");
        xml.append("      </Column>\n");
        xml.append("      <Column>\n");
        xml.append("        <Name>GroupDesc</Name>\n");
        xml.append("        <Value>").append(String.valueOf(groupDesc)).append("</Value>\n");
        xml.append("      </Column>\n");
        xml.append("      <Column>\n");
        xml.append("        <Name>GroupOption</Name>\n");
        xml.append("        <Value>").append(String.valueOf(groupOption)).append("</Value>\n");
        xml.append("      </Column>\n");
        xml.append("      <Column>\n");
        xml.append("        <Name>GroupCreationDate</Name>\n");
        xml.append("        <Value>").append(String.valueOf(groupCreationDate)).append("</Value>\n");
        xml.append("      </Column>\n");
        xml.append("      <Column>\n");
        xml.append("        <Name>GroupModifiedDate</Name>\n");
        xml.append("        <Value>").append(String.valueOf(groupModifiedDate)).append("</Value>\n");
        xml.append("      </Column>\n");
        xml.append("    </Row>\n");
        xml.append("  </Rows>\n");
        xml.append("</GroupsSection>\n");
        return xml.toString();
    }

    public static String getXML(Collection objGroupsBeans) {
        StringBuffer xml = new StringBuffer(1024);
        Iterator iterator = objGroupsBeans.iterator();
        xml.append("<GroupsSection>\n");
        xml.append("  <Rows>\n");
        while (iterator.hasNext()) {
            GroupsBean objGroupsBean = (GroupsBean)iterator.next();
            xml.append("    <Row>\n");
            xml.append("      <Column>\n");
            xml.append("        <Name>GroupID</Name>\n");
            xml.append("        <Value>").append(String.valueOf(objGroupsBean.groupID)).append("</Value>\n");
            xml.append("      </Column>\n");
            xml.append("      <Column>\n");
            xml.append("        <Name>GroupOwnerID</Name>\n");
            xml.append("        <Value>").append(String.valueOf(objGroupsBean.groupOwnerID)).append("</Value>\n");
            xml.append("      </Column>\n");
            xml.append("      <Column>\n");
            xml.append("        <Name>GroupOwnerName</Name>\n");
            xml.append("        <Value>").append(String.valueOf(objGroupsBean.groupOwnerName)).append("</Value>\n");
            xml.append("      </Column>\n");
            xml.append("      <Column>\n");
            xml.append("        <Name>GroupName</Name>\n");
            xml.append("        <Value>").append(String.valueOf(objGroupsBean.groupName)).append("</Value>\n");
            xml.append("      </Column>\n");
            xml.append("      <Column>\n");
            xml.append("        <Name>GroupDesc</Name>\n");
            xml.append("        <Value>").append(String.valueOf(objGroupsBean.groupDesc)).append("</Value>\n");
            xml.append("      </Column>\n");
            xml.append("      <Column>\n");
            xml.append("        <Name>GroupOption</Name>\n");
            xml.append("        <Value>").append(String.valueOf(objGroupsBean.groupOption)).append("</Value>\n");
            xml.append("      </Column>\n");
            xml.append("      <Column>\n");
            xml.append("        <Name>GroupCreationDate</Name>\n");
            xml.append("        <Value>").append(String.valueOf(objGroupsBean.groupCreationDate)).append("</Value>\n");
            xml.append("      </Column>\n");
            xml.append("      <Column>\n");
            xml.append("        <Name>GroupModifiedDate</Name>\n");
            xml.append("        <Value>").append(String.valueOf(objGroupsBean.groupModifiedDate)).append("</Value>\n");
            xml.append("      </Column>\n");
            xml.append("    </Row>\n");
        }//while
        xml.append("  </Rows>\n");
        xml.append("</GroupsSection>\n");
        return xml.toString();
    }
} //end of class GroupsBean