{"id":400,"date":"2025-07-20T03:27:11","date_gmt":"2025-07-19T19:27:11","guid":{"rendered":"https:\/\/www.hgfwq.com\/blog\/?p=400"},"modified":"2025-07-20T03:27:11","modified_gmt":"2025-07-19T19:27:11","slug":"mybatis-plus%e5%85%a8%e5%ad%97%e6%ae%b5%e6%a8%a1%e7%b3%8a%e6%9f%a5%e8%af%a2%e5%ae%9e%e6%88%98%e4%b8%8e%e6%9c%80%e4%bd%b3%e5%ae%9e%e8%b7%b5","status":"publish","type":"post","link":"https:\/\/www.hgfwq.com\/blog\/400.html","title":{"rendered":"MyBatis-Plus\u5168\u5b57\u6bb5\u6a21\u7cca\u67e5\u8be2\u5b9e\u6218\u4e0e\u6700\u4f73\u5b9e\u8df5"},"content":{"rendered":"

MyBatis-Plus\u5168\u5b57\u6bb5\u6a21\u7cca\u67e5\u8be2\u6307\u5357<\/h><\/p>\n

\"MyBatis-Plus\u5168\u5b57\u6bb5\u6a21\u7cca\u67e5\u8be2\u5b9e\u6218\u4e0e\u6700\u4f73\u5b9e\u8df5\"<\/p>\n

\u968f\u7740\u9879\u76ee\u7684\u4e0d\u65ad\u6269\u5c55\uff0c\u6570\u636e\u5e93\u8868\u7684\u6570\u91cf\u548c\u590d\u6742\u6027\u4e5f\u5728\u4e0d\u65ad\u589e\u52a0\u3002\u5728\u8fd9\u79cd\u60c5\u51b5\u4e0b\uff0c\u5b9e\u73b0\u5168\u5b57\u6bb5\u7684\u6a21\u7cca\u67e5\u8be2\u529f\u80fd\u53ef\u4ee5\u5927\u5927\u63d0\u9ad8\u5f00\u53d1\u6548\u7387\u548c\u7528\u6237\u4f53\u9a8c\u3002MyBatis-Plus\u662f\u4e00\u6b3e\u4f18\u79c0\u7684\u6301\u4e45\u5c42\u6846\u67b6\uff0c\u652f\u6301\u5168\u5b57\u6bb5\u6a21\u7cca\u67e5\u8be2\uff0c\u4e0b\u9762\u5c06\u8be6\u7ec6\u8bb2\u89e3\u5982\u4f55\u5728MyBatis-Plus\u4e2d\u5b9e\u73b0\u5168\u5b57\u6bb5\u6a21\u7cca\u67e5\u8be2\u3002<\/p>\n<\/p>\n

1. \u914d\u7f6eMyBatis-Plus<\/h><\/p>\n

\u9996\u5148\uff0c\u786e\u4fdd\u4f60\u7684\u9879\u76ee\u4e2d\u5df2\u7ecf\u6dfb\u52a0\u4e86MyBatis-Plus\u4f9d\u8d56\u3002\u5728Maven\u9879\u76ee\u4e2d\uff0c\u53ef\u4ee5\u5728pom.xml\u6587\u4ef6\u4e2d\u6dfb\u52a0\u4ee5\u4e0b\u4f9d\u8d56\uff1a<\/p>\n<\/p>\n

“`xml<\/p>\n

<\/p>\n

com.baomidou<\/groupId><\/p>\n

mybatis-plus-boot-starter<\/artifactId><\/p>\n

\u6700\u65b0\u7248\u672c\u53f7<\/version><\/p>\n

<\/dependency><\/p>\n

“`<\/p>\n

2. \u521b\u5efa\u5b9e\u4f53\u7c7b<\/h><\/p>\n

\u521b\u5efa\u4e00\u4e2a\u5b9e\u4f53\u7c7b\uff0c\u7528\u4e8e\u6620\u5c04\u6570\u636e\u5e93\u8868\u3002\u5b9e\u4f53\u7c7b\u4e2d\u9700\u8981\u5305\u542b\u6240\u6709\u9700\u8981\u6a21\u7cca\u67e5\u8be2\u7684\u5b57\u6bb5\uff0c\u5e76\u4f7f\u7528`@TableField`\u6ce8\u89e3\u6307\u5b9a\u5b57\u6bb5\u540d\u3002<\/p>\n<\/p>\n

“`java<\/p>\n

import com.baomidou.mybatisplus.annotation.TableField;<\/p>\n

import com.baomidou.mybatisplus.annotation.TableId;<\/p>\n

import com.baomidou.mybatisplus.annotation.TableName;<\/p>\n

@TableName(“your_table_name”)<\/p>\n

public class YourEntity {<\/p>\n

@TableId<\/p>\n

private Long id;<\/p>\n

@TableField(“field1”)<\/p>\n

private String field1;<\/p>\n

@TableField(“field2”)<\/p>\n

private String field2;<\/p>\n

@TableField(“field3”)<\/p>\n

private String field3;<\/p>\n

\/\/ … \u5176\u4ed6\u5b57\u6bb5<\/p>\n

}<\/p>\n

“`<\/p>\n

3. \u521b\u5efaMapper\u63a5\u53e3<\/h><\/p>\n

\u521b\u5efa\u4e00\u4e2aMapper\u63a5\u53e3\uff0c\u7ee7\u627fMyBatis-Plus\u7684BaseMapper\u63a5\u53e3\u3002\u5728Mapper\u63a5\u53e3\u4e2d\uff0c\u53ef\u4ee5\u4f7f\u7528`SelectAllLike`\u65b9\u6cd5\u5b9e\u73b0\u5168\u5b57\u6bb5\u6a21\u7cca\u67e5\u8be2\u3002<\/p>\n<\/p>\n

“`java<\/p>\n

import com.baomidou.mybatisplus.core.mapper.BaseMapper;<\/p>\n

import com.baomidou.mybatisplus.extension.plugins.pagination.Page;<\/p>\n

import org.apache.ibatis.annotations.Param;<\/p>\n

public interface YourMapper extends BaseMapper {<\/p>\n

Page selectAllLike(@Param(“keyWord”) String keyWord);<\/p>\n

}<\/p>\n

“`<\/p>\n

4. \u5b9e\u73b0\u5168\u5b57\u6bb5\u6a21\u7cca\u67e5\u8be2<\/h><\/p>\n

\u5728Service\u5c42\u4e2d\uff0c\u5b9e\u73b0\u5168\u5b57\u6bb5\u6a21\u7cca\u67e5\u8be2\u7684\u65b9\u6cd5\u3002\u8fd9\u91cc\u4f7f\u7528MyBatis-Plus\u7684`LambdaQueryWrapper`\u6765\u6784\u5efa\u67e5\u8be2\u6761\u4ef6\u3002<\/p>\n<\/p>\n

“`java<\/p>\n

import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper;<\/p>\n

import com.baomidou.mybatisplus.extension.plugins.pagination.Page;<\/p>\n

import org.springframework.beans.factory.annotation.Autowired;<\/p>\n

import org.springframework.stereotype.Service;<\/p>\n

@Service<\/p>\n

public class YourService {<\/p>\n

@Autowired<\/p>\n

private YourMapper yourMapper;<\/p>\n

public Page searchAllByKeyword(String keyword) {<\/p>\n

LambdaQueryWrapper queryWrapper = new LambdaQueryWrapper<>();<\/p>\n

queryWrapper.like(YourEntity::getField1, keyword)<\/p>\n

.or()<\/p>\n

.like(YourEntity::getField2, keyword)<\/p>\n

.or()<\/p>\n

.like(YourEntity::getField3, keyword)<\/p>\n

\/\/ … \u5bf9\u5176\u4ed6\u5b57\u6bb5\u8fdb\u884c\u76f8\u540c\u7684\u6a21\u7cca\u67e5\u8be2<\/p>\n

.or()<\/p>\n

.like(YourEntity::getFieldN, keyword);<\/p>\n

return yourMapper.selectPage(new Page<>(1, 10), queryWrapper);<\/p>\n

}<\/p>\n

}<\/p>\n

“`<\/p>\n

5. \u4f7f\u7528\u5168\u5b57\u6bb5\u6a21\u7cca\u67e5\u8be2<\/h><\/p>\n

\u5728Controller\u5c42\u4e2d\uff0c\u8c03\u7528Service\u5c42\u7684\u65b9\u6cd5\uff0c\u5b9e\u73b0\u5168\u5b57\u6bb5\u6a21\u7cca\u67e5\u8be2\u7684\u63a5\u53e3\u3002<\/p>\n<\/p>\n

“`java<\/p>\n

import org.springframework.beans.factory.annotation.Autowired;<\/p>\n

import org.springframework.web.bind.annotation.GetMapping;<\/p>\n

import org.springframework.web.bind.annotation.RequestParam;<\/p>\n

import org.springframework.web.bind.annotation.RestController;<\/p>\n

@RestController<\/p>\n

public class YourController {<\/p>\n

@Autowired<\/p>\n

private YourService yourService;<\/p>\n

@GetMapping(“\/search”)<\/p>\n

public Page search(@RequestParam(“keyword”) String keyword) {<\/p>\n

return yourService.searchAllByKeyword(keyword);<\/p>\n

}<\/p>\n

}<\/p>\n

“`<\/p>\n

\u95ee\u7b54\u73af\u8282<\/h><\/p>\n

\u95ee\uff1a<\/b>MyBatis-Plus\u7684\u5168\u5b57\u6bb5\u6a21\u7cca\u67e5\u8be2\u4f1a\u5bf9\u6570\u636e\u5e93\u6027\u80fd\u4ea7\u751f\u5f88\u5927\u5f71\u54cd\u5417\uff1f<\/p>\n

\u7b54\uff1a\u5168\u5b57\u6bb5\u6a21\u7cca\u67e5\u8be2\u53ef\u80fd\u4f1a\u5bf9\u6570\u636e\u5e93\u6027\u80fd\u4ea7\u751f\u4e00\u5b9a\u5f71\u54cd\uff0c\u56e0\u4e3a\u5b83\u9700\u8981\u626b\u63cf\u6240\u6709\u5b57\u6bb5\u3002\u5728\u6570\u636e\u91cf\u8f83\u5927\u6216\u5b57\u6bb5\u8f83\u591a\u7684\u8868\u4e0a\u4f7f\u7528\u65f6\uff0c\u5efa\u8bae\u5bf9\u6570\u636e\u5e93\u8fdb\u884c\u4f18\u5316\uff0c\u5982\u5efa\u7acb\u9002\u5f53\u7684\u7d22\u5f15\u3002<\/p>\n<\/p>\n

\u95ee\uff1a<\/b>\u5982\u4f55\u4f18\u5316\u5168\u5b57\u6bb5\u6a21\u7cca\u67e5\u8be2\u7684\u6027\u80fd\uff1f<\/p>\n

\u7b54\uff1a\u53ef\u4ee5\u901a\u8fc7\u4ee5\u4e0b\u65b9\u5f0f\u4f18\u5316\u5168\u5b57\u6bb5\u6a21\u7cca\u67e5\u8be2\u7684\u6027\u80fd\uff1a<\/p>\n<\/p>\n