Package com.example.dhaka_metro_rail

Class DatabaseHelper

java.lang.Object

android.database.sqlite.SQLiteOpenHelper

com.example.dhaka_metro_rail.DatabaseHelper

All Implemented Interfaces:

AutoCloseable

public class DatabaseHelper
extends android.database.sqlite.SQLiteOpenHelper

Field Summary

Fields

Modifier and Type	Field	Description
private static final String	COLUMN_ENDING_STATION
private static final String	COLUMN_STARTING_STATION
private static final String	COLUMN_TICKET_QUANTITY
private static final String	COLUMN_TICKET_TYPE
private android.content.Context	context
private static final String	DATABASE_NAME
private static final int	DATABASE_VERSION
private static final String	TABLE_NAME

Constructor Summary

Constructors

Constructor	Description
DatabaseHelper(android.content.Context context)

Method Summary

Modifier and Type	Method	Description
long	addTicket(String ticketType, int ticketQuantity, String startingStation, String endingStation)
void	onCreate(android.database.sqlite.SQLiteDatabase db)
void	onUpgrade(android.database.sqlite.SQLiteDatabase db, int oldVersion, int newVersion)

Methods inherited from class android.database.sqlite.SQLiteOpenHelper

close, getDatabaseName, getReadableDatabase, getWritableDatabase, onConfigure, onDowngrade, onOpen, setIdleConnectionTimeout, setLookasideConfig, setOpenParams, setWriteAheadLoggingEnabled

Methods inherited from class java.lang.Object

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

Field Details

DATABASE_NAME

private static final String DATABASE_NAME

See Also:

• Constant Field Values

TABLE_NAME

private static final String TABLE_NAME

See Also:

• Constant Field Values

COLUMN_TICKET_TYPE

private static final String COLUMN_TICKET_TYPE

See Also:

• Constant Field Values

COLUMN_TICKET_QUANTITY

private static final String COLUMN_TICKET_QUANTITY

See Also:

• Constant Field Values

COLUMN_STARTING_STATION

private static final String COLUMN_STARTING_STATION

See Also:

• Constant Field Values

COLUMN_ENDING_STATION

private static final String COLUMN_ENDING_STATION

See Also:

• Constant Field Values

DATABASE_VERSION

private static final int DATABASE_VERSION

See Also:

• Constant Field Values

context

private android.content.Context context

Constructor Details

DatabaseHelper

public DatabaseHelper(android.content.Context context)

Method Details

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

addTicket

public long addTicket(String ticketType,
 int ticketQuantity,
 String startingStation,
 String endingStation)