Java sqlite事务方法,Java SQLiteDatabase.insert方法代码示例

import net.sqlcipher.database.SQLiteDatabase; //导入方法依赖的package包/类

@Override public void onCreate(SQLiteDatabase db) {

db.execSQL(CREATE_LIST);

db.execSQL(CREATE_ITEM);

db.execSQL(CREATE_ITEM_LIST_ID_INDEX);

long groceryListId = db.insert(TodoList.TABLE, null, new TodoList.Builder()

.name("Grocery List")

.build());

db.insert(TodoItem.TABLE, null, new TodoItem.Builder()

.listId(groceryListId)

.description("Beer")

.build());

db.insert(TodoItem.TABLE, null, new TodoItem.Builder()

.listId(groceryListId)

.description("Point Break on DVD")

.build());

db.insert(TodoItem.TABLE, null, new TodoItem.Builder()

.listId(groceryListId)

.description("Bad Boys 2 on DVD")

.build());

long holidayPresentsListId = db.insert(TodoList.TABLE, null, new TodoList.Builder()

.name("Holiday Presents")

.build());

db.insert(TodoItem.TABLE, null, new TodoItem.Builder()

.listId(holidayPresentsListId)

.description("Pogo Stick for Jake W.")

.build());

db.insert(TodoItem.TABLE, null, new TodoItem.Builder()

.listId(holidayPresentsListId)

.description("Jack-in-the-box for Alec S.")

.build());

db.insert(TodoItem.TABLE, null, new TodoItem.Builder()

.listId(holidayPresentsListId)

.description("Pogs for Matt P.")

.build());

db.insert(TodoItem.TABLE, null, new TodoItem.Builder()

.listId(holidayPresentsListId)

.description("Cola for Jesse W.")

.build());

long workListId = db.insert(TodoList.TABLE, null, new TodoList.Builder()

.name("Work Items")

.build());

db.insert(TodoItem.TABLE, null, new TodoItem.Builder()

.listId(workListId)

.description("Finish SqlBrite library")

.complete(true)

.build());

db.insert(TodoItem.TABLE, null, new TodoItem.Builder()

.listId(workListId)

.description("Finish SqlBrite sample app")

.build());

db.insert(TodoItem.TABLE, null, new TodoItem.Builder()

.listId(workListId)

.description("Publish SqlBrite to GitHub")

.build());

long birthdayPresentsListId = db.insert(TodoList.TABLE, null, new TodoList.Builder()

.name("Birthday Presents")

.archived(true)

.build());

db.insert(TodoItem.TABLE, null, new TodoItem.Builder().listId(birthdayPresentsListId)

.description("New car")

.complete(true)

.build());

}