[java-list] =?iso-8859-1?Q?Conex=E3o_a_Banco_de_Dados_atrav=E9s_do_Applet?=

Sun, 10 Sep 2000 21:01:51 -0700

Estou tendo o seguinte erro:
         no suitable driver
na linha:
         conn = DriverManager.getConnection
                            (url,"my_user","my_passwd");
 
 
Meu url:
 
 
import java.net.URL;
import java.sql.*;
import java.awt.*;
import java.io.*;
import java.util.*;
import java.applet.*;
 
public class Conexao extends Applet
{  String url = "http://users.sti.com.br/janetenorio/conn?dbtype=odbc&dsn=cadastros.mdb";
 
   String user = "";
   String passwd = "";
 
   static final String query = "select * from Teste1";
 
 
   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");
              // e.printStackTrace();
            }
            return true;
      }
      else
        return false;
   }
}

Responder a