怎么把框中的代码换成EntityWrapper的查询条件,在线等,急
Wrapper wrapper = new EntityWrapper();
wrapper = wrapper.eq("school_id",'300000000000000');
wrapper = wrapper.addFilter("(volk is null OR birth_day IS NULL)");
addFilter是可以自己自定义的sql条件的
像这样的sql一般都在mapper里通过@select注解来做吧,如下:
持久层:
@Select("select * from role where role_code in(select role_code from user_role where username = #{username})")
List getUserRoles(String username);
业务处理:
List list = userMapper.getUserRoles(username);