模糊查询（通过真实测试例子来查询）

实体类

@Data

public class UserInfo {

    private String name;

}

 mapper层

@Mapper

public interface UserInfoMapper {

    List byName(String name);

}

mapper.xml(resources目录下)

        select *

        from basplu

        where name like '%' + #{name} + '%'

service层

@Service

public class UserInfoService {

    @Autowired

    public UserInfoMapper userInfoMapper;

    //通过名字进行模糊查询

    public List byName(String name) {

        return userInfoMapper.byName(name);

    }

}

controller层

@RestController

public class UserInfoController {

    @Autowired

    public UserInfoService userInfoService;

    @RequestMapping(value = "/byName")

    public List

        List listUserInfo = userInfoService.byName(name);

        List

        if (listUserInfo.size() > 0) {

            for (UserInfo list : listUserInfo) {

                Map resultMap = new HashMap<>();

                resultMap.put("name", list.getName());

                mapList.add(resultMap);

            }

        }

        return mapList;

    }

}

application.properties(resources目录下)

    4.0.0
    
        org.springframework.boot
        spring-boot-starter-parent
        2.4.5
        
    
    com.example
    informationmanagement
    0.0.1-SNAPSHOT
    informationmanagement
    Demo project for Spring Boot
    
        1.8
    
    

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

        
            org.springframework.boot
            spring-boot-starter-web
        

        
            org.mybatis.spring.boot
            mybatis-spring-boot-starter
            2.1.4
        

        
            com.microsoft.sqlserver
            mssql-jdbc
            runtime
        

        
            org.springframework.boot
            spring-boot-starter-test
            test
        

        
            org.projectlombok
            lombok
        

        
            com.alibaba
            fastjson
            1.2.6
        

        
            com.aliyun
            dingtalk
            1.1.47
        

        
            com.dingtalk
            dingtalk-api-sdk
            1.0.0-SNAPSHOT
            system
            ${pom.basedir}/lib/taobao-sdk-java-auto_1479188381469-20210207.jar
        

    

    
        
            
                org.springframework.boot
                spring-boot-maven-plugin
                2.3.5.RELEASE