转自:

springboot如何集成mybatis呢?

下文笔者讲述SpringBoot集成MyBatis的方法分享，如下所示

实现思路:引入mybatis-spring-boot-starter即可在SpringBoot中使用MyBatis

例
pom.xml配置

 org.springframework.bootspring-boot-dependencies2.3.0.RELEASEimportpomorg.springframework.bootspring-boot-starterorg.springframework.bootspring-boot-starter-weborg.projectlomboklombokorg.slf4jslf4j-apiorg.springframework.bootspring-boot-starter-testmysqlmysql-connector-java
org.mybatis.spring.bootmybatis-spring-boot-starter2.1.0com.github.pagehelperpagehelper-spring-boot-starter1.2.5
src/main/resources**/*.properties**/*.xml**/*.ymltrue

application.yml配置

mybatis的xml文件我是放在了resources下mybatis文件夹中

#mybatis
mybatis:mapper-locations: classpath*:mybatis/*.xmltype-aliases-package: com.java265.pojoconfiguration:map-underscore-to-camel-case: true
#showSql
logging:level:com.java265.mapper: debug
#pagehelper
pagehelper:helper-dialect: mysqlreasonable: truesupport-methods-arguments: trueparams: countSql

查询示例分享

@Data
@NoArgsConstructor
@AllArgsConstructorpublic class User implements Serializable {private Integer id;private String lastName;private String email;private String gender;private Integer age;
}
@Repository
public interface UserMapper {List batchFind(List ids);List list();
}
@Service
public class UserService {@AutowiredEmployeeMapper userMapper;public List batchFind(List ids){return userMapper.batchFind(ids);}public List list(){return userMapper.list();}
}

mybaits之xml文件配置

select * from tbl_user0">and id in#{id}

测试@Testpublic void test2(){List users = UserService.batchFind(Arrays.asList(1, 3, 4));log.info("结果：[{}]",users);}