I am new to SQlite databases. I am trying to view my databse but when ever I open the Android Device Monitor and go to Data/Data/ I only find folders with name 'con'; I'm working on an EMULATOR. Please help me as I've searched & 've tried several solutions like restarting and reaching adb shell but nothing worked......here is my databasehelper class code
package com.example.maria.sqlapp;
import android.content.Context;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteOpenHelper;
/**
* Created by Maria on 11/23/2015.
*/
public class Databasehelper extends SQLiteOpenHelper {
public static final String DATABASE_NAME= "student.db";
public static final String TABLE_NAME= "student_data";
public static final String COL_1= "ID";
public static final String COL_2= "NAME";
public static final String COL_3= "SURNAME";
public static final String COL_4= "MARKS";
public Databasehelper(Context context) {
super(context, DATABASE_NAME, null, 1);
SQLiteDatabase sqLiteDatabase = this.getReadableDatabase();
}
@Override
public void onCreate(SQLiteDatabase sqLiteDatabase) {
String query = "CREATE TABLE " + TABLE_NAME + "(" +
COL_1 + " INTEGER PRIMARY KEY AUTOINCREMENT, " +
COL_2 + " TEXT, " +
COL_3 + " TEXT, " +
COL_4 + " INTEGER " +
");";
sqLiteDatabase.execSQL(query);
}
/* sqLiteDatabase.execSQL("CREATE TABLE" + TABLE_NAME + "("
+COL_1 + "INTEGER PRIMARY KEY AUTOINCREMENT, "
+COL_2 +" TEXT, "
+COL_3 +" TEXT, "
+COL_4 +"INTEGER);");
}
*/
@Override
public void onUpgrade(SQLiteDatabase sqLiteDatabase, int oldVersion, int newVersion) {
sqLiteDatabase.execSQL("DROP TABLE IF EXISTS " + TABLE_NAME);
onCreate(sqLiteDatabase);
}
/*@Override
public void onUpgrade(SQLiteDatabase sqLiteDatabase, int i, int i1) {
sqLiteDatabase.execSQL("DROP TABLE IF EXISTS"+TABLE_NAME);
onCreate(sqLiteDatabase);
}*/
}
Aucun commentaire:
Enregistrer un commentaire