import java.awt.*;
import java.awt.event.*;
import java.applet.*;
import java.sql.*;
public class Login extends Applet implements ActionListener {

     GridBagLayout gbl = new GridBagLayout();
     GridBagConstraints gbc = new GridBagConstraints();
     Label status = new Label("Status Conexao");
     Button btok = new Button("Salvar");
     Button btcancelar = new Button("Cancelar");


     void addComponent( Component comp, int gridx, int gridy, int gridw, int gridh, int align)
     {
     // codigo para setar posicao dos campos
     }

     // FAZ A CONEXAO AO BANCO DB2 (DB2T)
     int conecta()
     {
          String dbUrl = "jdbc:odbc:DB2T";
          String user = "ADMIN";
          String password = "PATAROXA";

          try { // Load the driver (registers itself)
               Class.forName( "sun.jdbc.odbc.JdbcOdbcDriver");
               Connection c = DriverManager.getConnection( dbUrl, user, password);
               Statement s = c.createStatement();
               // SQL code:
               ResultSet r = s.executeQuery( "SELECT * FROM AGENTE_COBRANCA" );

               // ESSE TEXTO ABAIXO EH SO PARA RETORNAR ALGUMA COISA P/ O APPLET
               while(r.next())
               {    // Capitalization doesn't matter:
                    // System.out.println( r.getString("IDT_EMP") + " - " +r.getString("NUM_MAT_EPG"));
                    status.setText( r.getString("IDT_EMP"));  // STATUS EH UM LABEL DO APPLET
               }
               s.close();
               return 1;
          // Also closes ResultSet
           }
          catch(Exception e)
           { e.printStackTrace();
             status.setText( "Usuario/Senha invalido(s)");
             return 0;
           }
     } // fim conecta

    // TRATA EVENTO DO BOTAO
    public void actionPerformed(ActionEvent event)
    {
     Object source = event.getSource();

     if (source == btok) {
           //conecta("ADMIN", "PATAROXA");
          conecta();
          System.out.println("Botao Ok pressionado");   }
     else if (source == btcancelar)
          //panel.tfcod_cli.setText("1213");
          System.out.println("Botao cancelar pressionado");
     else {
            System.out.println("Nao entrou nem no Ok nem no Cancelar!");}
    }

     public void init(){

       setLayout(gbl);
 
       // AQUI EU OMITI COMANDOS DE CRIACAO DE LABELS E ETC, PRA NAO COMPLICAR
       btok.addActionListener(this);
       addComponent(btok,0,12,1,1,0);

       btcancelar.addActionListener(this);
       addComponent(btcancelar,1,12,1,1,0);

       addComponent(status,0,13,1,1,0);

    }
} // FIM