Java JDBC JdbcRowSet create
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 = "demo2suser"; String password = "password"; RowSetFactory rowSetFactory = null; try {//from w w w .j a va 2 s. com 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(); } } }