import java.sql.*;

public class Jdbc10 {
 public static void main(String args[]){
 System.out.println(
 "Copyright 2004, R.G.Baldwin");
 try {
 Statement stmt;
 ResultSet rs;

 //Register the JDBC driver for MySQL.
 Class.forName("com.mysql.jdbc.Driver");

 //Define URL of database server for
 // database named JunkDB on the localhost
 // with the default port number 3306.
 String url =
 "jdbc:mysql://localhost:3306/JunkDB";

 //Get a connection to the database for a
 // user named auser with the password
 // drowssap, which is password spelled
 // backwards.
 Connection con =
 DriverManager.getConnection(
 url,"auser", "drowssap");

 //Display URL and connection information
 System.out.println("URL: " + url);
 System.out.println("Connection: " + con);

 //Get a Statement object
 stmt = con.createStatement();

 //As a precaution, delete myTable if it
 // already exists as residue from a
 // previous run. Otherwise, if the table
 // already exists and an attempt is made
 // to create it, an exception will be
 // thrown.
 try{
 stmt.executeUpdate("DROP TABLE myTable");
 }catch(Exception e){
 System.out.print(e);
 System.out.println(
 "No existing table to delete");
 }//end catch

 //Create a table in the database named
 // myTable.
 stmt.executeUpdate(
 "CREATE TABLE myTable(test_id int," +
 "test_val char(15) not null)");

 //Insert some values into the table
 stmt.executeUpdate(
 "INSERT INTO myTable(test_id, " +
 "test_val) VALUES(1,'One')");
 stmt.executeUpdate(
 "INSERT INTO myTable(test_id, " +
 "test_val) VALUES(2,'Two')");
 stmt.executeUpdate(
 "INSERT INTO myTable(test_id, " +
 "test_val) VALUES(3,'Three')");
 stmt.executeUpdate(
 "INSERT INTO myTable(test_id, " +
 "test_val) VALUES(4,'Four')");
 stmt.executeUpdate(
 "INSERT INTO myTable(test_id, " +
 "test_val) VALUES(5,'Five')");

 //Get another statement object initialized
 // as shown.
 stmt = con.createStatement(
 ResultSet.TYPE_SCROLL_INSENSITIVE,
 ResultSet.CONCUR_READ_ONLY);

 //Query the database, storing the result
 // in an object of type ResultSet
 rs = stmt.executeQuery("SELECT * " +
 "from myTable ORDER BY test_id");

 //Use the methods of class ResultSet in a
 // loop to display all of the data in the
 // database.
 System.out.println("Display all results:");
 while(rs.next()){
 int theInt= rs.getInt("test_id");
 String str = rs.getString("test_val");
 System.out.println("\ttest_id= " + theInt
 + "\tstr = " + str);
 }//end while loop

 //Display the data in a specific row using
 // the rs.absolute method.
 System.out.println(
 "Display row number 2:");
 if( rs.absolute(2) ){
 int theInt= rs.getInt("test_id");
 String str = rs.getString("test_val");
 System.out.println("\ttest_id= " + theInt
 + "\tstr = " + str);
 }//end if

 //Delete the table and close the connection
 // to the database
 stmt.executeUpdate("DROP TABLE myTable");
 con.close();
 }catch( Exception e ) {
 e.printStackTrace();
 }//end catch
 }//end main
}//end class Jdbc10



Listing 42 Jdbc10.java

Copyright 2004, Richard G. Baldwin. Reproduction in whole or in part in any form or medium without express written permission from Richard Baldwin is prohibited.
About the author

Richard Baldwin is a college professor (at Austin Community College in Austin, TX) and private consultant whose primary focus is a combination of Java, C#, and XML. In addition to the many platform and/or language independent benefits of Java and C# applications, he believes that a combination of Java, C#, and XML will become the primary driving force in the delivery of structured information on the Web.

Richard has participate