Issuing a Query and Processing the Result | pgJDBC

jdbc.postgresql.org · 1,623 words · saved by 1 readers

Any time you want to issue SQL statements to the database, you require a Statement or PreparedStatement instance. Once you have a Statement or PreparedStatement , you can use issue a query. This will return a ResultSet instance, which contains the entire result (see the section called Getting results based on a cursor here for how to alter this behaviour). Example 5.1, “Processing a Simple Query in JDBC” illustrates this process. This example will issue a simple query and print out the first column of each row using a Statement . This example issues the same query as before but uses a PreparedStatement and a bind value in the query. By default the driver collects all the results for the query at once. This can be inconvenient for large data sets so the JDBC driver provides a means of basing a ResultSet on a database cursor and only fetching a small number of rows. A small number of rows are cached on the client side of the connection and when exhausted the next block of rows is retriev

Issuing a Query and Processing the Result | pgJDBC Issuing a Query and Processing the Result Any time you want to issue SQL statements to the database, you require a Statement or PreparedStatement instance. Once you have a Statement or PreparedStatement , you can use issue a query. This will return a ResultSet instance, which contains the entire result (see the section called Getting results based on a cursor here for how to alter this behaviour). Example 5.1, “Processing a Simple Query in JDBC” illustrates this process. Example 5.1. Processing a Simple Query in JDBC This example will issue a

Issuing a Query and Processing the Result | pgJDBC

related reading