/* Java for PC: accessing a database via the JDBC/ODBC bridge

  Replace <username> and <password> below with suitable strings

  Author: R Bland
  Modified: Simon Jones
*/

import java.sql.*;

public class DBviaJDBCODBC {

  public static void main(String args[]) {
    String url = "jdbc:odbc:DSN" ;
    //RB The third part (DSN) is the name of an ODBC User DSN
    //     that I set up using the ODBC Control Panel
    //     from Start/Settings/ODBC
    Connection con;
    ResultSet rs ;
    Statement stmt ;
    //
    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(url,
                               <username>, <password>);
      stmt = con.createStatement();
      rs = stmt.executeQuery("SELECT DISTINCT Season, Title FROM rb1.Panto");
      ResultSetMetaData rsmd = rs.getMetaData();
      int numberOfColumns = rsmd.getColumnCount();
      int rowCount = 0;
      while (rs.next()) {
        System.out.println("Row " + (++rowCount) + ":  ") ;
        for (int i = 1; i <= numberOfColumns; i++) {
          System.out.print("   Column " + i + ":  ") ;
          System.out.println(rs.getString(i)) ; }}
      con.close() ; }
      catch(SQLException ex) {
        System.err.println("SQLException: " + ex.getMessage()) ; }}

}