整合mybatis-plus
1.安装
Maven:
<dependency>
<groupId>com.baomidou</groupId>
<artifactId>mybatis-plus-boot-starter</artifactId>
<version>3.4.3</version>
</dependency>
2.配置
Spring Boot 工程:
- 在
application.yml
配置文件中添加 H2 数据库的相关配置: -
spring: datasource: driver-class-name: com.mysql.cj.jdbc.Driver url: jdbc:mysql://localhost:3306/jjshipping?serverTimezone=UTC username: root password: 密码
- 配置 MapperScan 注解
@SpringBootApplication
@MapperScan("com.baomidou.mybatisplus.samples.quickstart.mapper")
public class Application {
public static void main(String[] args) {
SpringApplication.run(Application.class, args);
}
}
3.注解
参考网址:mybaitis-plus
注解使用:实体类与数据库字段一一对应
user.java
package com.example.mybatisplus.bean;
import com.baomidou.mybatisplus.annotation.TableField;
import lombok.AllArgsConstructor;
import lombok.Data;
import lombok.NoArgsConstructor;
@Data
@AllArgsConstructor
@NoArgsConstructor
public class User {
private int id;
@TableField("userName")
private String userName;
@TableField("passWord")
private String passWord;
@TableField("realName")
private String realName;
}
目录结构
4.编码:
user.java
package com.example.mybatisplus.bean;
import com.baomidou.mybatisplus.annotation.TableField;
import lombok.AllArgsConstructor;
import lombok.Data;
import lombok.NoArgsConstructor;
@Data
@AllArgsConstructor
@NoArgsConstructor
public class User {
private int id;
@TableField("userName")
private String userName;
@TableField("passWord")
private String passWord;
@TableField("realName")
private String realName;
}
UserMapper.java
UserMapper 继承来自mybatis-plus的实现类(增删改查),所以自己可以不用写实现类,
如果自己想自定义mapper方法,方法和mybatis一样,请参考另一遍文章mybaitis+springbootd 环境下的增删改查
package com.example.mybatisplus.mapper;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.example.mybatisplus.bean.User;
import org.apache.ibatis.annotations.Mapper;
import java.util.List;
@Mapper
public interface UserMapper extends BaseMapper<User> {
public List<User> findall();
}
测试代码
@Test
void contextLoads() {
List<User> users = userMapper.selectList(null);
for (User user : users) {
System.out.println("user = " + user);
}
}
运行结果