The PostgreSQL JDBC Interface | ||
---|---|---|
<<< Previous | Issuing a Query and Processing the Result | Next >>> |
Statement
or PreparedStatement
Interface
The following must be considered when using the
Statement
or
PreparedStatement
interface:
You can use a single Statement
instance
as many times as you want. You could create one as soon as you
open the connection and use it for the connection's
lifetime. But you have to remember that only one
ResultSet
can exist per
Statement
or
PreparedStatement
at a given time.
If you need to perform a query while processing a
ResultSet
, you can simply create and
use another Statement
.
If you are using threads, and several are using the database,
you must use a separate Statement
for
each thread. Refer to the Chapter called Using the Driver in a Multithreaded or a Servlet Environment if you are
thinking of using threads, as it covers some important points.
When you are done using the Statement
or PreparedStatement
you should close it.
<<< Previous | Home | Next >>> |
Issuing a Query and Processing the Result | Up | Using the ResultSet Interface |