DBManager.java

package com.hussienalrubaye.androiddemowork;

import android.content.ContentValues;
import android.content.Context;
import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteOpenHelper;
import android.database.sqlite.SQLiteQueryBuilder;
import android.view.LayoutInflater;
import android.view.View;
import android.view.ViewGroup;
import android.widget.BaseAdapter;
import android.widget.TextView;
import android.widget.Toast;

import java.util.ArrayList;

/**
 * Created by hussienalrubaye on 9/8/16.
 */

public class DBManager {
    private SQLiteDatabase sqlDB;
    static final String DBName="Students";
    static final String TableName="Logins";
    static final String ColUserName="UserName";
    static final String ColPassWord="Password";
    static final String ColID="ID";
    static final  int DBVersion=3;
     // create table Logins(ID integer primary key autoincrment, UserName text, Password text)
     static final  String CreateTable=" CREATE TABLE IF NOT EXISTS " +TableName+
             "(ID INTEGER PRIMARY KEY AUTOINCREMENT,"+ ColUserName+
             " TEXT,"+ ColPassWord + " TEXT);";

   private static class  DatabaseHelperUser extends SQLiteOpenHelper{
Context context;
        DatabaseHelperUser(Context context){
            super(context,DBName,null,DBVersion);
            this.context=context;

        }

        @Override
        public void onCreate(SQLiteDatabase db) {
            db.execSQL(CreateTable);
            Toast.makeText(context,"Table is created",Toast.LENGTH_LONG).show();
        }

        @Override
        public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
        db.execSQL("Drop table IF  EXISTS "+ TableName);
            onCreate(db);
        }
    }



    public DBManager(Context context){

        DatabaseHelperUser db=new DatabaseHelperUser(context) ;
        sqlDB=db.getWritableDatabase();

    }

    public  long Insert(ContentValues values){
     long ID=   sqlDB.insert(TableName,"",values);
        //could insert id is user id, or fail id is or equal 0
        return ID;
    }
    //select username,Password from Logins where ID=1
    public Cursor query(String[] Projection,String Selection,String[] SelectionArgs,String SortOrder){

        SQLiteQueryBuilder qb= new SQLiteQueryBuilder();
        qb.setTables(TableName);

        Cursor cursor=qb.query(sqlDB,Projection,Selection,SelectionArgs,null,null,SortOrder);
        return cursor;
    }

    public int Delete(String Selection,String[] SelectionArgs){
        int count=sqlDB.delete(TableName,Selection,SelectionArgs);
        return count;
    }

public  int Update(ContentValues values,String Selection,String[] SelectionArgs)
{
    int count=sqlDB.update(TableName,values,Selection,SelectionArgs);
    return count;
}

}