AndroidDBのデータを読み込む

Android データベースのデータを読み込む(Select)
http://yan-note.blogspot.com/2010/09/android-select.html



// table create
/*
* 20111104カンマが抜けてた。。。
* db.execSQL(" CREATE TABLE TYZERO_BLUETOOTH_TABLE("
+ " BLUETOOTH_RECEIVE_TIME TEXT NOT NULL,"
+ " BLUETOOTH_NODE_NAME TEXT," ←これ以下のカンマが抜けてたせいで、BLUETOOTH_NODE_NAMEまでしかカラムがなかった
+ " BLUETOOTH_NODE_MAC TEXT,"
+ " BLUETOOTH_LANDMARK_NAME TEXT,"
+ " BLUETOOTH_LANDMARK_MAC TEXT,"
+ " BLUETOOTH_LANDMARK_RSSI REAL,"
+ " BLUETOOTH_RECEIVE_TIME_SECOND REAL,"
+ " BLUETOOTH_RECEIVE_TIME_YMD INTEGER" + ");");
*/