Guest User

Untitled

a guest
Jan 18th, 2019
87
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.18 KB | None | 0 0
  1. SimpleDateFormat dateFormat = new SimpleDateFormat("yyyyMMddHHmm");
  2. Calendar cal = Calendar.getInstance();
  3. sysTime = dateFormat.format(cal.getTime());
  4. LSysTime = Long.parseLong(sysTime);
  5. try {
  6. cursor = sqdb.rawQuery("SELECT * FROM "+CRA+" where Expired ='FALSE'", null);
  7. if (cursor != null) {
  8. if (cursor.moveToFirst()) {
  9. do {
  10. final String DBDate=cursor.getString(cursor.getColumnIndex("Reminder"));
  11. final String DBTime = cursor.getString(cursor.getColumnIndex("Time"));
  12. DbTime = DBDate+DBTime;
  13. LDbTime = Long.parseLong(DbTime);
  14. System.out.println(" Time : "+LDbTime);
  15.  
  16. if (LDbTime <= LSysTime) {
  17. rem_id = cursor.getString(cursor.getColumnIndex("_id"));
  18. remName = cursor.getString(cursor.getColumnIndex("Reminder_Name"));
  19. mediaPlayer.start();
  20. handler.post(new Runnable(){
  21. public void run() {
  22. alert.setTitle("Alert :"+remName);
  23. alert.setPositiveButton("OK", new DialogInterface.OnClickListener() {
  24. public void onClick(DialogInterface dialog, int whichButton) {
  25. mediaPlayer.stop();
  26. }
  27. });
  28. alert.show();
  29. }
  30. });
  31. Thread.sleep(5000);
  32. }
  33. } while (cursor.moveToNext());
  34. }
  35. }
  36. Thread.sleep(5000);
  37. } catch (Exception e) {
  38.  
  39. }
Add Comment
Please, Sign In to add comment