1 package org.claros.chat.controllers; 2 3 import java.util.List ; 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 21 public static List getPreferencesByUser(String user) throws Exception { 22 IGenericDao dao = null; 23 List myList = null; 24 try { 25 dao = Utility.getDbConnection(); 26 String sql = "SELECT * FROM PREFERENCES WHERE USERNAME = ?"; 27 myList = dao.readList(Preference.class, sql, new Object [] {user}); 28 } finally { 29 JdbcUtil.close(dao); 30 dao = null; 31 } 32 return myList; 33 } 34 35 40 public static void savePreference(Preference pref) throws Exception { 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 user, String key) throws Exception { 62 IGenericDao dao = null; 63 Preference tmp = null; 64 try { 65 dao = Utility.getDbConnection(); 66 String sql = "SELECT * FROM PREFERENCES WHERE USERNAME = ? AND PREF_KEY = ?"; 67 tmp = (Preference)dao.read(Preference.class, sql, new Object [] {user, key}); 68 } finally { 69 JdbcUtil.close(dao); 70 dao = null; 71 } 72 return tmp; 73 } 74 75 } 76 | Popular Tags |