DatabaseHelper

package com.example.appassistenza;

import java.util.ArrayList;
import android.content.Context;
import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteDatabase.CursorFactory;
import android.database.sqlite.SQLiteOpenHelper;

public class DatabaseHelper  {

    SQLiteDatabase mDb = null;
    DbHelper mDbHelper;
    Context mContext;

    private static final String DB_NAME = "DB";// nome del db
    private static final int DB_VERSION = 1; // numero di versione del nostro db

    public DatabaseHelper(Context ctx) {
        System.out.println("ISTANZIATO DB");
        mContext = ctx;
        mDbHelper = new DbHelper(ctx, DB_NAME, null, DB_VERSION);
    }

    public void open() { // il database su cui agiamo � leggibile/scrivibile
        mDb = mDbHelper.getWritableDatabase();

    }

    public void close() { // chiudiamo il database su cui agiamo
        mDb.close();
        System.out.println("Database chiuso");

    }



    static class AssistenzaDati {

        static final String ID = "_id";
        static final String RUBRICA = "assist_rubrica";
        static final String NOME = "nome";
        static final String COGNOME = "cognome";
        static final String INDIRIZZO = "indirzzo";
        static final String CITTA = "citt�";
        static final String EMAIL = "email";
        static final String TELEFONO = "telefono";



    }

    private static final String CREA_TABELLA_ANAGRAFICA = "CREATE TABLE IF NOT EXISTS "
            + AssistenzaDati.RUBRICA
            + " ("
            + AssistenzaDati.ID
            + " integer primary key autoincrement, "
            + AssistenzaDati.NOME
            + ", "
            + AssistenzaDati.COGNOME
            + ", "
            + AssistenzaDati.INDIRIZZO
            + ", "
            + AssistenzaDati.CITTA
            + ", "
            + AssistenzaDati.EMAIL
            + ", "
            + AssistenzaDati.TELEFONO + ");";



    private class DbHelper extends SQLiteOpenHelper {
        public DbHelper(Context context, String name, CursorFactory factory,
                int version) {
            super(context, name, factory, version);
        }



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



        @Override
        public void onCreate(SQLiteDatabase arg0) {
            // TODO Auto-generated method stub

        }
    }



    public SQLiteDatabase getWritableDatabase() {
        // TODO Auto-generated method stub
        return null;
    }
}