sf.database.jdbc.sql

Class RecordsHolder<T extends DBObject>

java.lang.Object

sf.database.jdbc.sql.RecordsHolder<T>

Type Parameters:

T -

All Implemented Interfaces:

Iterable<T>

public final class RecordsHolder<T extends DBObject>
extends Object
implements Iterable<T>

一个可以更新数据的结果集，我们可以直接在结果集上更新数据。 代码示例如下:

 

 RecordsHolder holder = db.selectForUpdate(QB.create(Root.class).getInstance());
 System.out.println("总数:" + holder.size());
 int n = 0;
 for (Root r : holder.get()) {
 r.setName("更新第" + n + "条。"); // 修改对象中的值
 n++;
 }
 holder.delete(holder.size() - 1); // 删除结果集中的最后一条记录(序号从0开始)
 Root root = holder.newRecord(); // 创建一条新纪录
 root.setName("新插入的记录");
 holder.commit(); // 提交上述修改并关闭游标（更新、删除、添加）
 
 

Author:

Field Summary

Fields

Modifier and Type	Field and Description
static int	AFTER_LAST
static int	BEFORE_FIRST

Method Summary

Modifier and Type	Method and Description
void	close() 关闭ResultSet和statement
int	commit() 将修改提交(更新到数据库)
int	commitAndClose() 将修改提交到数据库
void	delete(int index) 删除
void	delete(T object) 删除指定的记录
List<T>	get() 返回结果集
boolean	isDeleted(int index) 检查指定的对象是否删除
Iterator<T>	iterator()
T	newRecord() 创建一个新记录
int	size() 返回结果的条数
boolean	supportsNewRecord() 一些数据库不支持在ResultSet上新建记录，返回该标志

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Methods inherited from interface java.lang.Iterable

forEach, spliterator

Field Detail

BEFORE_FIRST

public static final int BEFORE_FIRST

See Also:

Constant Field Values

AFTER_LAST

public static final int AFTER_LAST

See Also:

Constant Field Values

Method Detail

size

public int size()

返回结果的条数

Returns:

get

public List<T> get()

返回结果集

Returns:

supportsNewRecord

public boolean supportsNewRecord()

一些数据库不支持在ResultSet上新建记录，返回该标志

Returns:

newRecord

public T newRecord()

创建一个新记录

Returns:

isDeleted

public boolean isDeleted(int index)

检查指定的对象是否删除

Parameters:

index - 序号，从0开始

Returns:

delete

public void delete(int index)

删除

Parameters:

index - 在结果集中的序号

delete

public void delete(T object)

删除指定的记录

Parameters:

object - 删除结果集当中指定的对象

commit

public int commit()

将修改提交(更新到数据库)

Throws:

SQLException

commitAndClose

public int commitAndClose()

将修改提交到数据库

Returns:

close

public void close()

关闭ResultSet和statement

Throws:

SQLException

iterator

public Iterator<T> iterator()

Specified by:

iterator in interface Iterable<T extends DBObject>