RunSQL method

Future<String> RunSQL(
  1. String sql
)

传入sql语句并单独执行这一条语句 成功：操作成功 失败：操作失败 打印报错

Implementation

Future<String> RunSQL(String sql) async {
  try {
    var databasePath = await getDatabasesPath();
    String path = join(databasePath, DBPath);
    Database database = await openDatabase(path);
    await database.execute(sql);
    await database.close();
    return "操作成功";
  } catch (e) {
    print(e.toString());
    return "操作失败";
  }
}