【MyBatis学习笔记】11. MyBatis注解

---

MyBatis常用注解

注解	对应XML	说明
@Insert	<insert>	新增SQL
@Update	<update>	更新SQL
@Delete	<delete>	删除SQL
@Select	<select>	查询SQL
@Param	–	参数映射
@Results	<resultMap>	结果映射
@Result	<result>	字段映射

如何使用

1. 注解扫描, 在mybatis-config.xml中增加配置

<mappers>
    <!-- 写法一 -->
    <mapper class="com.imooc.mybatis.dao.GoodsDAO" />
    <!-- 写法二 -->
    <mapper class="com.imooc.mybatis.dao" />
<mappers>

2. 新建接口

@Mapper
public interface GoodsDAO{
   
    @Select("select * from t_goods where current_price between #{min} and #{max} order by current_price limit 0,#{limt}")
    public List<Goods> selectByPriceRange(@Param("min")Float min,@Param("max")Float max,@Param("limt")Integer limt);
    
    @Insert("insert into t_goods(title,sub_title,original_cost,current_price,discount,is_free_delivery,category_id) values (#{title},#{sub_title},#{original_cost},#{current_price},#{discount},#{is_free_delivery},#{category_id})")
    @SelectKey(statement="select last_insert_id()",before=false,keyProperty="goodsId",resultType=Integer.class)
    public int insert(Goods goods);
    
    @Select("select * from t_goods")
    @Results({
   
        @Result(column="goods_id",property="goodsId",id=true),
        @Result(column="title",property="title"),
        @Result(column="current_price",property="currentPrice")
    })
    public List<GoodsDTO> selectAll();
}

3. 代码调用

session=MyBatisUtils.openSession();
GoodsDAO goodsDAO=session.getMapper(GoodsDAO.class);
goodsDAO.selectByPriceRange(100f,500f,20);
System.out.println(list.size());

session=MyBatisUtils.openSession();
Goods goods=new Goods();
goods.setTitle("测试商品");
goods.setSubTitle("测试子标题");
goods.setOriginalCost(200f);
goods