SQLite Class

Calling from Main class:

Mainactivity.class
SqliteHelper sh=new SqliteHelper(context);
sh.getWritableDatabase();
sh.close();



import android.content.ContentValues;
import android.content.Context;
import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteOpenHelper;
import android.util.Log;
import android.widget.Toast;

public class SqliteHelper extends SQLiteOpenHelper
{

    Context context;
    String columnNames[];
    private static final int DATABASE_VERSION = 1;
    private static final String DATABASE_NAME = "example.db";
    String query="Create table information(ID INTEGER PRIMARY KEY,name1 TEXT,name1 TEXT,name1 TEXT,name1 TEXT,name1 TEXT)";
    ContentValues values1;
   
    public SqliteHelper(Context context)
    {
        super(context, DATABASE_NAME , null , DATABASE_VERSION);
        this.context = context;
    }

    @Override
    public void onCreate(SQLiteDatabase db) {
        Toast.makeText(context,"Database created", Toast.LENGTH_SHORT).show();
        db.execSQL(query);
    }

    @Override
    public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
       
        Toast.makeText(context,"Database Updated", Toast.LENGTH_SHORT).show();
        db.execSQL("DROP TABLE IF EXISTS information");
        onCreate(db);

    }
    public void insertvalues(String tablename,ContentValues values) {
       
        SQLiteDatabase db = this.getWritableDatabase();
        this.values1 = values;
        //db.beginTransaction();
        db.insert(tablename, null, values1);
        //db.endTransaction();
        Toast.makeText(context,values1.get("BankName")+"Added ", Toast.LENGTH_SHORT).show();
        //db.close(); // Closing database connection
    }
   
    public Cursor readvalues(String tablename) {
       
        SQLiteDatabase db = this.getReadableDatabase();
   
        //db.beginTransaction();
        Cursor  cursor = db.rawQuery("SELECT * FROM information" ,null);
        //db.endTransaction();
        Log.i("tag", "ColunmName:"+cursor. getColumnName(1));
        return cursor;
    }
   
    public void delete_value(String tablename,String columnname,int value)
    {
        SQLiteDatabase db = this.getWritableDatabase();
        //information", "BankName"
        Log.i("deletequery", "DELETE FROM information WHERE ID='"+value+"'");
        db.execSQL("DELETE FROM information WHERE ID='"+value+"'");
       
    }
   
   
     public boolean Update(String tablename, ContentValues values,int where){

            SQLiteDatabase db = this.getWritableDatabase();
            Log.i("Update", ":"+where);
            return db.update(tablename, values, "ID='"+where+"'", null) > 0;

            // Inserting Row
            //db.update(tablename, values, "BankName='"+value+"'", null);
            // Closing database connection
           
           
           
       }
}