RunBatch method

Future<String> RunBatch(
  1. List<String> sql
)

传入sql语句组并事务提交多条sql语句 成功：操作成功 失败：操作失败 打印报错

Implementation

Future<String> RunBatch(List<String> sql) async {
  try {
    var databasePath = await getDatabasesPath();
    String path = join(databasePath, DBPath);
    Database database = await openDatabase(path);
    var batch = database.batch();
    for (var i = 0; i < sql.length; i++) {
      batch.execute(sql[i]);
    }
    var results = await batch.commit();
    await database.close();
    return "操作成功";
  } catch (e) {
    print(e.toString());
    return "操作失败";
  }
}