This section describes how to connect a JdbcRowSet object to a database server with a predefined connection object.
Another way to connect a JdbcRowSet object to a database server is to pass a predefined connection object to the JdbcRowSetImpl constructor.
Here is a sample sequence of method calls:
// Create a Connection object
Connection con = DriverManager.getConnection("connection_url");
// Creating a JdbcRowSet object with a connection object
JdbcRowSet jrs = new JdbcRowSetImpl(con);
// Provide a SQL statement for future use
jrs.setCommand("SQL_statement");
// Create a connnection using DriverManager
// Execute the SQL statement
jrs.execute();
Here is a sample program that connects a JdbcRowSet object to MySQL server with a predefined connection object:
/**
* MySqlRowSetConnectionObject.java
* Copyright (c) 2007 by Dr. Herong Yang. All rights reserved.
*/
import java.sql.*;
public class MySqlRowSetConnectionObject {
public static void main(String [] args) {
Connection con = null;
try {
// Create a Connection object
Class.forName("com.mysql.jdbc.Driver") ;
con = DriverManager.getConnection(
"jdbc:mysql://localhost:3306/HerongDB"
+"?user=Herong&password=TopSecret");
// Pass the Connection object to the new JdbcRowSet object
javax.sql.rowset.JdbcRowSet jrs
= new com.sun.rowset.JdbcRowSetImpl(con);
// Set a SQL statement
jrs.setCommand("SELECT 'Hello world!'");
// Connect and run the statement
jrs.execute();
// Get the result
jrs.next();
System.out.println("Result: "+jrs.getString(1));
// Close resources
jrs.close();
con.close();
} catch (Exception e) {
System.err.println("Exception: "+e.getMessage());
}
}
}
Output of compilation and execution was recorded here:
C:\>javac -cp .;\local\lib\rowset.jar
MySqlRowSetConnectionObject.java
MySqlRowSetConnectionObject.java:19:
warning: com.sun.rowset.JdbcRowSetImpl is Sun proprietary API
and may be removed in a future release
= new com.sun.rowset.JdbcRowSetImpl(con);
^
1 warning
C:\>java -cp .;\local\lib\rowset.jar;
\local\lib\mysql-connector-java-5.0.7-bin.jar
MySqlRowSetConnectionObject
Result: Hello world!
