springBoot，mybatis-plus集成sql server数据库

骑猪看日落 2024-03-24 17:28 35阅读 0赞

> 在springBoot项目中，使用Mybatis-Plus集成sql server数据库。

### 首先引入依赖 ###

<dependency>
                <groupId>com.microsoft.sqlserver</groupId>
                <artifactId>sqljdbc4</artifactId>
                <version>4.0</version>
            </dependency>
    		
            <dependency>
                <groupId>com.baomidou</groupId>
                <artifactId>mybatis-plus-boot-starter</artifactId>
                <version>3.5.2</version>
            </dependency>

### 配置springBoot依赖 ###

spring.datasource.driver-class-name=com.microsoft.sqlserver.jdbc.SQLServerDriver
    spring.datasource.url=jdbc:sqlserver://ip:1433;databasename=数据库名
    spring.datasource.username=账号
    spring.datasource.password=密码
    # 开启mybatis-plus的日志，方便查看sql语句的执行
    mybatis-plus.configuration.log-impl=org.apache.ibatis.logging.stdout.StdOutImpl

### 配置mybatis-plus的分页 ###

// 因为这是sql server 数据库，因此会和mysql的配置有点不一样，sql server版本不同，也会有些差别
    @Configuration
    public class MybatisPlusConfig {
        
    
    
        @Bean
        public MybatisPlusInterceptor mybatisPlusInterceptor(){
        
            MybatisPlusInterceptor mybatisPlusInterceptor = new MybatisPlusInterceptor();
            mybatisPlusInterceptor.addInnerInterceptor(new PaginationInnerInterceptor(DbType.SQL_SERVER2005)); // 高版本使用SQL_SERVER
            return mybatisPlusInterceptor;
        }
    }

### 实体类 ###

@TableName("zkt_table") // 对应表名
    public class Zkt {
        
        @TableId(type = IdType.AUTO) // 采用自增
        private Long id;
        @TableField(value = "SN")
        private String SN;
        private String location;
        private String ip;
        private String type;
        @TableField(value = "lastTime")
        private String lastTime;
        private Integer state = 1;
        private String park;
    
      set ,get ...
    }

### mapper包 ###

public interface ZktMapper extends BaseMapper<Zkt> {
        
    }

### service包 ###

public interface ZktService {
        
        Result fuzzy(ZktFuzzyParams zktFuzzyParams);
    }
    
    @Service
    public class ZktServiceImpl implements ZktService {
        
    
        @Resource
        private ZktMapper zktMapper;
    
        @Override
        public Result fuzzy(ZktFuzzyParams zktFuzzyParams) {
        
            LambdaQueryWrapper<Zkt> wrapper = new LambdaQueryWrapper();
            if (StringUtils.hasText(zktFuzzyParams.getSN())){
        
                wrapper.like(Zkt::getSN,zktFuzzyParams.getSN());
            }
            if (StringUtils.hasText(zktFuzzyParams.getPark())){
        
                wrapper.like(Zkt::getPark,zktFuzzyParams.getPark());
            }
    
            Page<Zkt> zktPage = zktMapper.selectPage(new Page<>(zktFuzzyParams.getPageNum(), zktFuzzyParams.getPageSize()), wrapper);
    
            return Result.success(zktPage);
        }

### controller包 ###

@RestController
    public class ZktController {
        
    
        @Resource
        private ZktService zktService;
    
        @GetMapping("/fuzzy")
        public Result fuzzy(ZktFuzzyParams zktFuzzyParams){
        
            return zktService.fuzzy(zktFuzzyParams);
        }
    }

> 致此集成结束，如有不足还请大家斧正。