Row Data Gateway encapsulates access to a single row in a database table, acting as an object that represents that row.

Each instance of a Row Data Gateway contains the data of one row and provides methods for its manipulation, such as saving or deleting the row from the database.

# When to use it?

This pattern is useful in applications that require a straightforward and simple abstraction of each database row, allowing data operations without the need to write repetitive SQL queries in the code.

It is suitable for applications with a relatively stable data structure, where database operations focus on individual entities represented by table rows.

# Detailed Example in Java

Consider a Person table in a database. We could have a Row Data Gateway called PersonGateway that encapsulates access to the rows of this table.

public class PersonGateway {
    private int id;
    private String name;
    private String email;
    // Database connection, omitted for simplicity

    public PersonGateway(int id) {
        // Load person data from the database
    }

    public void save() {
        // Save person changes to the database
    }

    public void delete() {
        // Delete this person from the database
    }

    // Getters and setters for id, name, email, etc.
}