String sqlCreateTbl =
"CREATE TABLE IF NOT EXISTS HOMEDATA (_id INTEGER PRIMARY KEY AUTOINCREMENT, homeNum INTEGER, homeType TEXT, homeName TEXT, homeRent TEXT, homeFee TEXT)"
;
db.execSQL(sqlCreateTbl);
public
void
insert(
int
homeNum, String homeType, String homeName, String homeRent, String homeFee) {
SQLiteDatabase db = getWritableDatabase();
String sqlInsert =
"INSERT OR IGNORE INTO HOMEDATA (homeNum, homeType, homeName, homeRent, homeFee) VALUES ("
+ homeNum +
", '"
+ homeType +
"', '"
+ homeName +
"', '"
+ homeRent +
"', '"
+ homeFee +
"')"
;
db.execSQL(sqlInsert);
db.close();
}