import java.sql.*;
import java.io.*;


public class MainApp {

  // main method
  public static void main(String[] args) {
    System.out.println("Start\n");
    // Initialize the Access Bridge Driver
    String url = null;
    try{
        Class.forName("com.hxtt.sql.access.AccessDriver").newInstance();
        url = "jdbc:Access:///test.mdb";
    } catch(Exception e) {
        System.err.println("Access Driver not found!");
        System.err.println(e.getMessage()); 
    }
    // Initialize the JdbcOdbc Bridge Driver
    try {
        Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
        url = "jdbc:odbc:Driver={Microsoft Access Driver (*.mdb)};DBQ=test.mdb;DriverID=22;READONLY=false}";
    } catch(ClassNotFoundException e) {
        System.err.println("JdbcOdbc Bridge Driver not found!");
        System.err.println(e.getMessage()); 
    }
    //Please see Connecting to the Database section of Chapter 2. Installation in Development Document
    //Please change "demodata" to your database directory
                                
    //Please replace with your query statement.
    //You should read SQL syntax in HXTT Access Development Document
    String sql = "select * from test where number1>0";

    try {
       Connection con = DriverManager.getConnection(url, "", "");
       if(con!= null){
            System.out.println("Got Connection.");
            DatabaseMetaData meta = con.getMetaData();
            System.out.println("Driver Name : "+meta.getDriverName());
            System.out.println("Driver Version : "+meta.getDriverVersion());
	    Statement st = null;
	    st = con.createStatement();
	    ResultSet rs = null;
	    rs = st.executeQuery("SELECT * FROM obj_person");
       }else{
	    System.out.println("Could not Get Connection");
       }
    } catch(Exception e) {
        System.err.println("Error!");
        System.err.println(e.getMessage()); 
    }
    System.out.println("End\n");
  }
}