import javax.sql.rowset.JdbcRowSet;
import javax.sql.rowset.RowSetProvider;
import java.sql.SQLException;

public class JdbcRowSetExample {

    public static void main(String[] args) {

        try {
            // Create JdbcRowSet
            JdbcRowSet rowSet =
                    RowSetProvider.newFactory()
                                  .createJdbcRowSet();

            // Database connection properties
            rowSet.setUrl(
                "jdbc:mysql://localhost:3306/jdbc_demo");

            rowSet.setUsername("root");
            rowSet.setPassword("password");

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

            // Execute query
            rowSet.execute();

            System.out.println(
                "Employee Details");
            System.out.println(
                "-----------------------------");

            // Retrieve records
            while (rowSet.next()) {

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

            // Close RowSet
            rowSet.close();

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