Using the RowSetFactory class - Java JDBC

Java examples for JDBC:RowSet

  1. HOME
  2. Java
  3. JDBC
  4. RowSet

Description

Using the RowSetFactory class

Demo Code

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

public class Main {
    public static void main(String[] args) {
        String databaseUrl = "jdbc:derby://localhost:1527/contact";
        String username = "richard";
        String password = "password";

        RowSetFactory rowSetFactory = null;
        try {/* w  w  w.  j  a  v  a2s  .c  o  m*/
            rowSetFactory = RowSetProvider.newFactory("com.sun.rowset.RowSetFactoryImpl", null);
        } catch (SQLException ex) {
            ex.printStackTrace();
            return;
        }

        try (
            JdbcRowSet rowSet = rowSetFactory.createJdbcRowSet();
            rowSet.setUrl(databaseUrl);
            rowSet.setUsername(username);
            rowSet.setPassword(password);
            rowSet.setCommand("SELECT * FROM COLLEAGUES");
            rowSet.execute();

            while (rowSet.next()) {
                System.out.println(rowSet.getInt("ID") + " - "
                        + rowSet.getString("FIRSTNAME"));
            }

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

    }
    
}

Related Tutorials