<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);
}