Flutter开发之——数据库，kotlin数组初始化

}

}

return path;

}

五 RawData数据库操作

---

5.1 创建数据库

rawDBTableCreate() async {

var path = await initDb(‘raw_simple.db’);

var db = await openDatabase(path);

try {

await db.execute(‘CREATE TABLE Test (id INTEGER PRIMARY KEY, name TEXT)’);

} finally {

await db.close();

}

}

5.2 插入数据库

rawDBInsert() async {

var path = await initDb(‘raw_simple.db’);

var db = await openDatabase(path);

try {

var insertResult= await db.rawInsert(‘INSERT INTO Test (name) VALUES (?)’, [‘test’]);

if (insertResult>0) {

Fluttertoast.showToast(msg: “数据插入成功”,gravity: ToastGravity.CENTER);

}else {

print(“其他”);

}

} finally {

await db.close();

}

}

5.3 查询数据库

rawDBQuery() async {

var path = await initDb(‘raw_simple.db’);

var db = await openDatabase(path);

try {

var result = await db.query(“Test”);

if (result.isNotEmpty) {

Fluttertoast.showToast(

msg: “数据查询成功:$result”, gravity: ToastGravity.CENTER);

} else {

Fluttertoast.showToast(

msg: “数据为空，请先写入数据”, gravity: ToastGravity.CENTER);

}

} catch (ex) {

Fluttertoast.showToast(msg: “$ex”, gravity: ToastGravity.CENTER);

} finally {

await db.close();

}

}

5.4 更新数据库

rawDBUpdate() async {

var path = await initDb(‘raw_simple.db’);

var db = await openDatabase(path);

try {

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,);