Convert a ResultSet String Into a Workable Variable to Populate a jTable

Question

I'm building a application that needs to convert a ResultSet String(rs.getString(Names);) into a workable variable to populate a jTable, only one collumn, then the rest I think that I could try by doing a loop.

How could I do this?

Answer 1

HI,I assume that you are trying to display the values in JTable, if that is the case. Why cant you get the results into a list from a Resultset and Iterate and display in the Jtable.

How you can store the data from Database to the List and same list can be sent to the Jtable

 try {

            con = ora.createConnection();
            if (con != null) {
                pstmt = con.prepareStatement(strQuery.toString());
                rs = pstmt.executeQuery();
                 while (rs.next()) {
                    khataChallanHeader.setChallanNo(Integer.valueOf(rs
                            .getInt("CHALLAN_NO")));
                    khataChallanHeader.setPropertyId(Long.valueOf(rs
                            .getLong("PROPERTY_ID")));
                    khataChallanHeader
                            .setDivisionName(rs.getString("DIV_NAME"));
                    khataChallanHeader.setCircleName(rs
                            .getString("CIRCLE_NAME"));
                    khataChallanHeader.setLayoutName(rs
                            .getString("LAYOUT_NAME"));

                     dtoList.add(khataChallanHeader);
                }

            }
        } catch (Exception ex) {
            ex.printStackTrace();
        } finally {
            pstmt.close();
            rs.close();
            ora.closeConnection(con);
        }
        // System.out.println(" the Size of the list is : " + dtoList.size());
        // return dtoList;
        return khataChallanHeader;

Answer 2

You create a Vector (called "data") to hold all the data.

Then you loop through the ResultSet. For every row you create a new Vector (called "row") and add the data from the ResultSet to the row Vector. Then you add the row Vector to the data Vector.

Now you create create a DefaultTableModel using the "data" Vector and another Vector containing your desired column name.