Query a jdbc odbc connection : JDBC ODBC « Database « Java Tutorial

1. Java Tutorial
2. Database
3. JDBC ODBC

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

public class MainClass{
  public static void main(String[] arguments) {
    String data = "jdbc:odbc:YourSettings";
    try {
      Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
      Connection conn = DriverManager.getConnection(data, "", "");
      Statement st = conn.createStatement();
      ResultSet rec = st.executeQuery("SELECT * FROM Coal WHERE (Country='"
          + arguments[0] + "') ORDER BY Year");
      while (rec.next()) {
        System.out.println(rec.getString(1) + "\t" + rec.getString(2) + "\t\t" + rec.getString(3)
            + "\t" + rec.getString(4));
      }
      st.close();
    } catch (Exception e) {
      System.out.println("Error: " + e.toString() + e.getMessage());
    }
  }
}