// Fig. 18.30: UpdateRecord.java
// Class UpdateRecord definition
import java.awt.*;
import java.awt.event.*;
import java.sql.*;
import javax.swing.*;

public class UpdateRecord implements ActionListener {
   private ScrollingPanel fields;
   private JTextArea output;
   private Connection connection;

   public UpdateRecord( Connection c, ScrollingPanel f,
                        JTextArea o )
   {
      connection = c;
      fields = f;
      output = o;
   }

   public void actionPerformed( ActionEvent e )
   {
      try {
         Statement statement = connection.createStatement();

         if ( ! fields.id.getText().equals( "" ) ) {
            String query = "UPDATE addresses SET " +
                   "firstname='" + fields.first.getText() + 
                   "', lastname='" + fields.last.getText() + 
                   "', address='" + fields.address.getText() +
                   "', city='" + fields.city.getText() + 
                   "', stateorprovince='" +
                   fields.state.getText() + 
                   "', postalcode='" + fields.zip.getText() +
                   "', country='" + fields.country.getText() +
                   "', emailaddress='" + 
                   fields.email.getText() + 
                   "', homephone='" + fields.home.getText() + 
                   "', faxnumber='" + fields.fax.getText() + 
                   "' WHERE id=" + fields.id.getText();
                   output.append( "\nSending query: " + 
                   connection.nativeSQL( query ) + "\n" );

            int result = statement.executeUpdate( query );
            
            if ( result == 1 )
               output.append( "\nUpdate successful\n" );
            else {
               output.append( "\nUpdate failed\n" );
               fields.first.setText( "" );
               fields.last.setText( "" );
               fields.address.setText( "" );
               fields.city.setText( "" );
               fields.state.setText( "" );
               fields.zip.setText( "" );
               fields.country.setText( "" );
               fields.email.setText( "" );
               fields.home.setText( "" );
               fields.fax.setText( "" );
            }

            statement.close();
         }
         else 
            output.append( "\nYou may only update an " +
                           "existing record. Use Find to " +
                           "locate the record, then " +
                           "modify the information and " +
                           "press Update.\n" );
      }
      catch ( SQLException sqlex ) {
         sqlex.printStackTrace();
         output.append( sqlex.toString() );
      }
   }
}

/**************************************************************************
 * (C) Copyright 1999 by Deitel & Associates, Inc. and Prentice Hall.     *
 * All Rights Reserved.                                                   *
 *                                                                        *
 * DISCLAIMER: The authors and publisher of this book have used their     *
 * best efforts in preparing the book. These efforts include the          *
 * development, research, and testing of the theories and programs        *
 * to determine their effectiveness. The authors and publisher make       *
 * no warranty of any kind, expressed or implied, with regard to these    *
 * programs or to the documentation contained in these books. The authors *
 * and publisher shall not be liable in any event for incidental or       *
 * consequential damages in connection with, or arising out of, the       *
 * furnishing, performance, or use of these programs.                     *
 *************************************************************************/