Advertisement
Guest User

Untitled

a guest
Sep 3rd, 2015
61
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 3.71 KB | None | 0 0
  1. public void ShowDB(){
  2. DatabaseAvrHelper mDatabaseAvrHelper;
  3. SQLiteDatabase mSqLiteDatabase;
  4. mDatabaseAvrHelper = new DatabaseAvrHelper(this);
  5. mSqLiteDatabase = mDatabaseAvrHelper.getReadableDatabase();
  6. String readQuery = "SELECT * FROM " + DatabaseAvrHelper.DATABASE_TABLE_AVR;
  7. Cursor cursor = mSqLiteDatabase.rawQuery(readQuery, null);
  8. ArrayAVR.clear();
  9. while (cursor.moveToNext()){
  10. int id = cursor.getInt(cursor.getColumnIndex(DatabaseAvrHelper._ID));
  11. String Num_ei = cursor.getString(cursor.getColumnIndex(DatabaseAvrHelper.NUM_EI_COLUMN));
  12. String Status_Ei = cursor.getString(cursor.getColumnIndex(DatabaseAvrHelper.STATUS_EI_COLUMN));
  13. //String Error_Code = cursor.getString(cursor.getColumnIndex(DatabaseAvrHelper.ERROR_CODE_EI_COLUMN));
  14. //String Comment_Ei = cursor.getString(cursor.getColumnIndex(DatabaseAvrHelper.COMMENT_EI_COLUMN));
  15. Long Date_Ei = cursor.getLong(cursor.getColumnIndex(DatabaseAvrHelper.DATE_EI_COLUMN));
  16. String dateString = null;
  17. if (Date_Ei != null) {
  18. SimpleDateFormat formatter = new SimpleDateFormat("dd.MM HH:mm");
  19. dateString = formatter.format(new Date(Date_Ei));
  20. }
  21. ArrayAVR.add(0, "№: " + Num_ei + " - " + Status_Ei + " - " + dateString);
  22. }
  23. ListAdapter = new ArrayAdapter<String>(this, android.R.layout.simple_list_item_1, ArrayAVR);
  24. ListView listview = (ListView)findViewById(R.id.listView2);
  25. listview.setAdapter(ListAdapter);
  26. mSqLiteDatabase.close();
  27. mDatabaseAvrHelper.close();
  28. }
  29.  
  30. Open_Close_AVR ShowDB = new Open_Close_AVR();
  31. ShowDB.ShowDB();
  32.  
  33. java.lang.RuntimeException: Unable to start receiver com.hakeem.avr.SmsBroadcastReceiver: java.lang.NullPointerException: Attempt to invoke virtual method 'android.database.sqlite.SQLiteDatabase android.content.Context.openOrCreateDatabase(java.lang.String, int, android.database.sqlite.SQLiteDatabase$CursorFactory, android.database.DatabaseErrorHandler)' on a null object reference
  34. at android.app.ActivityThread.handleReceiver(ActivityThread.java:2616)
  35. at android.app.ActivityThread.access$1700(ActivityThread.java:151)
  36. at android.app.ActivityThread$H.handleMessage(ActivityThread.java:1380)
  37. at android.os.Handler.dispatchMessage(Handler.java:102)
  38. at android.os.Looper.loop(Looper.java:135)
  39. at android.app.ActivityThread.main(ActivityThread.java:5254)
  40. at java.lang.reflect.Method.invoke(Native Method)
  41. at java.lang.reflect.Method.invoke(Method.java:372)
  42. at com.android.internal.os.ZygoteInit$MethodAndArgsCaller.run(ZygoteInit.java:903)
  43. at com.android.internal.os.ZygoteInit.main(ZygoteInit.java:698)
  44. Caused by: java.lang.NullPointerException: Attempt to invoke virtual method 'android.database.sqlite.SQLiteDatabase android.content.Context.openOrCreateDatabase(java.lang.String, int, android.database.sqlite.SQLiteDatabase$CursorFactory, android.database.DatabaseErrorHandler)' on a null object reference
  45. at android.content.ContextWrapper.openOrCreateDatabase(ContextWrapper.java:268)
  46. at android.database.sqlite.SQLiteOpenHelper.getDatabaseLocked(SQLiteOpenHelper.java:223)
  47. at android.database.sqlite.SQLiteOpenHelper.getReadableDatabase(SQLiteOpenHelper.java:187)
  48. at com.hakeem.avr.Open_Close_AVR.ShowDB(Open_Close_AVR.java:125)
  49. at com.hakeem.avr.SmsBroadcastReceiver.UpdateDB(SmsBroadcastReceiver.java:68)
  50. at com.hakeem.avr.SmsBroadcastReceiver.SmsFromPdus(SmsBroadcastReceiver.java:42)
  51. at com.hakeem.avr.SmsBroadcastReceiver.onReceive(SmsBroadcastReceiver.java:27)
  52. at android.app.ActivityThread.handleReceiver(ActivityThread.java:2609)
  53.  
  54. mSqLiteDatabase = mDatabaseAvrHelper.getReadableDatabase();
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement