API tools faq
paste
View difference between Paste ID: GDD8K36k and uT4QLhxj
SHOW: | | - or go back to the newest paste.
1-
public void ShowDB(){
1+
public void ShowDB(){
2-
    DatabaseAvrHelper mDatabaseAvrHelper;
2+
    DatabaseAvrHelper mDatabaseAvrHelper;
3-
    SQLiteDatabase mSqLiteDatabase;
3+
    SQLiteDatabase mSqLiteDatabase;
4-
    mDatabaseAvrHelper = new DatabaseAvrHelper(this);
4+
    mDatabaseAvrHelper = new DatabaseAvrHelper(this);
5-
    mSqLiteDatabase = mDatabaseAvrHelper.getReadableDatabase();
5+
    mSqLiteDatabase = mDatabaseAvrHelper.getReadableDatabase();
6-
    String readQuery = "SELECT * FROM " + DatabaseAvrHelper.DATABASE_TABLE_AVR;
6+
    String readQuery = "SELECT * FROM " + DatabaseAvrHelper.DATABASE_TABLE_AVR;
7-
    Cursor cursor = mSqLiteDatabase.rawQuery(readQuery, null);
7+
    Cursor cursor = mSqLiteDatabase.rawQuery(readQuery, null);
8-
    ArrayAVR.clear();
8+
    ArrayAVR.clear();
9-
    while (cursor.moveToNext()){
9+
    while (cursor.moveToNext()){
10-
        int id = cursor.getInt(cursor.getColumnIndex(DatabaseAvrHelper._ID));
10+
        int id = cursor.getInt(cursor.getColumnIndex(DatabaseAvrHelper._ID));
11-
        String Num_ei = cursor.getString(cursor.getColumnIndex(DatabaseAvrHelper.NUM_EI_COLUMN));
11+
        String Num_ei = cursor.getString(cursor.getColumnIndex(DatabaseAvrHelper.NUM_EI_COLUMN));
12-
        String Status_Ei = cursor.getString(cursor.getColumnIndex(DatabaseAvrHelper.STATUS_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));
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));
14+
        //String Comment_Ei = cursor.getString(cursor.getColumnIndex(DatabaseAvrHelper.COMMENT_EI_COLUMN));
15-
        Long Date_Ei = cursor.getLong(cursor.getColumnIndex(DatabaseAvrHelper.DATE_EI_COLUMN));
15+
        Long Date_Ei = cursor.getLong(cursor.getColumnIndex(DatabaseAvrHelper.DATE_EI_COLUMN));
16-
        String dateString = null;
16+
        String dateString = null;
17-
        if (Date_Ei != null) {
17+
        if (Date_Ei != null) {
18-
            SimpleDateFormat formatter = new SimpleDateFormat("dd.MM HH:mm");
18+
            SimpleDateFormat formatter = new SimpleDateFormat("dd.MM HH:mm");
19-
            dateString = formatter.format(new Date(Date_Ei));
19+
            dateString = formatter.format(new Date(Date_Ei));
20-
        }
20+
        }
21-
        ArrayAVR.add(0, "№: " + Num_ei + " - " + Status_Ei + " - " + dateString);
21+
        ArrayAVR.add(0, "№: " + Num_ei + " - " + Status_Ei + " - " + dateString);
22-
    }
22+
    }
23-
    ListAdapter = new ArrayAdapter<String>(this, android.R.layout.simple_list_item_1, ArrayAVR);
23+
    ListAdapter = new ArrayAdapter<String>(this, android.R.layout.simple_list_item_1, ArrayAVR);
24-
    ListView listview = (ListView)findViewById(R.id.listView2);
24+
    ListView listview = (ListView)findViewById(R.id.listView2);
25-
    listview.setAdapter(ListAdapter);
25+
    listview.setAdapter(ListAdapter);
26-
    mSqLiteDatabase.close();
26+
    mSqLiteDatabase.close();
27-
    mDatabaseAvrHelper.close();
27+
    mDatabaseAvrHelper.close();
28
}
29
30-
Open_Close_AVR ShowDB = new Open_Close_AVR();
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
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)
34+
        at android.app.ActivityThread.handleReceiver(ActivityThread.java:2616)
35-
        at android.app.ActivityThread.access$1700(ActivityThread.java:151)
35+
        at android.app.ActivityThread.access$1700(ActivityThread.java:151)
36-
        at android.app.ActivityThread$H.handleMessage(ActivityThread.java:1380)
36+
        at android.app.ActivityThread$H.handleMessage(ActivityThread.java:1380)
37-
        at android.os.Handler.dispatchMessage(Handler.java:102)
37+
        at android.os.Handler.dispatchMessage(Handler.java:102)
38-
        at android.os.Looper.loop(Looper.java:135)
38+
        at android.os.Looper.loop(Looper.java:135)
39-
        at android.app.ActivityThread.main(ActivityThread.java:5254)
39+
        at android.app.ActivityThread.main(ActivityThread.java:5254)
40-
        at java.lang.reflect.Method.invoke(Native Method)
40+
        at java.lang.reflect.Method.invoke(Native Method)
41-
        at java.lang.reflect.Method.invoke(Method.java:372)
41+
        at java.lang.reflect.Method.invoke(Method.java:372)
42-
        at com.android.internal.os.ZygoteInit$MethodAndArgsCaller.run(ZygoteInit.java:903)
42+
        at com.android.internal.os.ZygoteInit$MethodAndArgsCaller.run(ZygoteInit.java:903)
43-
        at com.android.internal.os.ZygoteInit.main(ZygoteInit.java:698)
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
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)
45+
        at android.content.ContextWrapper.openOrCreateDatabase(ContextWrapper.java:268)
46-
        at android.database.sqlite.SQLiteOpenHelper.getDatabaseLocked(SQLiteOpenHelper.java:223)
46+
        at android.database.sqlite.SQLiteOpenHelper.getDatabaseLocked(SQLiteOpenHelper.java:223)
47-
        at android.database.sqlite.SQLiteOpenHelper.getReadableDatabase(SQLiteOpenHelper.java:187)
47+
        at android.database.sqlite.SQLiteOpenHelper.getReadableDatabase(SQLiteOpenHelper.java:187)
48-
        at com.hakeem.avr.Open_Close_AVR.ShowDB(Open_Close_AVR.java:125)
48+
        at com.hakeem.avr.Open_Close_AVR.ShowDB(Open_Close_AVR.java:125)
49-
        at com.hakeem.avr.SmsBroadcastReceiver.UpdateDB(SmsBroadcastReceiver.java:68)
49+
        at com.hakeem.avr.SmsBroadcastReceiver.UpdateDB(SmsBroadcastReceiver.java:68)
50-
        at com.hakeem.avr.SmsBroadcastReceiver.SmsFromPdus(SmsBroadcastReceiver.java:42)
50+
        at com.hakeem.avr.SmsBroadcastReceiver.SmsFromPdus(SmsBroadcastReceiver.java:42)
51-
        at com.hakeem.avr.SmsBroadcastReceiver.onReceive(SmsBroadcastReceiver.java:27)
51+
        at com.hakeem.avr.SmsBroadcastReceiver.onReceive(SmsBroadcastReceiver.java:27)
52
        at android.app.ActivityThread.handleReceiver(ActivityThread.java:2609)
53
54
mSqLiteDatabase = mDatabaseAvrHelper.getReadableDatabase();
Public Pastes
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!