KickJava   Java API By Example, From Geeks To Geeks.

Java > Open Source Codes > org > jresearch > gossip > dao > drivers > UserQueries


1 /*
2  * $Id: UserQueries.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;
26
27 /**
28  * UserQueries
29  *
30  * @author <a HREF="alexnet@sourceforge.net">A. Pavlov</a>
31  * @version $version$ 21.03.2004
32  */
33 public abstract class UserQueries {
34
35     /**
36      * @return
37      */
38     public String JavaDoc getSql_ADD_USER() {
39         return ADD_USER;
40     }
41
42     /**
43      * @return
44      */
45     public String JavaDoc getSql_ADD_PENDING_USER() {
46         return ADD_PENDING_USER;
47     }
48
49     /**
50      * @return
51      */
52     public String JavaDoc getSql_CHANGE_PASSWORD() {
53         return CHANGE_PASSWORD;
54     }
55
56     /**
57      * @return
58      */
59     public String JavaDoc getSql_CHECK_USER() {
60         return CHECK_USER;
61     }
62
63     /**
64      * @return
65      */
66     public String JavaDoc getSql_CHECK_PENDING_USER() {
67         return CHECK_PENDING_USER;
68     }
69
70     /**
71      * @return
72      */
73     public String JavaDoc getSql_CHECK_USER_WITH_EMAIL() {
74         return CHECK_USER_WITH_EMAIL;
75     }
76
77     /**
78      * @return
79      */
80     public String JavaDoc getSql_COUNT_USERS() {
81         return COUNT_USERS;
82     }
83
84     /**
85      * @return
86      */
87     public String JavaDoc getSql_DELETE_USER() {
88         return DELETE_USER;
89     }
90
91     /**
92      * @return
93      */
94     public String JavaDoc getSql_DELETE_PENDING_USER() {
95         return DELETE_PENDING_USER;
96     }
97
98     /**
99      * @return
100      */
101     public String JavaDoc getSql_DELETE_EXPIRED_PENDING_USER() {
102         return DELETE_EXPIRED_PENDING_USER;
103     }
104
105     /**
106      * @return
107      */
108     public String JavaDoc getSql_GET_USER() {
109         return GET_USER;
110     }
111
112     /**
113      * @return
114      */
115     public String JavaDoc getSql_GET_USER_BY_ID() {
116         return GET_USER_BY_ID;
117     }
118
119     /**
120      * @return
121      */
122     public String JavaDoc getSql_GET_USER_ENCODED() {
123         return GET_USER_ENCODED;
124     }
125
126     public String JavaDoc getSql_GET_USER_EMAILS() {
127         return GET_USER_EMAILS;
128     }
129
130     /**
131      * @return
132      */
133     public abstract String JavaDoc getSql_GET_USER_INFO();
134
135     /**
136      * @return
137      */
138     public String JavaDoc getSql_GET_USER_INFO_BY_ID() {
139         return GET_USER_INFO_BY_ID;
140     }
141
142     /**
143      * @return
144      */
145     public String JavaDoc getSql_GET_USER_INFO_FULL() {
146         return GET_USER_INFO_FULL;
147     }
148
149     /**
150      * @return
151      */
152     public String JavaDoc getSql_GET_USER_STATUS() {
153         return GET_USER_STATUS;
154     }
155
156     /**
157      * @return
158      */
159     public abstract String JavaDoc getSql_GET_USERS();
160
161     /**
162      * @return
163      */
164     public abstract String JavaDoc getSql_SET_LAST_INTIME();
165
166     /**
167      * @return
168      */
169     public String JavaDoc getSql_UPDATE_USER() {
170         return UPDATE_USER;
171     }
172
173     /**
174      * @return
175      */
176     public String JavaDoc getSql_UPDATE_USER_STATUS() {
177         return UPDATE_USER_STATUS;
178     }
179
180     /**
181      * @return
182      */
183     public String JavaDoc getSql_GET_BAN_MAP() {
184         return GET_BAN_MAP;
185     }
186
187     /**
188      * @return
189      */
190     public String JavaDoc getSql_DELETE_BAN() {
191         return DELETE_BAN;
192     }
193
194     /**
195      * @return
196      */
197     public String JavaDoc getADD_BAN() {
198         return ADD_BAN;
199     }
200
201     private static final String JavaDoc ADD_USER = "INSERT INTO jrf_user(user_name, user_pass, user_mail, user_hp, user_icq,"
202             + "user_dob, user_city, user_occupation, user_status, user_signature, mes_per_page,"
203             + "auto_login, show_user_mail,last_intime,id) VALUES(?,?,?,?,?,?,?,?,1,?,?,?,?,?,?)";
204
205     private static final String JavaDoc CHANGE_PASSWORD = "UPDATE jrf_user SET user_pass = ? WHERE user_name = ?";
206
207     private static final String JavaDoc CHECK_USER = "SELECT user_name FROM jrf_user WHERE user_name = ?";
208
209     private static final String JavaDoc CHECK_USER_WITH_EMAIL = "SELECT * FROM jrf_user WHERE user_mail = ? AND user_name=?";
210
211     private static final String JavaDoc COUNT_USERS = "SELECT count(id) as tot FROM jrf_user";
212
213     private static final String JavaDoc DELETE_USER = "DELETE FROM jrf_user WHERE id = ? AND id != 1";
214
215     private static final String JavaDoc GET_USER = "SELECT * FROM jrf_user WHERE user_name = ? AND user_pass = ?";
216
217     private static final String JavaDoc GET_USER_BY_ID = "SELECT * FROM jrf_user WHERE id = ?";
218
219     private static final String JavaDoc GET_USER_EMAILS = "SELECT user_name,user_mail FROM jrf_user";
220
221     private static final String JavaDoc GET_USER_ENCODED = "SELECT * FROM jrf_user WHERE user_name = ? AND user_pass = ?";
222
223     private static final String JavaDoc GET_USER_INFO_FULL = "SELECT * FROM jrf_user WHERE user_name = ?";
224
225     private static final String JavaDoc GET_USER_INFO_BY_ID = "SELECT user_name,user_status FROM jrf_user WHERE id = ?";
226
227     private final static String JavaDoc GET_USER_STATUS = "SELECT user_status FROM jrf_user WHERE user_name =?";
228
229     private static final String JavaDoc UPDATE_USER = "UPDATE jrf_user SET "
230             + "user_mail=?,user_hp=?,user_icq=?,user_dob=?,user_city=?,user_occupation=?,"
231             + "user_signature =?,mes_per_page=?,auto_login=?,show_user_mail=? WHERE user_name = ?";
232
233     private static final String JavaDoc UPDATE_USER_STATUS = "UPDATE jrf_user SET user_status = ? WHERE user_name =?";
234
235     private static final String JavaDoc ADD_PENDING_USER = "INSERT INTO jrf_pending_user(user_name, user_mail, confirm_code, intime) VALUES(?,?,?,?)";
236
237     private static final String JavaDoc CHECK_PENDING_USER = "SELECT user_name FROM jrf_pending_user WHERE user_name = ? AND confirm_code = ?";
238
239     private static final String JavaDoc DELETE_PENDING_USER = "DELETE FROM jrf_pending_user WHERE user_name = ? ";
240
241     private static final String JavaDoc DELETE_EXPIRED_PENDING_USER = "DELETE FROM jrf_pending_user WHERE intime < ? ";
242
243     private final static String JavaDoc GET_BAN_MAP = "SELECT ban_mask,type_id FROM jrf_ban";
244
245     private static final String JavaDoc DELETE_BAN = "DELETE FROM jrf_ban WHERE type_id = ? AND ban_mask = ?";
246
247     private static final String JavaDoc ADD_BAN = "INSERT INTO jrf_ban(type_id,ban_mask) VALUES(?,?)";
248
249 }
250
Popular Tags