how to define the process of retrieving data from sqlite programmatically?
Im new to these sqlite accessing programming.i have 9 edittext and coded
to store values in sqlite db...next time if i insert the same value in
first edittext the remaining value should display without entering..code
below is what i have tried but couldnt get back the values
//this is my dbhandler class method
> public Data findProduct(String phone) { String query = "Select *
> FROM " + TABLE_FEEDBACK + " WHERE " + COLUMN_PHONENO + " = \"" +
> phone + "\"";
> SQLiteDatabase db = this.getWritableDatabase();
Cursor cursor = db.rawQuery(query, null);
Data data = new Data();
if (cursor.moveToFirst()) { cursor.moveToFirst();
data.setPHONE(cursor.getString(0));
data.setName(cursor.getString(1));
data.setFood(cursor.getString(2));
data.setService(cursor.getString(3));
data.setCleanliness(cursor.getString(4));
data.setExperience(cursor.getString(5));
data.setAddress(cursor.getString(6));
data.setEmail(cursor.getString(7));
data.setBirthday(cursor.getString(8));
data.setAnniversary(cursor.getString(9));
data.setFavrestaurant(cursor.getString(10));
data.setFavstaff(cursor.getString(11));
data.setFavdish(cursor.getString(12));
data.setSuggestion(cursor.getString(13));
data.setReturn(cursor.getString(14)); cursor.close();
} else {
data = null; }
db.close(); return data; }
/*public void openDataBase(SQLiteDatabase db) throws SQLException {
//Open the database
String myPath = DB_PATH + DATABASE_NAME;
db = SQLiteDatabase.openDatabase(myPath, null,
SQLiteDatabase.OPEN_READONLY);
} */
//this is my mainactivity method
public void lookupProduct (View view) { DBHandler dbHandler = new
DBHandler(MainActivity.this);
Data data =
dbHandler.findProduct(phonenumber.getText().toString());
if (data != null) {
name.setText(String.valueOf(data.getName()));
address.setText(String.valueOf(data.getAddress()));
} else {
name.setText("No Match Found");
} }
No comments:
Post a Comment