Gan dan Sist mau tanya, ane khan bikin fungsi buat query select di sqlite. Nah waktu mau open database biar bisa di-read malah null exception.
Nih fungsi buat open read-nya
Spoiler for kode:
public DBReminder openRead(Context c) throws SQLException {
helper = new DBHelper(c);
db = helper.getReadableDatabase();
return this;
}
Fungsi di activity-nya
Spoiler for kode:
public void cekPosisi(String txtAlamat) {
if (txtAlamat.toString().length() > 0) {
dbHandler.openRead(getApplicationContext());
String sql = "select * from task_table where alamat = '"+txtAlamat+"';";
Cursor rs = db.rawQuery(sql, null);
if(rs != null) {
rs.moveToFirst();
String addr = rs.getString(rs.getColumnIndex("alamat"));
Toast.makeText(this, "Anda ada tugas di " + addr, Toast.LENGTH_LONG).show();
} else {
Toast.makeText(this, "Anda tidak ada tugas di lokasi sekarang", Toast.LENGTH_LONG).show();
}
dbHandler.closeConn();
rs.close();
} else {
Toast.makeText(this, "Tidak ada alamat", Toast.LENGTH_LONG).show();
}
}
Fungsi diatas dipakenya disini. Di onClick-nya
Spoiler for kode:
public void navigateToLocation(double latitude, double longitude) {
GeoPoint p = new GeoPoint((int) (latitude * 1E6), (int) (1E6 * longitude));
userLat = p.getLatitudeE6();
userLon = p.getLongitudeE6();
//menggambar penanda lokasi
List<Overlay> mapOverlay = mapview.getOverlays();
Drawable draw = this.getResources().getDrawable(R.drawable.map_pin);
MapMarker mapMarker = new MapMarker(draw, this);
OverlayItem overlayItem = new OverlayItem(p, "", "Posisi anda sekarang");
mapMarker.AddOverlay(overlayItem);
mapOverlay.add(mapMarker);
alamat = convertToAddress(p);
teksAlamat.setText(alamat);
//tampilkan lokasi pengguna
mapcontrol.animateTo(p);
Toast.makeText(getApplicationContext(),
"Lokasi Anda " + alamat + "\n" + "lat = " + userLat + "\n" + "long = "
+ userLon, Toast.LENGTH_LONG).show();
//cek tugas
txtAddr = teksAlamat.getText().toString();
this.cariTugas.setOnClickListener(new OnClickListener() {
@Override
public void onClick(View v) {
// TODO Auto-generated method stub
Log.d("alamat textView", txtAddr);
cekPosisi(txtAddr);
}
});
}
Mohon bantuannya master-master skalian...
