实体类
@Data
public class UserInfo {
private String name;
}
mapper层
@Mapper
public interface UserInfoMapper {
List<UserInfo> byName(String name);
}
mapper.xml(resources目录下)
<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.example.informationmanagement.mapper.UserInfoMapper">
<resultMap type="com.example.informationmanagement.bean.UserInfo" id="userResultMap">
</resultMap>
<!-- 通过名字进行模糊查询 -->
<select id="byName" resultMap="userResultMap">
select *
from basplu
where name like '%' + #{name} + '%'
</select>
</mapper>
service层
@Service
public class UserInfoService {
@Autowired
public UserInfoMapper userInfoMapper;
//通过名字进行模糊查询
public List<UserInfo> byName(String name) {
return userInfoMapper.byName(name);
}
}
controller层
@RestController
public class UserInfoController {
@Autowired
public UserInfoService userInfoService;
@RequestMapping(value = "/byName")
public List<Map> byName(String name) {
List<UserInfo> listUserInfo = userInfoService.byName(name);
List<Map> mapList = new ArrayList<>();
if (listUserInfo.size() > 0) {
for (UserInfo list : listUserInfo) {
Map<String, Object> resultMap = new HashMap<>();
resultMap.put("name", list.getName());
mapList.add(resultMap);
}
}
return mapList;
}
}
application.properties(resources目录下)
<?xml version="1.0" encoding="UTF-8"?> <project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 https://maven.apache.org/xsd/maven-4.0.0.xsd"> <modelVersion>4.0.0</modelVersion> <parent> <groupId>org.springframework.boot</groupId> <artifactId>spring-boot-starter-parent</artifactId> <version>2.4.5</version> <relativePath/> </parent> <groupId>com.example</groupId> <artifactId>informationmanagement</artifactId> <version>0.0.1-SNAPSHOT</version> <name>informationmanagement</name> <description>Demo project for Spring Boot</description> <properties> <java.version>1.8</java.version> </properties> <dependencies> <dependency> <groupId>org.springframework.boot</groupId> <artifactId>spring-boot-starter-jdbc</artifactId> </dependency> <dependency> <groupId>org.springframework.boot</groupId> <artifactId>spring-boot-starter-web</artifactId> </dependency> <dependency> <groupId>org.mybatis.spring.boot</groupId> <artifactId>mybatis-spring-boot-starter</artifactId> <version>2.1.4</version> </dependency> <dependency> <groupId>com.microsoft.sqlserver</groupId> <artifactId>mssql-jdbc</artifactId> <scope>runtime</scope> </dependency> <dependency> <groupId>org.springframework.boot</groupId> <artifactId>spring-boot-starter-test</artifactId> <scope>test</scope> </dependency> <dependency> <groupId>org.projectlombok</groupId> <artifactId>lombok</artifactId> </dependency> <dependency> <groupId>com.alibaba</groupId> <artifactId>fastjson</artifactId> <version>1.2.6</version> </dependency> <dependency> <groupId>com.aliyun</groupId> <artifactId>dingtalk</artifactId> <version>1.1.47</version> </dependency> <dependency> <groupId>com.dingtalk</groupId> <artifactId>dingtalk-api-sdk</artifactId> <version>1.0.0-SNAPSHOT</version> <scope>system</scope> <systemPath>${pom.basedir}/lib/taobao-sdk-java-auto_1479188381469-20210207.jar</systemPath> </dependency> </dependencies> <build> <plugins> <plugin> <groupId>org.springframework.boot</groupId> <artifactId>spring-boot-maven-plugin</artifactId> <version>2.3.5.RELEASE</version> </plugin> </plugins> </build> </project>