在 SQLite 查询后填充 ListView

debugcn 发表于 Dev

用户9064724

我需要从查询中填充数据并ListView使用 custom填充它Item。

上OnCreateView，我这样称呼我的适配器：

final ArrayAdapter<String> arrayAdapter = new ArrayAdapter<String>
                (getContext(), android.R.layout.simple_list_item_1, stops)

这是我的全部代码 LoadData

public void LoadData() {
    String query = "SELECT ticket_placeto, COUNT(CASE WHEN passenger_type <> 'Baggage' THEN 1 END) AS Pass,\n" +
            "COUNT(CASE WHEN passenger_type =  'Baggage' THEN 1 END) AS Baggage FROM tickets GROUP BY ticket_placeto";

    c = sqldb.rawQuery(query, null);

    if (c != null) {
        if (c.moveToFirst()) {
            do {
                String placeto = c.getString(0);
                String passengers = c.getString(1);
                String baggages = c.getString(2);

                stops.add(placeto + "                 " + passengers + "               " + baggages);

            } while (c.moveToNext());
        }
    }
}

这是它的输出

我刚刚硬编码了stops.add临时显示数据的间距。我已经有一个自定义，ListItem Layout但同时没有使用它。

这是查询的结果 chrome://inspect

在此处输入图片说明

用户9064724

供您参考，我只是重新编码LoadData。感谢在这里帮助我的pskink以及在此线程上做出响应的其他人。

  public void LoadData() {
    String query = "SELECT _id, ticket_placeto, " +
            "COUNT(CASE WHEN passenger_type <> 'Baggage' THEN 1 END) AS Pass," +
            "COUNT(CASE WHEN passenger_type =  'Baggage' THEN 1 END) AS Baggage " +
            "FROM tickets GROUP BY ticket_placeto";


    final String[] columns = new String[]{
            DBHelper.TICKET_ID,
            DBHelper.TICKET_PLACETO,
            "Pass",
            "Baggage",
    };

    final int[] to = new int[]{
            R.id.stops_id,
            R.id.stops_location,
            R.id.stops_passengers,
            R.id.stops_baggages
    };


    c = sqldb.rawQuery(query,null);
    if (c != null) {
        adapter = new SimpleCursorAdapter(getContext(), R.layout.item_for_stops, c, columns, to, 0);
        lv_stops.setAdapter(adapter);
    }
}

本文收集自互联网，转载请注明来源。

如有侵权，请联系[email protected] 删除。