[java-list] Conexao a Banco de Dados

luizbarbosa Sat, 02 Sep 2000 11:47:33 -0700

Alguém poderia me ajudar a encontrar o erro pois nao esta conectando.

Obrigado.

// BDConexao.java

import java.net.URL;
import java.sql.*;
import java.awt.*;
import java.io.*;
import java.util.*;
import java.applet.*;

public class BDConexao extends Applet
{ String url = "c:jdbc:odbc:cadastros";
String my_user = "";
String my_passwd = "";

static final String query = "select * from discussao";

Button execute_button;

TextArea output;

Connection conn;

   public void init ()
   { this.setLayout (new BorderLayout ());
      Panel p = new Panel ();
      p.setLayout (new FlowLayout (FlowLayout.LEFT));
      execute_button = new Button ("Conectar");
      p.add (execute_button);
      this.add ("North", p);
      output = new TextArea (10, 60);
      this.add ("Center", output);
   }

   public boolean action (Event ev, Object arg)
   { if (ev.target == execute_button)
      { try
         { output.setText (null);
            if (conn == null)
            { output.appendText ("Lendo Drive JDBC" + "\n");

Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");

output.appendText ("Conectando " + "\n");

conn = DriverManager.getConnection(url,"my_user","my_passwd");

output.appendText ("Conectado\n");
}

Statement stmt = conn.createStatement ();

output.appendText ("Executando a Query " + query + "\n");

ResultSet rset = stmt.executeQuery (query);

            while (rset.next ())

            output.appendText (rset.getString (1) + "\n");
            output.appendText ("\n");
            output.appendText ("Concluido.\n");

         } catch (Exception e)
            { output.appendText (e.getMessage () + " 2 " + "\n");
            }
            return true;
      }
      else
        return false;
   }
}

[java-list] Conexao a Banco de Dados

Responder a