在SQL里写条件判断
@Sql("SELECT mobile_user.mobile_user_id from mobile_user " +
"INNER JOIN mobile_device_user ON mobile_user.mobile_user_id = mobile_device_user.mobile_user_id " +
"/BEGIN/" +
" WHERE /IF userName != null/mobile_user.user_name LIKE /userName/'%name%'/END/" +
"/END/" +
"ORDER BY mobile_user.mobile_user_id asc;")
重点是BEGIN和END的部分。