Database Journal
MS SQL Oracle DB2 Access MySQL PostgreSQL Sybase PHP SQL Etc SQL Scripts & Samples Tips Database Forum

» Database Journal Home
» Database Articles
» Database Tutorials
MS Access
SQL Scripts & Samples
» Database Forum
» Slideshows
Free Newsletters:

News Via RSS Feed

Database Journal |DBA Support |SQLCourse |SQLCourse2

Featured Database Articles

SQL etc

Posted Nov 24, 1998

Introduction to Databases for the Web: Pt 4 - Page 3

By Selena Sol

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 getString().

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 http://www.javasoft.com/products/jdbc/index.html.

SQL etc Archives

Comment and Contribute


(Maximum characters: 1200). You have characters left.



Latest Forum Threads
SQL etc Forum
Topic By Replies Updated
MySQL rollback UAL225 0 August 21st, 09:56 PM
Complex Search Query Galway 0 May 20th, 10:04 PM
change collation at once supercain 2 May 15th, 06:18 AM
SQL Features, tools and utilities question Neomite 1 April 10th, 09:13 AM