mybatisPlus与Springboot的整合入门

MybatisPlus简单使用

一、数据库表

create table sys_admin(
  admin_id int primary key auto_increment,
  admin_name varchar(20) not null,
  admin_age int not null
)

二、springboot工程

1）导入pom包

 <dependencies>
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter</artifactId>
        </dependency>

        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-test</artifactId>
            <scope>test</scope>
            <exclusions>
                <exclusion>
                    <groupId>org.junit.vintage</groupId>
                    <artifactId>junit-vintage-engine</artifactId>
                </exclusion>
            </exclusions>
        </dependency>

        <!--mybatis-plus-->
        <dependency>
            <groupId>com.baomidou</groupId>
            <artifactId>mybatis-plus-boot-starter</artifactId>
            <version>3.0.5</version>
        </dependency>

        <!--mysql-->
        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
        </dependency>

        <!--lombok用来简化实体类-->
        <dependency>
            <groupId>org.projectlombok</groupId>
            <artifactId>lombok</artifactId>
        </dependency>
    </dependencies>

2）配置application.yml文件

spring:
  datasource:
    driver-class-name: com.mysql.cj.jdbc.Driver
    username: root
    password: 115967286
    url: jdbc:mysql://localhost:3306/mybatis_plus?serverTimezone=GMT%2B8
    
#mybatisPlus日志
mybatis-plus.configuration.log-impl=org.apache.ibatis.logging.stdout.StdOutImpl

3)编写t_Admin实体类

//这里使用了lombok的方式进行值的注入

@Data
@AllArgsConstructor
@NoArgsConstructor
public class SysAdmin {
    private int adminId;
    private String adminName;
    private int adminAge;
}

4）表示adminMapper类

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import edu.mju.mybatsi.plus.entity.Admin;
@Repository
public interface SysAdminMapper extends BaseMapper<Admin> {
}

5)为主启动类进行添加mapper位置的扫描

@SpringBootApplication
@MapperScan("edu.mju.mybatis.plus.mapper")
public class ProjectMain {
    public static void main(String[] args) {
        SpringApplication.run(ProjectMain.class,args);
    }
}

6)进行数据的测试

@SpringBootTest
public class MybatsiPlusTest {

    @Autowired
    private SysAdminMapper sysAdminMapper;

    @Test
    public void testContext(){

        SysAdmin admin=new SysAdmin();
        admin.setAdminName("greety");
        admin.setAdminAge(18);
        sysAdminMapper.insert(admin);
    }
}