Springboot整合mybatis

新建一个 springboot工程 配置依赖

引入依赖

<!--引入druid的数据源-->
<dependency>
    <groupId>com.alibaba</groupId>
    <artifactId>druid-spring-boot-starter</artifactId>
    <version>1.1.21</version>
</dependency>

<!--引入mybatis和springboot的依赖-->
<dependency>
    <groupId>org.mybatis.spring.boot</groupId>
    <artifactId>mybatis-spring-boot-starter</artifactId>
    <version>2.1.4</version>
</dependency>

 

#配置druid数据源

spring.datasource.druid.driver-class-name=com.mysql.cj.jdbc.Driver
spring.datasource.druid.username=root
spring.datasource.druid.password=123456
spring.datasource.druid.url=jdbc:mysql://localhost:3306/supermarket?serverTimezone=Asia/Shanghai

#配置映射文件所在的路径

mybatis.mapper-locations=classpath:/mapper/*.xml

测试一下数据源配置是否成功

@SpringBootTest
class DemoApplicationTests {
    @Autowired
    private DataSource dataSource;
    @Test
    void contextLoads() throws SQLException {
        System.out.println(dataSource.getConnection());
    }
}

连接成功

配置主启动类：

@SpringBootApplication
@MapperScan(basePackages = {"com.lzj.demo.mapper"})
public class DemoApplication {
    public static void main(String[] args) {
        SpringApplication.run(DemoApplication.class, args);
    }
}

配置好之后就可以写业务代码了

测试select语句

△实体不是驼峰命名 要和数据库字段对应