spring boot mybatis 注解sql

spring boot  约定优于配置 ，集成mybatis 时候，一般也采用mybatis 注解sql .

下面简单介绍一下。

1：spring boot  pom 添加对mybatis 的支持及分页插件。

 <dependency>
            <groupId>org.mybatis.spring.boot</groupId>
            <artifactId>mybatis-spring-boot-starter</artifactId>
            <version>1.1.1</version>
        </dependency>
        
        
        <dependency>
<groupId>com.github.pagehelper</groupId>
<artifactId>pagehelper-spring-boot-starter</artifactId>
<version>1.1.0</version>
</dependency>


<dependency>
<groupId>com.github.abel533</groupId>
<artifactId>mapper</artifactId>
<version>3.0.0</version>
</dependency>

2： 编写mapper

   public interface Mtper<T> {



 @InsertProvider(method = "insertSelective", type = BaseProvider.class)
   int save(T t);
   
   
   
   @UpdateProvider(method = "updateByPrimaryKeySelective", type = BaseProvider.class)
   int update(T t);
   
   
   
   @DeleteProvider(method = "deleteByPrimaryKey", type = BaseProvider.class)
   int deleteByKey(T t,Object val);
   
   
   
   @SelectProvider(type=BaseProvider.class,method = "selectByPrimaryKey")
   T selectByKey(Class<?> clazz,Object val);
   
   
   @InsertProvider(type = BaseProvider.class, method = "insertAll")  
   int insertAll(@Param("list") List<T> list,T t);  

}

3: 编写sql 脚本

public class UserDynaSqlProvider extends BaseProvider {


    
public String findTutorByIdSql(User user) {
return "select u.id as id,c.cards as cards   from user u LEFT JOIN  card c on u.id=c.uid and u.id="
+ user.getId();


}


}

4：在service 层注入对应的mapper,  处理好业务逻辑即可

5：需要源码的可以联系我qq .2354764247 备注 ‘王芳平美女’  。