JDBC Example: Simple Select Statement

// Omnidex JDBC Example: Simple Select
import java.io.*;
import java.sql.*;
 
public class OdxSimpleSelect {
 
public OdxSimpleSelect() { }
 
// Main 
public static void main(String[] args){
 
// Declare JDBC objects 
Connection conn = null;
Statement stmt = null;
ResultSet rs = null;
 
// Register the Omnidex JDBC driver 
try{Class.forName("omnidex.jdbc.OdxJDBCDriver");}
catch(ClassNotFoundException ce) 
{
  pw.println("Driver error: " + ce);
  System.out.println("Driver error: " + ce);
  System.exit(0);
}
 
// Connect to the Omnidex Environment Catalog
try
{
  conn = DriverManager.getConnection( 
    "jdbc:omnidex:c:\\odxtesting\\dsn\\odx_file_ordersffl.dsn");
}
catch(SQLException se) 
{
  pw.println("Connect error: " + se);
  System.out.println("Connect error: " + se);
  System.exit(0);
}
 
// The SQL statement to be executed 
String sql = "select * from customers where state='co'";
try
{
  stmt = conn.createStatement();
  stmt.execute(sql);
  rs = stmt.getResultSet();
 
// Print the results from the Result Set returned after the Select
  while(rs.next())
  {
    System.out.print(rs.getString(1) + "\n");
    System.out.print(rs.getString(2) + "\n");
    System.out.print(rs.getString(3) + "\n");
    System.out.println(rs.getString(4)); 
  } 
} 
catch(SQLException se) 
{
  System.out.println("Execute query error: " + se);
}
 
// Close the Result Set, Statement and Connection objects */
try
{
  if(rs != null) rs.close();
  if(stmt != null) stmt.close();
  if(conn != null) conn.close();
}
catch(SQLException se) 
{
  System.out.println("Close error: " + se);
}
 
System.out.println("End of program.");
 
} // End Main
} // End Class