DBFlute -- 0.6.0 その2 {DisplaySql}


MemberCB cb = new MemberCB();
cb.setupSelect_MemberStatus();
cb.query().setMemberAccount_LikeSearch("S", new LikeSearchOption().likePrefix().escapeByPipeLine());
cb.query().addOrderBy_MemberId_Desc();
System.out.println(cb.toDisplaySql());// ★

  ↓

select ... from MEMBER left outer join MEMBER_STATUS on ...
where MEMBER_ACCOUNT like 'S%' escape by '|'
order by MEMBER_ID desc;

DEBUGログで出力されているものと同じSQL文字列