查询、存储过程、函数调用中使用行处理器-bboss persistent框架行处理器使用
bboss persistent框架提供能了行处理器的功能,通过行处理器,用户可以自行处理查询结果集、存储过程out参数、存储函数out参数。本文分别举例说明。
在查询中使用行处理器
假设通过PreparedDBUtil执行以下预编译查询:select * from testnewface where object_id < ? --查询testnewface中object_id小于设定参数的所有记录
结果集将被封装成TestNewface对象列表返回。
表testnewface的结构如下:
名称 是否为空? 类型
OWNER NOT NULL VARCHAR2(30)
OBJECT_NAME NOT NULL VARCHAR2(30)
SUBOBJECT_NAME VARCHAR2(30)
OBJECT_ID NOT NULL NUMBER
DATA_OBJECT_ID NUMBER
OBJECT_TYPE VARCHAR2(19)
CREATED NOT NULL DATE
LAST_DDL_TIME NOT NULL DATE
TIMESTAMP VARCHAR2(19)
STATUS VARCHAR2(7)
TEMPORARY VARCHAR2(1)
GENERATED VARCHAR2(1)
SECONDARY VARCHAR2(1)
TestNewface对象结构如下,每个属性和表testnewface列名相对应:
public class TestNewface {
String OWNER ;
String OBJECT_NAME ;
String SUBOBJECT_NAME ;
int OBJECT_ID ;
int DATA_OBJECT_ID ;
String OBJECT_TYPE ;
Date CREATED ;
Date LAST_DDL_TIME ;
String TIMESTAMP ;
String STATUS ;
String TEMPORARY ;
String GENERATED ;
String SECONDARY ;
public String getOWNER() {
return OWNER;
}
public void setOWNER(String owner) {
OWNER = owner;
}
public String getOBJECT_NAME() {
return OBJECT_NAME;
}
public void setOBJECT_NAME(String object_name) {
OBJECT_NAME = object_name;
}
public String getSUBOBJECT_NAME() {
return SUBOBJECT_NAME;
}
public void setSUBOBJECT_NAME(String subobject_name) {
SUBOBJECT_NAME = subobject_name;
}
public int getOBJECT_ID() {
return OBJECT_ID;
}
public void setOBJECT_ID(int object_id) {
OBJECT_ID = object_id;
}
public int getDATA_OBJECT_ID() {
return DATA_OBJECT_ID;
}
public void setDATA_OBJECT_ID(int data_object_id) {
DATA_OBJECT_ID = data_object_id;
}
public String getOBJECT_TYPE() {
return OBJECT_TYPE;
}
public void setOBJECT_TYPE(String object_type) {
OBJECT_TYPE = object_type;
}
public Date getCREATED() {
return CREATED;
}
public void setCREATED(Date created) {
CREATED = created;
}
责任编辑:小草