Java, looping through result set

by 
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());

More Related Contents:

  1. How to get the insert ID in JDBC?
  2. To prevent a memory leak, the JDBC Driver has been forcibly unregistered
  3. Is java.sql.Timestamp timezone specific?
  4. java.util.Date vs java.sql.Date
  5. MySQLSyntaxErrorException near “?” when trying to execute PreparedStatement
  6. Java ResultSet how to check if there are any results
  7. Retrieve column names from java.sql.ResultSet
  8. JDBC connection failed, error: TCP/IP connection to host failed
  9. How can I get the SQL of a PreparedStatement?
  10. Can we connect remote MySQL database in Android using JDBC? [closed]
  11. java.sql.SQLException Parameter index out of range (1 > number of parameters, which is 0) [closed]
  12. Is java.sql.Connection thread safe?
  13. JDBC MySql connection pooling practices to avoid exhausted connection pool
  14. Can I connect to SQL Server using Windows Authentication from Java EE webapp?
  15. How does Java’s PreparedStatement work?
  16. Create a jTDS connection string
  17. How to get all table names from a database?
  18. Should I use java.util.Date or switch to java.time.LocalDate
  19. org.postgresql.util.PSQLException: FATAL: sorry, too many clients already
  20. JPA SQL Server No Dialect mapping for JDBC type: -9
  21. Queries returning multiple result sets
  22. Java JDBC – How to connect to Oracle using tnsnames.ora
  23. Is it a good idea to put jdbc connection code in servlet class?
  24. How to convert TimeStamp to Date in Java?
  25. Java – Storing SQL statements in an external file [closed]
  26. Connection timeout for DriverManager getConnection
  27. How do I make a Java ResultSet available in my jsp? [duplicate]
  28. MyBatis executing multiple sql statements in one go, is that possible?
  29. A persistent connection with JDBC to MySQL
  30. Getting Hibernate and SQL Server to play nice with VARCHAR and NVARCHAR

Leave a Comment