老杜雀语的笔记:
https://www.yuque.com/dujubin/ltckqu/pozck9?#
密码:rs4n
1、MyBatis小技巧
1.1、#{} 和${}的区别
1.2、模糊查询小技巧
重点掌握最后一个
1.3、别名机制
1.4、mapper标签
2、MyBatis参数之多参数
3、Mybatis参数之@param注解
4、结果集映射
4.1、方式一:as起别名
<select id="selectAll" resultType="com.powernode.mybatis.pojo.Car">
select id,car_num as carNum,brand,guide_price as guidePrice,
produce_time as produceTime,car_type as carType from t_car
</select>
4.2、方式二:使用resultMap进行映射
<resultMap id="resultMap" type="com.powernode.mybatis.pojo.Car">
<id property="id" column="id"></id>
<result property="carNum" column="car_num"></result>
<result property="guidePrice" column="guide_price"></result>
<result property="cartype" column="car_type"></result>
<result property="produceTime" column="produce_time"></result>
</resultMap>
<select id="selectByRt" resultType="com.powernode.mybatis.pojo.Car" resultMap="resultMap">
select * from t_car
</select>
4.3、方式三:配置setting,开启驼峰命名自动映射
5、mybatis缓存机制
5.1 mybatis一级缓存
首先走的是一级缓存