hibernate find By Example, it will use all field
来源:互联网 发布:算法竞赛宝典怎么样 编辑:程序博客网 时间:2024/05/16 05:25
1.example
PtrsPosition examplePosition = new PtrsPosition();
PvTrs pvtrs = new PvTrs();
if (trade.getPvtrs() != null) {
pvtrs.setPortfoliocusip(trade.getPvtrs().getPortfoliocusip());//if not like this, it will use all the non null property to query
}
examplePosition.setPvtrs(pvtrs);
// examplePosition.setPvtrs(trade.getPvtrs());
examplePosition.setLoanfacility(trade.getLoanfacility());
List<PtrsPosition> ptrsPositions = new ArrayList<PtrsPosition>(ptrsPositionService
.getPositionsByExample(examplePosition));
2.sql
from
PTRSPOSITION this_,
LOANFACILITY loanfacili2_,
LOANDEAL loandeal5_,
PVTRS pvtrs1_
where
this_.LOANFACILITYID=loanfacili2_.LOANFACILITYID
and loanfacili2_.LOANDEALID=loandeal5_.LOANDEALID(+)
and this_.PTRSID=pvtrs1_.PVTRSID
and (
this_.POSITIONV=?
)
and (
pvtrs1_.PORTFOLIOCUSIP=?
)
and (
loanfacili2_.LDRFACILITYID=?
and loanfacili2_.LDRDEALID=?
and loanfacili2_.LOANXID=?
and loanfacili2_.FACILITYCUSIP=?
and loanfacili2_.FACILITYTYPE=?
and loanfacili2_.FACILITYNAME=?
and loanfacili2_.FACILITYDESC=?
and loanfacili2_.FACILITYSTATUS=?
and loanfacili2_.LSTATYPE=?
and loanfacili2_.GLOBALSIZE=?
and loanfacili2_.ORIGGLOBALSIZE=?
and loanfacili2_.GLOBALCCY=?
and loanfacili2_.FUNDEDFLAG=?
and loanfacili2_.FUNDEDAMOUNT=?
and loanfacili2_.UNFUNDEDAMOUNT=?
and loanfacili2_.DRAWDOWNLIMIT=?
and loanfacili2_.ISSUEDATE=?
and loanfacili2_.MATURITYDATE=?
and loanfacili2_.FIXEDRATEFLAG=?
and loanfacili2_.BASERATECATEGORY=?
and loanfacili2_.BASERATE=?
and loanfacili2_.SPREAD=?
and loanfacili2_.ALLINRATE=?
and loanfacili2_.COUPONFREQUENCY=?
and loanfacili2_.RATERESETFREQUENCY=?
and loanfacili2_.DAYCOUNT=?
and loanfacili2_.REPAYMENTSENIORITY=?
and loanfacili2_.SECUREDFLAG=?
and loanfacili2_.LIENSENIORITY=?
and loanfacili2_.PRORATAFLAG=?
and loanfacili2_.MINBORROWAMOUNT=?
and loanfacili2_.INCRBORROWAMOUNT=?
and loanfacili2_.PREPAYMENTOPTIONFLAG=?
and loanfacili2_.AMORTIZATIONFLAG=?
and loanfacili2_.EVERGREENREVOLVERFLAG=?
and loanfacili2_.TERMOUTREVOLVERCONVFLAG=?
and loanfacili2_.PAYMENTINKINDFLAG=?
and loanfacili2_.SNPRATING=?
and loanfacili2_.MOODYRATING=?
and loanfacili2_.COMMITEDOBLIGATIONFLAG=?
and loanfacili2_.ASSETID=?
and loanfacili2_.COVLITEFLAG=?
and loanfacili2_.RECORDSTATUS=?
and loanfacili2_.CREATEDBY=?
and loanfacili2_.CREATIONDATE=?
and loanfacili2_.MODIFIEDBY=?
and loanfacili2_.MODIFICATIONDATE=?
)
- hibernate find By Example, it will use all field
- Auto property synthesis will not synthesizeproterty;it will be implemented by its superclass, use@dy
- Hibernate query by Example
- hibernate by example 排除某些列
- auto property synthesis will not synthesize proterty ;it will be implementedby its superclass, use @
- Auto property synthesis will not synthesize property 'delegate'; it will be implemented by its super
- Auto property synthesis will not synthesize property ‘delegate’;it will be implemented by its superc
- Auto property synthesis will not synthesize property ‘delegate’;it will be implemented by its superc
- all instance of the license"*" are in use .VA will be disabled
- Maven by Example 1.1. Maven… What is it?
- Android Password Field Example
- /dev/hdb1 is apparently in use by the system; will not make a filesystem here!解决方法
- /dev/sdc is apparently in use by the system; will not make a filesystem here
- /dev/sdc1 is apparently in use by the system; will not make a filesystem here!
- /dev/hdb1 is apparently in use by the system; will not make a filesystem here!解决方法
- /dev/sdxx is apparently in use by the system; will not make a filesystem here! 解决方法
- /dev/sdb1 is apparently in use by the system; will not make a filesystem here
- Fedora 24 Will Use Wayland By Default, Fedora 24 Server Drops 32 Bit Support
- 拷贝项目时的注意事项
- JAVA Dynamic Proxy
- 内核初始化优化宏
- 2011-9-7多线程
- SQL清除某个数据库的所有数据库连接
- hibernate find By Example, it will use all field
- wireshark过滤器规则
- android --- listview 优化+复杂UI 《中航信android客户端实战 经验》
- 在SD卡中创建文件
- yaml简介以及在python上的应用
- Using the window.open method
- 使用AB进行压力测试
- android 学习2 :布局
- jQuery验证框架(一) 可选项 (jQuery validation)