本文共 3359 字，大约阅读时间需要 11 分钟。

问题出现场景

定义了一个类，该类中许多变量都定义成了boolean类型，在使用mybatis的if写sql语句时，判断条件中使用了类定义的boolean类型变量，导致结果一直不对

mybatis中if使用介绍

mybatis的if判断里面最好不要使用boolean类型的值。原因：mybatis默认会把boolean变量的空值转为false。所以如果遇见前端传空值，这个字段在mybatis里面永远就是false了。可以使用数字类型代替，但是不要使用0作为参数

GatewaySearchVO类（将boolean改成String类型）

public class GatewaySearchVO {    private Integer page;    private Integer limit;    private String startTime;    private String endTime;    private String rpid;    private String rpver;    private String designer;    private String testuserPhonenum;    private String environment;    private String epiclink;    private String daterange;    private String runStableAll;    private String stable;    private String unStable;    private String positiveAndReverseAll;    private String positive;    private String reverse;    private String isAssociatedCaseAll;    private String associated;    private String nonAffiliated;    private String reviewStatusAll;    private String toReview;    private String inTheReview;    private String endOfTheReview;    private String pbStatusAll;    private String isPB;    private String isNotPB;    private String cicdAll;    private String isCICD;    private String isNotCICD;    }

XML文件（将boolean改成String类型后的正确写法）

   
       
        
            
             
             
             
             
             
             
             
             
             
             
             
             
             
             
             
             
             
             
             
             
             
             
         
        
            select * from gatewaycase where 1=1                    AND date_format(changetime, '%Y-%m-%d') between #{startTime} and #{endTime}                            and rpid=#{rpid}                            and rpver=#{rpver}                            and designer=#{designer}                            and testuser_phonenum=#{testuserPhonenum}                            and environment=#{environment}                            and epiclink=#{epiclink}                            and(                                                run_stable = "yes"                                                    run_stable = "no"                                        )                            and(                                                positive_case = "yes"                                                    positive_case = "no"                                        )                            and(                                                is_associated_case = 1                                                    is_associated_case = 0                                        )                            and(                                                reviewstatus = "待评审"                                                    reviewstatus = "评审中"                                                    reviewstatus = "评审结束"                                        )                            and(                                                pbstatus = 1                                                    pbstatus = 0                                        )                            and(                                                cicd = 1                                                    cicd = 0                                        )                order by id desc    
   

转载地址：http://lqtii.baihongyu.com/