mybatis的使用

添加依赖

   <dependency>
            <groupId>org.mybatis.spring.boot</groupId>
            <artifactId>mybatis-spring-boot-starter</artifactId>
            <version>2.1.0</version>
        </dependency>
        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
<!--            <scope>runtime</scope>-->
        </dependency>

application.properties 配置mysql

spring.datasource.url=jdbc:mysql:///lirui
spring.datasource.username=root
spring.datasource.password=root
spring.datasource.driver-class-name=com.mysql.jdbc.Driver

构建mapper类

@Mapper
public interface UserMapper {
    @Select("select * from users")
    public List<User> findAll();
}

进行测试

@RunWith(SpringRunner.class)
@SpringBootTest
public class MybatisTests {
    @Autowired
    private UserMapper userMapper;

    @Test
    public void testFindAll(){
        List<User> list = userMapper.findAll();
        System.out.println(list);
    }
}