There are 2 classes. main class and Database class.
main
public class MainActivity extends AppCompatActivity {
@Override
protected void onCreate(Bundle savedInstanceState) {
super.onCreate(savedInstanceState);
setContentView(R.layout.activity_main);
Database g= new Database(this);
SQLiteDatabase db= g.getReadableDatabase();
}
}
Database class
public class Database extends SQLiteOpenHelper {
private static final String DATABASE_NAME = "School_DB.db";
private static final String TABLE_NAME = "student";
private static final String COL_1 = "ID";
private static final String COL_2 = "NAME";
private static final String COL_3 = "MARK";
public Database(Context context) {
super(context, DATABASE_NAME, null, 1);
}
@Override
public void onCreate(SQLiteDatabase db) {
String sqlQ = "CREATE TABLE IF NOT EXISTS " + TABLE_NAME + "("
+ COL_1 + " INTEGER PRIMARY KEY AUTOINCREMENT,"
+ COL_2 + " TEXT,"
+ COL_3 + " TEXT" + ")";
db.execSQL(sqlQ);
}
@Override
public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
db.execSQL("DROP TABLE IF EXISTS " + TABLE_NAME);
onCreate(db);
}
}
when I downloaded db data from "Device file explorer" in Android studio and viewed it in DBbrowser table showing is 0 (zero).
