数据结构
网络
关系数据库管理系统 (RDBMS)
操作系统
Java
MS Excel
iOS
HTML
CSS
Android
Python
C语言编程
C++
C#
MongoDB
MySQL
Javascript
PHP
物理
化学
生物
数学
英语
经济学
心理学
社会学
服装学
法学JDBC中的CachedRowSet是什么？请解释。
CachedRowSet是断开连接的行集的基类实现。它连接到数据源，从中读取数据，与数据源断开连接，处理检索到的数据，重新连接到数据源并写入修改。
创建CachedRowSet
可以使用RowSetFactory的**createCachedRowSet()**方法创建Cached RowSet对象。
可以使用RowSetProvider方法的**newfactory()**方法创建RowSetFactory对象。
使用上述方法创建**CachedRowSet**对象，如下所示：
//Creating the RowSet object RowSetFactory factory = RowSetProvider.newFactory(); CachedRowSet rowSet = factory.createCachedRowSet();
连接到数据源
创建RowSet对象后，需要将其连接到所需的数据源。
可以通过设置属性值（如用户名、密码、URL和数据源名称）来连接到数据源：
//Setting the URL
String mysqlUrl = "jdbc:mysql://127.0.0.1/SampleDB";
rowSet.setUrl(mysqlUrl);
//Setting the user name
rowSet.setUsername("root");
//Setting the password
rowSet.setPassword("password");准备和执行命令语句
缓存的行集有一个命令属性，可以向其传递查询。使用setCommand()方法将所需的查询设置为该属性。
rowSet.setCommand("select * from ProductSales");可以使用execute()方法执行RowSet对象持有的查询。
rowSet.execute();
示例
假设数据库中有一个名为ProductSales的表，其内容如下：
+----+-------------+--------------+--------------+--------------+-------+----------------+ | ID | ProductName | CustomerName | DispatchDate | DeliveryTime | Price | Location | +----+-------------+--------------+--------------+--------------+-------+----------------+ | 1 | Key-Board | Raja | 2019-09-01 | 05:30:00 | 7000 | Hyderabad | | 2 | Earphones | Roja | 2019-05-01 | 05:30:00 | 2000 | Vishakhapatnam | | 3 | Mouse | Puja | 2019-03-01 | 05:29:59 | 3000 | Vijayawada | | 4 | Mobile | Vanaja | 2019-03-01 | 04:40:52 | 9000 | Chennai | | 5 | Headset | Jalaja | 2019-04-06 | 18:38:59 | 6000 | Goa | +----+-------------+--------------+--------------+--------------+-------+----------------+
下面的例子将上述表的内容检索到CachedRowSet对象中并显示出来。
示例
import java.sql.Date;
import java.sql.DriverManager;
import java.sql.Time;
import javax.sql.rowset.CachedRowSet;
import javax.sql.rowset.RowSetFactory;
import javax.sql.rowset.RowSetProvider;
public class CachedRowSetExample {
public static void main(String args[]) throws Exception {
//Registering the Driver
DriverManager.registerDriver(new com.mysql.jdbc.Driver());
//Creating the RowSet object
RowSetFactory factory = RowSetProvider.newFactory();
CachedRowSet rowSet = factory.createCachedRowSet();
//Setting the URL
String mysqlUrl = "jdbc:mysql://127.0.0.1/SampleDB";
rowSet.setUrl(mysqlUrl);
//Setting the user name
rowSet.setUsername("root");
//Setting the password
rowSet.setPassword("password");
//Setting the query/command
rowSet.setCommand("select * from ProductSales");
rowSet.execute();
System.out.println("Contents of the row set");
while(rowSet.next()) {
System.out.print("ID: "+rowSet.getInt("ID")+", ");
System.out.print("Product Name: "+rowSet.getString("ProductName")+", ");
System.out.print("Customer Name: "+rowSet.getString("CustomerName")+", ");
System.out.print("Dispatch Date: "+rowSet.getDate("DispatchDate")+", ");
System.out.print("Delivery Time: "+rowSet.getTime("DeliveryTime"));
System.out.print("Price: "+rowSet.getString("Price")+", ");
System.out.print("Location: "+rowSet.getString("Location"));
System.out.println("");
}
}
}输出
Contents of the Rowset ID: 1, Product Name: Key-Board, Customer Name: Raja, Dispatch Date: 2019-09-01, Delivery Time: 05:30:00 Price: 7000, Location: Hyderabad ID: 2, Product Name: Earphones, Customer Name: Roja, Dispatch Date: 2019-05-01, Delivery Time: 05:30:00 Price: 2000, Location: Vishakhapatnam ID: 3, Product Name: Mouse, Customer Name: Puja, Dispatch Date: 2019-03-01, Delivery Time: 05:29:59 Price: 3000, Location: Vijayawada ID: 4, Product Name: Mobile, Customer Name: Vanaja, Dispatch Date: 2019-03-01, Delivery Time: 04:40:52Price: 9000, Location: Chennai ID: 5, Product Name: Headset, Customer Name: Jalaja, Dispatch Date: 2019-04-06, Delivery Time: 18:38:59 Price: 6000, Location: Goa
更新于：2019年7月30日
2K+ 次浏览
广告