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


1 /*
2  * $Id: ForumQueries.java,v 1.5 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  * ForumQueries
29  *
30  * @author <a HREF="alexnet@sourceforge.net">A. Pavlov</a>
31  * @version $version$ 21.03.2004
32  */
33 public abstract class ForumQueries {
34
35     public abstract String getSql_COUNT_LOG_ENTRIES();
36
37     public abstract String getSql_GET_LAST_MESS();
38
39     public abstract String getSql_GET_ROOT_MESS();
40
41     public abstract String getSql_GET_LAST_TOPICS();
42
43     public abstract String getSql_GET_LAST_TOPICS_IN_FORUM();
44
45     public abstract String getSql_GET_LAST_UPDATED_TOPICS();
46
47     public abstract String getSql_GET_LAST_UPDATED_TOPICS_ALL();
48
49     public abstract String getSql_GET_LOG_ENTRIES_ASC();
50
51     public abstract String getSql_GET_LOG_ENTRIES_DESC();
52
53     public abstract String getSql_GET_OLD_TOPICS();
54
55     public abstract String getSql_GET_THREAD_LAST_INTIME();
56
57     public abstract String getSql_GET_THREAD_LAST_MESS();
58
59     public abstract String getSql_GET_THREAD_MESSAGES();
60
61     public abstract String getSql_GET_THREAD_SUBJ();
62
63     public abstract String getSql_GET_THREADS();
64
65     public abstract String getSql_GET_USER_SUBSCRIPTIONS();
66
67     public abstract String getSql_SEARCH_QUERY_END();
68
69     public abstract String getSql_SEARCH_QUERY_SUFF();
70
71     public abstract String getSql_SEARCH_QUERY_SUFF_COUNT();
72
73     /**
74      * @return
75      */
76     public String getSql_ADD_ENTRY() {
77         return ADD_ENTRY;
78     }
79
80     /**
81      * @return
82      */
83     public String getSql_ADD_FORUM() {
84         return ADD_FORUM;
85     }
86
87     /**
88      * @return
89      */
90     public String getSql_ADD_GROUP() {
91         return ADD_GROUP;
92     }
93
94     /**
95      * @return
96      */
97     public String getSql_ADD_MESSAGE() {
98         return ADD_MESSAGE;
99     }
100
101     /**
102      * @return
103      */
104     public String getSql_ADD_MOD() {
105         return ADD_MOD;
106     }
107
108     /**
109      * @return
110      */
111     public String getSql_ADD_SUBSCRIPTION() {
112         return ADD_SUBSCRIPTION;
113     }
114
115     /**
116      * @return
117      */
118     public String getSql_CHECK_ENTRY() {
119         return CHECK_ENTRY;
120     }
121
122     /**
123      * @return
124      */
125     public String getSql_CHECK_USER_MOD() {
126         return CHECK_USER_MOD;
127     }
128
129     /**
130      * @return
131      */
132     public String getSql_CLEAN_USER_MOD() {
133         return CLEAN_USER_MOD;
134     }
135
136     /**
137      * @return
138      */
139     public String getSql_CLEAN_USER_SUBSCR() {
140         return CLEAN_USER_SUBSCR;
141     }
142
143     /**
144      * @return
145      */
146     public String getSql_COUNT_ENTRIES() {
147         return COUNT_ENTRIES;
148     }
149
150     /**
151      * @return
152      */
153     public String getSql_COUNT_NEW_THREADS() {
154         return COUNT_NEW_THREADS;
155     }
156
157     /**
158      * @return
159      */
160     public String getSql_COUNT_NEW_THREADS_ALL() {
161         return COUNT_NEW_THREADS_ALL;
162     }
163
164     /**
165      * @return
166      */
167     public String getSql_COUNT_SUBSCRIPTIONS() {
168         return COUNT_SUBSCRIPTIONS;
169     }
170
171     /**
172      * @return
173      */
174     public String getSql_COUNT_THREAD_MESSAGES() {
175         return COUNT_THREAD_MESSAGES;
176     }
177
178     /**
179      * @return
180      */
181     public String getSql_COUNT_FORUM_MESSAGES() {
182         return COUNT_FORUM_MESSAGES;
183     }
184
185     /**
186      * @return
187      */
188     public String getSql_COUNT_THREADS() {
189         return COUNT_THREADS;
190     }
191
192     /**
193      * @return
194      */
195     public String getSql_DELETE_ALL_ENTRIES() {
196         return DELETE_ALL_ENTRIES;
197     }
198
199     /**
200      * @return
201      */
202     public String getSql_DELETE_ENTRY() {
203         return DELETE_ENTRY;
204     }
205
206     /**
207      * @return
208      */
209     public String getSql_DELETE_FORUM() {
210         return DELETE_FORUM;
211     }
212
213     /**
214      * @return
215      */
216     public String getSql_DELETE_GROUP() {
217         return DELETE_GROUP;
218     }
219
220     /**
221      * @return
222      */
223     public String getSql_DELETE_MESSAGE() {
224         return DELETE_MESSAGE;
225     }
226
227     /**
228      * @return
229      */
230     public String getSql_DELETE_SUBSCRIPTION() {
231         return DELETE_SUBSCRIPTION;
232     }
233
234     /**
235      * @return
236      */
237     public String getSql_DELETE_SUBSCRIPTION_ALL() {
238         return DELETE_SUBSCRIPTION_ALL;
239     }
240
241     /**
242      * @return
243      */
244     public String getSql_DELETE_THREAD() {
245         return DELETE_THREAD;
246     }
247
248     /**
249      * @return
250      */
251     public String getSql_DELETE_THREAD_MESSAGES() {
252         return DELETE_THREAD_MESSAGES;
253     }
254
255     /**
256      * @return
257      */
258     public String getSql_DELETE_THREAD_SUBSCRIPTIONS() {
259         return DELETE_THREAD_SUBSCRIPTIONS;
260     }
261
262     /**
263      * @return
264      */
265     public String getSql_DROP_USER_MOD() {
266         return DROP_USER_MOD;
267     }
268
269     /**
270      * @return
271      */
272     public String getSql_DELETE_LOG_ALL() {
273         return DELETE_LOG_ALL;
274     }
275
276     /**
277      * @return
278      */
279     public String getSql_FORUM_INFO() {
280         return FORUM_INFO;
281     }
282
283     /**
284      * @return
285      */
286     public String getSql_GET_ALL_FORUMS() {
287         return GET_ALL_FORUMS;
288     }
289
290     /**
291      * @return
292      */
293     public String getSql_GET_CONSTANTS() {
294         return GET_CONSTANTS;
295     }
296
297     /**
298      * @return
299      */
300     public String getSql_GET_ENTRY_LIST() {
301         return GET_ENTRY_LIST;
302     }
303
304     /**
305      * @return
306      */
307     public String getSql_GET_ENTRY_LIST_FULL() {
308         return GET_ENTRY_LIST_FULL;
309     }
310
311     /**
312      * @return
313      */
314     public String getSql_GET_FORUM_LOCKED() {
315         return GET_FORUM_LOCKED;
316     }
317
318     /**
319      * @return
320      */
321     public String getSql_GET_FORUMS() {
322         return GET_FORUMS;
323     }
324
325     /**
326      * @return
327      */
328     public String getSql_GET_FORUMS_FOR_MOD() {
329         return GET_FORUMS_FOR_MOD;
330     }
331
332     /**
333      * @return
334      */
335     public String getSql_GET_FORUMS_ID_LIST() {
336         return GET_FORUMS_ID_LIST;
337     }
338
339     /**
340      * @return
341      */
342     public String getSql_GET_GROUP_INFO() {
343         return GET_GROUP_INFO;
344     }
345
346     /**
347      * @return
348      */
349     public String getSql_GET_GROUP_LIST() {
350         return GET_GROUP_LIST;
351     }
352
353     /**
354      * @return
355      */
356     public String getSql_GET_GROUPS() {
357         return GET_GROUPS;
358     }
359
360     /**
361      * @return
362      */
363     public String getSql_GET_MESS_INTIME() {
364         return GET_MESS_INTIME;
365     }
366
367     /**
368      * @return
369      */
370     public String getSql_GET_MESS_POS_BY_INTIME() {
371         return GET_MESS_POS_BY_INTIME;
372     }
373
374     /**
375      * @return
376      */
377     public String getSql_GET_MESSAGE() {
378         return GET_MESSAGE;
379     }
380
381     /**
382      * @return
383      */
384     public String getSql_GET_SKIN_PARAMS() {
385         return GET_SKIN_PARAMS;
386     }
387
388     /**
389      * @return
390      */
391     public String getSql_GET_SUBSCRIBERS_LIST() {
392         return GET_SUBSCRIBERS_LIST;
393     }
394
395     /**
396      * @return
397      */
398     public String getSql_GET_SUBSCRIPTION() {
399         return GET_SUBSCRIPTION;
400     }
401
402     /**
403      * @return
404      */
405     public String getSql_GET_SUBSCRIPTION_ALL() {
406         return GET_SUBSCRIPTION_ALL;
407     }
408
409     /**
410      * @return
411      */
412     public String getSql_GET_THREAD_ID_LIST() {
413         return GET_THREAD_ID_LIST;
414     }
415
416     /**
417      * @return
418      */
419     public String getSql_GET_THREAD_LOCKED() {
420         return GET_THREAD_LOCKED;
421     }
422
423     /**
424      * @return
425      */
426     public String getSql_GET_UPDATED_TOPICS() {
427         return GET_UPDATED_TOPICS;
428     }
429
430     /**
431      * @return
432      */
433     public String getSql_GET_UPDATED_TOPICS_IN_FORUM() {
434         return GET_UPDATED_TOPICS_IN_FORUM;
435     }
436
437     /**
438      * @return
439      */
440     public String getSql_GET_USER_MESS_COUNT() {
441         return GET_USER_MESS_COUNT;
442     }
443
444     /**
445      * @return
446      */
447     public String getSql_GET_USER_MOD_FORUMS() {
448         return GET_USER_MOD_FORUMS;
449     }
450
451     /**
452      * @return
453      */
454     public String getSql_INSERT_THREAD() {
455         return INSERT_THREAD;
456     }
457
458     /**
459      * @return
460      */
461     public String getSql_IS_USER_MOD() {
462         return IS_USER_MOD;
463     }
464
465     /**
466      * @return
467      */
468     public String getSql_MARK_USER_MESS() {
469         return MARK_USER_MESS;
470     }
471
472     /**
473      * @return
474      */
475     public String getSql_MOVE_THREAD() {
476         return MOVE_THREAD;
477     }
478
479     /**
480      * @return
481      */
482     public String getSql_SET_FORUM_LOCKED_STATUS() {
483         return SET_FORUM_LOCKED_STATUS;
484     }
485
486     /**
487      * @return
488      */
489     public String getSql_SET_THREAD_LOCKED_STATUS() {
490         return SET_THREAD_LOCKED_STATUS;
491     }
492
493     /**
494      * @return
495      */
496     public String getSql_SET_THREAD_SORT_BY() {
497         return SET_THREAD_SORT_BY;
498     }
499
500     /**
501      * @return
502      */
503     public String getSql_THREAD_INFO() {
504         return THREAD_INFO;
505     }
506
507     /**
508      * @return
509      */
510     public String getSql_UPDATE_CONSTANTS() {
511         return UPDATE_CONSTANTS;
512     }
513
514     /**
515      * @return
516      */
517     public String getSql_UPDATE_ENTRY() {
518         return UPDATE_ENTRY;
519     }
520
521     /**
522      * @return
523      */
524     public String getSql_UPDATE_FORUM() {
525         return UPDATE_FORUM;
526     }
527
528     /**
529      * @return
530      */
531     public String getSql_UPDATE_GROUP() {
532         return UPDATE_GROUP;
533     }
534
535     /**
536      * @return
537      */
538     public String getSql_UPDATE_MESSAGE() {
539         return UPDATE_MESSAGE;
540     }
541
542     /**
543      * @return
544      */
545     public String getSql_UPDATE_SKIN_PARAM() {
546         return UPDATE_SKIN_PARAM;
547     }
548
549     /**
550      * @return
551      */
552     public String getSql_UPDATE_SUBSCRIBE() {
553         return UPDATE_SUBSCRIBE;
554     }
555
556     /**
557      * @return
558      */
559     public String getSql_UPDATE_THREAD_LINTIME() {
560         return UPDATE_THREAD_LINTIME;
561     }
562
563     /**
564      * @return
565      */
566     public String getSql_GET_RANKS() {
567         return GET_RANKS;
568     }
569
570     /**
571      * @return
572      */
573     public String getSql_REMOVE_RANK() {
574         return REMOVE_RANK;
575     }
576
577     /**
578      * @return
579      */
580     public String getSql_ADD_RANK() {
581         return ADD_RANK;
582     }
583
584     /**
585      * @return
586      */
587     public String getSql_GET_RANK() {
588         return GET_RANK;
589     }
590
591     /**
592      * @return
593      */
594     public String getSql_UPDATE_RANK() {
595         return UPDATE_RANK;
596     }
597
598     /**
599      * @return
600      */
601     public String getSql_GET_ATTACH_INFO() {
602         return GET_ATTACH_INFO;
603     }
604
605     /**
606      * @return
607      */
608     public String getSql_GET_ATTACHMENTS() {
609         return GET_ATTACHMENTS;
610     }
611
612     /**
613      * @return
614      */
615     public String getSql_ADD_ATTACH_INFO() {
616         return ADD_ATTACH_INFO;
617     }
618
619     /**
620      * @return
621      */
622     public String getSql_DELETE_ATTACH() {
623         return DELETE_ATTACH;
624     }
625
626     /**
627      * @return
628      */
629     public String getSql_UPDATE_ATTACH_INFO() {
630         return UPDATE_ATTACH_INFO;
631     }
632
633     private static final String UPDATE_SKIN_PARAM = "UPDATE jrf_skin_params SET param_value = ? WHERE param_name = ? and skinid =?";
634
635     private static final String GET_SKIN_PARAMS = "SELECT param_name,param_value FROM jrf_skin_params WHERE skinid=?";
636
637     private static final String GET_CONSTANTS = "SELECT * FROM jrf_constants";
638
639     private static final String GET_ENTRY_LIST_FULL = "SELECT * FROM jrf_whois ORDER BY user_name DESC";
640
641     private static final String GET_MESS_POS_BY_INTIME = "SELECT count(id) FROM jrf_message WHERE threadid=? AND intime<=? ORDER BY intime";
642
643     private static final String GET_MESS_INTIME = "SELECT intime FROM jrf_message WHERE id=?";
644
645     private static final String ADD_ENTRY = "INSERT INTO jrf_whois(sessionid, ip, user_name, id) VALUES(?,?,?,?)";
646
647     private static final String ADD_FORUM = "INSERT INTO jrf_forum(forumtitle,forumdesc,groupid,forum_sort,forumid) VALUES(?,?,?,?,?)";
648
649     private static final String ADD_GROUP = "INSERT INTO jrf_group(group_name,group_sort,groupid) VALUES(?,?,?)";
650
651     private static final String ADD_MESSAGE = "INSERT INTO jrf_message(sender,centents,intime,heading,threadid,ip,id) VALUES(?,?,?,?,?,?,?)";
652
653     private static final String ADD_MOD = "INSERT INTO jrf_mod VALUES(?,?)";
654
655     private static final String ADD_SUBSCRIPTION = "INSERT INTO jrf_subscribe VALUES(?,?,?)";
656
657     private static final String CHECK_ENTRY = "SELECT id FROM jrf_whois WHERE sessionid=?";
658
659     private static final String CHECK_USER_MOD = "SELECT * FROM jrf_mod WHERE forum_id = ? AND user_name = ?";
660
661     private static final String CLEAN_USER_MOD = "DELETE FROM jrf_mod WHERE user_name =?";
662
663     private static final String CLEAN_USER_SUBSCR = "DELETE FROM jrf_subscribe WHERE user_name = ?";
664
665     private static final String COUNT_ENTRIES = "SELECT count(id) AS totus FROM jrf_whois";
666
667     private static final String COUNT_NEW_THREADS = "SELECT count(threadid) as tot FROM jrf_thread WHERE jrf_thread.lintime >?";
668
669     private static final String COUNT_NEW_THREADS_ALL = "SELECT count(threadid) as tot FROM jrf_thread WHERE jrf_thread.lintime >?";
670
671     private static final String COUNT_SUBSCRIPTIONS = "SELECT count(threadid) FROM jrf_subscribe WHERE user_name = ?";
672
673     private static final String COUNT_THREAD_MESSAGES = "SELECT count(id) as tot FROM jrf_message WHERE threadid=?";
674
675     private static final String COUNT_FORUM_MESSAGES = "SELECT count(jrf_message.id) AS tot FROM jrf_message, jrf_thread WHERE jrf_message.threadid=jrf_thread.threadid and jrf_thread.forumid=?";
676
677     private static final String COUNT_THREADS = "SELECT count(threadid) as tot_threads FROM jrf_thread WHERE forumid =?";
678
679     private static final String DELETE_ENTRY = "DELETE FROM jrf_whois WHERE sessionid=? OR user_name=?";
680
681     private static final String DELETE_ALL_ENTRIES = "DELETE FROM jrf_whois WHERE user_name IS NULL or user_name NOT LIKE 'Administrator' ";
682
683     private static final String DELETE_FORUM = "DELETE FROM jrf_forum WHERE forumid = ?";
684
685     private static final String DELETE_GROUP = "DELETE FROM jrf_group WHERE groupid = ?";
686
687     private static final String DELETE_MESSAGE = "DELETE FROM jrf_message WHERE id = ?";
688
689     private static final String DELETE_SUBSCRIPTION = "DELETE FROM jrf_subscribe WHERE (threadid=? AND user_mail=? AND user_name=?)";
690
691     private static final String DELETE_SUBSCRIPTION_ALL = "DELETE FROM jrf_subscribe WHERE (user_mail=? AND user_name LIKE ?)";
692
693     private static final String DELETE_THREAD = "DELETE FROM jrf_thread WHERE threadid =? ";
694
695     private static final String DELETE_THREAD_MESSAGES = "DELETE FROM jrf_message WHERE threadid = ?";
696
697     private static final String DELETE_THREAD_SUBSCRIPTIONS = "DELETE FROM jrf_subscribe WHERE threadid = ?";
698
699     private static final String DROP_USER_MOD = "DELETE FROM jrf_mod WHERE user_name = ? AND forum_id = ?";
700
701     private static final String FORUM_INFO = "SELECT * FROM jrf_forum WHERE forumid =?";
702
703     private static final String GET_ALL_FORUMS = "SELECT forumtitle, forumdesc, forumid, locked FROM jrf_forum WHERE jrf_forum.groupid = ? ORDER BY forum_sort";
704
705     private static final String GET_ENTRY_LIST = "SELECT * FROM jrf_whois WHERE user_name IS NOT NULL";
706
707     private static final String GET_FORUM_LOCKED = "SELECT locked FROM jrf_forum WHERE forumid = ?";
708
709     private static final String GET_FORUMS = "SELECT forumtitle, forumdesc, forumid, locked FROM jrf_forum WHERE jrf_forum.groupid = ? AND locked < 3 ORDER BY forum_sort";
710
711     private static final String GET_FORUMS_FOR_MOD = "SELECT jrf_forum.forumid AS fid, jrf_forum.forumtitle AS forumtitle,"
712             + " jrf_group.groupid AS gid FROM jrf_forum, jrf_group WHERE "
713             + " jrf_forum.groupid = jrf_group.groupid ORDER BY group_sort, jrf_group.groupid, jrf_forum.forum_sort";
714
715     private static final String GET_FORUMS_ID_LIST = "SELECT forumid FROM jrf_forum WHERE groupid = ?";
716
717     private static final String GET_GROUP_INFO = "SELECT * FROM jrf_group WHERE groupid = ?";
718
719     private static final String GET_GROUP_LIST = "SELECT * FROM jrf_group ORDER BY group_sort";
720
721     private static final String GET_GROUPS = "SELECT * FROM jrf_group ORDER BY group_sort";
722
723     private static final String GET_MESSAGE = "SELECT centents,heading,id,intime,ip,sender FROM jrf_message WHERE id = ?";
724
725     private static final String GET_SUBSCRIBERS_LIST = "SELECT DISTINCT user_mail, user_name FROM jrf_subscribe WHERE threadid = ? AND user_name != ?";
726
727     private static final String GET_SUBSCRIPTION = "SELECT * FROM jrf_subscribe WHERE (threadid=? AND user_mail=? AND user_name=?)";
728
729     private static final String GET_SUBSCRIPTION_ALL = "SELECT * FROM jrf_subscribe WHERE (user_mail=? AND user_name LIKE ?)";
730
731     private static final String GET_THREAD_ID_LIST = "SELECT threadid FROM jrf_thread WHERE forumid = ?";
732
733     private static final String GET_THREAD_LOCKED = "SELECT locked FROM jrf_thread WHERE threadid =?";
734
735     private static final String GET_UPDATED_TOPICS = "SELECT jrf_thread.THREADID as tid "
736             + " FROM jrf_user, jrf_thread, jrf_forum "
737             + " WHERE "
738             + " jrf_thread.LINTIME > jrf_user.LAST_INTIME AND "
739             + " jrf_thread.FORUMID = jrf_forum.FORUMID AND "
740             + " ( ( jrf_forum.locked < 3 AND jrf_user.USER_STATUS < 7) OR "
741             + " jrf_user.USER_STATUS >= 7 ) AND "
742             + " jrf_user.user_name = ? ";
743
744     private static final String GET_UPDATED_TOPICS_IN_FORUM = "SELECT jrf_thread.THREADID as tid "
745             + " FROM jrf_user, jrf_thread, jrf_forum "
746             + " WHERE "
747             + " jrf_thread.LINTIME > jrf_user.LAST_INTIME AND "
748             + " jrf_thread.FORUMID = jrf_forum.FORUMID AND "
749             + " ( ( jrf_forum.locked < 3 AND jrf_user.USER_STATUS < 7) OR "
750             + " jrf_user.USER_STATUS >= 7 ) AND "
751             + " jrf_user.user_name = ? AND jrf_thread.forumid = ? ";
752
753     private static final String GET_USER_MESS_COUNT = "SELECT count(id) as tot FROM jrf_message WHERE sender = ?";
754
755     private static final String GET_USER_MOD_FORUMS = "SELECT forumtitle, forumid FROM jrf_forum, jrf_mod WHERE jrf_mod.forum_id = forumid AND jrf_mod.user_name = ?";
756
757     private static final String INSERT_THREAD = "INSERT INTO jrf_thread(forumid, threadid) VALUES(?,?)";
758
759     private static final String IS_USER_MOD = "SELECT * FROM jrf_mod WHERE user_name = ?";
760
761     private static final String MARK_USER_MESS = "UPDATE jrf_message SET sender = ? WHERE sender = ?";
762
763     private static final String MOVE_THREAD = "UPDATE jrf_thread SET forumid =? WHERE threadid = ?";
764
765     private static final String SET_FORUM_LOCKED_STATUS = "UPDATE jrf_forum SET locked = ? WHERE forumid = ?";
766
767     private static final String SET_THREAD_LOCKED_STATUS = "UPDATE jrf_thread SET locked = ? WHERE threadid = ?";
768
769     private static final String SET_THREAD_SORT_BY = "UPDATE jrf_thread SET sortby = ? WHERE threadid = ?";
770
771     private static final String THREAD_INFO = "SELECT locked FROM jrf_thread WHERE threadid =?";
772
773     private static final String UPDATE_CONSTANTS = "UPDATE jrf_constants SET c_value=? WHERE c_name=?";
774
775     private static final String UPDATE_ENTRY = "UPDATE jrf_whois SET user_name = ? WHERE sessionid=? ";
776
777     private static final String UPDATE_FORUM = "UPDATE jrf_forum SET forumtitle = ?, forumdesc = ?,groupid = ?, forum_sort=? WHERE forumid = ?";
778
779     private static final String UPDATE_GROUP = "UPDATE jrf_group SET group_name = ?, group_sort = ? WHERE groupid = ?";
780
781     private static final String UPDATE_MESSAGE = "UPDATE jrf_message SET centents = ?, heading = ? WHERE id =?";
782
783     private static final String UPDATE_SUBSCRIBE = "UPDATE jrf_subscribe SET user_mail = ? WHERE user_name = ?";
784
785     private static final String UPDATE_THREAD_LINTIME = "UPDATE jrf_thread SET lintime =? WHERE threadid = ?";
786
787     private static final String GET_RANKS = "SELECT * FROM jrf_rank ORDER BY rank_count";
788
789     private static final String REMOVE_RANK = "DELETE FROM jrf_rank WHERE id = ?";
790
791     private static final String ADD_RANK = "INSERT INTO jrf_rank(id,rank_count, rank_name) VALUES(?,?,?)";
792
793     private static final String GET_RANK = "SELECT * FROM jrf_rank WHERE id = ?";
794
795     private static final String UPDATE_RANK = "UPDATE jrf_rank SET rank_count = ?, rank_name = ? WHERE id = ?";
796
797     private static final String GET_ATTACH_INFO = "SELECT * FROM jrf_attach WHERE id = ?";
798
799     private static final String GET_ATTACHMENTS = "SELECT * FROM jrf_attach WHERE message_id = ?";
800
801     private static final String ADD_ATTACH_INFO = "INSERT INTO jrf_attach(id, attach_content_type, attach_name, attach_description,attach_size,message_id)"
802             + " VALUES(?,?,?,?,?,?)";
803
804     private static final String DELETE_ATTACH = "DELETE FROM jrf_attach WHERE id = ?";
805
806     private static final String UPDATE_ATTACH_INFO = "UPDATE jrf_attach SET attach_name = ?, attach_description = ? WHERE id = ?";
807
808     private static final String DELETE_LOG_ALL = "DELETE FROM jrf_audit_log";
809
810 }
811

A to Z: JavaDoc & Examples

---

Daily Java News & Articles

---

Open Source Projects

---

Open Source Codes

---

Free Computer Books

---

Remove Frame

---

Popular Tags