1.1 --- a/trunk/com/so/news/storage/Group.java Tue Jan 20 10:21:03 2009 +0100
1.2 +++ /dev/null Thu Jan 01 00:00:00 1970 +0000
1.3 @@ -1,142 +0,0 @@
1.4 -/*
1.5 - * StarOffice News Server
1.6 - * see AUTHORS for the list of contributors
1.7 - *
1.8 - * This program is free software: you can redistribute it and/or modify
1.9 - * it under the terms of the GNU General Public License as published by
1.10 - * the Free Software Foundation, either version 3 of the License, or
1.11 - * (at your option) any later version.
1.12 - *
1.13 - * This program is distributed in the hope that it will be useful,
1.14 - * but WITHOUT ANY WARRANTY; without even the implied warranty of
1.15 - * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
1.16 - * GNU General Public License for more details.
1.17 - *
1.18 - * You should have received a copy of the GNU General Public License
1.19 - * along with this program. If not, see <http://www.gnu.org/licenses/>.
1.20 - */
1.21 -
1.22 -package com.so.news.storage;
1.23 -
1.24 -import java.sql.ResultSet;
1.25 -import java.sql.SQLException;
1.26 -import java.util.ArrayList;
1.27 -import java.util.List;
1.28 -import com.so.news.Debug;
1.29 -
1.30 -/**
1.31 - * Represents a logical Group within this newsserver.
1.32 - * @author Christian Lins
1.33 - */
1.34 -public class Group
1.35 -{
1.36 - private long id;
1.37 - private String name;
1.38 -
1.39 - /**
1.40 - * Private constructor.
1.41 - * @param name
1.42 - * @param id
1.43 - */
1.44 - Group(String name, long id)
1.45 - {
1.46 - this.id = id;
1.47 - this.name = name;
1.48 - }
1.49 -
1.50 - /**
1.51 - * Returns a Group identified by its full name.
1.52 - * @param name
1.53 - * @return
1.54 - */
1.55 - public static Group getByName(String name)
1.56 - {
1.57 - try
1.58 - {
1.59 - return Database.getInstance().getGroup(name);
1.60 - }
1.61 - catch(SQLException ex)
1.62 - {
1.63 - System.err.println(ex.getLocalizedMessage());
1.64 - ex.printStackTrace(Debug.getInstance().getStream());
1.65 - return null;
1.66 - }
1.67 - }
1.68 -
1.69 - /**
1.70 - * Returns a list of all groups this server handles.
1.71 - * @return
1.72 - */
1.73 - public static ArrayList<Group> getAll()
1.74 - {
1.75 - ArrayList<Group> buffer = new ArrayList<Group>();
1.76 -
1.77 - try
1.78 - {
1.79 - ResultSet rs = Database.getInstance().getGroups();
1.80 -
1.81 - while(rs.next())
1.82 - {
1.83 - String name = rs.getString("name");
1.84 - long id = rs.getLong("group_id");
1.85 -
1.86 - Group group = new Group(name, id);
1.87 - buffer.add(group);
1.88 - }
1.89 - }
1.90 - catch(SQLException ex)
1.91 - {
1.92 - ex.printStackTrace(Debug.getInstance().getStream());
1.93 - System.err.println(ex.getLocalizedMessage());
1.94 - }
1.95 -
1.96 - return buffer;
1.97 - }
1.98 -
1.99 - public List<Article> getAllArticles()
1.100 - throws SQLException
1.101 - {
1.102 - return getAllArticles(getFirstArticle(), getLastArticle());
1.103 - }
1.104 -
1.105 - public List<Article> getAllArticles(int first, int last)
1.106 - {
1.107 - return null;
1.108 - }
1.109 -
1.110 - public int getFirstArticle()
1.111 - throws SQLException
1.112 - {
1.113 - return Database.getInstance().getFirstArticleNumber(this);
1.114 - }
1.115 -
1.116 - public long getID()
1.117 - {
1.118 - return id;
1.119 - }
1.120 -
1.121 - public int getLastArticle()
1.122 - throws SQLException
1.123 - {
1.124 - return Database.getInstance().getLastArticleNumber(this);
1.125 - }
1.126 -
1.127 - public String getName()
1.128 - {
1.129 - return name;
1.130 - }
1.131 -
1.132 - public void setName(String name)
1.133 - {
1.134 - this.name = name;
1.135 - }
1.136 -
1.137 - public int getEstimatedArticleCount()
1.138 - throws SQLException
1.139 - {
1.140 - if (getLastArticle() < getFirstArticle())
1.141 - return 0;
1.142 - return getLastArticle() - getFirstArticle() + 1;
1.143 - }
1.144 -
1.145 -}