public boolean setUpvote(int v) { StatementHandle hndl; String query; if (vote == 0) { query = "INSERT INTO votes (upvote, uid, sid) VALUES (?, ?, ?)"; hndl = insert_vote; } else { query = "UPDATE votes SET upvote = ? WHERE uid = ? AND sid = ?"; hndl = set_vote; } ArrayList<Object> args = new ArrayList<Object>(); args.add(new Integer(v)); args.add(new Integer(uid)); args.add(new Integer(sid)); boolean ret; if (vote == 0) ret = DataAccess.createEntry(hndl, query, "id", args) > 0; else ret = DataAccess.update(hndl, query, args); if (ret) { vote = v; Solution s = Solution.getSolution(sid); s.setScore(); } return ret; }
public static long update(Application application) { ContentValues values = new ContentValues(); values.put(Uid, application.getUid()); values.put(AppName, application.getAppName()); values.put(PackageName, application.getPackageName()); values.put(Removed, application.getRemoved()); DataAccess da = new DataAccess(); return da.update( TableName, values, Id + " =? ", new String[] {String.valueOf(application.getId())}); }
public static long update(SystemSetting setting) { ContentValues values = new ContentValues(); values.put(Installed, setting.getInstalled() ? 1 : 0); values.put(RingingToneUri, setting.getRingingToneUri()); values.put(AlarmRingingTone, setting.getAlarmRingingTone()); values.put(VibrateInAlarms, setting.getVibrateInAlarms() ? 1 : 0); values.put(SoundInAlarms, setting.getSoundInAlarms() ? 1 : 0); DataAccess da = new DataAccess(); return da.update( TableName, values, Id + " = ? ", new String[] {String.valueOf(setting.getId())}); }