SQLiteOpenHelper – Advance Database

SQLiteOpenHelper – Advance Database

    public class MainActivity extends AppCompatActivity implements View.OnClickListener {
     
        private EditText name;
        private EditText sureName;
        private EditText remarks;
        private Button btn;
     
        DataBaseHelper db;
     
        @Override
        protected void onCreate(Bundle savedInstanceState) {
            super.onCreate(savedInstanceState);
            setContentView(R.layout.activity_main);
     
            db = new DataBaseHelper(this);
     
            name = (EditText) findViewById(R.id.name);
            sureName = (EditText) findViewById(R.id.sureName);
            remarks = (EditText) findViewById(R.id.remarks);
            btn = (Button) findViewById(R.id.btn);
     
            btn.setOnClickListener(this);
        }
     
        @Override
        public void onClick(View view) {
     
            boolean isInsert = db.insertData(name.getText().toString(), sureName.getText().toString(), remarks.getText().toString());
     
            if(isInsert)
                Toast.makeText(this, "Data is Insert", Toast.LENGTH_SHORT).show();
            else
                Toast.makeText(this, "No Data", Toast.LENGTH_SHORT).show();
        }
    }

on DataBaseHelper class

public class DataBaseHelper extends SQLiteOpenHelper{
 
    public static final String DATABASE_NAME = "student.db";
    public static final String TABLE_NAME = "student_table";
    public static final String COL_NAME = "name";
    public static final String COL_SURENAME = "surename";
    public static final String COL_MARKS = "marks";
 
    public DataBaseHelper(Context context) {
 
        //database will be created on this constriction called
        super(context, DATABASE_NAME, null, 1);
        Toast.makeText(context, "database created", Toast.LENGTH_SHORT).show();
 
        //create the table
 
    }
 
    @Override
    public void onCreate(SQLiteDatabase db) {
 
        //create a table
        db.execSQL("create table if not exists " +TABLE_NAME +" (ID INTEGER PRIMARY KEY AUTOINCREMENT, name TEXT, surename TEXT, marks INTEGER)");
 
    }
 
    @Override
    public void onUpgrade(SQLiteDatabase db, int i, int i1) {
 
        db.execSQL("DROP TABLE IF EXISTS" + TABLE_NAME);
        onCreate(db);
    }
 
    public boolean insertData(String name,String surname,String marks) {
        SQLiteDatabase db = this.getWritableDatabase();
        ContentValues contentValues = new ContentValues();
        contentValues.put(COL_NAME,name);
        contentValues.put(COL_SURENAME,surname);
        contentValues.put(COL_MARKS,marks);
        long result = db.insert(TABLE_NAME,null ,contentValues);
        if(result == -1)
            return false;
        else
            return true;
    }
}

More Info:

SQLiteOpenHelper Android Document