Test.java Source code

Introduction

Here is the source code for Test.java

Source

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

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

        RowSetFactory rowSetFactory = null;
        rowSetFactory = RowSetProvider.newFactory("com.sun.rowset.RowSetFactoryImpl", null);
        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"));
        }
    }
}