ibatis 3 学习笔记 6

动态拼接sql：

private String selectPersonLike(Person p){BEGIN(); // Clears ThreadLocal variableSELECT("P.ID, P.USERNAME, P.PASSWORD, P.FIRST_NAME, P.LAST_NAME");FROM("PERSON P");if (p.id != null) {WHERE("P.ID like #{id}");}if (p.firstName != null) {WHERE("P.FIRST_NAME like #{firstName}");}if (p.lastName != null) {WHERE("P.LAST_NAME like #{lastName}");}ORDER_BY("P.LAST_NAME");return SQL();}


Method Description
BEGIN()/RESET() 重置ThreadLocal状态
SELECT(String) select 参数
FROM(String) from 表名
JOIN(String)
INNER_JOIN(String)
LEFT_OUTER_JOIN(String)
RIGHT_OUTER_JOIN(String) 表连接
WHERE(String) where子句
OR() or 子句
AND() and 子句
GROUP_BY() group by 子句
HAVING(String) having 子句
ORDER_BY(String) order by 子句
SQL() 返回拼接的sql语句