import javax.sql.rowset.CachedRowSet;
import javax.sql.rowset.RowSetProvider;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;

public class CachedRowSetExample {

    public static void main(String[] args) {

        String url =
            "jdbc:mysql://localhost:3306/jdbc_demo";

        String username = "root";
        String password = "password";

        try {
            // Create CachedRowSet
            CachedRowSet rowSet =
                    RowSetProvider.newFactory()
                                  .createCachedRowSet();

            // Set database properties
            rowSet.setUrl(url);
            rowSet.setUsername(username);
            rowSet.setPassword(password);

            rowSet.setCommand(
                "SELECT employee_id, employee_name, " +
                "department, salary FROM employee");

            // Fill CachedRowSet
            rowSet.execute();

            System.out.println(
                "Data Retrieved from Database");

            // Close database connection
            // CachedRowSet keeps the data in memory
            System.out.println(
                "\nEmployee Details");
            System.out.println(
                "-----------------------------");

            while (rowSet.next()) {

                System.out.println(
                    rowSet.getInt("employee_id") + "  " +
                    rowSet.getString("employee_name") + "  " +
                    rowSet.getString("department") + "  " +
                    rowSet.getDouble("salary"));
            }

            rowSet.close();

        } catch (SQLException e) {
            e.printStackTrace();
        }
    }
}