Java JDBC JdbcRowSet create

Description

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();
      }

   }

}



PreviousNext

Related