S2JDBC、タイプセーフな記述でAND,OR条件を使う書き方。
select().where(
or(
new SimpleWhere().contains(column1(), ${hoge}),
new SimpleWhere().contains(column2(), ${hoge}),
),
and(
new SimpleWhere().eq(column3(), ${fuga}),
)
).getResultList()
http://d.hatena.ne.jp/Johnnydaisuke/20090106/1231275226