· 8 years ago · Jun 15, 2018, 07:00 PM
1public void createtablee() {
2 SQLiteDatabase sbb = Maindb.getInstancia().getWritableDatabase();
3 String colunas = "(id INTEGER , valoragua INTEGER ," +
4 " acordarhora INTERGER , dormirhora INTERGER , terceirahora INTERGER , quartahora INTERGER , quintahora INTERGER , " +
5 "acordarminutos INTERGER , dormirminutos INTERGER , quartaminutos INTERGER , terceiraminutos INTERGER , quintaminutos INTERGER )";
6 String query = "CREATE TABLE IF NOT EXISTS " + Maindb.TABELA + colunas;
7 sbb.execSQL(query);
8
9}
10
11public static final String DATABASE = "ProjetoGuimaraess";
12public static final int VERSION = 2;
13public static final String TABELA = "AguaEmpresas";
14public static Maindb instanciaa;
15
16public static Maindb getInstancia(){
17 if(instanciaa == null) instanciaa = new Maindb();
18 return instanciaa;
19
20
21}
22
23 private Maindb( ){
24 super(Myapp.getContext() , DATABASE,null , VERSION);
25
26Caused 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
27 at android.database.sqlite.SQLiteOpenHelper.getDatabaseLocked(SQLiteOpenHelper.java:223)
28 at android.database.sqlite.SQLiteOpenHelper.getWritableDatabase(SQLiteOpenHelper.java:163)
29 at com.example.aleander.ma_e.aguaempresatodosmetodos.crud.Creatt.createtablee(Creatt.java:9)
30 at com.example.aleander.ma_e.aguaempresatodosmetodos.ProntoAguaEmpresa.onCreate(ProntoAguaEmpresa.java:21)
31 at android.app.Activity.performCreate(Activity.java:6323)
32 at android.app.Instrumentation.callActivityOnCreate(Instrumentation.java:1108)
33 at android.app.ActivityThread.performLaunchActivity(ActivityThread.java:2387)
34 at android.app.ActivityThread.handleLaunchActivity(ActivityThread.java:2494)Â
35 at android.app.ActivityThread.access$900(ActivityThread.java:153)Â
36 at android.app.ActivityThread$H.handleMessage(ActivityThread.java:1347)Â
37 at android.os.Handler.dispatchMessage(Handler.java: