tl1.maxcom
Class BaseSQLite

java.lang.Object
  extended by SQLiteOpenHelper
      extended by tl1.maxcom.BaseSQLite

public class BaseSQLite
extends SQLiteOpenHelper

Classe pour la création des tables

Author:
Télécom Lille1

Field Summary
private static java.lang.String CAT_ID
           
private static java.lang.String CAT_IMAGE
           
private static java.lang.String CAT_NAME
           
private static java.lang.String CAT_NOTE
           
private static java.lang.String CAT_PARENT
           
private static java.lang.String CREATE_BDD_CATEGORIE
           
private static java.lang.String CREATE_BDD_SHEET
           
private static java.lang.String CREATE_BDD_TAXO
           
protected static SQLiteDatabase db
           
private static java.lang.String SHEET_DESCRIPTION
           
private static java.lang.String SHEET_FAVORITE
           
private static java.lang.String SHEET_ID
           
private static java.lang.String SHEET_IMAGE
           
private static java.lang.String SHEET_NAME
           
private static java.lang.String SHEET_NBCLIC
           
private static java.lang.String SHEET_NOTE
           
private static java.lang.String SHEET_SOUND
           
private static java.lang.String TABLE_CATEGORIE
           
private static java.lang.String TABLE_SHEET
           
private static java.lang.String TABLE_TAXONOMY
           
private static java.lang.String TAX_CAT
           
private static java.lang.String TAX_ID
           
private static java.lang.String TAX_SHEET
           
 
Constructor Summary
BaseSQLite(Context context, java.lang.String name, CursorFactory factory, int version)
           
 
Method Summary
 SQLiteDatabase getDb()
          Permet de récupérer la base de données pour l'utiliser dans les autres classes
 void onCreate(SQLiteDatabase db)
          Fonction appelée au premier lancement
 void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion)
           
 
Methods inherited from class java.lang.Object
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait
 

Field Detail

db

protected static SQLiteDatabase db

TABLE_CATEGORIE

private static final java.lang.String TABLE_CATEGORIE
See Also:
Constant Field Values

CAT_ID

private static final java.lang.String CAT_ID
See Also:
Constant Field Values

CAT_NAME

private static final java.lang.String CAT_NAME
See Also:
Constant Field Values

CAT_IMAGE

private static final java.lang.String CAT_IMAGE
See Also:
Constant Field Values

CAT_PARENT

private static final java.lang.String CAT_PARENT
See Also:
Constant Field Values

CAT_NOTE

private static final java.lang.String CAT_NOTE
See Also:
Constant Field Values

TABLE_SHEET

private static final java.lang.String TABLE_SHEET
See Also:
Constant Field Values

SHEET_ID

private static final java.lang.String SHEET_ID
See Also:
Constant Field Values

SHEET_NAME

private static final java.lang.String SHEET_NAME
See Also:
Constant Field Values

SHEET_DESCRIPTION

private static final java.lang.String SHEET_DESCRIPTION
See Also:
Constant Field Values

SHEET_IMAGE

private static final java.lang.String SHEET_IMAGE
See Also:
Constant Field Values

SHEET_SOUND

private static final java.lang.String SHEET_SOUND
See Also:
Constant Field Values

SHEET_FAVORITE

private static final java.lang.String SHEET_FAVORITE
See Also:
Constant Field Values

SHEET_NBCLIC

private static final java.lang.String SHEET_NBCLIC
See Also:
Constant Field Values

SHEET_NOTE

private static final java.lang.String SHEET_NOTE
See Also:
Constant Field Values

TABLE_TAXONOMY

private static final java.lang.String TABLE_TAXONOMY
See Also:
Constant Field Values

TAX_ID

private static final java.lang.String TAX_ID
See Also:
Constant Field Values

TAX_CAT

private static final java.lang.String TAX_CAT
See Also:
Constant Field Values

TAX_SHEET

private static final java.lang.String TAX_SHEET
See Also:
Constant Field Values

CREATE_BDD_CATEGORIE

private static final java.lang.String CREATE_BDD_CATEGORIE
See Also:
Constant Field Values

CREATE_BDD_SHEET

private static final java.lang.String CREATE_BDD_SHEET
See Also:
Constant Field Values

CREATE_BDD_TAXO

private static final java.lang.String CREATE_BDD_TAXO
See Also:
Constant Field Values
Constructor Detail

BaseSQLite

public BaseSQLite(Context context,
                  java.lang.String name,
                  CursorFactory factory,
                  int version)
Method Detail

onCreate

public void onCreate(SQLiteDatabase db)
Fonction appelée au premier lancement


getDb

public SQLiteDatabase getDb()
Permet de récupérer la base de données pour l'utiliser dans les autres classes


onUpgrade

public void onUpgrade(SQLiteDatabase db,
                      int oldVersion,
                      int newVersion)