Tuesday, 17 February 2015

How to create Database without using DBHelper Class


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;
        }
    }

No comments:

Post a Comment