KickJava   Java API By Example, From Geeks To Geeks.

Java > Open Source Codes > org > jresearch > gossip > dao > drivers > generic > GenericSqlUserQueries


1 /*
2  * $Id: GenericSqlUserQueries.java,v 1.3 2005/06/07 12:32:24 bel70 Exp $
3  *
4  * ***** BEGIN LICENSE BLOCK *****
5  * The contents of this file are subject to the Mozilla Public License
6  * Version 1.1 (the "License"); you may not use this file except in
7  * compliance with the License. You may obtain a copy of the License
8  * at http://www.mozilla.org/MPL/
9  *
10  * Software distributed under the License is distributed on an "AS IS"
11  * basis, WITHOUT WARRANTY OF ANY KIND, either express or implied. See
12  * the License for the specific language governing rights and
13  * limitations under the License.
14  *
15  * The Original Code is JGossip forum code.
16  *
17  * The Initial Developer of the Original Code is the JResearch, Org.
18  * Portions created by the Initial Developer are Copyright (C) 2004
19  * the Initial Developer. All Rights Reserved.
20  *
21  * Contributor(s):
22  * Alexey Pavlov <alexnet@users.sourceforge.net>
23  *
24  * ***** END LICENSE BLOCK ***** */

25 package org.jresearch.gossip.dao.drivers.generic;
26
27 import org.jresearch.gossip.dao.drivers.UserQueries;
28
29 /**
30  * OracleUserQueries
31  *
32  * @author <a HREF="alexnet@sourceforge.net">A. Pavlov</a>
33  * @version $version$ 21.03.2004
34  */

35 class GenericSqlUserQueries extends UserQueries {
36
37     /**
38      * @see org.jresearch.gossip.dao.drivers.UserQueries#getSql_GET_USER_INFO()
39      */

40     public String JavaDoc getSql_GET_USER_INFO() {
41         return GET_USER_INFO;
42     }
43
44     /**
45      * @see org.jresearch.gossip.dao.drivers.UserQueries#getSql_GET_USERS()
46      */

47     public String JavaDoc getSql_GET_USERS() {
48         return GET_USERS;
49     }
50
51     /**
52      * @see org.jresearch.gossip.dao.drivers.UserQueries#getSql_SET_LAST_INTIME()
53      */

54     public String JavaDoc getSql_SET_LAST_INTIME() {
55         return SET_LAST_INTIME;
56     }
57
58     private static final String JavaDoc GET_USER_INFO = "SELECT user_signature, user_name, user_city, user_status, count(jrf_message.id) as tot_mes"
59             + " FROM jrf_user, jrf_message WHERE user_name =? AND user_name = jrf_message.sender GROUP BY user_name, user_signature, user_city, user_status";
60
61     private static final String JavaDoc GET_USERS = "SELECT * FROM "
62             + " (SELECT user_name, id, user_status, "
63             + " ROW_NUMBER() OVER(ORDER BY user_name) AS R"
64             + " FROM jrf_user " + " ORDER BY user_name"
65             + ") WHERE R BETWEEN ? AND ?"; // block, user_toshow
66

67     private final static String JavaDoc SET_LAST_INTIME = "UPDATE jrf_user SET last_intime=sysdate WHERE user_name = ?";
68
69 }
70
Popular Tags