Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- ```java
- public List<Monument> retrieveAllMonument() {
- List<Monument> monuments = new ArrayList<>();
- String query = "SELECT * FROM MONUMENT;";
- Log.d("QUERYALLMONUMENT", query);
- Cursor cursor = this.getReadableDatabase().rawQuery(query, null);
- if(cursor.getCount() > 0 ) {
- if(cursor.moveToFirst()) {
- do {
- Monument monument = new Monument.Builder()
- .name(cursor.getString(cursor.getColumnIndex(DatabaseQuery.COL_MONUMENT_MONUMENTNAME)))
- .description(cursor.getString(cursor.getColumnIndex(DatabaseQuery.COL_MONUMENT_DESCRIPTION)))
- .creator(cursor.getString(cursor.getColumnIndex(DatabaseQuery.COL_MONUMENT_CREATOR)))
- .soundURL(cursor.getString(cursor.getColumnIndex(DatabaseQuery.COL_MONUMENT_SOUNDFILEURL)))
- .imageURL(cursor.getString(cursor.getColumnIndex(DatabaseQuery.COL_MONUMENT_IMAGEURL)))
- .latitude(cursor.getDouble(cursor.getColumnIndex(DatabaseQuery.COL_MONUMENT_LATITUDE)))
- .longitude(cursor.getDouble(cursor.getColumnIndex(DatabaseQuery.COL_MONUMENT_LONGITUDE)))
- .constructionYear(cursor.getInt(cursor.getColumnIndex(DatabaseQuery.COL_MONUMENT_CONSTRUCTIONYEAR)))
- .build();
- if(cursor.getInt(cursor.getColumnIndex(DatabaseQuery.COL_MONUMENT_ISVISITED)) == 1) {
- monument.setVisited(true);
- } else
- {
- monument.setVisited(false);
- }
- monuments.add(monument);
- }while (cursor.moveToNext());
- }
- }
- cursor.close();
- return monuments;
- }
- ```
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement