/*This class demonstrates how to handle MDB files without
	creating DSN name.
CratedBy: RaviSankar
*/

import java.sql.DriverManager;
import java.sql.Connection;
import java.sql.Statement;
import java.sql.ResultSet;
import java.sql.SQLException;
public class JdbcMdbDirectEx{
	public static void main(String args[]) throws SQLException{
		Connection connection=null;
		try{
			String dbPath= "jdbc:odbc:DRIVER={Microsoft Access Driver (*.mdb)};DBQ=D:\\KeyVoicesDatabaseVocat\\LOGIN.mdb";
							//Be careful while using this line. You should copy it exactly
			Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
			connection=DriverManager.getConnection(dbPath);
            System.out.println("!!!!! Connection Successful without DSN Name !!!!! ");
			Statement statement=connection.createStatement();
			ResultSet resultSet=statement.executeQuery("SELECT Login FROM Logintable");
			System.out.println("user names are:");
			while(resultSet.next()){
				System.out.println(resultSet.getString(1));
			}//while
		}catch(Exception e){
			e.printStackTrace();
		}finally{
			try{
				connection.close();
			}catch(Exception e){
				e.printStackTrace();
			}
		}//finally
	}//main
};