@entity
@table(name = "t_sen_disability_type")
在使用filter的时候还需要定义filter参数。 name 为filter名称,parameters为filter参数,@paramdef为参数定义,其中那么为apporcase(参数名称) type为该参数类型
@filterdef(name = "apporcasefilter", parameters = @paramdef(name = "apporcase", type = "string"))
public class disabilitytype extends identity {
private list<specneedquestion> specneedquestions;
@onetomany(fetch = fetchtype.lazy)
@filters( { @filter(name = "apporcasefilter", condition = ":apporcase=app_or_case") })
@joincolumn(name = "dis_type_id")
@orderby("qstindex")
public list<specneedquestion> getspecneedquestions() {
return specneedquestions;
}
public void setspecneedquestions(list<specneedquestion> specneedquestions) {
this.specneedquestions = specneedquestions;
}
@filters定义该对象关联specneedquestion对象是对应的所有的filters。
@filter 指定单个的filter 属性:name为filter的名字。condition为filter的过滤条件,其中:app_or_case为specneedquestion对象对应的表的字段,:apporcase为参数名称。
public list<disabilitytype> getdisables(string apporcase) {
string hql = "from disabilitytype t order by t.type";
session session = this.getsession();
filter filter = session.enablefilter("apporcasefilter");
filter.setparameter("apporcase", apporcase);
return find(hql);
}
@table(name = "t_sen_disability_type")
在使用filter的时候还需要定义filter参数。 name 为filter名称,parameters为filter参数,@paramdef为参数定义,其中那么为apporcase(参数名称) type为该参数类型
@filterdef(name = "apporcasefilter", parameters = @paramdef(name = "apporcase", type = "string"))
public class disabilitytype extends identity {
private list<specneedquestion> specneedquestions;
@onetomany(fetch = fetchtype.lazy)
@filters( { @filter(name = "apporcasefilter", condition = ":apporcase=app_or_case") })
@joincolumn(name = "dis_type_id")
@orderby("qstindex")
public list<specneedquestion> getspecneedquestions() {
return specneedquestions;
}
public void setspecneedquestions(list<specneedquestion> specneedquestions) {
this.specneedquestions = specneedquestions;
}
@filters定义该对象关联specneedquestion对象是对应的所有的filters。
@filter 指定单个的filter 属性:name为filter的名字。condition为filter的过滤条件,其中:app_or_case为specneedquestion对象对应的表的字段,:apporcase为参数名称。
public list<disabilitytype> getdisables(string apporcase) {
string hql = "from disabilitytype t order by t.type";
session session = this.getsession();
filter filter = session.enablefilter("apporcasefilter");
filter.setparameter("apporcase", apporcase);
return find(hql);
}
本文详细介绍了如何在特定的编程环境下,通过定义filter参数来优化对象关联查询的性能和效率,具体涉及到如何在查询中应用filter名称、设置参数以及实现过滤条件的应用。
425

被折叠的 条评论
为什么被折叠?



