package combd;

import java.sql.*;
import java.net.*;
import java.io.*;
import java.util.*;

public class Teste extends javax.swing.JFrame{

  private static javax.swing.JScrollPane jScrollPane1;
  private static javax.swing.JTable jTable1;
  private static TabelaQuery tab;

  public Teste() {
        jScrollPane1 = new javax.swing.JScrollPane();
        jTable1 = new javax.swing.JTable();

        setDefaultCloseOperation(javax.swing.WindowConstants.EXIT_ON_CLOSE);
        jTable1.setModel(tab);
        jScrollPane1.setViewportView(jTable1);

        getContentPane().add(jScrollPane1, java.awt.BorderLayout.CENTER);

        pack();
    }


  public static void main(String a[]){

    BancoDeDados banco = BancoDeDados.getBancoDeDados();

    banco.conecta("com.mysql.jdbc.Driver",
                  "jdbc:mysql://fmc2.graco.unb.br:3306/webmachining_temp",
                  "webmachining", "webmachining");

    PreparedStatement psttmt = banco.preparaPrepared(
      "SELECT stge_id, codigo FROM suporte_torneamento_geral_externo");

    ProcedimentoPSttmt proc = new ProcedimentoPSttmt(psttmt);
    tab = new TabelaQuery( proc.executeBusca() );

    java.awt.EventQueue.invokeLater( new Runnable() {
            public void run() {
                new Teste().setVisible(true);

            }
        });

    RequisitorHttp req = new RequisitorHttp(
      "http://localhost:8080/combdServlet/combdservlet");

    TabelaDeResultado resposta = (TabelaDeResultado)req.requisitaQuery(
      "SELECT codigo FROM suporte_torneamento_geral_externo", null);

    System.out.println(resposta.getNomeColuna(0));
  }
}