//  by Arul John


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

public class AccessDBReader {
    private Connection conn;
    private Statement st;
    private ResultSet rs;

    public void createConn() {
	try {
	    Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
	    conn = DriverManager.getConnection("jdbc:odbc:traits_dsn","","");
	} catch(Exception e) {
	    System.out.println("Sorry, couldn't connect to the database");
	    e.printStackTrace();
	}
    } // get the database connection first

    public void startQuery() {
	try {
	    st = conn.createStatement();
	    rs = st.executeQuery("select * from traits");
	    while (rs.next()) {
		System.out.print("trait_name=" + rs.getString("trait_name") + " ... ");
		System.out.print("traitType=" + rs.getString("traitType") + " ... ");
	    }
	} catch(Exception e) {
	    e.printStackTrace();
	}
    } // access the database

    public void closeConn() {
	try {
	    if (rs != null) rs.close();
	    if (st != null) st.close();
	    if (conn != null) conn.close();
	} catch(Exception e) {
	    e.printStackTrace();
	}
    } // close the database connection

    public static void main(String args[]) {
	AccessDBReader s = new AccessDBReader();
	s.createConn();
	s.startQuery();
	s.closeConn();
    }
}