Thread: ResultSet issues

Ok, I have this so far:

            String getCust = "SELECT FirstName, LastName FROM Customer WHERE FirstName = ?";
            PreparedStatement ps = con.prepareStatement(getCust);
            ps.setString(1, "Alexander");
            ResultSet rs = ps.executeQuery();

I just can't figure out how to get it be able to be stored? I've attempted an ArrayList and failed (maybe did it wrong??) Also, I'm just trying to populate a jTable is what i am shooting for ultimately. Anyone have any advice?

What do you mean by stored? Often, I will map the results from the ResultSet to a class...as you iterate over each row of the ResultSet, get the values from the ResultSet and create a new class (which you have defined elsewhere), which you can then add to a List.

I basically am trying to figure out how to populate data into my jTable on my frame from my database. I just haven't added a feature to iterate (advanced for loop) through multiple entries. I just don't know how I'd go from pulling the data out and getting it to the jTable?

Nevermind I got it:

            while (rs.next()){
                String s = rs.getString(1);
 
            }