dvdframe.java~57~

管理dvd碟片的软件

package dvd;

import java.sql.*;
import javax.swing.*;
import java.awt.*;
import java.awt.event.*;
import java.util.*;
import com.borland.jbcl.layout.*;

public class DVDFrame extends JFrame {
  private Connection connection;
  private JTable table;
  private String query = "SELECT * FROM movie_inf ";

  public boolean haverecords;

  public  DVDFrame(Connection   Connection)
  {
    // The URL specifying the Books database to which
    // this program connects using JDBC to connect to a
    // Microsoft ODBC database.
    connection=Connection;
  haverecords=false;
    // Load the driver to allow connection to the database

      getTable();

      this.addWindowListener(
        new WindowAdapter() {
        public void windowClosing( WindowEvent e )
        {

          System.exit( 0 );
        }
      }
      );


      setSize( 450, 150);
      if(haverecords==true)
        show();
      else this.dispose();

    }
    public   DVDFrame(Connection   Connection,String sqlquery)
    {
      // The URL specifying the Books database to which
      // this program connects using JDBC to connect to a
      // Microsoft ODBC database.
      connection=Connection;
      haverecords=false;
      // Load the driver to allow connection to the database
      query=sqlquery;
      getTable();

      setSize( 450,150 );
      this.addWindowListener(
        new WindowAdapter() {
        public void windowClosing( WindowEvent e )
        {

          System.exit( 0 );
        }
      }
      );
  if(haverecords==true)
      show();
      else this.dispose();

    }

    private void getTable()
    {
      Statement statement;
      ResultSet resultSet;

      try {


        statement = connection.createStatement();
        resultSet = statement.executeQuery( query );
        displayResultSet( resultSet );
        statement.close();
      }
      catch ( SQLException sqlex ) {
        sqlex.printStackTrace();
      }
    }

    private void displayResultSet( ResultSet rs )
        throws SQLException
    {
      // position to first record
    boolean moreRecords = rs.next();
    // moreRecord = rs.next();
      // If there are no records, display a message
      if ( ! moreRecords ) {
        haverecords=false;
        JOptionPane.showMessageDialog( this, "对不起，本店未存入相关信息,请重新输入" );
        setTitle( "No records to display" );
        return;
      }
      else haverecords=true;

      setTitle( "Informations table from DVD" );

      Vector columnHeads = new Vector();
      Vector rows = new Vector();

      try {
        // get column heads
        ResultSetMetaData rsmd = rs.getMetaData();

        for ( int i = 1; i <= rsmd.getColumnCount(); ++i )
          columnHeads.addElement( rsmd.getColumnName( i ) );

          // get row data
         do {
           rows.addElement( getNextRow( rs, rsmd ) );
         } while ( rs.next() );

         // display table with ResultSet contents
         table = new JTable( rows, columnHeads );
         JScrollPane scroller = new JScrollPane( table );
         getContentPane().add(scroller, BorderLayout.CENTER );
         validate();
       }
       catch ( SQLException sqlex ) {
         sqlex.printStackTrace();
       }
     }
 //  public boolean morerecord(){
   //    return  moreRecord ;
  // }

     private Vector getNextRow( ResultSet rs, ResultSetMetaData rsmd )
         throws SQLException
     {
       Vector currentRow = new Vector();

       for ( int i = 1; i <= rsmd.getColumnCount(); ++i )
         switch( rsmd.getColumnType( i ) ) {
           case Types.VARCHAR:
             currentRow.addElement( rs.getString( i ) );
             break;
           case Types.INTEGER:
             currentRow.addElement(
              new Long( rs.getLong( i ) ) );
             break;
           case Types.CHAR:
             currentRow.addElement( rs.getString(i));
             break;
           case Types.TINYINT:
             currentRow.addElement(
              new Long( rs.getLong( i ) ) );
              break;
            case Types.SMALLINT:
              currentRow.addElement(
              new Long( rs.getLong( i ) ) );
              break;
            default:
              System.out.println( "Type was: " +
                                  rsmd.getColumnTypeName( i ) );
          }

        return currentRow;
      }

      public void shutDown()
      {
        try {
          connection.close();
        }
        catch ( SQLException sqlex ) {
          System.err.println( "Unable to disconnect" );
          sqlex.printStackTrace();
        }
      }

      public DVDFrame() {
        try {
          jbInit();
        }
        catch(Exception e) {
          e.printStackTrace();
        }
      }
      private void jbInit() throws Exception {
        this.setFont(new java.awt.Font("Dialog", 0, 15));
      }


    }