public Method()
{
...
//create database
SQLiteDatabase db = this.openOrCreateDatabase("DatabaseName.db", 0, null);
//create table
db.execSQL("CREATE TABLE tableName ( columname1,columname2,columname3);");
//insert row
String sql="Insert into tableName(columname1,columname2,columname3) values(v1,v2,v3
db.execSQL(sql);
//update row
String insertId="UPDATE tableName SET columname1 = " + demovalue
+ " where columname2=" + Hello";
db.execSQL(insertId);
//drop table
db.execSQL("DROP TABLE tableName;");
if( existsColumnInTable(db,tableName, columname3))
{
// colum is duplicate
}
...
}
private boolean existsColumnInTable(SQLiteDatabase inDatabase,
String inTable, String columnToCheck) {
try {
Cursor mCursor = inDatabase.rawQuery("SELECT * FROM " + inTable
+ " LIMIT 0", null);
if (mCursor.getColumnIndex(columnToCheck) != -1)
return true;
else
return false;
} catch (Exception Exp) {
Log.d("... - existsColumnInTable",
"When checking whether a column exists in the table, an error occurred: "
+ Exp.getMessage());
return false;
}
}