KickJava   Java API By Example, From Geeks To Geeks.

Java > Open Source Codes > net > killingar > forum > internal > caches > GroupsCache


1 /* Copyright 2000-2005 Anders Hovmöller
2  *
3  * The person or persons who have associated their work with
4  * this document (the "Dedicator") hereby dedicate the entire
5  * copyright in the work of authorship identified below (the
6  * "Work") to the public domain.
7  *
8  * Dedicator makes this dedication for the benefit of the
9  * public at large and to the detriment of Dedicator's heirs
10  * and successors. Dedicator intends this dedication to be an
11  * overt act of relinquishment in perpetuity of all present
12  * and future rights under copyright law, whether vested or
13  * contingent, in the Work. Dedicator understands that such
14  * relinquishment of all rights includes the relinquishment of
15  * all rights to enforce (by lawsuit or otherwise) those
16  * copyrights in the Work.
17  *
18  * Dedicator recognizes that, once placed in the public
19  * domain, the Work may be freely reproduced, distributed,
20  * transmitted, used, modified, built upon, or otherwise
21  * exploited by anyone for any purpose, commercial or non-
22  * commercial, and in any way, including by methods that have
23  * not yet been invented or conceived.
24  */
25
26 /**
27  * Interface for an item with an ID
28  */
29 package net.killingar.forum.internal.caches;
30
31 import net.killingar.forum.internal.Group;
32 import net.killingar.forum.internal.IDItem;
33
34 import java.sql.Connection JavaDoc;
35 import java.sql.PreparedStatement JavaDoc;
36 import java.sql.ResultSet JavaDoc;
37 import java.sql.SQLException JavaDoc;
38
39 public class GroupsCache extends AbstractNamedItemCache
40 {
41     public synchronized Group getGroup(String JavaDoc groupname) throws SQLException JavaDoc
42     {
43         return (Group)get(groupname);
44     }
45
46     public synchronized Group getGroup(long groupID) throws SQLException JavaDoc
47     {
48         return (Group)get(groupID);
49     }
50
51     protected IDItem getObjectFromRow(ResultSet JavaDoc result) throws SQLException JavaDoc
52     {
53         return getGroupFromRow(result);
54     }
55
56     public static Group getGroupFromRow(ResultSet JavaDoc result) throws SQLException JavaDoc
57     {
58         return new Group(
59             result.getLong("ID"),
60             result.getLong("User"),
61             result.getLong("Access"),
62             result.getString("Name"),
63             result.getString("Type"));
64     }
65
66     protected PreparedStatement JavaDoc createStatement(Connection JavaDoc c) throws SQLException JavaDoc
67     {
68         PreparedStatement JavaDoc statement = c.prepareStatement("select * from Groups where LastChanged > ?");
69
70         statement.setTimestamp(1, latestUpdate);
71
72         return statement;
73     }
74 }
75
Popular Tags