Using JDBC to Query a Database
Once you have the statement handle,
it is very easy to query the database. To do so, you
use the statement handle to send standard SQL to the
database and then parse through the results returned
from the database. Take a look at the following example.
Click here for code example 2.
Note that if the field is an Integer,
you should use the
getInt() method in
ResultSet instead of
Using JDBC to Modify a Database
Modifying a database is just as
simple as querying a database. However, instead of using
executeQuery(), you use
executeUpdate() and you don't have
to worry about a result set. Consider the following example:
Click here for code example 3.
As you can see, there is not much to it.
Add, modify and delete are all handled by the
executeUpdate() method. You compose the SQL and send it
through JDBC in one simple call.
More on JDBC
There are many, many more things you can do
with JDBC. The API is as complex as the proprietary databases they
serve. However, for most web-applications, you will only need to
query and modify the database. So that is all we have decided to
go over here. If your project is more demanding, you can easily
browse the JDK API and documentation at