JDBC for MySQL - Herong's Tutorial Examples - v3.12, by Herong Yang
Sun Implementation of JdbcRowSet API
This section provides a tutorial example on how to access the reference implementation of JdbcRowSet API provided by Sun Microsystems.
The reference implementation of JdbcRowSet API was provided by Sun Microsystems. If you are using JDK 1.6, you need to download and install the Sun implementation JAR file. But since JDK 1.7, the Sun implementation is included in the JDK package now as the default implementation.
To access the Sun implementation, you can use methods from the RowSetProvider class and the RowSetFactory class:
// Creating an instance of the default RowSetFactory implementation RowSetFactory f = RowSetProvider.newFactory(); // Creating an instance of JdbcRowSet from the factory JdbcRowSet s = f.createJdbcRowSet();
Here is a tutorial program that shows how to create a JdbcRowSet object with the Sun default implementation:
/* MySqlRowSetFactory.java * Copyright (c) HerongYang.com. All Rights Reserved. */ import java.sql.*;; import javax.sql.rowset.RowSetProvider; import javax.sql.rowset.RowSetFactory; import javax.sql.rowset.JdbcRowSet; public class MySqlRowSetFactory { public static void main(String [] args) { try { RowSetFactory f = RowSetProvider.newFactory(); JdbcRowSet s = f.createJdbcRowSet(); System.out.println("RowSetFactory: "+f.getClass().getName()); System.out.println("JdbcRowSet: "+s.getClass().getName()); } catch (Exception e) { System.err.println("Exception: "+e.getMessage()); } } }
Compile and run it with JDK 13, you will get the following output:
herong> javac MySqlRowSetFactory.java herong> java MySqlRowSetFactory RowSetFactory: com.sun.rowset.RowSetFactoryImpl JdbcRowSet: com.sun.rowset.JdbcRowSetImpl
The output confirms that Sun implementation of JdbcRowSet API is the default implementation.
Table of Contents
JDBC (Java Database Connectivity) Introduction
MySQL JDBC Driver (MySQL Connector/J)
►MySQL - Reference Implementation of JdbcRowSet
Connecting JdbcRowSet to Database Servers
►Sun Implementation of JdbcRowSet API
Connecting JdbcRowSet with a Connection URL
Connecting JdbcRowSet with a Predefined Connection Object
Connecting JdbcRowSet with a Predefined ResultSet Object
Connecting JdbcRowSet with JNDI Directory Service
JdbcRowSet Query Statement with Parameters
Inserting Rows with JdbcRowSet Objects
MySQL - JBDC CallableStatement
MySQL CLOB (Character Large Object) - TEXT
MySQL BLOB (Binary Large Object) - BLOB