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


public class test
{
        public static String driver = null;

        public static String url = null;

        public static String dbName = null;

        public static String userName = null;

        public static String password = null;
        public static String protocol = null;

        public static String subprotocol = null;

        public static String poolName = null;



        public static Connection getIBMConnection()
        {
                        Connection conn= null;
        try
                {
                      Class.forName("oracle.jdbc.driver.OracleDriver");

                      protocol = "jdbc";
                      subprotocol ="oracle:thin:@";


                        dbName = "172.16.0.108:1521:zhao";
                        userName = "woodle_admin";
                        password = "admin";
                        url = protocol + ":" + subprotocol + dbName;
                        System.out.println("Driver = " + driver);
                        System.out.println("Database URL = " + url);
                        conn= DriverManager.getConnection(url,userName,password);

                }

                catch(Exception exp)
                {
                System.out.println("Create Failed. Message: \n" + exp.getMessage());
                        exp.printStackTrace();

                        return conn;
                }
                return conn;
        }



     public static void main(String args[])
     {

         try
          {
             Connection con = test.getIBMConnection();
             System.out.println("closing connection");
             if(con != null)
                  con.close();
          }
          catch(Exception e)
                {
                        System.out.println(e.toString());
                }

     }


}