导航

IDEA MyBatisPlus Mapper接口向Mapper.xml传参

Posted on 2021-04-10 15:34  KK者  阅读(388)  评论(0)    收藏  举报

String传参:

xxxMapper.java

 1 import com.baomidou.mybatisplus.mapper.BaseMapper;
 2 import com.pro.model.xxxdInfoModel;
 3 
 4 public interface xxxMapper extends BaseMapper<xxxInfoModel>{
 5     /**
 6      * 以xxxID查xxx信息
 7      * @param xxxId
 8      * @return
 9      */
10     xxxdInfoModel selectOneById(String xxxId);
11 }

根据IDEA提示自动生成xxxMapper.xml

  

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd" >

    <select id="selectOneById" resultType="com.pro.model.xxxdInfoModel" parameterType="string">
        SELECT xxxID,XXXName
        FROM com.dbo.xxxXinXi
        WHERE xxxID = #{xxxId,jdbcType=VARCHAR}
    </select>


</mapper>