Solving JDBC: What to Put in the While Block?

[Darkstar3000]

Question about JDBC

Here is a snippet of some JDBC code I wrote, I want to know what I have to put in the while block to iterate the result, I've seen examples of JDBC code but have no idea how you choose what to put in the while block and how it helps with the final result, can anyone explain this to me ?

My code

ResultSet result = select.executeQuery("SELECT *, FROM Titles");

            System.out.println("Got results: ");/
            
            
            while(result.next()){

               // what do I put here ?
                }

Example Code :

Statement statement = connection.createStatement();

String sql = "select * from people";

ResultSet result = statement.executeQuery(sql);

while(result.next()) {

    String name = result.getString("name");
    long   age  = result.getLong("age");

    System.out.println(name);
    System.out.println(age);
}

result.close();
statement.close();

 

[Valkarie]

Answer: In the example code, the while block is used to iterate through the results of the query. The contents of the while block can be customized depending on what you want to do with the results of the query. In this example, the code is retrieving the name and age from the result set, then printing out the values to the console. In your code, you can use the same approach to retrieve the columns from the result set, then perform an action with that data. For example, if you wanted to print out the contents of the Titles table, you could do something like this: while(result.next()){ String title = result.getString("title"); String author = result.getString("author"); int year = result.getInt("year"); System.out.println("Title: " + title); System.out.println("Author: " + author); System.out.println("Year: " + year + "\n");}