replace split string in JLIST element using ResultSet SQLITE

Question

I have a JList model (listModelGrid) with items with labels like this:

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

I want to replace Labels with ResultSet.getString method like this:

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");

I have tried it but stuck in loops:

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;
}

Thanks in advance!

Answer 1

The code in your method is written in a little complicated way.

I have used regex and simplified the code you wanted to write and here it is.

private String getPrintingLabels(ResultSet rs) throws SQLException {
        Pattern p = Pattern.compile("([a-zA-Z]+)(,? )?");
        StringBuilder sb = new StringBuilder();
        for (int i = 0; i < listModelGrid.getSize(); i++) {
            String element = String.valueOf(listModelGrid.getElementAt(i));

            Matcher m = p.matcher(element);
            while(m.find()) {
                sb.append(rs.getString(m.group(1)));
                if (m.group(2) != null) {
                    sb.append(m.group(2));
                }
            }
            sb.append(System.getProperty("line.separator")); // helps correctly insert a new line for any platform linux/windows/any
        }
        System.out.println(sb.toString());
        return sb.toString();
    }

I don't know if you are familiar with regex but by using regex your job is done quite easily. Also, using String concatenation is not a good idea specially when you have to do it quite much hence I have used StringBuild for same purpose. Also used line.separator property so no matter in what platform you run the code it will have appropriate line in your string. Just use my method instead of yours and see if the desired string the one you wanted.

Also in my code, you won't have to manually manage inserting ", " or " " as that is done automatically as it is present in the string.

Also make sure you import these two or any needed imports,

import java.util.regex.Matcher;
import java.util.regex.Pattern;