How do you use RowSet and modern alternatives with a simple code example?

RowSet is a standard Java interface that extends the capabilities of ResultSet, making it easier to work with data in a disconnected manner. It allows you to retrieve data from a database, manipulate it, and update the database seamlessly. Modern alternatives, like JPA (Java Persistence API) and Spring Data JPA, provide a more robust and convenient way to handle data persistence, while still allowing for powerful querying capabilities.

// Simple example using RowSet
import javax.sql.rowset.RowSet;
import javax.sql.rowset.SqlRowSet;
import javax.sql.rowset.RowSetProvider;
import java.sql.Connection;
import java.sql.SQLException;
import javax.sql.DataSource;

public class RowSetExample {
    public static void main(String[] args) {
        DataSource dataSource = getDataSource(); // assume this method provides a DataSource
        try {
            RowSet rowSet = RowSetProvider.newFactory().createCachedRowSet();
            rowSet.setDataSource(dataSource);
            rowSet.setCommand("SELECT * FROM my_table");
            rowSet.execute();

            while (rowSet.next()) {
                System.out.println("Column Value: " + rowSet.getString("column_name"));
            }
        } catch (SQLException e) {
            e.printStackTrace();
        }
    }

    private static DataSource getDataSource() {
        // Implementation to return DataSource
    }
}