Directly connecting to Database without using DataSource

//package _Connect;

import java.sql.*;

import java.sql.Connection;

import java.sql.DatabaseMetaData;

import java.sql.DriverManager;

import java.sql.PreparedStatement;

import java.sql.ResultSet;

import java.util.Calendar;

import java.util.Date;

import java.util.Properties;

public class TryQuery

{

public static void main(String[] args) throws Exception

{

Calendar cal = Calendar.getInstance();

long startMilis = 0;;

long endMilis = 0;

Connection con = null;

try

{

Class.forName("oracle.jdbc.driver.OracleDriver");

//DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());

Properties props = new Properties();

props.put("user", "abcd");

props.put("password", "abcd");

con = DriverManager.getConnection("jdbc:oracle:thin:@IPADDRESS:PORT_NO:SID",props);

DatabaseMetaData dbmd = con.getMetaData();

System.out.println("Connected to : " + dbmd.getDatabaseProductVersion());

System.out.println("JDBC Driver: " + dbmd.getDriverVersion());

System.out.println(dbmd.getURL());

PreparedStatement ps = con.prepareStatement("select slow_query(20) from dual");

ps.setQueryTimeout(5);

cal.setTime(new Date());

startMilis = cal.getTimeInMillis();

System.out.println("start query ");

ps.execute();

ResultSet rs = ps.getResultSet();

int counter = 0;

while (rs.next())

{

counter++;

}

ps.close();

}

catch (Exception e)

{

System.out.println(e);

}

finally

{

cal.setTime(new Date());

endMilis = cal.getTimeInMillis();

System.out.println("end query - Elapsed : " + ((endMilis - startMilis) / 1000) + " seconds");

con.close();

}

}

}