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 备注 ‘王芳平美女’ 。