吐槽mybatis+熊猫哥优化教程

        <if test="customer.email != null and customer.email !=''">            AND a.email like "%"#{customer.email}"%"        </if>        <if test="customer.salesName != null and customer.salesName !=''">            AND d.sales_name = #{customer.salesName}        </if>        <if test="customer.firstName != null and customer.firstName !=''">            AND a.first_name like "%"#{customer.firstName}"%"        </if>        <if test="customer.lastName != null and customer.lastName !=''">            AND a.last_name like "%"#{customer.lastName}"%"        </if>        <if test="customer.whatapp != null and customer.whatapp !=''">            AND a.whatapp like "%"#{customer.whatapp}"%"        </if>        <if test="customer.country != null and customer.country !=''">            AND a.country = #{customer.country}        </if>        <if test="customer.province != null and customer.province !=''">            AND a.province like "%"#{customer.province}"%"        </if>        <if test="customer.orderCount != null and customer.orderCount !=''">            AND a.order_count like "%"#{customer.orderCount}"%"        </if>        <if test="customer.orderAmount != null and customer.orderAmount !=''">            AND a.order_amount = #{customer.orderAmount}        </if>        <if test="customer.levelId != null and customer.levelId !=''">            AND a.level_id = #{customer.levelId}        </if>        <if test="customer.lastLoginDateStartDate != null">            AND s.last_order_date <![CDATA[>= ]]> #{customer.lastLoginDateStartDate}        </if>        <if test="customer.lastLoginDateEndDate != null">            AND s.last_order_date <![CDATA[< ]]> #{customer.lastLoginDateEndDate}        </if>        <if test="customer.lastOrderDateStartDate != null">            AND s.last_login_date <![CDATA[>= ]]> #{customer.lastOrderDateStartDate}        </if>        <if test="customer.lastOrderDateEndDate != null">            AND s.last_login_date <![CDATA[< ]]> #{customer.lastOrderDateEndDate}        </if>        <if test="customer.createAtStartDate != null">            AND s.create_at <![CDATA[>= ]]> #{customer.createAtStartDate}        </if>        <if test="customer.createAtEndDate != null">            AND s.create_at <![CDATA[< ]]> #{customer.createAtEndDate}        </if>

        <where>            <foreach collection="conditionList" item="a" separator="and">                    ${a}            </foreach>        </where>

/** * @program:ant * @author:aodeng * @blog:低调小熊猫(https://aodeng.cc) * @微信公众号:低调小熊猫 * @create:2019-06-04 18:41 **/@Retention(RetentionPolicy.RUNTIME)@Target(ElementType.FIELD)public @interface JewelryAlias {    String value() default  "";    String column() default  "";    String type() default  "";}

/** * @author:aodeng(低调小熊猫) * @Description: TODO * @Date: 19-6-4 **/public class JewelryAnnotationUtil {    private JewelryAnnotationUtil() {    }    public static List<String> getCondition(Object obj) throws IllegalAccessException {        List<String> result = new ArrayList<>();        System.out.println(obj.getClass()+"==============");        Field[] fieldList = obj.getClass().getSuperclass().getDeclaredFields();        for (Field field : obj.getClass().getDeclaredFields()) {            field.setAccessible(true);            if (field.isAnnotationPresent(JewelryAlias.class) && (field.get(obj) != null)) {                JewelryAlias j = field.getAnnotation(JewelryAlias.class);                StringBuilder s = new StringBuilder();                s.append(!StrUtil.isBlank(j.value()) ? j.value().concat(".") : "");                s.append(!StrUtil.isBlank(j.column()) ? j.column() : field.getName());                switch (j.type()) {                    case "=":                        s.append(" = ");                        if(field.getType().equals(String.class)){                            s.append("'").append(field.get(obj)).append("'");                        }else{                            s.append(field.get(obj));                        }                        break;                    case "like":                        s.append(" like ");                        if(field.getType().equals(String.class)){                            s.append("'").append("%").append(field.get(obj)).append("%").append("'");                        }else{                            s.append("%").append(field.get(obj)).append("%");                        }                        break;                    default:                        break;                }                result.add(s.toString());            }        }        return result;    }}

    @RequestMapping(value = "/getOrderListByPage", method = RequestMethod.POST)    public SuccessData getOrderListByPage(@RequestBody ConditionalQueryVo<SalesOrderQueryVo> queryVo) throws IllegalAccessException{        if (ObjectUtil.isNull(queryVo.getConditionalObject())){            queryVo.setConditionalObject(new SalesOrderQueryVo());        }        return CheckSqlStatus.getSuccessData(orderService.getOrderListByPage(JewelryAnnotationUtil.getCondition(queryVo.getConditionalObject()), queryVo.getPageIndex(), queryVo.getPageSize()));    }

/** * @author:aodeng(低调小熊猫) * @Description: TODO * @Date: 19-6-4 **/@Datapublic class SalesOrderQueryVo {    @JewelryAlias(value = "sot", column = "carrier_code", type = "=")    private String carrierCode;   @JewelryAlias(value = "sot", column = "track_number", type = "like")    private String trackNumber;    @JewelryAlias(value = "so", column = "order_increment", type = "like")    private String orderIncrement;    @JewelryAlias(value = "sot", column = "status", type = "=")    private Integer status;}

List<SalesOrderModel> getOrderListByPage(Page<Object> page,@Param("conditionList") List<String> conditionList);