vendredi 20 mars 2015

How to replace the values in table while the insert name already exist in the table

How to i update my values while insert if already exist the same name in the table. example: my table have the values(bala,100,chennai).again i try to insert the values if the inserting name is same i want to replace the values(bala,100,chennai) to (bala,50,mumbai). while i insert(bala,50,mumbai). i am beginner in the database side. Thanks in Advance.



public class HorizantalDBHandler extends SQLiteOpenHelper {

// All Static variables
// Database Version
private static final int DATABASE_VERSION = 1;

// Database Name
private static final String DATABASE_NAME = "hrlist";

// Contacts table name
// private static final String TABLE_CONTACTS = "breakfast";
private static final String TABLE_BREAKFAST = "hrlist";

// Contacts Table Columns names

private static final String KEY_ID = "id";
private static final String KEY_NUMBER = "number";
private static final String KEY_NAME = "name";
private static final String KEY_IMAGE = "image";

public HorizantalDBHandler(Context context) {
super(context, DATABASE_NAME, null, DATABASE_VERSION);
}

// Creating Tables
@Override
public void onCreate(SQLiteDatabase db) {
String CREATE_BREAKFAST_TABLE = "CREATE TABLE " + TABLE_BREAKFAST + "("
+ KEY_ID + " INTEGER PRIMARY KEY," + KEY_NAME + " TEXT,"
+ KEY_NUMBER + " TEXT," + KEY_IMAGE + " BLOB" + ")";

db.execSQL(CREATE_BREAKFAST_TABLE);
}

// Upgrading database
@Override
public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
// Drop older table if existed
db.execSQL("DROP TABLE IF EXISTS " + TABLE_BREAKFAST);

// Create tables again
onCreate(db);
}

/**
* All CRUD(Create, Read, Update, Delete) Operations
*/

public// Adding new contact
void addContact(HorizantalPojo contact) {
SQLiteDatabase db = this.getWritableDatabase();

ContentValues values = new ContentValues();

System.out.println("################");
System.out.println("################");
System.out.println("################");
System.out.println(contact._name);
System.out.println(contact._number);
System.out.println(contact._image);

values.put(KEY_NAME, contact._name); // Contact Name
values.put(KEY_NUMBER, contact._number);
values.put(KEY_IMAGE, contact._image); // Contact Phone
//
//
// Inserting Row
db.insert(TABLE_BREAKFAST, null, values);

System.out.println("INSERTED SUCCESSSSSSSSSSS");
db.close(); // Closing database connection
// }
}
public List<HorizantalPojo> getAllContacts() {
List<HorizantalPojo> contactList = new ArrayList<HorizantalPojo>();
// Select All Query
String selectQuery = "SELECT * FROM hrlist ORDER BY name";

SQLiteDatabase db = this.getWritableDatabase();
Cursor cursor = db.rawQuery(selectQuery, null);
// looping through all rows and adding to list
if (cursor.moveToFirst()) {
do {
HorizantalPojo contact = new HorizantalPojo();
contact.setID(Integer.parseInt(cursor.getString(0)));
contact.setName(cursor.getString(1));
contact.setNumber(cursor.getString(2));
contact.setImage(cursor.getBlob(3));

System.out.println("^^^^^^^^^^^^^^^^");
System.out.println("^^^^^^^^^^^^^^^^");
System.out.println("^^^^^^^^^^^^^^^^");
System.out.println("^^^^^^^^^^^^^^^^");
System.out.println(cursor.getString(0));
System.out.println(cursor.getString(1));
System.out.println(cursor.getString(2));
System.out.println(cursor.getBlob(3));

// Adding contact to list
contactList.add(contact);
} while (cursor.moveToNext());
}
// close inserting data from database
db.close();
// return contact list
return contactList;

}
}

Aucun commentaire:

Enregistrer un commentaire