? ? ? ? @MethodAnnot()
? ? ? ? public static List<VwUserRole> getVwUserRoleByList(VwUserRole ? ? ?vwUserRole){ ?
? ? ? ? ? ? ? return vwUserRoleService.selectList(
? ? ? ? ? ? ? ? ? ? ? ? new EntityWrapper<VwUserRole>(vwUserRole).like("username",vwUserRole.getUsername(), SqlLike.DEFAULT));
? ? ? ? }

SELECT id,username,del_flag AS delFlag FROM vw_user_role WHERE username='a' AND del_flag='0' AND (username LIKE '%a%')

? ? ? ? ?@MethodAnnot()
? ? ? ? public static List<VwUserRole> getVwUserRoleByList(VwUserRole vwUserRole){
? ? ? ? ? ? ? ? EntityWrapper ew=new EntityWrapper();
? ? ? ? ? ? ? ? ew.setEntity(new VwUserRole());
? ? ? ? ? ? ? ? ew.eq("del_flag",'0');
? ? ? ? ? ? ? ? ew.like("username",vwUserRole.getUsername(), SqlLike.DEFAULT);
? ? ? ? ? ? ? ? return vwUserRoleService.selectList(ew);
? ? ? ? }

SELECT id,username,del_flag AS delFlag FROM vw_user_role WHERE (del_flag = 0 AND username LIKE '%a%')

like(boolean condition, String column, String value)
like(String column, String value)
like(boolean condition, String column, String value, SqlLike type)
like(String column, String value, SqlLike type)

? ? LEFT("left", "左邊%"),
? ? RIGHT("right", "右邊%"),
? ? CUSTOM("custom", "定制"),
? ? DEFAULT("default", "兩邊%");