complete_2.java

程序练习中包括书中实例程序代码和练习中要用到的代码,是压缩文件

package questions.c17;
import java.sql.*;
import java.util.*;
public class Complete_2{
   private String deptNumber;
   private String deptName;
   private String manager;
   public Complete_2( ) {
      deptNumber = "TBA";
      deptName = "To be Announced";
      manager = "unknown";
   }
   public void setDeptNumber( String deptNumber ) {
      this.deptNumber = deptNumber;
   }
   public String getDeptNumber( ) {
      return deptNumber;
   }
   public void setDeptName( String deptName ) {
      this.deptName = deptName;
   }
   public String getDeptName( ) {
      return deptName;
   }
   public String getManager( ) {
      return manager;
   }
   public void setManager( String manager ) {
      this.manager = manager;
   }
   public void setManager( String first, String last ) {
      this.manager = first + " " + last;
   }
   public String toString( ) {
      String output = getDeptNumber();
      while ( output.length() < 6 ) {
         output += " ";
      }
      output += getDeptName();
      while ( output.length() < 30 ) {
         output += " ";
      }
      output += getManager();
      return output;
   }   
   static public ResultSet getAllDepartments( ) { 
      ResultSet rs = null;
      try {                         
// insert the code to load the driver and 
// open a connection                         
         String query = "SELECT " + 
            "DEPTNO,DEPTNAME,FIRSTNME,LASTNAME " +
            "FROM USERID.DEPARTMENT,USERID.EMPLOYEE " +
            "WHERE USERID.DEPARTMENT.MGRNO=" +
            "USERID.EMPLOYEE.EMPNO";
// insert the code to create a statement and run the
// SELECT statement stored in the variable query
      } catch( Exception e ) {
         System.out.println( "Unable to retreive data." );
         e.printStackTrace( System.out );
      }
      return rs;
   }
   static public Complete_2 getDept( ResultSet rs ) {
      Complete_2 dept = new Complete_2( );
      try {
// Insert code to get the deptartment number, name and
// managers first and last name from the ResultSet. 
// Set the fields in dept accordingly.
      } catch( Exception e ) {
           System.out.println( 
              "Unable to extract department data." );   
      }   
      return dept;
   }
   static public void main( String[] args )
         throws SQLException {
      ResultSet rs = getAllDepartments( );
      if ( ! rs.next() ) {
         System.out.println( 
            "No department data available." );
         System.exit( 0 );
      } 
      System.out.println(  
         "CODE  DEPARTMENT NAME             MANAGER" ); 
      System.out.println( 
         "********************************************" ); 
      do {
// insert the code to print one department
      } while ( rs.next() );
      System.out.println( 
         "********************************************" );
   }
}