Java Reference
In-Depth Information
Cross-Reference
ResultSetMetaData
methods and usage are discussed in
Chapter 4
;
usage examples are in
Chapter 10
.
In the expanded version of the
DatabaseUtilities
class shown in
Listing 6-7
, a second version of
the
execute()
method has been added. This new version accepts a String array argument so that it
can loop through a number of
SQL INSERT
commands.
Listing 6-7: DatabaseUtilities — JDBC code
package jdbc_bible.part2;
import java.awt.event.*;
import java.sql.*;
import java.util.Vector;
import sun.jdbc.odbc.JdbcOdbcDriver;
public class DatabaseUtilities{
static String jdbcDriver = "sun.jdbc.odbc.JdbcOdbcDriver";
static String dbName = "Contacts";
static String urlRoot = "jdbc:odbc:";
private ActionListener exceptionListener = null;
public DatabaseUtilities(){
registerDriver();
}
public void setDatabaseName(String dbName){
this.dbName=dbName;
}
public void registerDriver(){
try {
Class.forName(jdbcDriver);
DriverManager.registerDriver(new JdbcOdbcDriver());
}
catch(ClassNotFoundException e){
reportException(e.getMessage());
}