sql

public void update(sql sql, String table, String column, String value, long uniccode) {

    SQLiteDatabase SQ = sql.getWritableDatabase();

    SQ.execSQL("UPDATE "+table+" SET "+column+" = \'" + value + "\' WHERE uniccode = \'"+uniccode+"\';");

  }

public Cursor get(sql sql, String table, String[] values) {

    SQLiteDatabase SQ = sql.getReadableDatabase();

    return SQ.query(table, values, null, null, null, null, null);

  }

  public void write(sql sql, String table, String[] column, String[] value) {

    SQLiteDatabase SQ = sql.getWritableDatabase();

    Cursor C = get(sql, table, new String[] {"uniccode"});

    if (C != null && C.moveToFirst()) {

      C.moveToFirst();

      do {

        if (C.getString(0).equals(value[4])) {

          C.close();

          return;

        }

      } while (C.moveToNext());

    }

    if (C != null) C.close();

    ContentValues cv = new ContentValues();

    for (int i = 0; i < column.length; i++) {

      cv.put(column[i], value[i]);

    }

    long k = SQ.insert(table, null, cv);

  }