oracle driver connect pool

/*
 * To change this license header, choose License Headers in Project Properties.
 * To change this template file, choose Tools | Templates
 * and open the template in the editor.
 */

package com.iminido.db;

 

import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.ResultSetMetaData;
import java.sql.SQLException;
import java.sql.Statement;


import oracle.jdbc.pool.OracleDataSource;


public class OracleDataSource1 {

	/**
	 * @param args
	 * @throws SQLException
	 */
	public static void main(String[] args) throws SQLException {
		OracleDataSource oraDataSource = new OracleDataSource();
		// oraDataSource.setServerName("127.0.0.1");
		// oraDataSource.setDatabaseName("HR");
		// oraDataSource.setUser("HR");
		// oraDataSource.setPassword("HR");
		oraDataSource.setURL("jdbc:oracle:thin:hr/hr@//localhost:1521/XE");
		Connection conn = oraDataSource.getConnection();
		Statement stmt = conn.createStatement();
		stmt.execute("select * from tab");
		showResultSet(stmt.getResultSet());
		stmt.execute("select * from jobs");
		showResultSet(stmt.getResultSet());
		stmt.execute("select * from DEPARTMENTS");
		showResultSet(stmt.getResultSet());
	}

	static void showResultSet(ResultSet resultSet) throws SQLException {
		ResultSetMetaData resultSetMetaData = resultSet.getMetaData();
		int num = resultSetMetaData.getColumnCount();
		while (resultSet.next()) {
			for (int i = 1; i <= num; i++) {
				System.out.print(resultSetMetaData.getCatalogName(i) + " "
						+ resultSet.getString(i));
			}
			System.out.println();
		}
	}
}