import java.sql.*;
import java.awt.*;
import java.applet.*;
import java.awt.event.*;
import java.io.*;

public class robson extends Applet {
 Button btnLis = new Button("List");
 Button btnCon = new Button("Connect");
 Button btnRob = new Button("Robson - Test");
 TextArea saida = new TextArea("",15,59,TextArea.SCROLLBARS_BOTH);
 Statement st;
 Connection co;
 ResultSet rs;

 public void init() {
  setLayout(new FlowLayout());
  btnLis.addActionListener(new btnLis_actionAdapter());
  btnCon.addActionListener(new btnCon_actionAdapter());
  btnRob.addActionListener(new btnRob_actionAdapter());

  add(saida);
  add(btnCon);
  add(btnLis); 
  add(btnRob); 
 } 

 class btnCon_actionAdapter implements ActionListener {
  public void actionPerformed(ActionEvent e) {
   try {
     saida.append("Carregando Driver ...\n");
    Class.forName ("postgresql.Driver"); 
     saida.append("Driver Carregado ...\n");
     saida.append("Conectando ao Banco de Dados ...\n");
      co = DriverManager.getConnection("jdbc:postgresql://host/db","user","pass");
    //btnCon.setEnabled(false);
   }
   catch (Exception e1) {
    //saida.setText("Problema ao Conectar no Banco de Dados"+"\n"+"Erro: "+e1.toString()+"\n");
    saida.append("Problema ao Conectar no Banco de Dados"+"\n"+"Erro: "+e1.toString()+"\n");
   }
  }
 }

 class btnLis_actionAdapter implements ActionListener {
  public void actionPerformed(ActionEvent e) {
   try { 
    lista_rob();
   } 
   catch (Exception e1) {
    saida.append(e1.toString()+"\n");
   }
  }
 }

 class btnRob_actionAdapter implements ActionListener {
  public void actionPerformed(ActionEvent e) {
   try { 
    saida.append("Robson\n");
   } 
   catch (Exception e1) {
    saida.append(e1.toString()+"\n");
   }
  }
 }

 public void lista_rob() throws Exception {
  String nome; 

  st = co.createStatement(); 
  rs = st.executeQuery("select name from people");

  saida.setText("");
  saida.append("Name \n");

  while (rs.next()) { 
   nome = rs.getString("name");
   saida.append(nome+"\n");
  }
 }

}