RunSelect method

Future<List<Map>> RunSelect(
  1. String sql
)

传入sql语句并单独执行这一条搜索语句 成功：查询数据 失败：返回空 打印报错

Implementation

Future<List<Map>> RunSelect(String sql) async {
  try {
    var databasePath = await getDatabasesPath();
    String path = join(databasePath, DBPath);
    Database database = await openDatabase(path);
    List<Map> list = await database.rawQuery(sql);
    await database.close();
    return list;
  } catch (e) {
    List<Map> err = [];
    print(e.toString());
    return err;
  }
}