<select id="getUser_like" parameterClass="com.ibatis.User"
resultMap="GetUser">
select * from user
<dynamic prepend="where">
<isNotEmpty prepend="and" property="name"> name like
'%$name$%'
</isNotEmpty>
</dynamic>
</select>
public void testGetUser1() throws SQLException {
/**
* 模糊查询,查询符合指定条件的所有Person对象
*
* @param person
* @return
*/
List<User> personList = new ArrayList<User>();
User user = new User();
user.setName("zhangsan");
try {
personList = sqlMap.queryForList("getUser_like", user);
System.out.println(personList);
for (User user1 : personList) {
System.out.println(user1.getId() + " " + user1.getEmail());
}
} catch (SQLException e) {
e.printStackTrace();
} finally {
try {
sqlMap.endTransaction();
} catch (SQLException e) {
e.printStackTrace();
}
}