samedi 7 mars 2015

How can I implement a String variable instead of 'Landschaft'?

I have created a SpinnerActivity, which looks like following:



http://ift.tt/1NuaeBi



Now for example if I select 'Landschaft' (in English: landscape) I want to search in the DatabaseHandler.java for a location which is in the category 'Landschaft' (landscape)


Therefore I have written the following method in DatabaseHandler.java:


In this method, I have just written Kategorie = Landscape.


However I want, that the selected SpinnerArray (Landschaft, Brücken...etc.) in my Spinner would be inserted in my DatabaseHandler instead of "Landschaft", how can I do that?



public List<Position> getAllPositionsWithCategory() {
List<Position> positionList = new ArrayList<Position>();

String selectQuery = "SELECT * FROM " + TABLE_POSITIONS
+ " WHERE Kategorie = 'Landschaft'";

SQLiteDatabase db = this.getWritableDatabase();

Cursor cursor = db.rawQuery(selectQuery, null);

// looping through all rows and adding to list

if (cursor.moveToFirst()) {

do {

Position position = new Position();

position.setID(Integer.parseInt(cursor.getString(0)));

position.setName(cursor.getString(1));

position.setKategorie(cursor.getString(2));

position.setLaenge(cursor.getFloat(3));

position.setBreite(cursor.getFloat(4));

// Adding position to list

positionList.add(position);

} while (cursor.moveToNext());

}
}

Aucun commentaire:

Enregistrer un commentaire