![](https://img.laitimes.com/img/_0nNw4CM6IyYiwiM6ICdiwiIzQjN3EjN1EjM2ADNwYTMwIzLcRXZu5ibkN3Yuc2bsJmLn1Wavw1LcpDc0RHaiojIsJye.jpg)
1. 加載驅動.
2. 連接配接資料庫.
3. 操作資料庫.
建立表:
create table person(
_id integer primary key,
name varchar(20),
age integer
);
添加: insert into person(name, age) values('lisi', 19);
删除: delete from person where _id = 1;
修改: update person set name = '李四' where name = '王五';
查詢所有: select * from person;
查詢單條: select * from person where name = 'zhangsan';
sqliteexpert3, pc上的工具軟體。
adb shell
事務:
update person set balance = balance - 100 where name = 'lisi';
update person set balance = balance + 100 where name = 'zhangsan';
// 開啟事務
db.begintransaction();
// 标記事務成功
db.settransactionsuccessful();
// 停止事務
db.endtransaction();
listview_item.xml