public static boolean savePreference(Preference preference) { String sqlstmt = ""; if (getPreference(preference.getId()) == null) { sqlstmt = "insert into tpreference (pr_id, pr_value) values (" + Db.getString(preference.getId()) + ", " + Db.getString(preference.getValue()) + ")"; } else { sqlstmt = "update tpreference set " + "pr_value = " + Db.getString(preference.getValue()) + " where pr_id = " + Db.getString(preference.getId()); } return Db.db.execute(sqlstmt); }