=?iso-8859-1?Q?Re:_=5Bjava-list=5D_Banco_de_Dados_-_Conex=E3o?=

Sat, 28 Dec 2002 05:07:58 -0800

Tem essa maneira abaixo que conhe�o que vc n�o precisa ficar configurado o ODBC.
 
package banco;
 
/**
 * <p>Title: </p>
 * <p>Description: </p>
 * <p>Copyright: Copyright (c) 2002</p>
 * <p>Company: </p>
 * @author unascribed
 * @version 1.0
 */
 
import java.sql.*;
import java.util.*;
 
public class Teste
{
        ResultSet rs;
        ResultSet rsn;
        int li_cont = 0;
        String arr[];
        int arri[];
 
        public void retorna_alunos()
                {
                Connection con;
                String createString;
                Statement stmt;
                String query = "select nome from aluno";
 
                try{
                        Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
                }
 
                catch(java.lang.ClassNotFoundException e){
                        System.err.print("ClassNotFoundException: ");
                        System.err.println(e.getMessage());
                }
                try {
                        con = DriverManager.getConnection("jdbc:odbc:Driver={MicroSoft Access Driver (*.mdb)};DBQ=C:\\banco.mdb","java","12345");
                        stmt = con.createStatement();
 
                        rs = stmt.executeQuery(query);
 
                        int i;
 
                        arr = new String [8];
                        String ls_teste = null;
 
                        while (rs.next()){
                                   //arr[li_cont] = rs.getString("nome");
                                ls_teste = rs.getString("nome");
                                System.out.println(ls_teste);
                                 li_cont++;
                        }
 
                        stmt.close();
                        con.close();
                }
 
                catch(SQLException ex){
                        System.err.println("SQLException: " + ex.getMessage());
                }
                catch(Exception ex1){};
        }
 
        public static void main(String args[]){
                System.out.println("teste");
                Teste teste = new Teste();
                teste.retorna_alunos();
        }
}
 
 
----- Original Message -----
Sent: Thursday, December 26, 2002 11:30 PM
Subject: [java-list] Banco de Dados - Conex�o

Gostaria de saber como conectar ao banco de dados sem ser pelo odbc.
 
Obrigado!

Responder a