var update = await db.rawUpdate(‘UPDATE Test SET name = ? WHERE name = ?’,
[‘updated name’, ‘test’]);
var result = await db.query(‘Test’);
if (result!=null) {
Fluttertoast.showToast(msg: “数据更新成功:$result”,gravity: ToastGravity.CENTER,);
}else {
print(“其他”);
}
} finally {
await db.close();
}
}
5.5 删除数据库
rawDBDelete() async {
var path = await initDb(‘raw_simple.db’);
var db = await openDatabase(path);
try {
deleteDatabase(path);
Fluttertoast.showToast(msg: “数据删除成功”,gravity: ToastGravity.CENTER,);
} finally {
await db.close();
}
}
5.6 界面布局
ListView(
children: [
Center(child: Text(“Raw数据库操作”, style: TextStyle(color: Colors.orange, fontSize: 15.0),),),
Padding(padding: const EdgeInsets.all(5.0), child: ElevatedButton(child: const Text(‘rawDBTableCreate’), onPressed: () => rawDBTableCreate())),
Padding(padding: const EdgeInsets.all(5.0), child: ElevatedButton(child: const Text(‘rawDBInsert’), onPressed: () => rawDBInsert())),
Padding(padding: const EdgeInsets.all(5.0), child: ElevatedButton(child: const Text(‘rawDBQuery’), onPressed: () => rawDBQuery())),
Padding(padding: const EdgeInsets.all(5.0), child: ElevatedButton(child: const Text(‘rawDBUpdate’), onPressed: () => rawDBUpdate())),
Padding(padding: const EdgeInsets.all(5.0), child: ElevatedButton(child: const Text(‘rawDBDelete’), onPressed: () => rawDBDelete())),
],
)
6.1 Model类及数据库操作类
import ‘dart:io’;
import ‘