KickJava   Java API By Example, From Geeks To Geeks.

Java > Open Source Codes > org > claros > chat > controllers > PreferencesController


1 package org.claros.chat.controllers;
2
3 import java.util.List JavaDoc;
4
5 import org.claros.chat.models.Preference;
6 import org.claros.chat.utility.Utility;
7
8 import com.jenkov.mrpersister.impl.mapping.AutoGeneratedColumnsMapper;
9 import com.jenkov.mrpersister.itf.IGenericDao;
10 import com.jenkov.mrpersister.itf.mapping.IObjectMappingKey;
11 import com.jenkov.mrpersister.util.JdbcUtil;
12
13 public class PreferencesController {
14     
15     /**
16      *
17      * @param user
18      * @return
19      * @throws Exception
20      */

21     public static List JavaDoc getPreferencesByUser(String JavaDoc user) throws Exception JavaDoc {
22         IGenericDao dao = null;
23         List JavaDoc myList = null;
24         try {
25             dao = Utility.getDbConnection();
26             String JavaDoc sql = "SELECT * FROM PREFERENCES WHERE USERNAME = ?";
27             myList = dao.readList(Preference.class, sql, new Object JavaDoc[] {user});
28         } finally {
29             JdbcUtil.close(dao);
30             dao = null;
31         }
32         return myList;
33     }
34
35     /**
36      *
37      * @param pref
38      * @throws Exception
39      */

40     public static void savePreference(Preference pref) throws Exception JavaDoc {
41         IGenericDao dao = null;
42         try {
43             dao = Utility.getDbConnection();
44             
45             Preference tmp = getPreferenceByUserKey(pref.getUsername(), pref.getPrefKey());
46             if (tmp != null) {
47                 pref.setId(tmp.getId());
48             }
49             if (pref.getId() == null) {
50                 IObjectMappingKey myObj = Utility.persistMan.getObjectMappingFactory().createInstance(Preference.class, new AutoGeneratedColumnsMapper(true));
51                 dao.insert(myObj, pref);
52             } else {
53                 dao.update(pref);
54             }
55         } finally {
56             JdbcUtil.close(dao);
57             dao = null;
58         }
59     }
60
61     public static Preference getPreferenceByUserKey(String JavaDoc user, String JavaDoc key) throws Exception JavaDoc {
62         IGenericDao dao = null;
63         Preference tmp = null;
64         try {
65             dao = Utility.getDbConnection();
66             String JavaDoc sql = "SELECT * FROM PREFERENCES WHERE USERNAME = ? AND PREF_KEY = ?";
67             tmp = (Preference)dao.read(Preference.class, sql, new Object JavaDoc[] {user, key});
68         } finally {
69             JdbcUtil.close(dao);
70             dao = null;
71         }
72         return tmp;
73     }
74     
75 }
76
Popular Tags