public void test()
{
	BufferedWriter writer = null;
	Connection conn = null;
	PreparedStatement ps = null;
	ResultSet rs = null;
	try
	{
		writer = new BufferedWriter(new FileWriter("AFile"))

		conn = DriverManager.getConnection("jdbc:XXX", "USR", "PWD" );
		ps = conn.prepareStatement("SELECT * FROM ATable");
		rs = ps.executeQuery();
		while(rs.next())
		{
			String data = null;
			//get data from rs
                        writer.write(data);
		}
		return;
	}
	finally
	{
		if(rs != null)
			rs.close();
		if(ps != null)
			ps.close();
		if(conn != null)
			conn.close();
		if(writer != null)
			writer.close();
	}
}

 
> 	finally
> 	{
> 		if(rs != null)
> 			rs.close();
> 		if(ps != null)
> 			ps.close();
> 		if(conn != null)
> 			conn.close();
> 		if(writer != null)
> 			writer.close();
> 	}
> } 

Query query = Manager.getQuery("select bar from foo");
 
query.execute(new Handler() {
    public void handle(Row row)
    {
       // do things with row
    }
});

class File {
public:
    File(const string& path)  // constructor
    : h_(open_file(path))
    {
        if (h_ == 0) {
            throw "Could not open " + path;
        }
    }
    
    ~File( )  // destructor
    {
        close( );
    }

    void close( )  // for completeness
    {
        if (h_ != 0) {
            close_file(h_);
        }
    }

private:
    Handle h_;
};

function foo(const string& path)
{
    File f(path);
    g( );  // may throw an exception

    // no need to close f manually before the }
    // no need to catch the exception to close f
}