Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SimpleDateFormat dateFormat = new SimpleDateFormat("yyyyMMddHHmm");
- Calendar cal = Calendar.getInstance();
- sysTime = dateFormat.format(cal.getTime());
- LSysTime = Long.parseLong(sysTime);
- try {
- cursor = sqdb.rawQuery("SELECT * FROM "+CRA+" where Expired ='FALSE'", null);
- if (cursor != null) {
- if (cursor.moveToFirst()) {
- do {
- final String DBDate=cursor.getString(cursor.getColumnIndex("Reminder"));
- final String DBTime = cursor.getString(cursor.getColumnIndex("Time"));
- DbTime = DBDate+DBTime;
- LDbTime = Long.parseLong(DbTime);
- System.out.println(" Time : "+LDbTime);
- if (LDbTime <= LSysTime) {
- rem_id = cursor.getString(cursor.getColumnIndex("_id"));
- remName = cursor.getString(cursor.getColumnIndex("Reminder_Name"));
- mediaPlayer.start();
- handler.post(new Runnable(){
- public void run() {
- alert.setTitle("Alert :"+remName);
- alert.setPositiveButton("OK", new DialogInterface.OnClickListener() {
- public void onClick(DialogInterface dialog, int whichButton) {
- mediaPlayer.stop();
- }
- });
- alert.show();
- }
- });
- Thread.sleep(5000);
- }
- } while (cursor.moveToNext());
- }
- }
- Thread.sleep(5000);
- } catch (Exception e) {
- }
Add Comment
Please, Sign In to add comment