Android SQLite(2)如何判断表是否已经存在

在sql语句中用 if not exists

void create_table(){
        SQLiteDatabase dbWireter = dbhelper.getWritableDatabase();
        String sql = String.format("CREATE TABLE if not exists %s(%s %s DEFAULT %s,%s %s DEFAULT %s)",
                DB_TABLE,
                DB_COLUMN_NAME,"TEXT","NONE",
                DB_COLUMN_GENDER,"TEXT","NONE");
        dbWireter.execSQL(sql);
        dbWireter.close();
    }

 

转载于:https://www.cnblogs.com/sjjg/p/4634009.html