SeXg2Vmx

1 try {
2            ClubsDB = this.openOrCreateDatabase(DB_NAME, MODE_PRIVATE, null);
3
4           //  ClubsDB.execSQL("DROP TABLE IF EXISTS "+TABLE_NAME+";");
5
6            ClubsDB.execSQL("CREATE TABLE IF NOT EXISTS " +
7                    TABLE_NAME +
8                    " (ClubName VARCHAR," +
9                    " X DOUBLE, Y DOUBLE);");
10
11            ClubsDB.execSQL("DELETE FROM " + TABLE_NAME);
12
13            mFillDbsTable();
14
15            Cursor c = ClubsDB.rawQuery("SELECT * FROM " +
16                    TABLE_NAME + "", null);
17
18            if (c != null) {
19                if (c.moveToFirst()) {
20                    do {
21                        String ClubName = c.getString(c.getColumnIndex("ClubName"));
22                        Double X = c.getDouble(c.getColumnIndex("X"));
23                        Double Y = c.getDouble(c.getColumnIndex("Y"));
24                    } while (c.moveToNext());
25                }
26            }
27          
28        } catch (SQLiteException se) {
29            Log.e(getClass().getSimpleName(), se.toString());
30
31        } finally {
32            if (ClubsDB != null)
33                //ClubsDB.execSQL("DELETE FROM " + TABLE_NAME);
34                ClubsDB.close();
35    }
36
37
38
39
40
41
42
43
44 private void mFillDbsTable() {
45        try {
46            ClubsDB.execSQL("INSERT INTO " +
47                    TABLE_NAME +
48                    " Values ('פורום ישראל',31.2222292, 34.80229499999996);");
49            ClubsDB.execSQL("INSERT INTO " +
50                    TABLE_NAME +
51                    " Values ('מועדון הברקה',31.2391409, 34.792734300000006);");
52
53        } catch (SQLiteException se) {
54            Log.e(getClass().getSimpleName(), "Could not create records");
55        }
56    }