public class JDBCUtil

{

  private static Properties p = new Properties();

  private static ThreadLocal<Connection> tl = new ThreadLocal();

  static {

    InputStream stream = JDBCUtil.class.getResourceAsStream("/jdbc.properties");

    try{

      p.load(stream);

    } catch (Exception e) {

         e.printStackTrace();

    } finally {

      try {

        stream.close();

      } catch (IOException e) {

        e.printStackTrace();

      }

    }

  }

  public static Connection getConnection()

  {

    Connection connection = (Connection)tl.get();

    if (connection == null) {

      try {

        Class.forName(p.getProperty("driver"));

        connection = DriverManager.getConnection(p.getProperty("url"), p.getProperty("username"), p.getProperty("password"));

        tl.set(connection);

      }

      catch (Exception e) {

        e.printStackTrace();

      }

    }

    return connection;

  }

  public static void close(Connection conn, PreparedStatement pst, ResultSet rs) {

    if (conn != null) {

      try {

        conn.close();

        tl.remove();

      } catch (SQLException e) {

        e.printStackTrace();

      }

    }

    if (pst != null) {

      try {

        pst.close();

      } catch (SQLException e) {

        e.printStackTrace();

      }

    }

    if (rs != null) {

      try {

        rs.close();

      } catch (SQLException e) {

        e.printStackTrace();

      }

    }

  }

}

driver=oracle.jdbc.OracleDriver

url=jdbc:oracle:thin:@localhost:1521:xe

username=hr

password=root