Notes

package com.example.myapplication;

import android.content.ContentValues;
import android.content.Context;
import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteOpenHelper;

public class StudentHelper extends SQLiteOpenHelper {

public StudentHelper(Context context) {
super(context, "Student",null,1);
}

@Override
public void onCreate(SQLiteDatabase db) {
db.execSQL("create table CS5(name varchar(50), enroll varchar(5) primary key, id varchar(20))");
}

@Override
public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {

}
public boolean CS5_insert(String enroll, String sname, String id){
SQLiteDatabase sqLiteDatabase = this.getWritableDatabase();
ContentValues contentValues = new ContentValues();
contentValues.put("enroll", enroll);
contentValues.put("sname", sname);
contentValues.put("id", id);
long l = sqLiteDatabase.insert("CS5",null, contentValues);
if (l > 0)
return true;
else
return false;
}
public Cursor getData(){
SQLiteDatabase sqLiteDatabase = this.getReadableDatabase();

Cursor cursor = sqLiteDatabase.rawQuery("select * from CS5", null);
return cursor;
}
}