Create ResultSet from ODBC - Java JDBC

Java examples for JDBC:ODBC

  1. HOME
  2. Java
  3. JDBC
  4. ODBC

Description

Create ResultSet from ODBC

Demo Code

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;


public class OdbcJdbcPuente {

  public static void main(String[] args) {
    // TODO Auto-generated method stub
    //from www.j a  va  2 s  .c  o m
    try {
      Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
      Connection conexion = DriverManager.getConnection("jdbc:odbc:Mysql-odbc64");
      
      Statement sentencia = conexion.createStatement();
      ResultSet resul = sentencia.executeQuery("SELECT * FROM departamentos");
      
      while(resul.next()){
        System.out.println(resul.getInt(1) + " " + resul.getString(2));
      }
      
      resul.close();
      sentencia.close();
      conexion.close();
      
    } catch (ClassNotFoundException  e) {
      // TODO Auto-generated catch block
      e.printStackTrace();
    } catch(SQLException e){
      e.printStackTrace();
    }
    


  }

}

Related Tutorials