A sample program for your reference. This connects and retrieves data from
a database "SAMPLE" which has been already defined as a ODBC datasource.

import java.sql.*;

public class jdbc3
{
public static void main(String[] args)
{
 String data = "jdbc:odbc:SAMPLE";
 try
 {
  Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
  Connection conn =
DriverManager.getConnection(data,"userid","password");
  Statement st = conn.createStatement();
  ResultSet rec = st.executeQuery( "SELECT DEPTNO FROM
schema.DEPARTMENT");
  while(rec.next())
  {
   System.out.println(rec.getString("DEPTNO"));
  }
  st.close();
 } catch (Exception e)
 {
  System.out.println("Error -" + e.toString());
 }
}
}