try {
			PreparedStatement pstmt = null;
			ResultSet rs = null;
			try {
				pstmt = conn.prepareStatement("select ...");
				rs = pstmt.executeQuery();
				.....
			} finally {
				rs.close();//возможны исключения
				pstmt.close();
			}
		} catch (SQLException e) {
			e.printStackTrace();
		}

		try {
			PreparedStatement pstmt = null;
			try {
				pstmt = conn.prepareStatement("select ...");
				ResultSet rs = null;
				try {
					rs = pstmt.executeQuery();
					.......
				} finally {
					rs.close();
				}
			} finally {
				pstmt.close();
			}
		} catch (SQLException e) {
			e.printStackTrace();
		}

	public static void closeResources(Object... resources){
		for (Object resource: resources){
			for(Method method : resource.getClass().getMethods()){
				if (method.getName().equalsIgnoreCase("close")){
					try {
						method.invoke(resources,new Object[0]);
					} catch (Exception e) {
						throw new RuntimeException("Error close resource"+resource,e);
					}
				}
			}
		}
	}


		PreparedStatement pstmt = null;
		ResultSet rs = null;
		try {
			pstmt = conn.prepareStatement("select ...");
			rs = pstmt.executeQuery();
		} catch (SQLException e) {
			e.printStackTrace();
		} finally {
			closeResources(rs,pstmt);
		}

	public static void SQLClose(Connection conn) {
		try {
			conn.close();
		} catch (Exception e) {
			System.err.println("Error on close DB connection");
			e.printStackTrace();
		}
	}

	public static void SQLClose(PreparedStatement pstmt) {
	//аналогично
	}

	public static void SQLClose(ResultSet rs) {
	//аналогично
	}

	public static void SQLClose(Object... resources) {
		for (Object resource : resources) {
			if (resource == null) {
				(new NullPointerException("Try close null sql resource"))
						.printStackTrace();
				return;
			}
			if (resource instanceof ResultSet)
				SQLClose((ResultSet) resource);
			else if (resource instanceof PreparedStatement)
				SQLClose((PreparedStatement) resource);
			else if (resource instanceof Connection)
				SQLClose((Connection) resource);
			else throw new IllegalArgumentException("Don't closed SQL resource: "+resource);
		}
	}

	....

		Connection conn = null;
		PreparedStatement pstmt = null;
		ResultSet rs = null;
		try {
			conn = ods.getConnection();
			pstmt = conn.prepareStatement("select 1 from dual");
			rs = pstmt.executeQuery();
			System.out.println(rs);
		} catch (SQLException e) {
			e.printStackTrace();
		} finally {
			 SQLClose(rs,pstmt,conn);
		}

	public static void closeResources(Object... resources) {
		for (Object resource : resources) {
			if (resource == null)
				(new NullPointerException("Try close null resource"))
						.printStackTrace();
			else {
				try {
					Method method = resource.getClass().getMethod("close");
					method.setAccessible(true);
					method.invoke(resource, new Object[0]);
				} catch (Exception e) {
					(new RuntimeException("Error close resource" + resource, e))
							.printStackTrace();
				}
			}
		}
	}