/* 判断列是否存在 */
private boolean checkColumnExist(SQLiteDatabase db, String tableName,
String columnName) {
db.beginTransaction();
boolean result = false;
Cursor cursor = null;
try {
// 查询一行
cursor = db.rawQuery("SELECT * FROM " + tableName + " LIMIT 0",
null);
result = cursor != null && cursor.getColumnIndex(columnName) != -1;
db.setTransactionSuccessful();
} catch (Exception e) {
} finally {
db.endTransaction();
if (null != cursor && !cursor.isClosed()) {
cursor.close();
}
}
return result;
}
private boolean checkColumnExist(SQLiteDatabase db, String tableName,
String columnName) {
db.beginTransaction();
boolean result = false;
Cursor cursor = null;
try {
// 查询一行
cursor = db.rawQuery("SELECT * FROM " + tableName + " LIMIT 0",
null);
result = cursor != null && cursor.getColumnIndex(columnName) != -1;
db.setTransactionSuccessful();
} catch (Exception e) {
} finally {
db.endTransaction();
if (null != cursor && !cursor.isClosed()) {
cursor.close();
}
}
return result;
}