android sqlite database is locked (code 5): , while compiling:....

安卓开发时用到了sqlite数据库， 到网上复制了点例子，结果反复运行的时候出现异常：database is locked (code 5): , while compiling:....

到网上查都是一堆的代码，看着就头晕

最后解决：

执行sql后关闭事务，再关闭数据库即可。

部分代码:

private ProfileDBHelper profileDBHelper; public ProfileDAO(Context context){ this.context = context; profileDBHelper = new ProfileDBHelper(context); } public void save(String brand, String type){ SQLiteDatabase db = profileDBHelper.getWritableDatabase(); db.beginTransaction(); String sql = "insert into " + ProfileDBHelper.TABLE_NAME + "(id, brand, type)" + " values(null, '" + brand + "','" + type + "')"; db.execSQL(sql); db.setTransactionSuccessful(); db.endTransaction(); // db.close(); // }