1600 PMP mock questions 1400 CAPM mock questions 800 SCJP 6 mock questions 600 OCAJP 7 mock questions 590 OCPJP 7 mock questions 556 SCWCD 5 mock questions 500 OCEJWCD 6 mock questions pdfDownload (java,struts, hibernet etc)

JDBC Tutorials

Q. What is Rowset ? CachedRowSet,JDBCRowSet and WebRowSet ?

A RowSet object is a java bean component and extends the ResultSet interface.
The RowSet is majorly classified into two types :

1. Connected Rowset :
The connected rowset as the name suggests in connected to the database connection object like the resultset.
The JDBCRowSet is the example of the connected RowSet.

2. Disconnected RowSet:
The disconnected RowSet only connects to the database whenever required and after finishing the interaction they close the database connection.

There are three types of RowSet :

A CachedRowSet class?
a disconnected rowset that caches its data in memory; not suitable for very large data sets, but an ideal way to provide thin Java clients.

Example :
CachedRowSet cachedRs = new CachedRowSetImpl();
cachedRs.setUsername("scott");
cachedRs.setPassword("tiger");
cachedRs.setUrl("jdbc:oracle://localhost:3306/test");
cachedRs.setCommand("select * from employee");
cachedRs.setPageSize(4);
cachedRs.execute();
while (cachedRs.nextPage()) {
while (cachedRs.next()) {
System.out.println(cachedRs.getString("emp_name"));
}
}

A JDBCRowSet class?
a connected rowset that serves mainly as a thin wrapper around a ResultSet object to make a JDBC driver look like a JavaBeans component.
Example:
JdbcRowSet jdbcRs = new JdbcRowSetImpl();
jdbcRs.setUsername("scott");
jdbcRs.setPassword("tiger");
jdbcRs.setUrl("jdbc:oracle://localhost:3306/test");
jdbcRs.setCommand("select * from employee");
jdbcRs.execute();
while(jdbcRs.next()) {
System.out.println(jdbcRs.getString("emp_name"));
}


A WebRowSet class?
a connected rowset that uses the HTTP protocol internally to talk to a Java servlet that provides data access;
used to make it possible for thin web clients to retrieve and possibly update a set of rows.

Reviews and Comments


PMP, CAPM, PMI is a registered certification mark of the Project Management Institute, Inc

Copyright © www.techfaq360.com 2016


About US | Contact US | Privacy Policy | Terms and Conditions  | Website disclaimer  | Cancellation and Refund Policy  | Shipping & Delivery Policy