co.uk.wxApp.controllers

Class DBAdapter

java.lang.Object

co.uk.wxApp.controllers.DBAdapter

public class DBAdapter
extends java.lang.Object

Handles connections to the local SQLite database

Author:

Heavily influenced / mostly copied from Android book: Beginning Android Application Development - WEI-MENG LEE, 2012

Constructor Summary

Constructors

Constructor and Description
DBAdapter(android.content.Context ctx) Set up connection to the database

Method Summary

Methods

Modifier and Type	Method and Description
void	close() Close the database
android.database.Cursor	getAllData(boolean isLiveData) Obtain all data for a given table in the db
android.database.Cursor	getCityInfo(java.lang.String city) Obtain lat/lng data for a particular city
DBAdapter	open() Open the database
void	update(java.lang.String[] data) Updates the entire live table with new data

Methods inherited from class java.lang.Object

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

Constructor Detail

DBAdapter

public DBAdapter(android.content.Context ctx)

Set up connection to the database

Parameters:

ctx -

Method Detail

open

public DBAdapter open()
               throws android.database.SQLException

Open the database

Returns:

Throws:

android.database.SQLException

close

public void close()

Close the database

getAllData

public android.database.Cursor getAllData(boolean isLiveData)

Obtain all data for a given table in the db

Parameters:

isLiveData - which table to use (live or cities)

Returns:

all the data for that table

getCityInfo

public android.database.Cursor getCityInfo(java.lang.String city)

Obtain lat/lng data for a particular city

Parameters:

city - the city name

Returns:

data

update

public void update(java.lang.String[] data)

Updates the entire live table with new data

Parameters:

data - the 2D data array for the nine cities