Java, looping through result set

java, jdbc, resultset, sql

Solution

List<String> sids = new ArrayList<String>();
List<String> lids = new ArrayList<String>();

String query = "SELECT rlink_id, COUNT(*)"
             + "FROM dbo.Locate  "
             + "GROUP BY rlink_id ";

Statement stmt = yourconnection.createStatement();
try {
    ResultSet rs4 = stmt.executeQuery(query);

    while (rs4.next()) {
        sids.add(rs4.getString(1));
        lids.add(rs4.getString(2));
    }
} finally {
    stmt.close();
}

String show[] = sids.toArray(sids.size());
String actuate[] = lids.toArray(lids.size());

Problem

In Java, I have a query like this: ``` String querystring1= "SELECT rlink_id, COUNT(*)" + "FROM dbo.Locate " + "GROUP BY rlink_id "; ``` The table rlink_id has this data: ``` Sid lid 3 2 4 4 7 3 9 1 ``` How do I extract these values with a Java ResultSet? Here is what I have so far: ``` String show[] = {rs4.getString(1)}; String actuate[] = {rs4.getString(2)}; asString = Arrays.toString(actuate); ```

Original source