MyBatis中如何动态拼接Sql字符串呢？

转自:

MyBatis中如何动态拼接Sql字符串呢？

MyBatis简介

MyBatis拥有非常强大的动态SQL处理能力
下文笔者讲述动态sql的相关简介说明，如下所示:

if

SELECT * FROM User
WHERE state = 'ACTIVE'

AND userName like #{userName}

当没有传递userName信息时，则不传入此参数

---

choose,when,otherwise

SELECT * FROM User
WHERE


AND userName like #{userName}


AND userName like #{lastName}

 

set

update User

username=#{username},
password=#{password},
email=#{email}

where id=#{id}


同上的问题，优化后


update User


username=#{username},
password=#{password},
email=#{email}

where id=#{id}