mybatis的多代表查询两表 left join on

Java在开发

已于 2022-07-22 10:38:41 修改

阅读量755

点赞数

分类专栏： mybatis 文章标签： mybatis java

于 2022-07-22 10:34:34 首次发布

本文链接：https://blog.csdn.net/weixin_47641362/article/details/125927057

版权

mybatis 专栏收录该内容

7 篇文章 0 订阅

订阅专栏

controller

  /**
     *
     *张子辉  4
     */

    @GetMapping("/queryAllPatientS")
    public PageList<PatientRegisterDomain> queryAllPatientS(String name,String idCard,String callTime,String firstaidStatus,String createTime,int pageCurrent, int pageSize,String statu,Integer carId,String orgName){

        if ("1".equals(statu)) {
            return patientRegisterImpl.queryAllpatient(name,idCard,callTime,firstaidStatus,createTime,pageCurrent,pageSize,carId,orgName);
        } else if ("2".equals(statu)) {
            return patientRegisterImpl.queryAllPatientsBycodes(name,idCard,callTime,firstaidStatus,createTime,pageCurrent,pageSize,carId,orgName);
        }else if (orgName!=null){
            return patientRegisterImpl.queryAllHisptoals(name,idCard,callTime,firstaidStatus,createTime,pageCurrent,pageSize,carId,orgName);
        }
        return patientRegisterImpl.queryAllpatient(name,idCard,callTime,firstaidStatus,createTime,pageCurrent,pageSize,carId,orgName);
    }

service

    PageList<PatientRegisterDomain> queryAllPatientsBycodes(String name, String idCard, String callTime, String firstaidStatus, String createTime, int pageCurrent, int pageSize,Integer carId,String orgName);

service impl

@Override
    public PageList<PatientRegisterDomain> queryAllHisptoals(String name, String idCard, String callTime, String firstaidStatus, String createTime, int pageCurrent, int pageSize, Integer carId, String orgName) {
        PageHelper.startPage(pageCurrent, pageSize);
        List<PatientRegisterDomain> all =  patientRegisterDao.queryAllHisptoals(name,idCard,callTime,firstaidStatus,createTime,pageCurrent,pageSize,carId,orgName);
        PageInfo<PatientRegisterDomain> pageInfo = new PageInfo<>(all);

        PageList pageList = new PageList(pageInfo.getTotal(), pageInfo.getList());
        return pageList;
    }

dao

    @Override
    public PageList<PatientRegisterDomain> queryAllHisptoals(String name, String idCard, String callTime, String firstaidStatus, String createTime, int pageCurrent, int pageSize, Integer carId, String orgName) {
        PageHelper.startPage(pageCurrent, pageSize);
        List<PatientRegisterDomain> all =  patientRegisterDao.queryAllHisptoals(name,idCard,callTime,firstaidStatus,createTime,pageCurrent,pageSize,carId,orgName);
        PageInfo<PatientRegisterDomain> pageInfo = new PageInfo<>(all);

        PageList pageList = new PageList(pageInfo.getTotal(), pageInfo.getList());
        return pageList;
    }

mapper

 <select id="queryAllHisptoals" parameterType="string" resultMap="BaseResultMap">
    select
     y.NAME
    from  yqjj_firstaid f
    left join yqjj_patient y
    on  f.ID=y.FIRSTAID_ID

        <where>
            <if test="name != null and name != ''">
                NAME = #{name}
            </if>

            <if test="idCard != null and idCard != ''">
                and  ID_CARD = #{idCard}
            </if>

            <!--<if test="callTime != null and callTime != ''">-->
            <!--and  date(CALL_TIME) = date(#{callTime,jdbcType=TIMESTAMP})-->
            <!--</if>-->

            <if test=" callTime != null  and callTime != '' ">
                and CALL_TIME &gt;= DATE_FORMAT(#{callTime},'%Y-%m-%d 00:00:00')
            </if>
            <if test=" callTime != null and callTime != ''">
                and CALL_TIME &lt;=  DATE_FORMAT(#{callTime},'%Y-%m-%d 23:59:59')
            </if>

            <if test="firstaidStatus != null and firstaidStatus != ''">
                and  FIRSTAID_STATUS = #{firstaidStatus}
            </if>

            <if test="carId != null and carId != ''">
                and  CAR_ID = #{carId}
            </if>

            <if test="orgName != null and orgName != ''">
                and  f.ORG_NAME = #{orgName}
            </if>
        </where>

    </select>