基本springboot 的mybatis注解开发

 <dependency>
            <groupId>org.mybatis.spring.boot</groupId>
            <artifactId>mybatis-spring-boot-starter</artifactId>
            <version>1.2.0</version>
</dependency>

导入pom之后首先配置启动类上面修改注解扫描

 @MapperScan("com.yumin.dataobject.mappper")  

写mapper的接口 增删改查  

package com.yumin.dataobject.mappper;

public interface ProductCategoryMappper {


    @Insert("insert into product_category(category_name,category_type) values(#{category_name,jdbcType=VARCHAR },#{category_type,jdbcType=INTEGER })")
    int insertByMap(Map<String, Object> map);


    @Insert("insert into product_category(category_name,category_type) values(#{categoryName},#{categoryType},#{categoryStatus} )")
    int insertByObject(ProductCategory pc);

    @Select("select * from  product_category  where category_type  = #{categoryType}")
    @Results({
            @Result(column = "category_id", property = "categoryId"),
            @Result(column = "category_name",property = "categoryName"),
            @Result(column = "category_type", property = "categoryType"),
    })
    ProductCategory findByCatoryType(Integer categoryType);


    @Select("select * from product_category  where category_name  like CONCAT('%',#{categoryNam1e},'%')")
    @Results({
            @Result(column = "category_id", property = "categoryId"),
            @Result(column = "category_name",property = "categoryName"),
            @Result(column = "category_status", property = "categoryStatus")
    })
    List<ProductCategory> findByCategoryName(String categoryNam1e);


    @Update("update product_category  set category_name  = #{categoryName} where category_type= #{categoryType}")
    int updateProductCategory(@Param("categoryName") String categoryName, @Param("categoryType") Integer categoryType);


    @Update("update product_category  set category_name  = #{categoryName} where category_type= #{categoryType}")
    int  updateProductCategor(ProductCategory  pc );


    @Delete("delete from product_category where category_type=#{categoryType}")
    int deleteProductCategory(Integer categoryType);



}