Selenium – Access Database using JDBC

package com.practice.jdbc;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.*;
/*
 * This class helps in retrieving the data from Oracle
 * Author - Seetaram Hegde
 */
public class Dataset {
	private String conURL;
	private String uname;
	private String pwd;
	private String dURL;
	private Connection con = null;
	
	public Dataset(String connectionURL, String driverURL, String username, String password){
		this.conURL=connectionURL;
		this.dURL=driverURL;
		this.uname=username;
		this.pwd=password;
	}
	
	public HashMap<Integer, String> ExecQuery(String Query,int colIndex) throws Exception{
		HashMap<Integer, String> columnVal=new HashMap<Integer, String>();
		int i=0;
	    Connection conn = getDatabaseConnection();
	    if(con!= null){
		    Statement smt = conn.createStatement();
		    ResultSet rslt =
		         smt.executeQuery(Query);
		    while (rslt.next()) {
		    	columnVal.put(i, rslt.getString(colIndex));
		    	i++;
		    }
		    smt.close();

	    }else{
		    System.out.println("Could not Get Connection");
	    }
		
		
		return columnVal;
	}
	
	private Connection getDatabaseConnection(){

		try {
			Class.forName(dURL);	

		} catch(java.lang.ClassNotFoundException e) {
			System.err.print("ClassNotFoundException: ");
			System.err.println(e.getMessage());
		}

		try {
		   this.con = DriverManager.getConnection(conURL, uname, pwd);
		} catch(SQLException ex) {
			System.err.println("SQLException: " + ex.getMessage());
		}

		return con;
	}
	
}

package com.practice.jdbc;

import java.util.HashMap;
import java.util.Iterator;
import java.util.Map;
import java.util.Set;

/*
 * This Java program utilizes the Dataset class to retrieve the data from EMP table
 * Author - Seetaram Hegde
 */

public class JDBCEx {

	public static void main(String[] args) {
		HashMap<Integer, String> colData = new HashMap<Integer, String>();
		Dataset DB = new Dataset("jdbc:odbc:OraDSN",
				     "sun.jdbc.odbc.JdbcOdbcDriver","scott","tiger");
		try {
			colData=DB.ExecQuery("select ename from emp", 1);
			Set set = colData.entrySet();
			Iterator i = set.iterator();
			
			while(i.hasNext()) {
				Map.Entry me = (Map.Entry)i.next();
				System.out.print(me.getKey() + ": ");
				System.out.println(me.getValue());
				}
				System.out.println(); 
			
		} catch (Exception e) {
			e.printStackTrace();
		}
	}

}