DBFlute core libraries for Java8
- dbflute-engine: class generator tool
- dbflute-runtime: jar library for application
DBFlute has tolerance to DB change.
- Lean Startup & Incremental Development
- Implementing with Designing Development
*ConditionBean
List<Member> memberList = memberBhv.selectList(cb -> {
cb.setupSelect_MemberStatus();
cb.query().setMemberName_LikeSearch("S", op -> op.likePrefix());
cb.query().existsPurchase(purchaseCB -> {
purchaseCB.query().setPurchasePrice_GreaterEqual(200);
});
cb.query().addOrderBy_Birthdate_Desc();
});select dfloc.MEMBER_ID as MEMBER_ID, dfloc.MEMBER_NAME as ...
, dfrel_0.MEMBER_STATUS_CODE as MEMBER_STATUS_CODE_0, ...
from MEMBER dfloc
inner join MEMBER_STATUS dfrel_0 on dfloc.MEMBER_STATUS_CODE = dfrel_0.MEMBER_STATUS_CODE
where dfloc.MEMBER_NAME like 'S%' escape '|'
and exists (select sub1loc.MEMBER_ID
from PURCHASE sub1loc
where sub1loc.MEMBER_ID = dfloc.MEMBER_ID
and sub1loc.PURCHASE_PRICE >= 200
)
order by dfloc.BIRTHDATE desc*OutsideSql
/*
[Example for Simple Select]
It uses CustomizeEntity and ParameterBean.
*/
-- #df:entity#
-- !df:pmb!
-- !!AutoDetect!!
select mb.MEMBER_ID
, mb.MEMBER_NAME
, mb.BIRTHDATE
, stat.MEMBER_STATUS_NAME
from MEMBER mb
left outer join MEMBER_STATUS stat
on mb.MEMBER_STATUS_CODE = stat.MEMBER_STATUS_CODE
/*BEGIN*/
where
/*IF pmb.memberId != null*/
mb.MEMBER_ID = /*pmb.memberId*/3
/*END*/
/*IF pmb.memberName != null*/
and mb.MEMBER_NAME like /*pmb.memberName*/'S%' -- // keyword for prefix search
/*END*/
/*IF pmb.birthdate != null*/
and mb.BIRTHDATE = /*pmb.birthdate*/'1966-09-15' -- // used as equal
/*END*/
/*END*/
order by mb.BIRTHDATE desc, mb.MEMBER_ID ascSimpleMemberPmb pmb = new SimpleMemberPmb();
pmb.setMemberName_PrefixSearch("S");
List<SimpleMember> memberList = memberBhv.outsideSql().selectList(pmb);you can clone the example project of DBFlute:
- git clone https://github.com/dbflute/dbflute-howto.git
- prepare database by *ReplaceSchema at DBFlute client directory 'dbflute_maihamadb'
- compile it by Java8, on e.g. Eclipse or IntelliJ or ... as Maven project
- see HowToSelectTest.java
you can implement condition-bean as trial, and can execute it by JUnit
*ReplaceSchema
// call manage.sh at lastaflute-example-harbor/dbflute_maihamadb
// and select replace-schema in displayed menu
...:dbflute_maihamadb ...$ sh manage.shSee for the detail:
http://dbflute.seasar.org/ja/environment/setup/maven.html
(sorry Japanese site now...English coming soon)
*for DBFlute Runtime
<properties>
<dbflute.version>1.1.6</dbflute.version>
...
</properties>
...
<dependencies>
<dependency>
<groupId>org.dbflute</groupId>
<artifactId>dbflute-runtime</artifactId>
<version>${dbflute.version}</version>
</dependency>
...
</dependencies>*to download DBFlute Engine
<plugin>
<groupId>org.dbflute</groupId>
<artifactId>dbflute-maven-plugin</artifactId>
<version>1.1.0</version>
<configuration>
<clientProject>xxxdb</clientProject>
<packageBase>com.xxx.dbflute</packageBase>
</configuration>
</plugin>Apache License 2.0
http://dbflute.seasar.org/
(sorry Japanese site now...English coming soon)
DBFlute forks Apache Torque and S2Dao and (heavily) extends it.
And is influenced by Doma, ActiveRecord
If the frameworks were not there, no DBFlute here.
I appreciate every framework.
DBFlute is used by:
- Fess: https://github.com/codelibs/fess
- S2Robot: https://github.com/codelibs/s2robot
- and other many business projects, comming soon...