SQLHelper class running example

MyActivity.java

public class MyActivity extends ActionBarActivity {

    SomsHelper somsHelper;
    @Override
    protected void onCreate(Bundle savedInstanceState) {
        super.onCreate(savedInstanceState);
        setContentView(R.layout.activity_my);
        
        somsHelper = new SomsHelper(this);

        SQLiteDatabase sqlDatabase=somsHelper.getWritableDatabase();

    }
}

SomsHelper.java

public class SomsHelper extends SQLiteOpenHelper {

    private static final String DATABASE_NAME = "somsdatabase";
    private static final String TABLE_NAME = "SOMSTABLE";
    private static final String UID = "_id";
    private static final String NAME = "Name";
    private static final String ADDRESS = "Address";
    private static final String CREATE_TABLE="CREATE TABLE "+TABLE_NAME+" ("+UID+" INTEGER PRIMARY KEY AUTOINCREMENT, "+NAME+" VARCHAR(255), "+ADDRESS+" VARCHAR(255));";
    private static final String DROP_TABLE="DROP TABLE IF EXISTS "+TABLE_NAME;
    private static final int DATABASE_VERSION = 7;
    private Context context;

    public SomsHelper(Context context){
        super(context, DATABASE_NAME, null, DATABASE_VERSION);
        this.context = context;
        Message.message(context,"constructor called");
    }
    @Override
    public void onCreate(SQLiteDatabase db) {
        //first time called when db is created
        //CREATE TABLE SOMSTABLE (_id INTEGER PRIMARYKEY AUTOINCREMENT, Name VARCHAR(255));
        try {
            db.execSQL(CREATE_TABLE);
            Message.message(context,"OnCreate called");
        } catch (SQLException e) {
            Message.message(context,""+e);
        }


    }

    @Override
    public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
        try {
            Message.message(context,"OnUpgrade called");
            db.execSQL(DROP_TABLE);
            onCreate(db);
        } catch (SQLException e) {
            Message.message(context,""+e);
        }
    }
}