使用 ResultSet SQLITE 替换 JLIST 元素中的拆分字符串

Question

我有一个 JList 模型 ( listModelGrid)，其中包含带有如下标签的项目：

LastName, FirstName Spouse // e.g. This is 1st list item with labels

Children                   // e.g. This is 2nd list item with labels

Street                     // e.g. This is 3rd list item with labels

City, State Postal         // e.g. This is 4th list item with labels

我想用这样的ResultSet.getString方法替换标签：

String labels = "";

labels += resultSet.getString("LastName")+", "+resultSet.getString("FirstName")+" "+

          resultSet.getString("Spouse") + "\n";

labels += resultSet.getString("Children") + "\n";

labels += resultSet.getString("Street") + "\n";

labels += resultSet.getString("City")+", "+resultSet.getString("State")+" "+

          resultSet.getString("Postal");

我试过了，但卡在循环中：

private String getPrintingLabels(ResultSet rs) throws SQLException {

    String str = "";

    for (int i = 0; i < listModelGrid.getSize(); i++) {

        String element = String.valueOf(listModelGrid.getElementAt(i));

        String[] lbls = element.split(",\\s");

        str += rs.getString(lbls[0])+", ";

        for(int j = 1; j < lbls.length ; j++) {

            // Stuck on her

        }

        String[] lbls2 = element.split("\\s");

        str += rs.getString(lbls2[0])+" ";

        for(int j = 1; j < lbls2.length ; j++) {

            // Stuck on her

        }

    }

    return str;

}

提前致谢！