it.rn2014.db

Class DataBaseManager

java.lang.Object

android.database.sqlite.SQLiteOpenHelper

it.rn2014.db.DataBaseManager

public class DataBaseManager
extends android.database.sqlite.SQLiteOpenHelper

Classe per la gestione dei DATABASE

Author:

Luca Sirri

Field Summary

Fields

Modifier and Type	Field and Description
private android.database.sqlite.SQLiteDatabase	database Riferimento al database
private java.io.File	DB_FILE Riferimento al file DB
private static java.lang.String	DB_NAME Nome del database
private java.lang.String	DB_PATH Path del database
static java.lang.String	TAG Tag per i log

Constructor Summary

Constructors

Constructor and Description
DataBaseManager(android.content.Context context, java.lang.String name) Costruttore che istanzia un nuovo DB caricando PATH, NAME e FILE

Method Summary

Methods

Modifier and Type	Method and Description
boolean	checkDataBase() Controlla se il db esiste
private boolean	checkDataBase(java.io.File dbFile) Controlla se il db esiste
void	close() Chiude il database
void	createDataBase() Crea un nuovo database
boolean	deleteDataBase() Elimina il database
private boolean	deleteDataBase(java.io.File dbFile) Elimina il file di database indicato
void	onCreate(android.database.sqlite.SQLiteDatabase db)
void	onUpgrade(android.database.sqlite.SQLiteDatabase db, int oldVersion, int newVersion)
boolean	openDataBase() Apre il database al fine di poterci fare query

Methods inherited from class android.database.sqlite.SQLiteOpenHelper

getDatabaseName, getReadableDatabase, getWritableDatabase, onConfigure, onDowngrade, onOpen, setWriteAheadLoggingEnabled

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Field Detail

TAG

public static final java.lang.String TAG

Tag per i log

See Also:

Constant Field Values

DB_NAME

private static java.lang.String DB_NAME

Nome del database

DB_PATH

private java.lang.String DB_PATH

Path del database

database

private android.database.sqlite.SQLiteDatabase database

Riferimento al database

DB_FILE

private java.io.File DB_FILE

Riferimento al file DB

Constructor Detail

DataBaseManager

public DataBaseManager(android.content.Context context,
               java.lang.String name)

Costruttore che istanzia un nuovo DB caricando PATH, NAME e FILE

Parameters:

context - Contesto di esecuzione

name - Nome del database

Method Detail

createDataBase

public void createDataBase()
                    throws java.io.IOException

Crea un nuovo database

Throws:

java.io.IOException - Se ha problemi di IO (non riesce a creare il file)

deleteDataBase

public boolean deleteDataBase()

Elimina il database

Returns:

True se completato correttamente, false altrimenti

deleteDataBase

private boolean deleteDataBase(java.io.File dbFile)

Elimina il file di database indicato

Parameters:

dbFile - File DB Da eliminare

Returns:

True se completato correttamente, false altrimenti

checkDataBase

public boolean checkDataBase()

Controlla se il db esiste

Returns:

True se esiste, false altrimenti

checkDataBase

private boolean checkDataBase(java.io.File dbFile)

Controlla se il db esiste

Parameters:

dbFile - File DB Da controllare

Returns:

True se esiste, false altrimenti

openDataBase

public boolean openDataBase()
                     throws android.database.SQLException

Apre il database al fine di poterci fare query

Returns:

True se aperto correttamente, false altrimenti

Throws:

android.database.SQLException - Errori a livello di DB

close

public void close()

Chiude il database

Overrides:

close in class android.database.sqlite.SQLiteOpenHelper

onCreate

public void onCreate(android.database.sqlite.SQLiteDatabase db)

Specified by:

onCreate in class android.database.sqlite.SQLiteOpenHelper

onUpgrade

public void onUpgrade(android.database.sqlite.SQLiteDatabase db,
             int oldVersion,
             int newVersion)

Specified by:

onUpgrade in class android.database.sqlite.SQLiteOpenHelper