【Mybatis的if标签判空会把0判成空】

Mybatis的if标签判空会把0判成空

我也踩过这个坑( 1 )

已统计您的踩坑,无需重复点击

回答(0)

详细描述

错误截图

源码

    <!--根据id或状态或所属作品id查询留言-->
    <select id="selectMessage" resultMap="messageMap">
        SELECT * FROM message
        <where>
            <if test="messageId!=''and messageId!=null">
                message_id=#{messageId}
            </if>
            <if test="messageStatus ==0 or messageStatus == 1">
                AND message_status=#{messageStatus}
            </if>
            <if test="messageReplyWorkId !='' and messageReplyWorkId !=null">
                AND message_reply_work_id=#{messageReplyWorkId}
            </if>
            <if test="messageReplyId !='' and messageReplyId !=null">
                AND message_reply_id=#{messageReplyId}
            </if>
        </where>
        ORDER BY message_create_at DESC
    </select>

    public CodeMessageData selectMessage(Work workReceive, Message messageReceive, Integer pn, Integer num) {
        PageHelper.startPage(pn, num);
        Work work = new Work();
        work.setWorkName(workReceive.getWorkName());
        List<Work> workList = workMapper.selectWork(work);
        if(null==workList||workList.size()==0){
            return new CodeMessageData(0,"未找到该作品");
        }else{
            Message message = new Message();
            message.setMessageReplyWorkId(workList.get(0).getWorkId());
            message.setMessageReplyId(0L);
            message.setMessageStatus(messageReceive.getMessageStatus());
            List<Message> messageList = messageMapper.selectMessage(message);
            if (null == messageList || messageList.size() == 0) {
                return new CodeMessageData(0, "未找到该作品留言");
            } else {
                return new CodeMessageData(1, "查询成功", new PageInfo<Message>(messageList));
            }
        }
    }

    @RequestMapping(value = "/SelectMessage", method = RequestMethod.POST)
    public CodeMessageData selectMessage(Work workReceive, Message messageReceive, Integer pn, Integer num) {
        if(null!=messageReceive.getMessageStatus()&&(messageReceive.getMessageStatus()!=0&&messageReceive.getMessageStatus()!=1)){
            return new CodeMessageData(0,"留言状态错误");
        }else if(null==workReceive.getWorkName()||workReceive.getWorkName()==""){
            return new CodeMessageData(0,"留言所属作品名错误");
        }else if (null==pn||pn<=0||null==num||num<=0) {
            return new CodeMessageData(0, "页码错误");
        }else{
            return messageService.selectMessage(workReceive,messageReceive,pn,num);
        }

    }

编辑于2024-11-18