SQLiteOpenHelper.getReadableDatabase（）方法崩溃

Question

这是我DatabaseHelper类

public class DatabaseHelper extends SQLiteOpenHelper 

    public static final int DATABASE_VERSION = 1; 
    public static final String DATABASE_NAME = "MyAccountsDB.db"; 

    public static final String TABLE_Accounts = "Accounts"; 

    public static final String COLUMN_AccountID= "AccountID"; 
    public static final String COLUMN_WebSite= "WebSite"; 
    public static final String COLUMN_Email= "Email"; 
    public static final String COLUMN_UserName = "UserName"; 
    public static final String COLUMN_Password= "Password"; 


    private static final String TEXT_TYPE = " TEXT"; 
    private static final String INT_TYPE = " INTEGER"; 
    private static final String COMMA_SEP = ","; 

    private static final String SQL_CREATE_TABLE_Accounts = 
      "CREATE TABLE " + TABLE_Accounts + 
        " (" + 
        COLUMN_AccountID + INT_TYPE +" PRIMARY KEY AUTOINCREMENT NOT NULL"+ COMMA_SEP + 
        COLUMN_WebSite + TEXT_TYPE + COMMA_SEP + 
        COLUMN_Email + TEXT_TYPE + COMMA_SEP + 
        COLUMN_UserName + TEXT_TYPE + COMMA_SEP + 
        COLUMN_Password+ TEXT_TYPE + ")"; 
    public DatabaseHelper(Context context) 
    { 
     super(context, DATABASE_NAME, null, DATABASE_VERSION); 
    } 


    @Override 
    public void onCreate(SQLiteDatabase db) 
    { 
     db.execSQL(SQL_CREATE_TABLE_Accounts); 
    } 

    @Override 
    public void onUpgrade(SQLiteDatabase db, int i, int i1) 
    { 
     db.execSQL("DROP TABLE IF EXISTS " + TABLE_Accounts); 
     onCreate(db); 
    } 
    public void CreateAccount(Account acc) 
    { 
     SQLiteDatabase db = getWritableDatabase(); 

     String insertAccount = "Insert into Accounts (WebSite,Email,UserName,Password) values" + 
     "('" + acc.getWebSite() + "','" + acc.geteMail() + "','" + acc.getUserName() + "','" + acc.getPassWord() + "')"; 
     db.execSQL(insertAccount); 
    } 

    public ArrayList<Account> getAllAccounts() 
    { 
     String query = "SELECT AccountID , WebSite FROM Accounts"; 
     ArrayList<Account> Accounts = new ArrayList<Account>(); 
     SQLiteDatabase database = getReadableDatabase();//when its called here no problem and load all the accounts the way i want 
     Cursor c = database.rawQuery(query, null); 
     if (c != null) 
     { 
      while (c.moveToNext()) 
      { 
       Account acc = new Account(); 
       acc.setAccountID(c.getInt(0)); 
       acc.setWebSite(c.getString(1)); 
       Accounts.add(acc); 
      } 
     } 
     return Accounts; 
    } 
    public Account getAccountByID(int id) 
    { 
     Account acc = new Account(); 
     String query = "SELECT WebSite , eMail , UserName , Password from Accounts where AccountID = " + id; 
     SQLiteDatabase database = getReadableDatabase();//but when i call it here following exception thrown 
     Cursor c = database.rawQuery(query, null); 
     if (c != null) 
     { 
      while (c.moveToFirst()) 
      { 
       acc.setAccountID(c.getInt(0)); 
       acc.setWebSite(c.getString(1)); 
       acc.seteMail(c.getString(2)); 
       acc.setUserName(c.getString(3)); 
       acc.setPassWord(c.getString(4)); 
      } 
     } 
     return acc; 
    } 

---

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 

我有同样的方法和函数的语法另一个应用程序，它的工作没有任何问题

Answer 1

谢谢大家...我已经找到了答案....我是从一个片段调用 getAccountById方法，所以，我必须重新通过 语境再次给它

UpdateAccountFragment a = new UpdateAccountFragment(accountID,getActivity()); 

和UpdateAccountFragment样子

public UpdateAccountFragment (int accountID , Context context) 
{ 
    this.context = context; 
    this.accountID = accountID; 
} 

Answer 2

问题是在您的查询中：

String query = "SELECT WebSite , eMail , UserName , Password from Accounts where AccountID = " + id; 

您已使用eMail而不是Email。您的Accounts表中名为eMail的表中没有column。还将from更改为FROM和where子条款更改为WHERE。

更改Query如下：

String query = "SELECT WebSite , Email , UserName , Password FROM Accounts WHERE AccountID = " + id; 

＃从Activity或Fragment像下面创建的DatabaseHelperinstance：

从活动：

public class MainActivity extends AppCompatActivity { 

    DatabaseHelper db; 

    @Override 
    protected void onCreate(Bundle savedInstanceState) { 
     super.onCreate(savedInstanceState); 
     setContentView(R.layout.activity_main); 

     db = new DatabaseHelper(this); // Context is this 

     ............... 
     .................... 
    } 

} 

从片段：

public class UpdateAccountFragment extends Fragment { 

    DatabaseHelper db; 

    @Override 
    public void onCreate(@Nullable Bundle savedInstanceState) { 
     super.onCreate(savedInstanceState); 

     db = new DatabaseHelper(getActivity()); // Context is getActivity() 

     ............... 
     .................... 
    } 
} 

希望这将有助于〜

Answer 3

我相信你需要以不同的方式创建数据库帮手。

例如，

public class MainActivity extends Activity { 

    private DatabaseHelper db; // Don't initialize here 

    @Override 
    protected void onCreate(Bundle b) { 
     ... 
     db = new DatabaseHelper(this); // Do it here 
    } 
} 

，并应解决当前的错误，如果你使用整个活动同db变量，但你仍然有在SQL查询等事项，不你的表定义相匹配。

您也不想使用while (c.moveToFirst())，除非您希望该循环永不结束。

public Account getAccountByID(int id) 
{ 
    Account acc = new Account(); 
    SQLiteDatabase database = getReadableDatabase(); 

    Cursor c = database.query(TABLE_Accounts, 
      { COLUMN_WebSite , COLUMN_Email , COLUMN_UserName , COLUMN_Password }, 
      COLUMN_AccountID + "=?", 
      { String.valueOf(id) }, 
      null, null, null, null); 
     );  

    try { 
     if (c != null && c.moveToFirst()) 
     { 
      acc.setAccountID(id); 
      acc.setWebSite(c.getString(0)); 
      acc.seteMail(c.getString(1)); 
      acc.setUserName(c.getString(2)); 
      acc.setPassWord(c.getString(3)); 
     } 
    } catch (Exception e) { 
     e.printStackTrace(); 
    } finally { 
     if (c != null) c.close(); 
    } 
    return acc; 
}