debug_4.java

来自「北京大学出版社的」· Java 代码 · 共 32 行

package questions.c17;
import java.sql.*;
import java.util.*;
public class Debug_4 {
   public static void main( String [] args ) {
      try {
         Class.forName( "COM.ibm.db2.jdbc.app.DB2Driver" );
 	 Connection con = DriverManager.getConnection(
            "jdbc:DB2:SAMPLE" );
         String sql = "SELECT FIRSTNME,LASTNAME FROM " +
            "PAULAL.EMPLOYEE WHERE JOB = 'DESIGNER'"; 
         Statement s = con.createStatement();
         ResultSet rs = s.executeQuery( sql );
         System.out.println( " The designers are: " );
         while ( rs.next() ) { 
            String output = rs.getString( 1 ).trim();
            output += ", " + rs.getString( "LASTNAME" );
            System.out.println( output );
         }
         rs.close();
         s.close();
         con.close();
      } catch( Exception e ) {
         System.out.println( e.getMessage() );
         e.printStackTrace();
      } finally {
         System.out.println( 
            "There should be no exceptions." );
      }
      
   }
}