android数据库清除表,android 数据库增删改查笔记

表结构

private final String storeColumns = "store_id,store_name,store_area_id,store_area_name,user_id,user_name";

清空表数据，并根据表中的字段入库

/**

* @param storeList

*/

public void insertStore(List storeList) {

if (storeList.size() == 0) {

Log.i(TAG, "BasicDataManager---insertStore--数据为空，不执行插入");

return;

}

SQLiteDatabase db = dbOpenHelper.getWritableDatabase();

try {

db.beginTransaction();

//先删除

db.execSQL("delete from wd_store", new Object[]{});

for (int i = 0; i < storeList.size(); i++) {

StoreEntity entity = storeList.get(i);

db.execSQL(

"insert into wd_store(" + storeColumns + ") values(?,?,?,?,?,?)",

new Object[]{entity.getStoreId(), entity.getStoreName(