catch ( ClassNotFoundException cnfex ) {//4
         System.err.println(
              "Failed to load JDBC/ODBC driver." );
         cnfex.printStackTrace();
         System.exit( 1 );  // terminate program
       }//4
       catch ( SQLException sqlex ) {//5
         System.err.println( "Unable to connect" );
         sqlex.printStackTrace();
       }//5
       //this.hide();
       DVDFrame movieFrame=new DVDFrame(connection,quire1);
       movieFrame.setSize(450,450);

        jtx1.setText("");
     }//2
     else  {if(jrb2.isSelected()){//6
         try {//7
           Class.forName( "sun.jdbc.odbc.JdbcOdbcDriver" );

           connection = DriverManager.getConnection(  url );
         }//7
         catch ( ClassNotFoundException cnfex ) {//8
           System.err.println(
                "Failed to load JDBC/ODBC driver." );
           cnfex.printStackTrace();
           System.exit( 1 );  // terminate program
         }//8
         catch ( SQLException sqlex ) {//9
           System.err.println( "Unable to connect" );
           sqlex.printStackTrace();
         }//9
         //this.hide();
         DVDFrame movieFrame=new DVDFrame(connection,quire2);


         movieFrame.setSize(450,450);


         jtx1.setText("");
       }//6
     }
   }//1
   else
     JOptionPane.showMessageDialog(null,"Please enter the DVD name you want","sorry",JOptionPane.INFORMATION_MESSAGE);

 }

 void jButton5_actionPerformed(ActionEvent e) {
   String  roleName= jtx2.getText().trim();
   String quire4="select * from movie_inf where 演員中文名 like '"+roleName+"'";
   if(!roleName.equals(""))
   { try {//3
       Class.forName( "sun.jdbc.odbc.JdbcOdbcDriver" );

       connection = DriverManager.getConnection(  url );
     }//3
     catch ( ClassNotFoundException cnfex ) {//4
       System.err.println(
            "Failed to load JDBC/ODBC driver." );
       cnfex.printStackTrace();
       System.exit( 1 );  // terminate program
     }//4
     catch ( SQLException sqlex ) {//5
       System.err.println( "Unable to connect" );
       sqlex.printStackTrace();
     }//5

     DVDFrame movieFrame=new DVDFrame(connection,quire4);
     movieFrame.setSize(450,450);
     jtx2.setText("");

   }
   else
     JOptionPane.showMessageDialog(null,"Please enter the playactor name you want","sorry",JOptionPane.INFORMATION_MESSAGE);
 }

 void jtx2_actionPerformed(ActionEvent e) {

 }

 void jButton3_actionPerformed(ActionEvent e) {
   String directorNation= jcb2.getSelectedItem().toString();
   String quire5="SELECT * FROM director where d_nation like '%"+directorNation+"%'";
   try {//3
     Class.forName( "sun.jdbc.odbc.JdbcOdbcDriver" );

     connection = DriverManager.getConnection(  url );
   }//3
   catch ( ClassNotFoundException cnfex ) {//4
     System.err.println(
          "Failed to load JDBC/ODBC driver." );
     cnfex.printStackTrace();
          System.exit( 1 );  // terminate program
       }//4
       catch ( SQLException sqlex ) {//5
         System.err.println( "Unable to connect" );
         sqlex.printStackTrace();
       }//5

       DVDFrame movieFrame=new DVDFrame(connection,quire5);
       movieFrame.setSize(450,450);


     }

     void jButton6_actionPerformed(ActionEvent e) {
       String  directorName= jtx3.getText().trim();
       String quire4="select * from movie_inf where 演員中文名 like '"+directorName+"'";
       if(!directorName.equals(""))
       { try {//3
           Class.forName( "sun.jdbc.odbc.JdbcOdbcDriver" );

           connection = DriverManager.getConnection(  url );
         }//3
         catch ( ClassNotFoundException cnfex ) {//4
           System.err.println(
            "Failed to load JDBC/ODBC driver." );
           cnfex.printStackTrace();
           System.exit( 1 );  // terminate program
         }//4
         catch ( SQLException sqlex ) {//5
           System.err.println( "Unable to connect" );
           sqlex.printStackTrace();
         }//5

         DVDFrame movieFrame=new DVDFrame(connection,quire4);
         movieFrame.setSize(450,450);
         jtx3.setText("");
       }
       else
         JOptionPane.showMessageDialog(null,"Please enter the director name you want","sorry",JOptionPane.INFORMATION_MESSAGE);

     }

  class CustomerView_jButton1_actionAdapter implements java.awt.event.ActionListener {
    CustomerView adaptee;

    CustomerView_jButton1_actionAdapter(CustomerView adaptee) {
      this.adaptee = adaptee;
    }
    public void actionPerformed(ActionEvent e) {
      adaptee.jButton1_actionPerformed(e);
    }
  }

  class CustomerView_jcb2_actionAdapter implements java.awt.event.ActionListener {
    CustomerView adaptee;

    CustomerView_jcb2_actionAdapter(CustomerView adaptee) {
      this.adaptee = adaptee;
    }
    public void actionPerformed(ActionEvent e) {
      adaptee.jcb2_actionPerformed(e);
    }
  }

  class CustomerView_jcb1_actionAdapter implements java.awt.event.ActionListener {
    CustomerView adaptee;

    CustomerView_jcb1_actionAdapter(CustomerView adaptee) {
      this.adaptee = adaptee;
    }
    public void actionPerformed(ActionEvent e) {
      adaptee.jcb1_actionPerformed(e);
    }
  }

  class CustomerView_jtx3_actionAdapter implements java.awt.event.ActionListener {
    CustomerView adaptee;

    CustomerView_jtx3_actionAdapter(CustomerView adaptee) {
      this.adaptee = adaptee;
    }
    public void actionPerformed(ActionEvent e) {
      adaptee.jtx3_actionPerformed(e);
    }
  }

  class CustomerView_jButton2_actionAdapter implements java.awt.event.ActionListener {
    CustomerView adaptee;

    CustomerView_jButton2_actionAdapter(CustomerView adaptee) {
      this.adaptee = adaptee;
    }
    public void actionPerformed(ActionEvent e) {
      adaptee.jButton2_actionPerformed(e);
    }
  }

  class CustomerView_jtx1_actionAdapter implements java.awt.event.ActionListener {
    CustomerView adaptee;

    CustomerView_jtx1_actionAdapter(CustomerView adaptee) {
      this.adaptee = adaptee;
    }
    public void actionPerformed(ActionEvent e) {
      adaptee.jtx1_actionPerformed(e);
    }
  }

  class CustomerView_jButton4_actionAdapter implements java.awt.event.ActionListener {
    CustomerView adaptee;

    CustomerView_jButton4_actionAdapter(CustomerView adaptee) {
    this.adaptee = adaptee;
  }
  public void actionPerformed(ActionEvent e) {
    adaptee.jButton4_actionPerformed(e);
  }
}

class CustomerView_jButton5_actionAdapter implements java.awt.event.ActionListener {
  CustomerView adaptee;

  CustomerView_jButton5_actionAdapter(CustomerView adaptee) {
    this.adaptee = adaptee;
  }
  public void actionPerformed(ActionEvent e) {
    adaptee.jButton5_actionPerformed(e);
  }
}

class CustomerView_jtx2_actionAdapter implements java.awt.event.ActionListener {
  CustomerView adaptee;

  CustomerView_jtx2_actionAdapter(CustomerView adaptee) {
    this.adaptee = adaptee;
  }
  public void actionPerformed(ActionEvent e) {
    adaptee.jtx2_actionPerformed(e);
  }
}

class CustomerView_jButton3_actionAdapter implements java.awt.event.ActionListener {
  CustomerView adaptee;

  CustomerView_jButton3_actionAdapter(CustomerView adaptee) {
    this.adaptee = adaptee;
  }
  public void actionPerformed(ActionEvent e) {
    adaptee.jButton3_actionPerformed(e);
  }
}

class CustomerView_jButton6_actionAdapter implements java.awt.event.ActionListener {
  CustomerView adaptee;

  CustomerView_jButton6_actionAdapter(CustomerView adaptee) {
    this.adaptee = adaptee;
  }
  public void actionPerformed(ActionEvent e) {
    adaptee.jButton6_actionPerformed(e);
  }
}
}

class CustomerView_jButton1_actionAdapter implements java.awt.event.ActionListener {
  CustomerView adaptee;

  CustomerView_jButton1_actionAdapter(CustomerView adaptee) {
    this.adaptee = adaptee;
  }
  public void actionPerformed(ActionEvent e) {
    adaptee.jButton1_actionPerformed(e);
  }
}

class CustomerView_jButton4_actionAdapter implements java.awt.event.ActionListener {
  CustomerView adaptee;

  CustomerView_jButton4_actionAdapter(CustomerView adaptee) {
    this.adaptee = adaptee;
  }
  public void actionPerformed(ActionEvent e) {
    adaptee.jButton4_actionPerformed(e);
  }
}

class CustomerView_jButton6_actionAdapter implements java.awt.event.ActionListener {
  CustomerView adaptee;

  CustomerView_jButton6_actionAdapter(CustomerView adaptee) {
    this.adaptee = adaptee;
  }
  public void actionPerformed(ActionEvent e) {
    adaptee.jButton6_actionPerformed(e);
  }
}

class CustomerView_jButton5_actionAdapter implements java.awt.event.ActionListener {
  CustomerView adaptee;

  CustomerView_jButton5_actionAdapter(CustomerView adaptee) {
    this.adaptee = adaptee;
  }
  public void actionPerformed(ActionEvent e) {
    adaptee.jButton5_actionPerformed(e);
  }
}

class CustomerView_jcb1_actionAdapter implements java.awt.event.ActionListener {
  CustomerView adaptee;

  CustomerView_jcb1_actionAdapter(CustomerView adaptee) {
    this.adaptee = adaptee;
  }
  public void actionPerformed(ActionEvent e) {
    adaptee.jcb1_actionPerformed(e);
  }
}

class CustomerView_jButton2_actionAdapter implements java.awt.event.ActionListener {
  CustomerView adaptee;

  CustomerView_jButton2_actionAdapter(CustomerView adaptee) {
    this.adaptee = adaptee;
  }
  public void actionPerformed(ActionEvent e) {
    adaptee.jButton2_actionPerformed(e);
  }
}

class CustomerView_jButton3_actionAdapter implements java.awt.event.ActionListener {
  CustomerView adaptee;

  CustomerView_jButton3_actionAdapter(CustomerView adaptee) {
    this.adaptee = adaptee;
  }
  public void actionPerformed(ActionEvent e) {
    adaptee.jButton3_actionPerformed(e);
  }
}