KickJava   Java API By Example, From Geeks To Geeks.

Java > Open Source Codes > org > jresearch > gossip > dao > drivers > mysql > MySqlUserQueries


1 /*
2  * $Id: MySqlUserQueries.java,v 1.3 2005/06/07 12:32:35 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.mysql;
26
27 import org.jresearch.gossip.dao.drivers.UserQueries;
28
29 /**
30  * MySqlUserQueries
31  *
32  * @author <a HREF="alexnet@sourceforge.net">A. Pavlov</a>
33  * @version $version$ 21.03.2004
34  */
35 class MySqlUserQueries extends UserQueries {
36
37     private static final String JavaDoc GET_USER_INFO = "SELECT user_signature, user_name, user_city, user_status, count(jrf_message.id) as tot_mes"
38             + " FROM jrf_user, jrf_message WHERE user_name =? AND user_name = jrf_message.sender GROUP BY user_name";
39
40     private static final String JavaDoc GET_USERS = "SELECT user_name, id, user_status FROM jrf_user ORDER BY user_name LIMIT ?,?"; // block,
41 // user_toshow
42
43     private final static String JavaDoc SET_LAST_INTIME = "UPDATE jrf_user SET last_intime=NOW() WHERE user_name = ?";
44
45     /**
46      * @see org.jresearch.gossip.dao.drivers.UserQueries#getSql_GET_USER_INFO()
47      */
48     public String JavaDoc getSql_GET_USER_INFO() {
49         return GET_USER_INFO;
50     }
51
52     /**
53      * @see org.jresearch.gossip.dao.drivers.UserQueries#getSql_GET_USERS()
54      */
55     public String JavaDoc getSql_GET_USERS() {
56         return GET_USERS;
57     }
58
59     /**
60      * @see org.jresearch.gossip.dao.drivers.UserQueries#getSql_SET_LAST_INTIME()
61      */
62     public String JavaDoc getSql_SET_LAST_INTIME() {
63         return SET_LAST_INTIME;
64     }
65
66 }
67
Popular Tags