{"id":10006759,"date":"2022-10-28T15:11:02","date_gmt":"2022-10-28T07:11:02","guid":{"rendered":"https:\/\/ityet.com\/?p=10006759"},"modified":"2022-10-28T15:11:02","modified_gmt":"2022-10-28T07:11:02","slug":"%e7%9c%8b%e4%ba%86%e6%88%91%e7%9a%84-mybatis-plus-%e7%94%a8%e6%b3%95%ef%bc%8c%e5%85%a8%e5%85%ac%e5%8f%b8%e5%90%8c%e4%ba%8b%e5%bc%80%e5%a7%8b%e6%82%84%e6%82%84%e6%a8%a1%e4%bb%bf%e4%ba%86%e3%80%82","status":"publish","type":"post","link":"https:\/\/itmax.cn\/?p=10006759","title":{"rendered":"\u770b\u4e86\u6211\u7684 mybatis-plus \u7528\u6cd5\uff0c\u5168\u516c\u53f8\u540c\u4e8b\u5f00\u59cb\u6084\u6084\u6a21\u4eff\u4e86\u3002\u3002"},"content":{"rendered":"

\u672c\u6587\u4e3b\u8981\u4ecb\u7ecd mybatis-plus \u8fd9\u6b3e\u63d2\u4ef6\uff0c\u9488\u5bf9 springboot \u7528\u6237\u3002\u5305\u62ec\u5f15\u5165\uff0c\u914d\u7f6e\uff0c\u4f7f\u7528\uff0c\u4ee5\u53ca\u6269\u5c55\u7b49\u5e38\u7528\u7684\u65b9\u9762\u505a\u4e00\u4e2a\u6c47\u603b\u6574\u7406\uff0c\u5c3d\u91cf\u5305\u542b\u5927\u5bb6\u5e38\u7528\u7684\u573a\u666f\u5185\u5bb9\u3002<\/p>\n

\"\"<\/p>\n

\u4f5c\u8005\uff1a\u6211\u729f\u4e0d\u8fc7\u4f60\u3000\/
\u539f\u6587\u94fe\u63a5\uff1ahttps:\/\/juejin.cn\/post\/705472…<\/a><\/p><\/blockquote>\n

\u5173\u4e8e mybatis-plus \u662f\u4ec0\u4e48\uff0c\u4e0d\u591a\u505a\u4ecb\u7ecd\u4e86\uff0c\u770b\u5b98\u65b9\u6587\u6863\uff0c\u54b1\u4eec\u76f4\u63a5\u4ee3\u7801\u64b8\u8d77\u6765\u3002<\/p>\n

\u4e00\u3001\u5feb\u901f\u5f00\u59cb<\/h2>\n

\u672c\u6587\u57fa\u4e8e springboot\u3001maven\u3001jdk1.8\u3001mysql \u5f00\u53d1\uff0c\u6240\u4ee5\u5f00\u59cb\u524d\u6211\u4eec\u9700\u8981\u51c6\u5907\u597d\u8fd9\u5957\u73af\u5883\u3002<\/p>\n

Spring Boot \u57fa\u7840\u5c31\u4e0d\u4ecb\u7ecd\u4e86\uff0c\u63a8\u8350\u770b\u8fd9\u4e2a\u514d\u8d39\u6559\u7a0b\uff1a<\/p>\n

https:\/\/github.com\/javastacks\/spring-boot-best-practice<\/a><\/p><\/blockquote>\n

\u65b0\u5efa\u5982\u4e0b\u6570\u636e\u5e93\uff1a<\/p>\n

\"\"<\/p>\n

\u5efa\u8bae\u5927\u5bb6\u9009\u62e9 utf8mb4 \u8fd9\u79cd\u5b57\u7b26\u96c6\uff0c\u505a\u8fc7\u5fae\u4fe1\u7684\u540c\u5b66\u5e94\u8be5\u4f1a\u77e5\u9053\uff0c\u5fae\u4fe1\u7528\u6237\u540d\u79f0\u7684\u8868\u60c5\uff0c\u662f\u9700\u8981\u8fd9\u79cd\u5b57\u7b26\u96c6\u624d\u80fd\u5b58\u50a8\u7684\u3002<\/p>\n

\u6211\u5c31\u9ed8\u8ba4\u5176\u4ed6\u73af\u5883\u5df2\u7ecf\u51c6\u5907\u597d\u4e86\uff0c\u54b1\u4eec\u76f4\u63a5\u4ece mybatis-plus \u5f00\u59cb\u3002<\/p>\n

1.1 \u4f9d\u8d56\u51c6\u5907<\/h3>\n

\u60f3\u8981\u4ec0\u4e48\u4f9d\u8d56\u7248\u672c\u7684\u53bb maven \u4ed3\u5e93\u67e5\u770b\uff1a<\/p>\n

https:\/\/mvnrepository.com\/<\/a><\/p><\/blockquote>\n

\u5f15\u5165 mybatis-plus \u4f9d\u8d56\uff1a<\/p>\n

<dependency>\n    <groupId>com.baomidou<\/groupId>\n    <artifactId>mybatis-plus-boot-starter<\/artifactId>\n    <version>3.5.0<\/version>\n<\/dependency><\/code><\/pre>\n
\u5f15\u5165 mysql \u4f9d\u8d56\uff1a<\/p>\n
<dependency>\n    <groupId>mysql<\/groupId>\n    <artifactId>mysql-connector-java<\/artifactId>\n    <version>8.0.27<\/version>\n<\/dependency><\/code><\/pre>\n
\u76ee\u524d\uff0c\u591a\u6570\u9879\u76ee\u4f1a\u6709\u591a\u6570\u636e\u6e90\u7684\u8981\u6c42\uff0c\u6216\u8005\u662f\u4e3b\u4ece\u90e8\u7f72\u7684\u8981\u6c42\uff0c\u6240\u4ee5\u6211\u4eec\u8fd8\u9700\u8981\u5f15\u5165 mybatis-plus \u5173\u4e8e\u591a\u6570\u636e\u6e90\u7684\u4f9d\u8d56\uff1a<\/p>\n
<!-- mybatis-plus \u591a\u6570\u636e\u6e90 -->\n<dependency>\n    <groupId>com.baomidou<\/groupId>\n    <artifactId>dynamic-datasource-spring-boot-starter<\/artifactId>\n    <version>3.5.0<\/version>\n<\/dependency><\/code><\/pre>\n
1.2 \u914d\u7f6e\u51c6\u5907<\/h3>\n
Spring Boot \u57fa\u7840\u5c31\u4e0d\u4ecb\u7ecd\u4e86\uff0c\u63a8\u8350\u770b\u8fd9\u4e2a\u514d\u8d39\u6559\u7a0b\uff1a<\/p>\n
https:\/\/github.com\/javastacks\/spring-boot-best-practice<\/a><\/p><\/blockquote>\n
springboot \u542f\u52a8\u7c7b\u3002\u914d\u7f6e@MapperScan \u6ce8\u89e3\uff0c\u7528\u4e8e\u626b\u63cf Mapper \u6587\u4ef6\u4f4d\u7f6e:<\/p>\n
import org.mybatis.spring.annotation.MapperScan;\nimport org.springframework.boot.SpringApplication;\nimport org.springframework.boot.autoconfigure.SpringBootApplication;\nimport org.springframework.cloud.client.discovery.EnableDiscoveryClient;\n\n@EnableDiscoveryClient\n@MapperScan(\/"com.wjbgn.user.mapper\/")\n@SpringBootApplication\npublic class RobNecessitiesUserApplication {\n\n    public static void main(String[] args) {\n        SpringApplication.run(RobNecessitiesUserApplication.class, args);\n    }\n\n}<\/code><\/pre>\n
\u6570\u636e\u6e90\u914d\u7f6e\uff0c\u6b64\u5904\u914d\u7f6e\u4e00\u4e3b\u4e00\u4ece\u7684\u73af\u5883\uff0c\u5f53\u524d\u6211\u53ea\u6709\u4e00\u53f0\uff0c\u6240\u4ee5\u6b64\u5904\u914d\u7f6e\u4e00\u6837\u7684\uff1a<\/p>\n
spring:\n  datasource:\n    dynamic:\n      primary: master #\u8bbe\u7f6e\u9ed8\u8ba4\u7684\u6570\u636e\u6e90\u6216\u8005\u6570\u636e\u6e90\u7ec4,\u9ed8\u8ba4\u503c\u5373\u4e3amaster\n      strict: false #\u4e25\u683c\u5339\u914d\u6570\u636e\u6e90,\u9ed8\u8ba4false. true\u672a\u5339\u914d\u5230\u6307\u5b9a\u6570\u636e\u6e90\u65f6\u629b\u5f02\u5e38,false\u4f7f\u7528\u9ed8\u8ba4\u6570\u636e\u6e90\n      datasource:\n        master:\n          url: jdbc:mysql:\/\/127.0.0.1:3306\/rob_necessities?useUnicode=true&characterEncoding=utf-8&useSSL=false&serverTimezone =Asia\/Shanghai\n          username: root\n          password: 123456\n        slave_1:\n          url: jdbc:mysql:\/\/127.0.0.1:3306\/rob_necessities?useUnicode=true&characterEncoding=utf-8&useSSL=false&serverTimezone =Asia\/Shanghai\n          username: root\n          password: 123456<\/code><\/pre>\n
\u8865\u5145<\/strong>\uff1a\u8fd9\u91cc\u9762\u56e0\u4e3a\u9ed8\u8ba4\u4f7f\u7528\u7684\u662fHikariCP<\/code>\u6570\u636e\u6e90,\u76ee\u524d\u4e5f\u63a8\u8350\u4f7f\u7528\u8fd9\u4e2a\uff0c\u76f8\u6bd4\u4e8edruid<\/code>\u6709\u66f4\u9ad8\u7684\u6027\u80fd\uff0c\u4f46\u662f\u4e0d\u80fd\u5ffd\u7565\u4e0b\u9762\u7684\u914d\u7f6e\uff0c\u5426\u5219\u670d\u52a1\u4f1a\u4e0d\u65ad\u629b\u51fa\u5f02\u5e38\uff0c\u539f\u56e0\u662f\u6570\u636e\u5e93\u7684\u8fde\u63a5\u65f6\u5e38\u548c\u8fde\u63a5\u6c60\u7684\u914d\u7f6e\u6ca1\u6709\u505a\u597d\u3002<\/p>\n
spring:\n  datasource:\n    dynamic:\n      hikari:\n        max-lifetime: 1800000\n        connection-timeout: 5000\n        idle-timeout: 3600000\n        max-pool-size: 12\n        min-idle: 4\n        connection-test-query: \/**ping*\/<\/code><\/pre>\n
1.3 \u542f\u52a8\u670d\u52a1<\/h3>\n
\u4e0b\u9762\u76f4\u63a5\u542f\u52a8\u670d\u52a1\uff1a<\/p>\n
\"\"<\/p>\n
\u5f97\u5230\u5982\u4e0a\u7ed3\u679c\u8868\u793a\u542f\u52a8\u6210\u529f\u4e86\u3002<\/p>\n
\u4e8c\u3001\u4f7f\u7528<\/h3>\n
\u524d\u9762\u6211\u4eec\u6210\u529f\u7684\u96c6\u6210\u8fdb\u6765\u4e86 mybatis-plus\uff0c\u914d\u5408 springboot \u4f7f\u7528\u4e0d\u8981\u592a\u65b9\u4fbf\u3002\u4e0b\u9762\u6211\u4eec\u770b\u770b\u5982\u4f55\u4f7f\u7528\u5b83\u6765\u64cd\u4f5c\u6211\u4eec\u7684\u6570\u636e\u5e93\u3002\u4ecb\u7ecd\u4e00\u4e0b\u5e38\u89c4\u7684\u7528\u6cd5\u3002<\/p>\n
2.1 \u5b9e\u4f53\u7c7b\u6ce8\u89e3<\/h3>\n
mybatis-plus \u4e3a\u4f7f\u7528\u8005\u5c01\u88c5\u4e86\u5f88\u591a\u7684\u6ce8\u89e3\uff0c\u65b9\u4fbf\u6211\u4eec\u4f7f\u7528\uff0c\u6211\u4eec\u9996\u5148\u770b\u4e0b\u5b9e\u4f53\u7c7b\u4e2d\u6709\u54ea\u4e9b\u6ce8\u89e3\u3002\u6709\u5982\u4e0b\u7684\u5b9e\u4f53\u7c7b\uff1a<\/p>\n
@TableName(value = \/"user\/")\npublic class UserDO {\n\n    \/**\n     * \u4e3b\u952e\n     *\/\n    @TableId(value = \/"id\/", type = IdType.AUTO)\n    private Long id;\n\n    \/**\n     * \u6635\u79f0\n     *\/\n    @TableField(\/"nickname\/")\n    private String nickname;\n\n    \/**\n     * \u771f\u5b9e\u59d3\u540d\n     *\/\n    private String realName;\n}<\/code><\/pre>\n
@TableName \u8868\u540d\u6ce8\u89e3\uff0c\u7528\u4e8e\u6807\u8bc6\u5b9e\u4f53\u7c7b\u5bf9\u5e94\u7684\u8868\u3002<\/p>\n
\u5176\u8bf4\u660e\u5982\u4e0b\uff0c\u5173\u4e8e\u8fd9\u4e9b\u4e66\u5199\uff0c\u5e38\u89c4\u60c5\u51b5\u57fa\u672c\u5f88\u5c11\u7528\u5230\uff0c\u4e0d\u505a\u591a\u4f59\u89e3\u91ca\u4e86\uff1a<\/p>\n
@Documented\n@Retention(RetentionPolicy.RUNTIME)\n@Target({ElementType.TYPE, ElementType.ANNOTATION_TYPE})\npublic @interface TableName {\n\n    \/**\n     * \u5b9e\u4f53\u5bf9\u5e94\u7684\u8868\u540d\n     *\/\n    String value() default \/"\/";\n\n    \/**\n     * schema\n     *\n     * @since 3.1.1\n     *\/\n    String schema() default \/"\/";\n\n    \/**\n     * \u662f\u5426\u4fdd\u6301\u4f7f\u7528\u5168\u5c40\u7684 tablePrefix \u7684\u503c\n     * <p> \u53ea\u751f\u6548\u4e8e \u65e2\u8bbe\u7f6e\u4e86\u5168\u5c40\u7684 tablePrefix \u4e5f\u8bbe\u7f6e\u4e86\u4e0a\u9762 {@link #value()} \u7684\u503c <\/p>\n     * <li> \u5982\u679c\u662f false , \u5168\u5c40\u7684 tablePrefix \u4e0d\u751f\u6548 <\/li>\n     *\n     * @since 3.1.1\n     *\/\n    boolean keepGlobalPrefix() default false;\n\n    \/**\n     * \u5b9e\u4f53\u6620\u5c04\u7ed3\u679c\u96c6,\n     * \u53ea\u751f\u6548\u4e0e mp \u81ea\u52a8\u6ce8\u5165\u7684 method\n     *\/\n    String resultMap() default \/"\/";\n\n    \/**\n     * \u662f\u5426\u81ea\u52a8\u6784\u5efa resultMap \u5e76\u4f7f\u7528,\n     * \u53ea\u751f\u6548\u4e0e mp \u81ea\u52a8\u6ce8\u5165\u7684 method,\n     * \u5982\u679c\u8bbe\u7f6e resultMap \u5219\u4e0d\u4f1a\u8fdb\u884c resultMap \u7684\u81ea\u52a8\u6784\u5efa\u5e76\u6ce8\u5165,\n     * \u53ea\u9002\u5408\u4e2a\u522b\u5b57\u6bb5 \u8bbe\u7f6e\u4e86 typeHandler \u6216 jdbcType \u7684\u60c5\u51b5\n     *\n     * @since 3.1.2\n     *\/\n    boolean autoResultMap() default false;\n\n    \/**\n     * \u9700\u8981\u6392\u9664\u7684\u5c5e\u6027\u540d\n     *\n     * @since 3.3.1\n     *\/\n    String[] excludeProperty() default {};\n}<\/code><\/pre>\n
@TableId \u4e3b\u952e\u6ce8\u89e3<\/p>\n
\u770b\u770b\u5176\u6e90\u7801\uff1a<\/p>\n
@Documented\n@Retention(RetentionPolicy.RUNTIME)\n@Target({ElementType.FIELD, ElementType.ANNOTATION_TYPE})\npublic @interface TableId {\n\n    \/**\n     * \u5b57\u6bb5\u503c\uff08\u9a7c\u5cf0\u547d\u540d\u65b9\u5f0f\uff0c\u8be5\u503c\u53ef\u65e0\uff09\n     *\/\n    String value() default \/"\/";\n\n    \/**\n     * \u4e3b\u952eID\n     * {@link IdType}\n     *\/\n    IdType type() default IdType.NONE;\n}<\/code><\/pre>\n
\u5176\u4e2d IdType \u5f88\u91cd\u8981\uff1a<\/p>\n\n\n\n\n\n\n\n\n\n
\u540d\u79f0<\/th>\n\u63cf\u8ff0<\/th>\n<\/tr>\n<\/thead>\n
AUTO<\/td>\n\u6570\u636e\u5e93\u81ea\u589e ID<\/td>\n<\/tr>\n
NONE<\/td>\n\u8be5\u7c7b\u578b\u4e3a\u672a\u8bbe\u7f6e\u4e3b\u952e\u7c7b\u578b(\u6ce8\u89e3\u91cc\u7b49\u4e8e\u8ddf\u968f\u5168\u5c40,\u5168\u5c40\u91cc\u7ea6\u7b49\u4e8e INPUT)<\/td>\n<\/tr>\n
INPUT<\/td>\n\u7528\u6237\u81ea\u5df1\u8bbe\u7f6e\u7684 ID<\/td>\n<\/tr>\n
ASSIGN_ID<\/td>\n\u5f53\u7528\u6237\u4f20\u5165\u4e3a\u7a7a\u65f6\uff0c\u81ea\u52a8\u5206\u914d\u7c7b\u578b\u4e3a Number \u6216 String \u7684\u4e3b\u952e\uff08\u96ea\u82b1\u7b97\u6cd5\uff09<\/td>\n<\/tr>\n
ASSIGN_UUID<\/td>\n\u5f53\u7528\u6237\u4f20\u5165\u4e3a\u7a7a\u65f6\uff0c\u81ea\u52a8\u5206\u914d\u7c7b\u578b\u4e3a String \u7684\u4e3b\u952e<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n
@TableFiled \u8868\u5b57\u6bb5\u6807\u8bc6<\/p>\n
\u4e0b\u9762\u770b\u770b\u5176\u4e3b\u8981\u5e38\u7528\u5c5e\u6027\uff1a<\/p>\n\n\n\n\n\n\n\n
\u540d\u79f0<\/th>\n\u63cf\u8ff0<\/th>\n<\/tr>\n<\/thead>\n
value<\/td>\n\u6570\u636e\u5e93\u5b57\u6bb5\u540d<\/td>\n<\/tr>\n
condition<\/td>\n\u5b57\u6bb5  where<\/code> \u5b9e\u4f53\u67e5\u8be2\u6bd4\u8f83\u6761\u4ef6\uff0c\u901a\u8fc7SqlCondition<\/code>\u8bbe\u7f6e \u5982\u679c\u672a\u8bbe\u7f6e\u6761\u4ef6\uff0c\u5219\u6309\u7167\u6b63\u5e38\u76f8\u7b49\u6765\u67e5\u8be2 \u82e5\u8bbe\u7f6e\u5219\u6309\u7167\u4ee5\u4e0b\u89c4\u5219\uff1a \u7b49\u4e8e\uff1aEQUAL = "%s=#{%s}"<\/code>; \u4e0d\u7b49\u4e8e\uff1aNOT_EQUAL = "%s<>#{%s}";<\/code> \u5de6\u53f3\u6a21\u7cca\uff1aLIKE = "%s LIKE CONCAT('%%',#{%s},'%%')";<\/code> oracle \u5de6\u53f3\u6a21\u7cca ORACLE_LIKE = "%s LIKE CONCAT(CONCAT('%%',#{%s}),'%%')";<\/code> \u5de6\u6a21\u7cca\uff1aLIKE_LEFT = "%s LIKE CONCAT('%%',#{%s})";<\/code> \u53f3\u6a21\u7cca\uff1aLIKE_RIGHT = "%s LIKE CONCAT(#{%s},'%%')";<\/code><\/td>\n<\/tr>\n
fill<\/td>\n\u81ea\u52a8\u586b\u5145\u7b56\u7565\uff0c\u901a\u8fc7FieldFill<\/code>\u8bbe\u7f6e \u4e0d\u5904\u7406\uff1aFieldFill.DEFAULT \u63d2\u5165\u65f6\u586b\u5145\u5b57\u6bb5\uff1aFieldFill.INSERT \u66f4\u65b0\u65f6\u586b\u5145\u5b57\u6bb5\uff1aFieldFill.UPDATE \u63d2\u5165\u6216\u65b0\u589e\u65f6\u586b\u5145\u5b57\u6bb5\uff1aFieldFill.INSERT_UPDATE<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n
\u5173\u4e8e\u5176\u4ed6\u7684\u5c5e\u6027\uff0c\u6211\u4e0d\u592a\u63a8\u8350\u4f7f\u7528\uff0c\u7528\u5f97\u8d8a\u591a\uff0c\u8d8a\u5bb9\u6613\u8499\u5708\u3002\u53ef\u4ee5\u901a\u8fc7 wapper \u67e5\u8be2\u53bb\u8bbe\u7f6e\u3002<\/p>\n
2.2 CRUD<\/h3>\n
mybatis-plus \u5c01\u88c5\u597d\u4e86\u4e00\u6761\u63a5\u53e3\u4f9b\u6211\u4eec\u76f4\u63a5\u8c03\u7528\u3002\u5173\u4e8e\u5185\u90e8\u7684\u5177\u4f53\u65b9\u6cd5\uff0c\u5728\u4f7f\u7528\u65f6\u5019\u81ea\u5df1\u4f53\u4f1a\u5427\uff0c\u6b64\u5904\u4e0d\u5217\u4e3e\u4e86\u3002<\/p>\n
2.2.1 Service \u5c42 CRUD<\/h4>\n
\u6211\u4eec\u4f7f\u7528\u7684\u65f6\u5019\uff0c\u9700\u8981\u5728\u81ea\u5df1\u5b9a\u4e49\u7684 service \u63a5\u53e3\u5f53\u4e2d\u7ee7\u627fIService<\/code>\u63a5\u53e3\uff1a<\/p>\n
import com.baomidou.mybatisplus.extension.service.IService;\nimport com.wjbgn.user.entity.UserDO;\n\n\/**\n * @description\uff1a \u7528\u6237\u670d\u52a1\u63a5\u53e3\n * @author\uff1aweirx\n * @date\uff1a2022\/1\/17 15:02\n * @version\uff1a3.0\n *\/\npublic interface IUserService extends IService<UserDO> {\n}<\/code><\/pre>\n
\u540c\u65f6\u8981\u5728\u6211\u4eec\u7684\u63a5\u53e3\u5b9e\u73b0 impl \u5f53\u4e2d\u7ee7\u627fServiceImpl<\/code>\uff0c\u5b9e\u73b0\u81ea\u5df1\u7684\u63a5\u53e3\uff1a<\/p>\n
import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;\nimport com.wjbgn.user.entity.UserDO;\nimport com.wjbgn.user.mapper.UserMapper;\nimport com.wjbgn.user.service.IUserService;\n\n\/**\n * @description\uff1a \u7528\u6237\u63a5\u53e3\u5b9e\u73b0\n * @author\uff1aweirx\n * @date\uff1a2022\/1\/17 15:03\n * @version\uff1a3.0\n *\/\npublic class UserServiceImpl extends ServiceImpl<UserMapper, UserDO> implements IUserService {\n\n}<\/code><\/pre>\n
\u6240\u4ee5\u6211\u4eec\u7684<\/p>\n
2.2.2 Mapper \u5c42 CRUD<\/h4>\n
mybatis-plus \u5c06\u5e38\u7528\u7684 CRUD \u63a5\u53e3\u5c01\u88c5\u6210\u4e86BaseMapper<\/code>\u63a5\u53e3,\u6211\u4eec\u53ea\u9700\u8981\u5728\u81ea\u5df1\u7684 Mapper \u4e2d\u7ee7\u627f\u5b83\u5c31\u53ef\u4ee5\u4e86\uff1a<\/p>\n
\/**\n * @description\uff1a \u7528\u6237mapper\n * @author\uff1aweirx\n * @date\uff1a2022\/1\/17 14:55\n * @version\uff1a3.0\n *\/\n@Mapper\npublic interface UserMapper extends BaseMapper<UserDO> {\n}<\/code><\/pre>\n
2.3 \u5206\u9875<\/h3>\n
\u4f7f\u7528\u5206\u9875\u8bdd\u9700\u8981\u589e\u52a0\u5206\u9875\u63d2\u4ef6\u7684\u914d\u7f6e\uff1a<\/p>\n
import com.baomidou.mybatisplus.annotation.DbType;\nimport com.baomidou.mybatisplus.extension.plugins.MybatisPlusInterceptor;\nimport com.baomidou.mybatisplus.extension.plugins.inner.PaginationInnerInterceptor;\nimport org.mybatis.spring.annotation.MapperScan;\nimport org.springframework.context.annotation.Bean;\nimport org.springframework.context.annotation.Configuration;\n\n@Configuration\n@MapperScan(\/"com.wjbgn.*.mapper*\/")\npublic class MybatisPlusConfig {\n\n    @Bean\n    public MybatisPlusInterceptor mybatisPlusInterceptor() {\n        MybatisPlusInterceptor interceptor = new MybatisPlusInterceptor();\n        interceptor.addInnerInterceptor(new PaginationInnerInterceptor(DbType.MYSQL));\n        return interceptor;\n    }\n\n}<\/code><\/pre>\n
\u5982\u4e0a\u914d\u7f6e\u540e\uff0c\u6211\u4eec\u76f4\u63a5\u4f7f\u7528\u5206\u9875\u65b9\u6cd5\u5c31\u884c\u3002<\/p>\n
2.4 \u903b\u8f91\u5220\u9664\u914d\u7f6e<\/h3>\n
\u5f88\u591a\u60c5\u51b5\u4e0b\u6211\u4eec\u7684\u7cfb\u7edf\u90fd\u9700\u8981\u903b\u8f91\u5220\u9664\uff0c\u65b9\u4fbf\u6062\u590d\u67e5\u627e\u8bef\u5220\u9664\u7684\u6570\u636e\u3002<\/p>\n
\u901a\u8fc7 mybatis-plus \u53ef\u4ee5\u901a\u8fc7\u5168\u5c40\u914d\u7f6e\u7684\u65b9\u5f0f\uff0c\u800c\u4e0d\u9700\u8981\u518d\u53bb\u624b\u52a8\u5904\u7406\u3002\u9488\u5bf9\u66f4\u65b0\u548c\u67e5\u8be2\u64cd\u4f5c\u6709\u6548\uff0c\u65b0\u589e\u4e0d\u505a\u9650\u5236\u3002<\/p>\n
\u901a\u5e38\u4ee5\u6211\u7684\u4e60\u60ef\u903b\u8f91\u5220\u9664\u5b57\u6bb5\u901a\u5e38\u5b9a\u4e49\u4e3ais_delete<\/code>,\u5728\u5b9e\u4f53\u7c7b\u5f53\u4e2d\u5c31\u662fisDelete<\/code>\u3002\u90a3\u4e48\u5728\u914d\u7f6e\u6587\u4ef6\u4e2d\u5c31\u53ef\u4ee5\u6709\u5982\u4e0b\u7684\u914d\u7f6e\uff1a<\/p>\n
mybatis-plus:\n  global-config:\n    db-config:\n      logic-delete-field: isDelete # \u5168\u5c40\u903b\u8f91\u5220\u9664\u7684\u5b9e\u4f53\u5b57\u6bb5\u540d(since 3.3.0,\u914d\u7f6e\u540e\u53ef\u4ee5\u5ffd\u7565\u4e0d\u914d\u7f6e\u6b65\u9aa42)\n      logic-delete-value: 1 # \u903b\u8f91\u5df2\u5220\u9664\u503c(\u9ed8\u8ba4\u4e3a 1)\n      logic-not-delete-value: 0 # \u903b\u8f91\u672a\u5220\u9664\u503c(\u9ed8\u8ba4\u4e3a 0)<\/code><\/pre>\n
\u6216\u8005\u901a\u8fc7\u6ce8\u89e3@TableLogic<\/code><\/p>\n
@TableLogic\nprivate Integer isDelete;<\/code><\/pre>\n
2.5 \u901a\u7528\u679a\u4e3e\u914d\u7f6e<\/h3>\n
\u76f8\u4fe1\u540e\u7aef\u7684\u540c\u5b66\u90fd\u7ecf\u5386\u8fc7\u4e00\u4e2a\u60c5\u51b5\uff0c\u6bd4\u5982\u6027\u522b<\/code>\u8fd9\u4e2a\u5b57\u6bb5\uff0c\u5206\u522b\u503c\u548c\u540d\u79f0\u5bf9\u5e941\u7537<\/code>\u30012\u5973<\/code>,\u8fd9\u4e2a\u5b57\u6bb5\u5728\u6570\u636e\u5e93\u65f6\u662f\u6570\u503c\u7c7b\u578b\uff0c\u800c\u524d\u7aef\u5c55\u793a\u5219\u662f\u5c55\u793a\u5b57\u7b26\u4e32\u7684\u540d\u79f0\u3002\u6709\u51e0\u79cd\u5e38\u89c1\u5b9e\u73b0\u65b9\u6848\u5462\uff1f<\/p>\n
    \n
  • \u6570\u636e\u5e93\u67e5\u8be2 sql \u901a\u8fc7 case \u5224\u65ad\uff0c\u8fd4\u56de\u540d\u79f0\uff0c\u4ee5\u524d oracle \u7ecf\u5e38\u8fd9\u4e48\u505a<\/li>\n
  • \u6570\u636e\u5e93\u8fd4\u56de\u7684\u503c\uff0c\u91cd\u65b0\u904d\u5386\u8d4b\u503c\u8fdb\u53bb\uff0c\u8fd9\u65f6\u5019\u8fd8\u9700\u8981\u5224\u65ad\u8fd9\u4e2a\u503c\u5230\u5e95\u662f\u7537\u662f\u5973\u3002<\/li>\n
  • \u524d\u7aef\u5199\u6b7b\uff0c\u8fd4\u56de 1 \u5c31\u662f\u7537\uff0c\u8fd4\u56de 2 \u5c31\u662f\u5973\u3002<\/li>\n<\/ul>\n
    \u76f8\u4fe1\u65e0\u8bba\u54ea\u79cd\u65b9\u6cd5\u90fd\u6709\u5176\u7f3a\u70b9\uff0c\u6240\u4ee5\u6211\u4eec\u53ef\u4ee5\u4f7f\u7528 mybatis-plus \u63d0\u4f9b\u7684\u65b9\u5f0f\u3002\u6211\u4eec\u5728\u8fd4\u56de\u7ed9\u524d\u7aef\u65f6\uff1a<\/p>\n
      \n
    • \u53ea\u9700\u8981\u5728\u904d\u5386\u65f6 get \u8fd9\u4e2a\u679a\u4e3e\uff0c\u76f4\u63a5\u8d4b\u503c\u5176\u540d\u79f0\uff0c\u4e0d\u9700\u8981\u518d\u6b21\u5224\u65ad\u3002<\/li>\n
    • \u76f4\u63a5\u8fd4\u56de\u7ed9\u524d\u7aef\uff0c\u8ba9\u524d\u7aef\u53bb\u53bb\u679a\u4e3e\u7684 name<\/li>\n<\/ul>\n
      \u8fd9\u6837\u5927\u5bb6\u90fd\u4e0d\u9700\u8981\u5199\u6b7b\u8fd9\u4e2a\u503c\u3002<\/p>\n
      \u4e0b\u9762\u770b\u770b\u5982\u4f55\u5b9e\u73b0\u8fd9\u4e2a\u529f\u80fd\uff1a<\/p>\n
        \n
      • \u5174\u4e49\u679a\u4e3e\uff0c\u5b9e\u73b0 IEnum \u63a5\u53e3\uff1a<\/li>\n<\/ul>\n
        import com.baomidou.mybatisplus.annotation.IEnum;\nimport com.fasterxml.jackson.annotation.JsonFormat;\n\n\/**\n * @description\uff1a \u6027\u522b\u679a\u4e3e\n * @author\uff1aweirx\n * @date\uff1a2022\/1\/17 16:26\n * @version\uff1a3.0\n *\/\n@JsonFormat(shape = JsonFormat.Shape.OBJECT)\npublic enum SexEnum implements IEnum<Integer> {\n    MAN(1, \/"\u7537\/"),\n    WOMAN(2, \/"\u5973\/");\n    private Integer code;\n    private String name;\n\n    SexEnum(Integer code, String name) {\n        this.code = code;\n        this.name = name;\n    }\n\n    @Override\n    public Integer getValue() {\n        return code;\n    }\n\n    public String getName() {\n        return name;\n    }\n\n}<\/code><\/pre>\n
        @JsonFormat \u6ce8\u89e3\u4e3a\u4e86\u89e3\u51b3\u679a\u4e3e\u7c7b\u8fd4\u56de\u524d\u7aef\u53ea\u5c55\u793a\u6784\u9020\u5668\u540d\u79f0\u7684\u95ee\u9898\u3002<\/p>\n