Spring Boot：Spring Boot配置Mybatis-Plus

这仅仅一些所需依赖，不要盲目全直接粘贴到pom文件中。

 
    
        1.1.1
        1.0.5
        2.0.7
        5.1.38
        1.1.12
    
 
 
        
            com.alibaba
            druid
            ${druid.version}
        

        
        
            org.mybatis.spring.boot
            mybatis-spring-boot-starter
            ${mybatis-spring-boot.version}
        

        
        
            org.springframework.boot
            spring-boot-starter-jdbc
        

        
        
            mysql
            mysql-connector-java
            ${mysql-connector-java.version}
        

        
        
            com.baomidou
            mybatisplus-spring-boot-starter
            ${mybatisplus-spring-boot-starter.version}
        

        
        
            com.baomidou
            mybatis-plus
            ${mybatisplus.version}
        
 

### 启动端口号server:
  port: 8080### 设置数据库spring:
  datasource:
    url: jdbc:mysql://127.0.0.1:3306/hrabbit_admin?autoReconnect=true&useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=false
    username: root    password: root### 配置mybatisPlusmybatis-plus:
  mapper-locations: classpath:mapper@Configuration@EnableTransactionManagement@MapperScan({"com.hrabbit.admin.modual.system.mapper"})public class SingleDataSourceConfig {    
    @Bean
    @ConfigurationProperties(prefix = "spring.datasource")    public DruidProperties druidProperties() {        return new DruidProperties();
    }    
    @Bean
    public DruidDataSource dataSource(DruidProperties druidProperties) {
        DruidDataSource dataSource = new DruidDataSource();
        druidProperties.config(dataSource);        return dataSource;
    }    
    @Bean
    public PaginationInterceptor paginationInterceptor() {
        PaginationInterceptor paginationInterceptor = new PaginationInterceptor();
        paginationInterceptor.setDialectType(DBType.MYSQL.getDb());        return paginationInterceptor;
    }
}

添加@TableName和@TableId等注解:

@Data@TableName(value = "sys_user")public class SysUser {    
    @TableId(type = IdType.AUTO)    private Integer id;    
    private String name;

}

主要继承baseMapper类，实现一些crud

public interface SysUserMapper extends baseMapper {    
    SysUser findSysUserById(@Param("id") Long id);
}

注意 ： 如果在xml 中不写SQL的，可以使用注解的方式在此接口当中直接写SQL，实体和数据库表字段不一致，使用@Result注解来映射

主要继承 IService

public interface SysUserService extends IService {    
    SysUser findSysUserById(Long id);    
    SysUser selectById(Long id);
}

@Service@SuppressWarnings("all")public class SysUserServiceImpl extends ServiceImpl implements SysUserService {    @Autowired
    private SysUserMapper sysUserMapper;    
    @Override
    public SysUser findSysUserById(Long id){        return sysUserMapper.findSysUserById(id);
    }    
    @Override
    public SysUser selectById(Long id){        return sysUserMapper.selectById(id);
    }

}

@Controller@RequestMapping("user")public class SysUserController {    @Autowired
    private SysUserService sysUserService;    
    @RequestMapping("/")    @ResponseBody
    public Object index() {        return sysUserService.selectById(1L);
    }

}

在Postman访问接口，成功获取到系统用户数据：

image.png

作者：hrabbits
链接：https://www.jianshu.com/p/fbb3bc22c25b