import java.awt.*;
import java.awt.event.*;
import java.sql.*;
import javax.swing.*;

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

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

   public void actionPerformed( ActionEvent e )
   {
      try {
         if ( !fields.clncodg.getText().equals( "" ) ) {
            Statement statement =connection.createStatement();
            String query = "DELETE FROM TBcliente " +
                           "WHERE clncodg = " +
                           fields.clncodg.getText() + "";
            output.append( "\nEnviando query : " + 
                           connection.nativeSQL( query ) 
                           + "\n" );

			int result = statement.executeUpdate( query );
            
            if ( result == 1 )
				output.append( "\nRegistro Excluido\n" );
            else {
               output.append( "\nFalha na Exclusao\n" );
            }
            statement.close();
         }
         else 
            fields.clcdesc.setText( 
               "Entre com a descricao e precione Procurar" );
      }
      catch ( SQLException sqlex ) {
         sqlex.printStackTrace();
         output.append( sqlex.toString() );
      }
   }

   // Display results of query. If rs is null
}