1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57
| private void ShowSQLiteDBdata() {
SQLITEDATABASE = SQLITEHELPER2.getWritableDatabase();
cursor = SQLITEDATABASE.rawQuery("SELECT DISTINCT Code,Support,N,E FROM table_los", null);
code.clear();
Support.clear();
north.clear();
east.clear();
int i = 0;
if (cursor.moveToFirst()) {
do {
code.add(cursor.getString(cursor.getColumnIndex(SQLiteHelper2.KEY_ID)));
Support.add(cursor.getString(cursor.getColumnIndex(SQLiteHelper2.KEY_Subject)));
north.add(cursor.getString(cursor.getColumnIndex(SQLiteHelper2.KEY_Name)));
east.add(cursor.getString(cursor.getColumnIndex(SQLiteHelper2.KEY_PhoneNumber)));
double f1 = Double.parseDouble(north.get(i));
double f2 = Double.parseDouble(east.get(i));
double d1 = Double.parseDouble(t1.getText().toString());
double d2 = Double.parseDouble(t2.getText().toString());
double dd = Distance(f1, f2, "N", "E", d1, d2, "N", "E");
long AA = Azimut(f1, f2, "N", "E", d1, d2, "N", "E");
dis.add(String.valueOf(dd));
az.add(String.valueOf(AA));
i++;
} while (cursor.moveToNext());
}
ListAdapter = new SQLiteListAdapter(MainGPSActivity.this,
code,
Support,
az,
dis
);
//Collections.sort(ListAdapter);
listsiteproche.setAdapter(ListAdapter);
cursor.close();
} |
Partager