pom.xml 导入 mybatis-starter,mysql和驱动,如下:
<dependency>
<groupId>org.mybatis.spring.boot</groupId>
<artifactId>mybatis-spring-boot-starter</artifactId>
<version>2.2.2</version>
</dependency>
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
</dependency>
application.yml 配置数据库连接信息
spring:
datasource:
driver-class-name: com.mysql.cj.jdbc.Driver
url: jdbc:mysql://192.168.126.156:3306/test
username: root
password: 123456
用户实体
@Data
public class User {
public long id;
public String name;
}
创建数据库操作类,本文采用注解版本
@Mapper
public interface UserMapper {
@Select("select * from user")
public List<User> getAll();
}
测试
@SpringBootTest
public class MybatisTest {
@Autowired
private UserMapper userMapper;
@Test
public void test(){
List<User> all = userMapper.getAll();
System.out.println(all);
}
}