1.引入MySQL和Mybatis依赖
<dependency>
<groupId>com.mysql</groupId>
<artifactId>mysql-connector-j</artifactId>
<version>8.1.0</version>
</dependency>
<dependency>
<groupId>org.mybatis.spring.boot</groupId>
<artifiactId>mybatis-spring-boot-starter</artifactId>
<version>2.2.2</version>
</dependency>
2.设置配置文件
spring:
datasource:
url: jdbc:mysql://192.168.150.101:3306/db04 #链接路径
driver-class-name: com.mysql.cj.jdbc.Driver #数据库驱动
username: root #帐号
password: 123 #密码
3.定义mapper层接口和编写SQL语句
@mapper
public interface UserMapper{
/**
* 编写sql语句
*
/
@select("select * from user")
public list<User> getUserInfo();
}
4.创建测试类进行调试
@SpringBootTest
public class MybatisTest{
@AutoWired
private UserMapper userMapper
@Test
public void testMybatis(){
list<User> userInfo = userMapper.getUserInfo();
for(User user : userInfo){
system.out.println(user);
}
}
}
5.查看输出结果(实体类重写toString)
user = User(id=1, name=光明右使, age=48, gender=1, phone=18800000005)
user = User(id=2, name=白眉鹰王, age=55, gender=1, phone=18800000000)
user = User(id=3, name=金毛狮王, age=45, gender=1, phone=18800000001)
user = User(id=4, name=青翼蝠王, age=38, gender=1, phone=18800000002)
user = User(id=5, name=紫衫龙王, age=42, gender=2, phone=18800000003)
user = User(id=6, name=光明左使, age=37, gender=1, phone=18800000004)
6.配置SQL语句检测=>Idea可以帮助我们去检测SQL语句,效果如下
user表信息如下(没有user1这个表格和name2这个字段)
比对上图可知Idea可以帮助我们检测MySQL中的表名,字段名,和SQL语句的关键字等信息,具体开启方法如下
7.选取SQL语句然后右键,点击Show Context Actions
8.点击Language Injection Settings(注意不是点击右侧的箭头,直接点中间位置)
9.选择MySQL然后点击OK即可
若是以上设置还没有生效,那是因为没有和数据库建立链接,和数据库建立链接即可,具体如下