json - 使用 ListView 在行中显示 json 数据

Question

我想把activity中的数据显示到ListView中下面是图像

如果这是我的代码

    FutureBuilder(
      future: UserController.getActivity(_selectedUser),
       builder: (context, snapshot) {
        if(snapshot.hasData){
           return Column(
               children: <Widget>[
                   Expanded

(
                  child: ListView.separated(
                       itemCount: snapshot.data.length,
                       itemBuilder: (context, position){
                        var item = snapshot.data.elementAt(position);
                        return Text(item[0]["activity "]);
                       }
                   ),
                )
            ],
           );
         }

         return Center(
            child: CircularProgressIndicator(),
         );
      },
   ),

这里是 api.dart 的代码

   static getCompany() async {
    return await Http.get("user/getCompany");
  }

这是数据库的 Controller 代码

public function GetCompany() {
        $sql = "SELECT 
        clients.companies.name
      FROM
        clients.companies";
        $parameter = [];

        return $this->queryArray($sql, $parameter);
    }

和 library.php 中的 queryArray

protected function queryArray($sql, $parameter){
        try {
            $stmt = $this->query($sql, $parameter);
            return $stmt->fetchAll(PDO::FETCH_ASSOC);
        }catch(Exception $e){
            return array();
        }
    }

Answer 1

这是代码，我如何从 firebase 获取数据

Future<void> _getCarList() async {
    _list.clear();

    setState(() {
      isApiInExecution = true;
    });

    await _driveListRef.once().then((DataSnapshot snapshot) {
      setState(() {
        isApiInExecution = false;
      });

      if (snapshot == null || snapshot.value == null) {
        return;
      }
      print(' 11 Connected to second database and read ${snapshot.value}');
//      HashMap<String, String> _values = snapshot.value;
      snapshot.value.forEach((key, _vehicleModel) {
        VehicleModel vehicleModel = VehicleModel(
            rego: (_vehicleModel['rego'] != null ? _vehicleModel['rego'] : ""),
            state:
                (_vehicleModel['state'] != null ? _vehicleModel['state'] : ""),
            vin: (_vehicleModel['vin'] != null ? _vehicleModel['vin'] : ""),
            year: (_vehicleModel['year'] != null ? _vehicleModel['year'] : ""),
            make: (_vehicleModel['make'] != null ? _vehicleModel['make'] : ""),
            model:
                (_vehicleModel['model'] != null ? _vehicleModel['model'] : ""),
            colour: (_vehicleModel['colour'] != null
                ? _vehicleModel['colour']
                : ""));

        _list.add(vehicleModel);
      });
    }).then((onError) {
      if (onError == null) {
        return;
      }
      print('On Error Connected to second database and read $onError');
    });
  }

希望对你有帮助