{"id":716,"date":"2024-12-10T20:18:00","date_gmt":"2024-12-10T12:18:00","guid":{"rendered":"https:\/\/eve2333.top\/?p=716"},"modified":"2024-12-10T20:18:00","modified_gmt":"2024-12-10T12:18:00","slug":"%e9%9d%9e%e5%b8%b8%e7%ae%80%e5%8d%95%e5%ae%9e%e7%94%a8%e7%9a%84%e5%89%8d%e5%90%8e%e7%ab%af%e5%88%86%e7%a6%bb%e9%a1%b9%e7%9b%ae-%e4%bb%93%e5%ba%93%e7%ae%a1%e7%90%86%e7%b3%bb%e7%bb%9f%ef%bc%88springboot","status":"publish","type":"post","link":"https:\/\/eve2333.top\/?p=716","title":{"rendered":"\u975e\u5e38\u7b80\u5355\u5b9e\u7528\u7684\u524d\u540e\u7aef\u5206\u79bb\u9879\u76ee-\u4ed3\u5e93\u7ba1\u7406\u7cfb\u7edf\uff08Springboot+Vue\uff09part 1"},"content":{"rendered":"\n

\u4e00\u3001\u521b\u5efa\u540e\u7aef\u9879\u76ee<\/h1>\n\n\n\n

1. \u521b\u5efa\u6587\u4ef6\u5939spring_vue_wms
2. \u6253\u5f00\u8fd9\u4e2a\u6587\u4ef6\u5939
3. \u53f3\u952e\u70b9\u51fb\u521b\u5efa\u65b0\u6a21\u5757(springboot)
\u53f3\u952e\u6253\u5f00new module\uff0c\u9009\u62e9spring initializr<\/p>\n\n\n\n

\"\"
Develop tools\u9009\u62e9Lombok\uff0cweb\u9009\u62e9spring web\uff0csql\u9009\u62e9mysql\u3002\u521b\u5efaspring\u7684\u65f6\u5019\u8bb0\u5f97\u628agroud\u90a3\u5565\u6539\u6210Maven\uff0c\u4e3a\u4ec0\u4e48\u6211\u6ca1\u6709wms.iml\u6587\u4ef6<\/strong>\uff0c\u5220\u96644\u4e2a\u6587\u4ef6gitgnore,help.md,mvnw,mvnw.cmd<\/p>\n\n\n\n

\u53f3\u8fb9\u4e00\u680f\u5982\u679c\u6ca1\u6709maven\uff0c\u5c31ctrl+shift+a\uff0c\u9009\u62e9\u201c\u6dfb\u52a0\u4e3amaven\u9879\u76ee\u201d<\/p>\n\n\n\n

,pom.xml\u7b2c\u4e09\u5341\u516b\u884c\u4fee\u6539<\/p>\n\n\n\n

<dependency>\n            <groupId>com.mysql<\/groupId>\n            <artifactId>mysql-connector-j<\/artifactId>\n            <version>5.7.42<\/version>\n            <scope>runtime<\/scope>\n<\/dependency><\/code><\/pre>\n\n\n\n
\u7b2c\u516b\u884c\u6839\u636e\u81ea\u5df1\u539f\u4f5c\u8005\u662f2.7.1\u52302.6.7\uff0c\u672c\u6b21\u672c\u4eba\u4e0d\u4e0e\u4fee\u6539\uff0c\u8ba4\u4e3a\u8fd8\u662f3.3.5\uff0c\u52a0\u8f7d\u6ce1\u6cab\u6587\u4ef6\u7684\u83ab\u540d\u5176\u5999\u7684error<\/p>\n\n\n\n
<version>2.6.7<\/version><\/code><\/pre>\n\n\n\n
\u603b\u4e4bxml\u53d8\u6210\u5982\u4e0b<\/p>\n\n\n\n
<?xml version=\"1.0\" encoding=\"UTF-8\"?>\n<project xmlns=\"http:\/\/maven.apache.org\/POM\/4.0.0\" xmlns:xsi=\"http:\/\/www.w3.org\/2001\/XMLSchema-instance\"\n\txsi:schemaLocation=\"http:\/\/maven.apache.org\/POM\/4.0.0 https:\/\/maven.apache.org\/xsd\/maven-4.0.0.xsd\">\n\t<modelVersion>4.0.0<\/modelVersion>\n\t<parent>\n\t\t<groupId>org.springframework.boot<\/groupId>\n\t\t<artifactId>spring-boot-starter-parent<\/artifactId>\n\t\t<version>3.3.5<\/version>\n\t\t<relativePath\/> <!-- lookup parent from repository -->\n\t<\/parent>\n\t<groupId>com.wms<\/groupId>\n\t<artifactId>wms<\/artifactId>\n\t<version>0.0.1-SNAPSHOT<\/version>\n\t<name>wms<\/name>\n\t<description>wms<\/description>\n\t<url\/>\n\t<licenses>\n\t\t<license\/>\n\t<\/licenses>\n\t<developers>\n\t\t<developer\/>\n\t<\/developers>\n\t<scm>\n\t\t<connection\/>\n\t\t<developerConnection\/>\n\t\t<tag\/>\n\t\t<url\/>\n\t<\/scm>\n\t<properties>\n\t\t<java.version>23<\/java.version>\n\t<\/properties>\n\t<dependencies>\n\t\t<dependency>\n\t\t\t<groupId>org.springframework.boot<\/groupId>\n\t\t\t<artifactId>spring-boot-starter-web<\/artifactId>\n\t\t<\/dependency>\n\n\t\t<dependency>\n\t\t\t<groupId>com.mysql<\/groupId>\n\t\t\t<artifactId>mysql-connector-j<\/artifactId>\n\t\t\t<version>8.0.32<\/version>\n\t\t\t<scope>runtime<\/scope>\n\t\t<\/dependency>\n\t\t<dependency>\n\t\t\t<groupId>org.projectlombok<\/groupId>\n\t\t\t<artifactId>lombok<\/artifactId>\n\t\t\t<optional>true<\/optional>\n\t\t<\/dependency>\n\t\t<dependency>\n\t\t\t<groupId>org.springframework.boot<\/groupId>\n\t\t\t<artifactId>spring-boot-starter-test<\/artifactId>\n\t\t\t<version>3.3.5<\/version>\n\t\t\t<scope>test<\/scope>\n\t\t<\/dependency>\n\t<\/dependencies>\n\n\t<build>\n\t\t<plugins>\n\t\t\t<plugin>\n\t\t\t\t<groupId>org.springframework.boot<\/groupId>\n\t\t\t\t<artifactId>spring-boot-maven-plugin<\/artifactId>\n\t\t\t\t<configuration>\n\t\t\t\t\t<excludes>\n\t\t\t\t\t\t<exclude>\n\t\t\t\t\t\t\t<groupId>org.projectlombok<\/groupId>\n\t\t\t\t\t\t\t<artifactId>lombok<\/artifactId>\n\t\t\t\t\t\t<\/exclude>\n\t\t\t\t\t<\/excludes>\n\t\t\t\t<\/configuration>\n\t\t\t<\/plugin>\n\t\t<\/plugins>\n\t<\/build>\n\n<\/project>\n<\/code><\/pre>\n\n\n\n
\u00a0\u9879\u76ee\u76ee\u5f55\u5982\u4e0b<\/strong>
\"\"<\/p>\n\n\n\n
 4. \u521b\u5efa\u6d4b\u8bd5\u7c7b\u5e76\u6d4b\u8bd5\uff0c\u5728wms\/src\/java\/com.wms\u6dfb\u52a0\u8f6f\u4ef6\u5305controller\uff0c\u65b0\u5efa\u4e00\u4e2aHelloController.java \u7c7b<\/p>\n\n\n\n
package com.wms.controller;\n\nimport org.springframework.web.bind.annotation.GetMapping;\nimport org.springframework.web.bind.annotation.RestController;\n\n@RestController\npublic class HelloController {\n    @GetMapping\n    public String hello(){\n        return \"Hello World\";\/\/\u9009\u62e9\u67e5\u8be2\u9879via\n    }\n}<\/code><\/pre>\n\n\n\n
\u65e0\u6548\u7684\u53d1\u884c\u7248\u672c\u542f\u52a8\u5931\u8d25\uff1a\u70b9\u53f3\u4e0a\u89d2\u7684\u8bbe\u7f6e-\u9879\u76ee\u8bbe\u7f6e-\u9009\u62e91.8\u3001sdk\u9ed8\u8ba4\u503c\uff0c\u5de6\u4e0a\u89d2\u6253\u5f00\u914d\u7f6e\u641cJava Compiler\u9009\u62e9\u9879\u76ee\u7f16\u8f91\u5668\u7248\u672c8<\/p>\n\n\n\n
\u8fd0\u884c\u6210\u529f\uff01\uff01\uff01\u6253\u5f00local8080\u53ef\u4ee5\u770b\u89c1\u7f51\u9875\u91cc\u9762hello\u7684\u8bdd\"\"<\/p>\n\n\n\n
\u53ef\u4ee5\u8be6\u7ec6\u770b\u4e00\u770b\u89c6\u9891\u4f5c\u8005\u7684\u90e8\u5206\u5e2e\u52a9 \u6211\u4e5f\u505a\u4e86CSDN\u521b\u4f5c\u4e2d\u5fc3<\/a><\/p>\n\n\n\n
\u53cb\u60c5\u63d0\u793a\uff1a\u5b66\u4e60\u6b64\u9879\u76ee\u53ef\u80fd\u9700\u8981\u4e00\u70b9\u70b9\u529f\u5e95<\/s><\/p>\n\n\n\n
\u4e8c\u3001\u52a0\u5165mybatis\u2014plus\u652f\u6301<\/h1>\n\n\n\n
MyBatis-Plus \ud83d\ude80 \u4e3a\u7b80\u5316\u5f00\u53d1\u800c\u751f<\/a><\/p>\n\n\n\n
1. \u5728xml\u4e2d\u52a0\u5165\u4f9d\u8d56\u4ee3\u7801<\/p>\n\n\n\n
<dependency>\n    <groupId>com.baomidou<\/groupId>\n    <artifactId>mybatis-plus-boot-starter<\/artifactId> \n    <version>3.4.1<\/version>\n<\/dependency><\/code><\/pre>\n\n\n\n
\u6700\u65b0\u7248\u5df2\u7ecf\u8fbe\u5230\u4e863.5.9 \u7248\u672c,\u53f3\u8fb9\u7684maven\u4e2d\u70b9\u51fb\u5237\u65b0\u7b49\u5f855s\u5373\u53ef<\/p>\n\n\n\n
2.\u521b\u5efa\u6570\u636e\u5e93\u5b9e\u4f8b\u3001\u521b\u5efa\u7528\u6237\u8868\u3001\u63d2\u5165\u9ed8\u8ba4\u6570\u636e<\/p>\n\n\n\n
create table user\n(\n    id        int auto_increment comment'\u4e3b\u952e' \n        primary key,\n    no        varchar(20)            null comment'\u8d26\u53f7', \n    name      varchar(100)           not null comment'\u540d\u5b57',\n    password  varchar(20)            not null comment'\u5bc6\u7801',\n    age       int                    null,\n    sex       int                    null comment '\u6027\u522b',\n    phone     varchar(20)            null comment '\u7535\u8bdd', \n    role_id   int                    null comment '\u89d2\u8272 0\u8d85\u7ea7\u7ba1\u7406\u5458,1\u7ba1\u7406\u5458,2\u666e\u901a\u8d26\u53f7',\n    isvalid   varchar(4) default 'Y' null comment '\u662f\u5426\u6709\u6548\uff0cY\u6709\u6548\uff0c\u5176\u4ed6\u65e0\u6548'\n)\n\n    charset utf8; \n<\/code><\/pre>\n\n\n\n
\u9f20\u6807\u53f3\u952e\u70b9\u51fbmysql,\u65b0\u5efa\u6570\u636e\u5e93,
\"\"
wms02 \u51fa\u73b0\u4e00\u4e2a\u65b0\u5efa\u67e5\u8be2\uff0c\u5c06\u4e0a\u8ff0\u4ee3\u7801\u590d\u5236\u5176\u4e2d,\u70b9\u51fb\u8fd0\u884c<\/p>\n\n\n\n\n\n

\u5de6\u680f\u9009\u62e9\u8868\uff0c\u51fa\u73b0user\u00a0\u00a0\u200b<\/p>\n\n\n\n\n\n
id<\/td>no<\/td>name<\/td>password<\/td>age<\/td>sex<\/td>phone<\/td>role_id<\/td>isvalid<\/td><\/tr>
1<\/td>sa<\/td>\u8d85\u7ea7\u7ba1\u7406\u5458<\/td>123<\/td>18<\/td>1<\/td>114514<\/td>0<\/td>Y<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n
\u70b9\u51fb\u4e0b\u65b9\u7684\u5c0f\u5bf9\u53f7\u4fdd\u5b58\uff0c\u53ef\u4ee5\u5237\u65b0\u4e00\u4e0b <\/p>\n\n\n\n
\u56de\u5230idea\uff0cresources\u4e2d\u81ea\u52a8\u914d\u7f6eapplication.properties,\u6539\u4e3ayml\u6587\u4ef6 ( \u5176\u5b9e\u4e0d\u6539\u4e5f\u65e0\u6240\u8c13<\/p>\n\n\n\n
 3.yml\u6587\u4ef6\u7684\u914d\u7f6e
\u7aef\u53e3\u548c\u6570\u636e\u6e90\u7684\u914d\u7f6e\uff0c\u6839\u636e\u81ea\u5df1\u7684mysql\u6539\u7aef\u53e3\u53f7(\u6211\u7684\u5c31\u8fd93306-- 13306
\u4e0b\u65b9\u7b2c\u4e03\u884cURL\u7f29\u8fdb\u5f88\u91cd\u8981 url\u7b49\u914d\u7f6e\u5e94\u7f29\u8fdb\u5728datasource\u4e0b\uff0c\u5426\u5219\u4f1a\u62a5\u9519  ; mysql8\u7684\u8bdd\u5728jdbc\u524d\u52a0cj.<\/p>\n\n\n\n
\nserver:\n  port:\n    8090\n\nspring:\n  datasource:\n    url: jdbc:mysql:\/\/localhost:13306\/wms02?useUnicode=true&characterEncoding=utf-8&useSSL=false&serverTimezone=GMT%2B8\n    driver-class-name: com.mysql.jdbc.Driver\n    username: root\n    password: root<\/code><\/pre>\n\n\n\n
<\/p>\n\n\n\n
\u00a0\u5e76\u4e14idea\u4e0emysql\u8fde\u63a5\uff0c\u6709\u4eba\u8bf4\u5199\u6210com.mysql.cj.jdbc.Driver\u00a0 \u00a0error\u7684<\/s>
\"\"<\/p>\n\n\n\n
\u63a5\u4e0b\u6765\u65b0\u5efa\u591a\u4e2a\u6587\u4ef6
\"\"<\/p>\n\n\n\n
 User.java<\/p>\n\n\n\n
package com.wms.entity;\n\nimport com.baomidou.mybatisplus.annotation.TableField;\nimport lombok. Data;\n\n@Data\npublic class User {\n    private int id;\n    private String no;\n    private String name;\n    private String password;\n    private int sex;\n    private int roleId;\n    private String phone;\n    @TableField(\"isvalid\")\n    private String isValid;\n}<\/code><\/pre>\n\n\n\n
UserMapper.java<\/p>\n\n\n\n
package com.wms.mapper;\n\nimport com.baomidou.mybatisplus.core.mapper.BaseMapper;\nimport com.wms. entity.User;\nimport org.apache.ibatis.annotations. Mapper;\n\n@Mapper\npublic interface UserMapper extends BaseMapper<User> {}<\/code><\/pre>\n\n\n\n
 UserService.java<\/p>\n\n\n\n
package com.wms.service;\n\nimport com.baomidou.mybatisplus.extension.service.IService;\nimport com.wms.entity.User;\n\npublic interface UserService extends IService<User>{}<\/code><\/pre>\n\n\n\n
 UserServiceImpl.java<\/p>\n\n\n\n
package com.wms.service.impl;\n\nimport com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;\nimport com.wms.entity.User;\nimport com.wms.mapper.UserMapper;\nimport com.wms.service.UserService;\nimport org. springframework. stereotype. Service;\n\n@Service\npublic class UserServiceImpl extends ServiceImpl<UserMapper, User> implements UserService {\n\n}<\/code><\/pre>\n\n\n\n
service\u7c7b\u5b9a\u4e49\u63a5\u53e3,serviceImpl\u5bf9\u63a5\u53e3\u51fd\u6570\u8fdb\u884c\u5b9e\u73b0<\/p>\n\n\n\n
\u5728hellocontroller.java\u4e2d\u6682\u4e14\u4fee\u6539\u7528\u4e00\u4e0blist<\/p>\n\n\n\n
package com.wms.controller;\n\nimport com.wms.entity.User;\nimport com.wms.service.UserService;\nimport org.springframework.beans.factory.annotation.Autowired;\nimport org.springframework.web.bind.annotation.GetMapping;\nimport org.springframework.web.bind.annotation.RestController;\n\nimport java.util.List;\n\n@RestController\npublic class HelloController {\n    @GetMapping\n    public String hello() {\n        return \"hello wms\";\n    }\n\n    @Autowired\n    private UserService userService;\n\n    @GetMapping(\"\/list\")\n    public List<User> list() {\n        return  userService.list();\n    }\n}<\/code><\/pre>\n\n\n\n
\u62a5\u9519\u4e86\uff01\uff01idea\u662f2024.1\uff0c\u95ee\u9898\u5728\u4e8emabayis.plus\u7684\u4f9d\u8d56\u8981\u6539mybatis-plus-spring-boot3-starter,\u7248\u672c\u6539\u62103.5.7\u3002\u89c6\u9891\u91cc\u7684boot\u6539\u6210\u4e86spring-boot3\uff0c\u4fee\u6539\u4f60\u7684pom.xml\u5e76\u4e14\u5237\u65b0<\/p>\n\n\n\n
<dependency>\n    <groupId>com.baomidou<\/groupId>\n    <artifactId>mybatis-plus-spring-boot3-starter<\/artifactId>\n    <version>3.5.7<\/version>\n<\/dependency><\/code><\/pre>\n\n\n\n
\u6210\u529f\u8fd0\u884c!!!\u5c3d\u7ba1\u62a5\u544a\u6709\u9519\u8bef
\"\"<\/p>\n\n\n\n\n\n
 \u6839\u636e\u4f60\u63d0\u4f9b\u7684\u65e5\u5fd7\u4fe1\u606f\uff0c\u5e94\u7528\u7a0b\u5e8f\u5df2\u7ecf\u6210\u529f\u542f\u52a8\uff0c\u5e76\u4e14Tomcat\u670d\u52a1\u5668\u6b63\u57288080\u7aef\u53e3\u4e0a\u8fd0\u884c\u3002\u4f60\u770b\u5230\u7684\u201c\u7ea2\u8272\u62a5\u544a\u201d\u53ef\u80fd\u662f\u6307\u65e5\u5fd7\u4e2d\u7684\u8b66\u544a\u4fe1\u606f\u3002\u8fd9\u4e9b\u8b66\u544a\u4fe1\u606f\u901a\u5e38\u4e0d\u4f1a\u963b\u6b62\u5e94\u7528\u7a0b\u5e8f\u542f\u52a8\uff0c\u4f46\u5b83\u4eec\u6307\u51fa\u4e86\u4e00\u4e9b\u53ef\u80fd\u7684\u95ee\u9898\u6216\u6700\u4f73\u5b9e\u8df5\u3002<\/p>\n\n\n\n
\u4ee5\u4e0b\u662f\u4f60\u65e5\u5fd7\u4e2d\u7684\u4e24\u4e2a\u8b66\u544a\uff1a<\/p>\n\n\n\n
1. **MySQL\u9a71\u52a8\u7c7b\u52a0\u8f7d\u8b66\u544a**\uff1a<\/p>\n\n\n\n
   Loading class `com.mysql.jdbc.Driver'. This is deprecated. The new driver class is `com.mysql.cj.jdbc.Driver'. The driver is automatically registered via the SPI and manual loading of the driver class is generally unnecessary.\n<\/code><\/pre>\n\n\n\n
 \u8fd9\u4e2a\u8b66\u544a\u662f\u56e0\u4e3a\u4f60\u7684\u914d\u7f6e\u4e2d\u53ef\u80fd\u8fd8\u5728\u4f7f\u7528\u65e7\u7684MySQL\u9a71\u52a8\u7c7b`com.mysql.jdbc.Driver`\uff0c\u800c\u63a8\u8350\u4f7f\u7528\u7684\u662f\u65b0\u7684\u9a71\u52a8\u7c7b`com.mysql.cj.jdbc.Driver`\u3002\u8fd9\u4e2a\u8b66\u544a\u544a\u8bc9\u4f60\uff0c\u65e7\u7684\u9a71\u52a8\u7c7b\u5df2\u7ecf\u88ab\u5f03\u7528\uff0c\u800c\u4e14\u901a\u5e38\u60c5\u51b5\u4e0b\uff0c\u4e0d\u9700\u8981\u624b\u52a8\u52a0\u8f7d\u9a71\u52a8\u7c7b\uff0c\u56e0\u4e3aJDBC\u9a71\u52a8\u4f1a\u901a\u8fc7SPI\uff08Service Provider Interface\uff09\u673a\u5236\u81ea\u52a8\u88ab\u6ce8\u518c\u3002<\/p>\n\n\n\n
   \u8981\u89e3\u51b3\u8fd9\u4e2a\u95ee\u9898\uff0c\u4f60\u53ef\u4ee5\u66f4\u65b0\u4f60\u7684\u6570\u636e\u5e93\u8fde\u63a5\u914d\u7f6e\uff0c\u4f7f\u7528\u65b0\u7684\u9a71\u52a8\u7c7b\u3002\u5982\u679c\u4f60\u4f7f\u7528\u7684\u662f`application.properties`\u6216`application.yml`\u6587\u4ef6\uff0c\u786e\u4fdd\u4f60\u7684\u914d\u7f6e\u5982\u4e0b\u6240\u793a\uff1a<\/p>\n\n\n\n
\nserver:\n  port: 8090\n\nspring:\n  datasource:\n    url: jdbc:mysql:\/\/localhost:13306\/wms02?useUnicode=true&characterEncoding=utf-8&useSSL=false&serverTimezone=GMT%2B8\n    driver-class-name: com.mysql.cj.jdbc.Driver\n    username: root\n    password: root<\/code><\/pre>\n\n\n\n
2. **\u4e3b\u952e\u7c7b\u578b\u8b66\u544a**\uff1a
   This primary key of \"id\" is primitive !\u4e0d\u5efa\u8bae\u5982\u6b64\u8bf7\u4f7f\u7528\u5305\u88c5\u7c7b in Class: \"com.wms.entity.User\"
   \u8fd9\u4e2a\u8b66\u544a\u662fMyBatis Plus\u53d1\u51fa\u7684\uff0c\u5b83\u5efa\u8bae\u4f60\u7684\u4e3b\u952e\u7c7b\u578b\u5e94\u8be5\u4f7f\u7528\u5305\u88c5\u7c7b\uff08\u5982`Integer`\u3001`Long`\u7b49\uff09\uff0c\u800c\u4e0d\u662f\u539f\u59cb\u7c7b\u578b\uff08\u5982`int`\u3001`long`\u7b49\uff09\u3002\u8fd9\u662f\u56e0\u4e3a\u5728\u67d0\u4e9b\u60c5\u51b5\u4e0b\uff0c\u539f\u59cb\u7c7b\u578b\u53ef\u80fd\u4f1a\u5f15\u8d77\u95ee\u9898\uff0c\u6bd4\u5982\u5f53\u4e3b\u952e\u4e3a0\u6216\u8d1f\u6570\u65f6\u3002<\/p>\n\n\n\n
   \u8981\u89e3\u51b3\u8fd9\u4e2a\u95ee\u9898\uff0c\u4f60\u9700\u8981\u68c0\u67e5\u4f60\u7684`User`\u5b9e\u4f53\u7c7b\uff0c\u5e76\u786e\u4fdd`id`\u5b57\u6bb5\u4f7f\u7528\u7684\u662f\u5305\u88c5\u7c7b\uff0c\u4f8b\u5982\uff1a<\/p>\n\n\n\n
   public class User {\n       private Integer id; \/\/ \u4f7f\u7528Integer\u800c\u4e0d\u662fint\n       \/\/ \u5176\u4ed6\u5b57\u6bb5\u548c\u65b9\u6cd5\n   }<\/code><\/pre>\n\n\n\n
\u7ee7\u7eed\u6784\u5efa\u5176\u4ed6\u65b9\u6cd5\u5982add\u7b49,
HelloController.java<\/p>\n\n\n\n
package com.wms.controller;\n\nimport com.wms.entity.User;\nimport com.wms.service.UserService;\nimport org.springframework.beans.factory.annotation.Autowired;\nimport org.springframework.web.bind.annotation.GetMapping;\nimport org.springframework.web.bind.annotation.RestController;\n\nimport java.util.List;\n\n@RestController\npublic class HelloController {\n    @GetMapping\n    public String hello() {\n        return \"hello wms\";\n    }\n\n    @Autowired\n    private UserService userService;\n\n    @GetMapping(\"\/list\")\n    public List<User> list() {\n        \/\/return  userService.list();\n        return userService.listAll();\n    }\n}<\/code><\/pre>\n\n\n\n
UserServiceImpl.java<\/p>\n\n\n\n
package com.wms.service.impl;\n\nimport com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;\nimport com.wms.entity.User;\nimport com.wms.mapper.UserMapper;\nimport com.wms.service.UserService;\nimport org.springframework.stereotype.Service;\n\nimport java.util.List;\n\n@Service\npublic class UserServiceImpl extends ServiceImpl<UserMapper, User> implements UserService {\n\n\n    private UserMapper userMapper;\n    @Override\n    public List<User> listAll(){\n        return  userMapper.listAll();\n    }\n}<\/code><\/pre>\n\n\n\n
UserMapper.java<\/p>\n\n\n\n
package com.wms. mapper;\n\nimport com.baomidou.mybatisplus.core.mapper.BaseMapper;\nimport com.wms. entity.User;\nimport org.apache.ibatis.annotations.Mapper;\n\nimport java.util.List;\n\n@Mapper\npublic interface UserMapper extends BaseMapper<User> {\n    List<User> listAll();\n}<\/code><\/pre>\n\n\n\n
UserService.java<\/p>\n\n\n\n
package com.wms.service;\n\nimport com.baomidou.mybatisplus.extension.service.IService;\nimport com.wms.entity.User;\n\nimport java.util.List;\n\npublic interface UserService extends IService<User>{\n    List<User> listAll();\n}<\/code><\/pre>\n\n\n\n
mybatis---plus\u539f\u6765\u4e0d\u652f\u6301\u8fd9\u4e2a,\u9700\u8981\u4f60\u6765\u6dfb\u52a0\u914d\u7f6exml<\/p>\n\n\n\n
\u6211\u4eec\u5728resource\u4e2d\u65b0\u5efa\u6587\u4ef6\u5939mapper,\u65b0\u5efa\u6587\u4ef6UserMapper.xml<\/p>\n\n\n\n
<?xml version=\"1.0\" encoding=\"UTF-8\"?>\n<!DOCTYPE mapper PUBLIC \"-\/\/mybatis.org\/\/DTD Mapper 3.0\/\/EN\"\n        \"http:\/\/mybatis.org\/dtd\/mybatis-3-mapper.dtd\">\n<mapper namespace=\"com.wms.mapper.UserMapper\">\n    <select id=\"listAll\" resultType=\"com.wms.entity.User\">\n        select * from  user\n    <\/select>\n<\/mapper><\/code><\/pre>\n\n\n\n
\"\"<\/figure>\n\n\n\n
\u53ef\u4ee5\u8fd0\u884c \u5e76\u57288090\u4e2d\u663e\u793a \u200b<\/p>\n\n\n\n
 \u4e09\u3001\u4f7f\u7528\u4ee3\u7801\u751f\u6210\u5668\u751f\u6210\u4ee3\u7801<\/h1>\n\n\n\n
\u53ef\u4ee5\u76f4\u63a5\u4e0b\u8f7d\u63d2\u4ef6\uff0c\u5728\u914d\u7f6e\u7684\u65f6\u5019\u76f4\u63a5\u52fe\u9009\u90a3\u4e2a\u914d\u7f6e\uff0c\u4f1a\u5e2e\u4f60\u4e0b\u597d\u7684<\/p>\n\n\n\n
<dependency>\n    <groupId>com.baomidou<\/groupId>\n    <artifactId>mybatis-plus-generator<\/artifactId> \n    <version>3.4.1<\/version>\n<\/dependency>\n<dependency>\n    <groupId>org.freemarker<\/groupId> \n    <artifactId>freemarker<\/artifactId>                                 \n    <version>2.3.30<\/version>\n<\/dependency> \n<dependency>\n    <groupId>com.spring4all<\/groupId>\n    <artifactId>spring-boot-starter-swagger<\/artifactId> \n    <version>1.5.1.RELEASE<\/version>\n<\/dependency> \n<\/code><\/pre>\n\n\n\n
\u5148\u5728pom.xml\u4e2d\u6dfb\u52a0\u4f9d\u8d56\u5e76\u5237\u65b0maven<\/p>\n\n\n\n
\u5728com.wms\u4e0b\u65b0\u5efa\u8f6f\u4ef6\u5305common,\u4e0b\u5c5eCodeGenerartor.java<\/p>\n\n\n\n
package com.wms.common;\nimport com.baomidou.mybatisplus.core.exceptions.MybatisPlusException;\nimport com.baomidou.mybatisplus.core.toolkit.StringPool;\nimport com.baomidou.mybatisplus.core.toolkit.StringUtils;\nimport com.baomidou.mybatisplus.generator.AutoGenerator;\nimport com.baomidou.mybatisplus.generator.InjectionConfig;\nimport com.baomidou.mybatisplus.generator.config.*;\nimport com.baomidou.mybatisplus.generator.config.po.TableInfo;\nimport com.baomidou.mybatisplus.generator.config.rules.NamingStrategy;\nimport com.baomidou.mybatisplus.generator.engine.FreemarkerTemplateEngine;\nimport java.util.ArrayList;\nimport java.util.List;\nimport java.util.Scanner;\npublic class CodeGenerator {\n    \/**\n     * <p>\n     *\n     \u8bfb\u53d6\u63a7\u5236\u53f0\u5185\u5bb9\n     * <\/p>\n     *\/\n    public static String scanner(String tip) {\n        Scanner scanner = new Scanner(System.in);\n        StringBuilder help = new StringBuilder();\n        help.append(\"\u8bf7\u8f93\u2f0a\" + tip + \"\uff1a\");\n        System.out.println(help.toString());\n        if (scanner.hasNext()) {\n            String ipt = scanner.next();\n            if (StringUtils.isNotBlank(ipt)) {\n                return ipt;\n            }\n        }\n        throw new MybatisPlusException(\"\u8bf7\u8f93\u2f0a\u6b63\u786e\u7684\" + tip + \"\uff01\");\n    }\n    \/**\n     *\n     \u64cd\u4f5c\u6b65\u9aa4\uff1a\n     *  1.\u4fee\u6539\u6570\u636e\u6e90\u5305\u62ec\u5730\u5740\u5bc6\u7801\u4fe1\u606f\uff0c\u5bf9\u5e94\u4ee3\u7801\u6807\u8bb0\uff1a\u2f00\u3001 \u4e0b\u540c\n     *  2.\u6a21\u5757\u914d\u7f6e\uff0c\u53ef\u4ee5\u4fee\u6539\u5305\u540d\n     *  3.\u4fee\u6539\u6a21\u677f\uff08\u8fd9\u6b65\u53ef\u5ffd\u7565\uff09\n     *  @param args\n     *\/\n    public static void main(String[] args) {\n        \/\/\u4ee3\u7801\u2f63\u6210\u5668\n        AutoGenerator mpg = new AutoGenerator();\n        \/\/\u5168\u5c40\u914d\u7f6e\n        GlobalConfig gc = new GlobalConfig();\n        String projectPath = System.getProperty(\"user.dir\")+\"\/wms\";\/\/\u5730\u5740\n        gc.setOutputDir(projectPath + \"\/src\/main\/java\");\n        gc.setAuthor(\"wms\");\/\/\u4f5c\u8005\n        gc.setOpen(false);\n        gc.setSwagger2(true); \/\/\u5b9e\u4f53\u5c5e\u6027 Swagger2 \u6ce8\u89e3\n        gc.setBaseResultMap(true);\/\/ XML ResultMap\n        gc.setBaseColumnList(true);\/\/ XML columList\n        \/\/\u53bb\u6389service\u63a5\u2f1d\u2fb8\u5b57\u2e9f\u7684I, \u5982DO\u4e3aUser\u5219\u53ebUserService\n        gc.setServiceName(\"%sService\");\n        mpg.setGlobalConfig(gc);\n        \/\/\u6570\u636e\u6e90\u914d\u7f6e\u2f00\u3001\u4fee\u6539\u6570\u636e\u6e90\n        DataSourceConfig dsc = new DataSourceConfig();\n        \/\/\n        dsc.setUrl(\"jdbc:mysql:\/\/localhost:13306\/wms02?useUnicode=true&characterEncoding=UTF8&useSSL=false\");\n                \/\/ dsc.setSchemaName(\"public\");\n                dsc.setDriverName(\"com.mysql.jdbc.Driver\");\n        dsc.setUsername(\"root\");\n        dsc.setPassword(\"root\");\n        mpg.setDataSource(dsc);\n        \/\/\u5305\u914d\u7f6e\n        PackageConfig pc = new PackageConfig();\n        \/\/pc.setModuleName(scanner(\"\u6a21\u5757\u540d\"));\n        \/\/ \u2f06\u3001\u6a21\u5757\u914d\u7f6e\n        pc.setParent(\"com.wms\")\n                .setEntity(\"entity\")\n                .setMapper(\"mapper\")\n                .setService(\"service\")\n                .setServiceImpl(\"service.impl\")\n                .setController(\"controller\");\n        mpg.setPackageInfo(pc);\n        \/\/ \u2f83\u5b9a\u4e49\u914d\u7f6e\n        InjectionConfig cfg = new InjectionConfig() {\n            @Override\n            public void initMap() {\n                \/\/ to do nothing\n            }\n        };\n        \/\/\u5982\u679c\u6a21\u677f\u5f15\u64ce\u662f freemarker\n        String templatePath = \"templates\/mapper.xml.ftl\";\n        \/\/\u5982\u679c\u6a21\u677f\u5f15\u64ce\u662f velocity\n        \/\/ String templatePath = \"\/templates\/mapper.xml.vm\";\n        \/\/ \u2f83\u5b9a\u4e49\u8f93\u51fa\u914d\u7f6e\n        List<FileOutConfig> focList = new ArrayList<>();\n        \/\/ \u2f83\u5b9a\u4e49\u914d\u7f6e\u4f1a\u88ab\u4f18\u5148\u8f93\u51fa\n        focList.add(new FileOutConfig(templatePath) {\n            @Override\n            public String outputFile(TableInfo tableInfo) {\n                \/\/ \u2f83\u5b9a\u4e49\u8f93\u51fa\u2f42\u4ef6\u540d \uff0c \u5982\u679c\u4f60 Entity \u8bbe\u7f6e\u4e86\u524d\u540e\u7f00\u3001\u6b64\u5904\u6ce8\u610f xml \u7684\u540d\u79f0\u4f1a\u8ddf\u7740\u53d1\u2f63\u53d8\u5316\uff01\uff01\n                return projectPath + \"\/src\/main\/resources\/mapper\/\" + pc.getModuleName()\n                        + \"\/\" + tableInfo.getEntityName() + \"Mapper\" +\n                        StringPool.DOT_XML;\n            }\n        });\n        \/*\n        cfg.setFileCreate(new IFileCreate() {\n            @Override\n            public boolean isCreate(ConfigBuilder configBuilder, FileType fileType,\nString filePath) {\n                \/\/ \u5224\u65ad\u2f83\u5b9a\u4e49\u2f42\u4ef6\u5939\u662f\u5426\u9700\u8981\u521b\u5efa\n                checkDir(\"\u8c03\u2f64\u9ed8\u8ba4\u2f45\u6cd5\u521b\u5efa\u7684\u2f6c\u5f55\uff0c\u2f83\u5b9a\u4e49\u2f6c\u5f55\u2f64\");\n                if (fileType == FileType.MAPPER) {\n                    \/\/ \u5df2\u7ecf\u2f63\u6210 mapper \u2f42\u4ef6\u5224\u65ad\u5b58\u5728\uff0c\u4e0d\u60f3\u91cd\u65b0\u2f63\u6210\u8fd4\u56de false\n                    return !new File(filePath).exists();\n                }\n                \/\/ \u5141\u8bb8\u2f63\u6210\u6a21\u677f\u2f42\u4ef6\n                return true;\n            }\n        });\n        *\/\n        cfg.setFileOutConfigList(focList);\n        mpg.setCfg(cfg);\n        \/\/\u914d\u7f6e\u6a21\u677f\n        TemplateConfig templateConfig = new TemplateConfig();\n        \/\/\u4e09\u3001\u4fee\u6539\u6a21\u677f\n        \/\/\u914d\u7f6e\u2f83\u5b9a\u4e49\u8f93\u51fa\u6a21\u677f\n        \/\/\u6307\u5b9a\u2f83\u5b9a\u4e49\u6a21\u677f\u8def\u5f84\uff0c\u6ce8\u610f\u4e0d\u8981\u5e26\u4e0a.ftl\/.vm, \u4f1a\u6839\u636e\u4f7f\u2f64\u7684\u6a21\u677f\u5f15\u64ce\u2f83\u52a8\u8bc6\u522b\n        \/\/\n        \/*templateConfig.setEntity(\"templates\/entity2.java\");\n        templateConfig.setService(\"templates\/service2.java\");\n        templateConfig.setController(\"templates\/controller2.java\");\n        templateConfig.setMapper(\"templates\/mapper2.java\");\n        templateConfig.setServiceImpl(\"templates\/serviceimpl2.java\");*\/\n\n        templateConfig.setXml(null);\n        mpg.setTemplate(templateConfig);\n        \/\/\u7b56\u7565\u914d\u7f6e\n        StrategyConfig strategy = new StrategyConfig();\n        strategy.setNaming(NamingStrategy.underline_to_camel);\n        strategy.setColumnNaming(NamingStrategy.underline_to_camel);\n        \/\/ strategy.setSuperEntityClass(\"\u4f60\u2f83\u2f30\u7684\u2f57\u7c7b\u5b9e\u4f53,\u6ca1\u6709\u5c31\u4e0d\u2f64\u8bbe\u7f6e!\");\n        \/\/strategy.setSuperEntityClass(\"BaseEntity\");\n        strategy.setEntityLombokModel(true);\n        strategy.setRestControllerStyle(true);\n        \/\/\u516c\u5171\u2f57\u7c7b\n        \/\/strategy.setSuperControllerClass(\"BaseController\");\n        \/\/ strategy.setSuperControllerClass(\"\u4f60\u2f83\u2f30\u7684\u2f57\u7c7b\u63a7\u5236\u5668,\u6ca1\u6709\u5c31\u4e0d\u2f64\u8bbe\u7f6e!\");\n        \/\/\u5199\u4e8e\u2f57\u7c7b\u4e2d\u7684\u516c\u5171\u5b57\u6bb5\n        \/\/ strategy.setSuperEntityColumns(\"id\");\n        strategy.setInclude(scanner(\"\u8868\u540d\uff0c\u591a\u4e2a\u82f1\u2f42\u9017\u53f7\u5206\u5272\").split(\",\"));\n        strategy.setControllerMappingHyphenStyle(true);\n        \/\/strategy.setTablePrefix(pc.getModuleName() + \"_\");\n        \/\/\u5ffd\u7565\u8868\u524d\u7f00tb_,\u2f50\u5982\u8bf4tb_user,\u76f4\u63a5\u6620\u5c04\u6210user\u5bf9\u8c61\n        \/\/\u56db\u3001\u6ce8\u610f\u662f\u5426\u8981\u53bb\u6389\u8868\u524d\u7f00\n        \/\/strategy.setTablePrefix(\"tb_\");\n        mpg.setStrategy(strategy);\n        mpg.setTemplateEngine(new FreemarkerTemplateEngine());\n        mpg.execute();\n    }\n}<\/code><\/pre>\n\n\n\n
\u8bd5\u8bd5\u80fd\u4e0d\u80fd\u7528,\u628ahelloController,\u5b9e\u4f53entity\u7684User,mapper\u91cc\u7684UserMapper , UserServiceImpl,userservice,resource\u7684usermapper.xml\u5220\u9664<\/p>\n\n\n\n
\u53f3\u952e\u8fd0\u884cCodegenerator.java<\/p>\n\n\n\n
\"\"<\/figure>\n\n\n\n
 usercontroller.java\u8865\u5145\u5982\u4e0b<\/p>\n\n\n\n
package com.wms.controller;\n\n\nimport com.wms.entity.User;\nimport com.wms.service.UserService;\nimport org.springframework.beans.factory.annotation.Autowired;\nimport org.springframework.web.bind.annotation.GetMapping;\nimport org.springframework.web.bind.annotation.RequestMapping;\n\nimport org.springframework.web.bind.annotation.RestController;\n\nimport java.util.List;\n\n\/**\n * <p>\n *  \u524d\u7aef\u63a7\u5236\u5668\n * <\/p>\n *\n * @author wms\n * @since 2024-11-19\n *\/\n@RestController\n@RequestMapping(\"\/user\")\npublic class UserController {\n\n    @Autowired\n    private UserService userService;\n    \n    @GetMapping\n    public List<User> list(){\n        return userService.list();\n    }\n}\n<\/code><\/pre>\n\n\n\n
\u7531\u4e8e\u7248\u672c\u95ee\u9898\uff0c\uff08\u65f6\u95f4\u7684\u5272\u88c2\u611f\uff09pom.xml\u4e2d\u7edf\u4e00\u7528mybatis3.5.7\u7248\u672c\uff0c\u5982\u679cCodeGenerator\u4e2d\u6709\u90e8\u5206\u5305\u5bfc\u4e0d\u5165\uff0c\u53f3\u952e\u9009\u62e9\u5176\u4ed6\u7248\u672c\uff08\u59823.4.1\uff09\u5373\u53ef\u3002\u8bb0\u5f97\u901a\u8fc7\u4fee\u6539pom.xml\u4e0b\u8f7d\u5bf9\u5e94\u7248\u672c\u7684\u4f9d\u8d56\uff1b<\/p>\n\n\n\n
\u6ca1\u6709@Mapper\u7684\u8981\u81ea\u5df1\u5728UserMapper\u4e2d\u6dfb\u52a0<\/p>\n\n\n\n
pom.xml\u7684\u90e8\u5206\u6dfb\u52a0\uff0c\u76f4\u63a5\u590d\u5236\u5373\u53ef<\/p>\n\n\n\n
<?xml version=\"1.0\" encoding=\"UTF-8\"?>\n<project xmlns=\"http:\/\/maven.apache.org\/POM\/4.0.0\" xmlns:xsi=\"http:\/\/www.w3.org\/2001\/XMLSchema-instance\"\n\txsi:schemaLocation=\"http:\/\/maven.apache.org\/POM\/4.0.0 https:\/\/maven.apache.org\/xsd\/maven-4.0.0.xsd\">\n\t<modelVersion>4.0.0<\/modelVersion>\n\t<parent>\n\t\t<groupId>org.springframework.boot<\/groupId>\n\t\t<artifactId>spring-boot-starter-parent<\/artifactId>\n\t\t<version>3.3.5<\/version>\n\t\t<relativePath\/> <!-- lookup parent from repository -->\n\t<\/parent>\n\t<groupId>com.wms<\/groupId>\n\t<artifactId>wms<\/artifactId>\n\t<version>0.0.1-SNAPSHOT<\/version>\n\t<name>wms<\/name>\n\t<description>wms<\/description>\n\t<url\/>\n\t<licenses>\n\t\t<license\/>\n\t<\/licenses>\n\t<developers>\n\t\t<developer\/>\n\t<\/developers>\n\t<scm>\n\t\t<connection\/>\n\t\t<developerConnection\/>\n\t\t<tag\/>\n\t\t<url\/>\n\t<\/scm>\n\t<properties>\n\t\t<java.version>23<\/java.version>\n\t<\/properties>\n\t<dependencies>\n\t\t<dependency>\n\t\t\t<groupId>org.springframework.boot<\/groupId>\n\t\t\t<artifactId>spring-boot-starter-web<\/artifactId>\n\t\t<\/dependency>\n\n\t\t<dependency>\n\t\t\t<groupId>com.mysql<\/groupId>\n\t\t\t<artifactId>mysql-connector-j<\/artifactId>\n\t\t\t<version>8.0.32<\/version>\n\t\t\t<scope>runtime<\/scope>\n\t\t<\/dependency>\n\t\t<dependency>\n\t\t\t<groupId>org.projectlombok<\/groupId>\n\t\t\t<artifactId>lombok<\/artifactId>\n\t\t\t<optional>true<\/optional>\n\t\t<\/dependency>\n\t\t<dependency>\n\t\t\t<groupId>org.springframework.boot<\/groupId>\n\t\t\t<artifactId>spring-boot-starter-test<\/artifactId>\n\t\t\t<version>3.3.5<\/version>\n\t\t\t<scope>test<\/scope>\n\t\t<\/dependency>\n\n\t\t<dependency>\n\t\t\t<groupId>com.baomidou<\/groupId>\n\t\t\t<artifactId>mybatis-plus-spring-boot3-starter<\/artifactId>\n\t\t\t<version>3.5.7<\/version>\n\t\t<\/dependency>\n\t\t<dependency>\n\t\t\t<groupId>com.baomidou<\/groupId>\n\t\t\t<artifactId>mybatis-plus-generator<\/artifactId>\n\t\t\t<version>3.4.1<\/version>\n\t\t<\/dependency>\n\t\t<dependency>\n\t\t\t<groupId>org.freemarker<\/groupId>\n\t\t\t<artifactId>freemarker<\/artifactId>\n\t\t\t<version>2.3.30<\/version>\n\t\t<\/dependency>\n\t\t<dependency>\n\t\t\t<groupId>com.spring4all<\/groupId>\n\t\t\t<artifactId>spring-boot-starter-swagger<\/artifactId>\n\t\t\t<version>1.5.1.RELEASE<\/version>\n\t\t<\/dependency>\n\t\t<dependency>\n\t\t\t<groupId>com.baomidou<\/groupId>\n\t\t\t<artifactId>mybatis-plus-generator<\/artifactId>\n\t\t\t<version>3.4.1<\/version>\n\t\t<\/dependency>\n\t\t<dependency>\n\t\t\t<groupId>com.baomidou<\/groupId>\n\t\t\t<artifactId>mybatis-plus-extension<\/artifactId>\n\t\t\t<version>3.5.7<\/version>\n\t\t<\/dependency>\n\n\t<\/dependencies>\n\n\t<build>\n\t\t<plugins>\n\t\t\t<plugin>\n\t\t\t\t<groupId>org.springframework.boot<\/groupId>\n\t\t\t\t<artifactId>spring-boot-maven-plugin<\/artifactId>\n\t\t\t\t<configuration>\n\t\t\t\t\t<excludes>\n\t\t\t\t\t\t<exclude>\n\t\t\t\t\t\t\t<groupId>org.projectlombok<\/groupId>\n\t\t\t\t\t\t\t<artifactId>lombok<\/artifactId>\n\t\t\t\t\t\t<\/exclude>\n\t\t\t\t\t<\/excludes>\n\t\t\t\t<\/configuration>\n\t\t\t<\/plugin>\n\t\t<\/plugins>\n\t<\/build>\n\n<\/project>\n<\/code><\/pre>\n\n\n\n
\"\"<\/p>\n\n\n\n
 \u56db\u3001\u5b9e\u73b0\u589e\u5220\u6539\u67e5<\/h1>\n\n\n\n
Usercontroller\u6dfb\u52a0\u589e\u5220\u6539\u7684\u529f\u80fd<\/p>\n\n\n\n
package com.wms.controller;\n\n\nimport com.wms.entity.User;\nimport com.wms.service.UserService;\nimport org.springframework.beans.factory.annotation.Autowired;\nimport org.springframework.web.bind.annotation.*;\n\nimport java.util.List;\n\n\/**\n * <p>\n *  \u524d\u7aef\u63a7\u5236\u5668\n * <\/p>\n *\n * @author wms\n * @since 2024-11-19\n *\/\n@RestController\n@RequestMapping(\"\/user\")\npublic class UserController {\n\n    @Autowired\n    private UserService userService;\n\n    @GetMapping(\"\/list\")\n    public List<User> list(){\n        return userService.list();\n    }\n\n    \/\/\u65b0\u589e\n    @PostMapping(\"\/save\")\n    public boolean save(@RequestBody User user){\n        return userService.save(user);\n    }\n    \/\/\u4fee\u6539\n    @PostMapping(\"\/mod\")\n    public boolean mod(@RequestBody User user){\n        return userService.updateById(user);\n    }\n    \/\/\u65b0\u589e\u6216\u4fee\u6539\n    @PostMapping(\"\/saveOrMod\")\n    public boolean saveOrMod(@RequestBody User user){\n        return userService.saveOrUpdate(user);\n    }\n    \/\/\u5220\u9664\n    @GetMapping(\"\/delete\")\n    public boolean delete(Integer id){\n        return userService.removeById(id);\n    }\n\n\n}<\/code><\/pre>\n\n\n\n
\u542f\u52a8\u540e\u6253\u5f00postman\u6309\u7167\u5982\u4e0b\u6240\u793a\u8f93\u5165POST\u7684\u6570\u636e\u5e76\u4e14send\u4ed6\uff0c200OK\u548ctrue\u5c31\u662f\u53d1\u9001\u6210\u529f<\/p>\n\n\n\n
\"\"<\/figure>\n\n\n\n
 \u6253\u5f00Navicat\u67e5\u8be2\uff08\u7531\u4e8e\u672c\u4eba\u6309\u4e86\u4e24\u6b21send\uff0c\u56e0\u6b64\u6709\u91cd\u590d\u6570\u636e\uff0c\u4e0d\u8fc7\u8fd9\u4e5f\u53cd\u6620\u51fa\u6570\u636e\u91cd\u590d\u7684\u5904\u7406\u95ee\u9898<\/p>\n\n\n\n
\"\"<\/figure>\n\n\n\n
 \u7ee7\u7eed\u66f4\u6362\u5176\u4ed6\u65b9\u6cd5\u5982mod\u4fee\u6539\uff0c\u4fee\u6539\u6210\u529f\uff01\uff01<\/p>\n\n\n\n
\"\"\"\"<\/p>\n\n\n\n
\u00a0\u4ee5\u6b64\u7c7b\u63a8\uff0c\u90fd\u662f\u8fd9\u6837\u4e86\uff0csaveormod\u662f\u4fee\u6539\u6216\u6dfb\u52a0\uff0c\u6839\u636e\u6570\u636e\u7684id\u5b58\u5728\u4e0d\u5b58\u5728<\/strong>\uff0c\u5f53\u6211i\u4e0dpost\u90a3\u4e2aid\u65f6\uff0c\u5c31\u4f1a\u65b0\u5efa\u4e86\u200b<\/p>\n\n\n\n
\"\"<\/figure>\n\n\n\n
\"\"<\/p>\n\n\n\n
\u00a0delete\u5219\u662f\u4f7f\u7528GET\u65b9\u6cd5\uff0c\u76f4\u63a5\u5bfc\u5165\u5bf9\u5e94\u7684id\u5373\u53ef\u5b9e\u73b0\u5220\u9664<\/p>\n\n\n\n
\"\"<\/figure>\n\n\n\n
 \u63a5\u4e0b\u6765\u505a\u67e5\u8be2\u3002\u4f9d\u65e7\u662fUserController\u4e2d\u6dfb\u52a0<\/p>\n\n\n\n
\/\/\u67e5\u8be2\uff08\u6a21\u7cca\u3001\u5339\u914d\uff09\n    @PostMapping(\"\/listP\")\n    public List<User>listP(@RequestBody User user) {\n        LambdaQueryWrapper<User> lambdaQueryWrapper = new LambdaQueryWrapper();\n        lambdaQueryWrapper.like(User::getName, user.getName());\n        return userService.list(lambdaQueryWrapper);\n    }<\/code><\/pre>\n\n\n\n
\"\"<\/figure>\n\n\n\n
 lambdaQueryWrapper.eq(User::getName, user.getName());\n        \/\/eq\u5c31\u662f\u5b8c\u5168\u5339\u914d<\/code><\/pre>\n\n\n\n
\u4e94\u3001\u5206\u9875\u7684\u5904\u7406<\/h1>\n\n\n\n
\u5165\u53c2\u7684\u5c01\u88c5\uff0c\u4f9d\u65e7\u662fusercontroller\u6d4b\u8bd5\u6253\u5370\u662f\u5426\u80fd\u591f\u6210\u529f\u8fd0\u884c
\u7b2c\u4e00\u4e2a\u53c2\u6570\u8981\u4f20\u5165\u51fd\u6570\u5f0f\u63a5\u53e3\uff0c\u8fd9\u5199\u6cd5\u662fLamda\u8868\u8fbe\u5f0f\uff1bpagehelper\u7684\u5206\u9875\u633a\u4e0d\u9519\uff0cmybatis-plus\u63d0\u4f9b\u7684\u5206\u9875\u63d2\u4ef6\u57283.5.9\u7248\u672c\u540e\u5927\u66f4\u65b0\uff0cyou can try\u8fd9\u53ef\u4ee5\u51cf\u8f7b\u5f88\u591a\u4ee3\u7801\u91cf<\/p>\n\n\n\n
@PostMapping(\"\/listPage\")\n    public List<User>listPage(@RequestBody HashMap map){\n        System.out.println(map);\n        \/*LambdaQueryWrapper<User>LambdaQueryWrapper=newLambdaQueryWrapper();\n        LambdaQueryWrapper.eq(User::getName,user.getName());\n        return userService.list(LambdaQueryWrapper);*\/\n \n        return null;\n    }<\/code><\/pre>\n\n\n\n
\u5728com.wms.common\u4e0b\u65b0\u5efa\u65b9\u6cd5QueryPageParam.java<\/p>\n\n\n\n
package com.wms.common;\nimport lombok.Data;\n\n@Data\npublic class QueryPageParam{\n    \/\/\u9ed8\u8ba4\n    private static int PAGE_SIZE=20;\n    private static int PAGE_NUM=1;\n    private int pageSize=PAGE_SIZE;\n    private int pageNum=PAGE_NUM;\n\n}<\/code><\/pre>\n\n\n\n
 \u4fee\u6539listPage<\/p>\n\n\n\n
 @PostMapping(\"\/listPage\")\n    public List<User>listPage(@RequestBody QueryPageParam param){\n        System.out.println(param);\n        \/\/System.out.println(\"num===\"+(String)map.get(\"pageSize\"));\n\n        System.out.println(\"num===\"+param.getPageNum());\n        System.out.println(\"size===\"+param.getPageSize());\n        \/*LambdaQueryWrapper<User>LambdaQueryWrapper=newLambdaQueryWrapper();\n        LambdaQueryWrapper.eq(User::getName,user.getName());\n        return userService.list(LambdaQueryWrapper);*\/\n\n        return null;\n    }<\/code><\/pre>\n\n\n\n
\u7531\u4e8e\u9ed8\u8ba4\u8bbe\u7acb\u662f20\u548c1\uff0c\u81ea\u7136\u4f1a\u5728idea\u548cpostman\u4e2d\u51fa\u73b0\u5982\u4e0b\u754c\u9762<\/p>\n\n\n\n
\"\"<\/figure>\n\n\n\n
\u8fd9\u4e24\u4e2a\u53c2\u6570\uff0c\u6700\u540e\u4f1a\u5f53\u4f5csql\u7684\u4e24\u4e2a\u67e5\u8be2\u6761\u4ef6\u53bb\u5904\u7406\u5206\u9875\u3002 <\/strong><\/p>\n\n\n\n
\u524d\u8f88\u8bf4\uff1a\u5343\u4e07\u4e0d\u8981\u62ffMap\u5f53\u4f20\u53c2\uff0c\u7ef4\u62a4\u706b\u846c\u573a  <\/strong>\u4e00\u5b9a\u8981\u7528map\uff0c\u4f46\u662f\u5199\u63a5\u53e3\u6587\u6863\u4e0d\u5c31\u884c\u4e86\uff0c\u5e76\u4e14\u6709\u65f6\u5019\u53c2\u6570\u540d\u79f0\u662f\u4e0d\u56fa\u5b9a\u7684\u8c01\u8981\u662f\u518d\u6562\u7528Map\u4f20\u53c2\uff0c\u6211\u8fc7\u53bb\u5c31\u662f\u4e00JIO_idea map\u4f20\u53c2\u8981\u5177\u4f53\u7c7b\u578b-CSDN\u535a\u5ba2<\/a><\/p>\n\n\n\n
\u56e0\u4e3a\u539f\u6765\u7684\u90a3\u79cd\u8fd8\u5f97\u6267\u884c\u5b8c\u8fd8\u5f97\u5f3a\u8f6c\u5316\u6574\u578b\uff0c\u5224\u65ad\u662f\u5426\u4e3a0\u4ec0\u4e48\u7684\uff0c\u6240\u4ee5\u8981\u5165\u53c2\u7684\u5c01\u88c5<\/p>\n\n\n\n
 querypage\u6dfb\u52a0HashMap<\/p>\n\n\n\n
package com.wms.common;\nimport lombok.Data;\n\nimport java.util.HashMap;\n\n@Data\npublic class QueryPageParam{\n    \/\/\u9ed8\u8ba4\n    private static int PAGE_SIZE=20;\n    private static int PAGE_NUM=1;\n    private int pageSize=PAGE_SIZE;\n    private int pageNum=PAGE_NUM;\n\n    private HashMap parma;\n}<\/code><\/pre>\n\n\n\n
usercontroller\u628aparma\u90e8\u5206\u6539\u4e3aquery<\/p>\n\n\n\n
@PostMapping(\"\/listPage\")\n    public List<User>listPage(@RequestBody QueryPageParam query){\n        System.out.println(query);\n        \/\/System.out.println(\"num===\"+(String)map.get(\"pageSize\"));\n\n        System.out.println(\"num===\"+query.getPageNum());\n        System.out.println(\"size===\"+query.getPageSize());\n        \/*LambdaQueryWrapper<User>LambdaQueryWrapper=newLambdaQueryWrapper();\n        LambdaQueryWrapper.eq(User::getName,user.getName());\n        return userService.list(LambdaQueryWrapper);*\/\n\n        return null;\n    }<\/code><\/pre>\n\n\n\n
\"\"<\/figure>\n\n\n\n
\u5206\u9875\u62e6\u622a\u5668<\/h3>\n\n\n\n
 \u63d2\u4ef6\u4e3b\u4f53 | MyBatis-Plus<\/a>     \u5728com.wms.common\u4e0b\u65b0\u5efaMybatisPlusConfig.java\u4ece\u7f51\u7ad9\u4e2d\u590d\u5236\u5373\u53ef<\/p>\n\n\n\n
package com.wms.common;\n\nimport 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.wms\")\npublic class MybatisPlusConfig {\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\n\n\n
\u8fd9\u5176\u5b9e\u4e0d\u4e71\u597d\u5427\uff0c1.Page\u662f\u8bbe\u7f6e\u9875\u7801\u548c\u5c3a\u5bf8\u7684\uff0c2.Lam...\u662f\u5f97\u5230\u4f60\u7684\u6570\u636e(\u6b64\u65f6\u8fd8\u6ca1\u8fdb\u884c\u771f\u6b63\u7684\u5206\u9875)\uff0c3.IPage\u624d\u662f\u5bf9\u6570\u636e\u8fdb\u884c\u5206\u9875\u7684\u64cd\u4f5c\uff0c\u7ed3\u679c\u4fdd\u5b58\u5728IPage\u5bf9\u8c61\u4e2d\uff08\u8fd9\u91cc\u662fresult\uff09\uff1b\u8fd4\u56de\u7ed3\u679c\u662f[]\u7684\u540c\u5b66\u770b\u770b\u81ea\u5df1json\u7684pageNum\u662f\u4e0d\u662f1\uff0c\u56e0\u4e3a\u6570\u636e\u5e93\u8bb0\u5f55\u4e2a\u6570\u4e0d\u591f\u7684\u8bdd\uff0c\u5176\u4ed6\u9875\u662f\u6ca1\u6709\u6570\u636e\u7684\uff1b\u5982\u679c\u67e5\u7684\u6570\u636e\u662f\u5168\u90e8\uff0c\u53ef\u80fd\u662f\u62e6\u622a\u5668\u51fa\u95ee\u9898\u4e86\uff0c\u6362\u52303.4.1\u7684\u62e6\u622a\u5668\uff1btotal\u7b49\u4e8e\u96f6\u662f\u56e0\u4e3aMybatisPlusConfig\u7c7b\u6ca1\u6709\u5199<\/p>\n\n\n\n
@PostMapping(\"\/listPage\")\n    public List<User>listPage(@RequestBody QueryPageParam query){\n        HashMap param = query.getParam();\n        String name = (String) param.get(\"name\");\n        System.out.println(\"name===\" + (String) param.get(\"name\"));\n\/*\n        HashMap param =query.getParam();\n        System.out.println(\"name===\"+(String)param.get(\"name\"));\n        System.out.println(\"no===\"+(String)param.get(\"no\"));\n        \/*LambdaQueryWrapper<User>LambdaQueryWrapper=newLambdaQueryWrapper();\n        LambdaQueryWrapper.eq(User::getName,user.getName());\n        return userService.list(LambdaQueryWrapper);*\/\n\n        Page<User> page = new Page();\n        page.setCurrent(query.getPageNum());\n        page.setSize(query.getPageSize());\n\n        LambdaQueryWrapper<User> lambdaQueryWrapper = new LambdaQueryWrapper();\n        lambdaQueryWrapper.like(User::getName, name);\n\n        IPage result=userService.page(page,lambdaQueryWrapper);\n\n        System.out.println(\"total==\"+result.getTotal());\n\n\n        return result.getRecords();\n    }<\/code><\/pre>\n\n\n\n
\u5f53\u6211\u60f3\u81ea\u5df1\u5c01\u88c5\u4e00\u4e2a\u65b9\u6cd5\u65f6\uff0c \uff08\u4e4b\u524d\u662f\u81ea\u5e26\u7684\u65b9\u6cd5  \u73b0\u5728\u662f\u81ea\u5df1\u5199\u7684 \uff09<\/p>\n\n\n\n
 \u5728userservice\u5bfc\u5165pageC<\/p>\n\n\n\n
package com.wms.service;\n\nimport com.baomidou.mybatisplus.core.metadata.IPage;\nimport com.baomidou.mybatisplus.extension.plugins.pagination.Page;\nimport com.wms.entity.User;\nimport com.baomidou.mybatisplus.extension.service.IService;\n\n\/**\n * <p>\n *  \u670d\u52a1\u7c7b\n * <\/p>\n *\n * @author wms\n * @since 2024-11-19\n *\/\npublic interface UserService extends IService<User> {\n\n    IPage pageC(IPage<User> page);\n}<\/code><\/pre>\n\n\n\n
\u5728userServiceImpl\u4e2d\u5bfc\u5165\uff08\u5bf9\u4e8eUserserviceImpl\u7684\u7ea2\u8272\uff0c\u53f3\u952e\u9009\u62e9\u7b2c\u4e00\u4e2aPageC\u7684\"\"\u4e8e\u662fuserserviceIpml\u53d8\u6210\u8fd9\u6837<\/p>\n\n\n\n
package com.wms.service.impl;\n\nimport com.baomidou.mybatisplus.core.metadata.IPage;\nimport com.wms.entity.User;\nimport com.wms.mapper.UserMapper;\nimport com.wms.service.UserService;\nimport com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;\nimport jakarta.annotation.Resource;\nimport org.springframework.stereotype.Service;\n\n\/**\n * <p>\n *  \u670d\u52a1\u5b9e\u73b0\u7c7b\n * <\/p>\n *\n * @author wms\n * @since 2024-11-19\n *\/\n@Service\npublic class UserServiceImpl extends ServiceImpl<UserMapper, User> implements UserService {\n\n    @Resource\n    private UserMapper userMapper;\n    @Override\n    public IPage pageC(IPage<User> page) {\n        return userMapper.pageC(page);\n    }\n}\n<\/code><\/pre>\n\n\n\n
 \u540c\u671fUserController\u8865\u5145\u5982\u4e0b<\/p>\n\n\n\n
@PostMapping(\"\/listPageC\")\n    \/\/public List<User>listPage(@RequestBody HashMap map){\n    public List<User>listPageC(@RequestBody QueryPageParam query) {\n        HashMap param = query.getParam();\n        String name = (String) param.get(\"name\");\n        System.out.println(\"name===\" + (String) param.get(\"name\"));\n\n        Page<User> page = new Page();\n        page.setCurrent(query.getPageNum());\n        page.setSize(query.getPageSize());\n\n       \/* LambdaQueryWrapper<User> lambdaQueryWrapper = new LambdaQueryWrapper();\n        lambdaQueryWrapper.like(User::getName, name);*\/\n\n        IPage result=userService.pageC(page);\n\n        System.out.println(\"result==\"+result.getTotal());\n\n\n        return result.getRecords();\n    }<\/code><\/pre>\n\n\n\n
\"\"<\/p>\n\n\n\n
\u63d2\u4ef6\u81ea\u7136\u4fee\u6539usermapper.xml\u5982\u4e0b<\/p>\n\n\n\n
<?xml version=\"1.0\" encoding=\"UTF-8\"?>\n<!DOCTYPE mapper PUBLIC \"-\/\/mybatis.org\/\/DTD Mapper 3.0\/\/EN\" \"http:\/\/mybatis.org\/dtd\/mybatis-3-mapper.dtd\">\n<mapper namespace=\"com.wms.mapper.UserMapper\">\n\n    <!-- \u901a\u7528\u67e5\u8be2\u6620\u5c04\u7ed3\u679c -->\n    <resultMap id=\"BaseResultMap\" type=\"com.wms.entity.User\">\n        <id column=\"id\" property=\"id\" \/>\n        <result column=\"no\" property=\"no\" \/>\n        <result column=\"name\" property=\"name\" \/>\n        <result column=\"password\" property=\"password\" \/>\n        <result column=\"age\" property=\"age\" \/>\n        <result column=\"sex\" property=\"sex\" \/>\n        <result column=\"phone\" property=\"phone\" \/>\n        <result column=\"role_id\" property=\"roleId\" \/>\n        <result column=\"isvalid\" property=\"isvalid\" \/>\n    <\/resultMap>\n\n    <!-- \u901a\u7528\u67e5\u8be2\u7ed3\u679c\u5217 -->\n    <sql id=\"Base_Column_List\">\n        id, no, name, password, age, sex, phone, role_id, isvalid\n    <\/sql>\n\n    <select id=\"pageC\" resultType=\"com.wms.entity.User\">\n        select * from user\n    <\/select>\n<\/mapper>\n<\/code><\/pre>\n\n\n\n
\u5220\u9664xml\u7684pageC\u7684\u90a3\u53e5<\/p>\n\n\n\n
resultType=\"com.wms.entity.User\"<\/pre>\n\n\n\n
\u00a0\u5c45\u7136\u5728usermappper.java\u62a5\u9519\u7684\u60c5\u51b5\u4e0b\u6210\u529f\u8fd0\u884c\u4e86\uff0c\u4f46\u662f\u5728Navicat\u62a5\u9519\u4e86<\/p>\n\n\n\n
\"\"<\/figure>\n\n\n\n
\u591a\u65b9\u4fee\u6539 \uff0c\u5c06usermapper.java\u4fee\u6539\uff0c\u5373\u52a0\u4e00\u4e2a<User>\u5c31\u4e0d\u4f1a\u7206\u7ea2<\/p>\n\n\n\n
IPage <User> pageC(IPage<User> page);<\/code><\/pre>\n\n\n\n
\u00a0\u6210\u529f\u8fd0\u884c
\"\"<\/p>\n\n\n\n
\u4e3a\u4e86\u4fdd\u8bc1\u4f60\u6709\u6b63\u786e\u7684\u7ed3\u679c\u6211\u5c06\u63d0\u4f9b5\u4e2a\u4ee3\u7801<\/p>\n\n\n\n
package com.wms.controller;\n\n\nimport com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper;\nimport com.baomidou.mybatisplus.core.metadata.IPage;\nimport com.baomidou.mybatisplus.extension.plugins.pagination.Page;\nimport com.wms.common.QueryPageParam;\nimport com.wms.entity.User;\nimport com.wms.service.UserService;\nimport org.springframework.beans.factory.annotation.Autowired;\nimport org.springframework.web.bind.annotation.*;\n\nimport java.util.HashMap;\nimport java.util.List;\n\n\/**\n * <p>\n * \u524d\u7aef\u63a7\u5236\u5668\n * <\/p>\n *\n * @author wms\n * @since 2024-11-19\n *\/\n@RestController\n@RequestMapping(\"\/user\")\npublic class UserController {\n\n    @Autowired\n    private UserService userService;\n\n    @GetMapping(\"\/list\")\n    public List<User> list() {\n        return userService.list();\n    }\n\n    \/\/\u65b0\u589e\n    @PostMapping(\"\/save\")\n    public boolean save(@RequestBody User user) {\n        return userService.save(user);\n    }\n\n    \/\/\u4fee\u6539\n    @PostMapping(\"\/mod\")\n    public boolean mod(@RequestBody User user) {\n        return userService.updateById(user);\n    }\n\n    \/\/\u65b0\u589e\u6216\u4fee\u6539\n    @PostMapping(\"\/saveOrMod\")\n    public boolean saveOrMod(@RequestBody User user) {\n        return userService.saveOrUpdate(user);\n    }\n\n    \/\/\u5220\u9664\n    @GetMapping(\"\/delete\")\n    public boolean delete(Integer id) {\n        return userService.removeById(id);\n    }\n\n    \/\/\u67e5\u8be2\uff08\u6a21\u7cca\u3001\u5339\u914d\uff09\n    @PostMapping(\"\/listP\")\n    public List<User> listP(@RequestBody User user) {\n        LambdaQueryWrapper<User> lambdaQueryWrapper = new LambdaQueryWrapper();\n        lambdaQueryWrapper.like(User::getName, user.getName());\n        \/\/lambdaQueryWrapper.eq(User::getName, user.getName());\n        \/\/eq\u5c31\u662f\u5b8c\u5168\u5339\u914d\n        return userService.list(lambdaQueryWrapper);\n    }\n\n    @PostMapping(\"\/listPage\")\n    \/\/public List<User>listPage(@RequestBody HashMap map){\n    public List<User>listPage(@RequestBody QueryPageParam query) {\n        HashMap param = query.getParam();\n        String name = (String) param.get(\"name\");\n        System.out.println(\"name===\" + (String) param.get(\"name\"));\n        \/*System.out.println(\"no===\"+(String)param.get(\"no\"));*\/\n            \/*LambdaQueryWrapper<User>LambdaQuer[Wrapper=newLambdaQueryWrapper();\n            lambdaQueryWrapper.eq(User::getName,user.getName());\n\n            return userService.list(lambdaQueryllrapper);*\/\n        Page<User> page = new Page();\n        page.setCurrent(query.getPageNum());\n        page.setSize(query.getPageSize());\n\n        LambdaQueryWrapper<User> lambdaQueryWrapper = new LambdaQueryWrapper();\n        lambdaQueryWrapper.like(User::getName, name);\n\n        IPage result=userService.page(page,lambdaQueryWrapper);\n\n        System.out.println(\"result==\"+result.getTotal());\n\n\n        return result.getRecords();\n    }\n\n    @PostMapping(\"\/listPageC\")\n    \/\/public List<User>listPage(@RequestBody HashMap map){\n    public List<User>listPageC(@RequestBody QueryPageParam query) {\n        HashMap param = query.getParam();\n        String name = (String) param.get(\"name\");\n        System.out.println(\"name===\" + (String) param.get(\"name\"));\n\n        Page<User> page = new Page();\n        page.setCurrent(query.getPageNum());\n        page.setSize(query.getPageSize());\n\n       \/* LambdaQueryWrapper<User> lambdaQueryWrapper = new LambdaQueryWrapper();\n        lambdaQueryWrapper.like(User::getName, name);*\/\n\n        IPage result=userService.pageC(page);\n\n        System.out.println(\"result==\"+result.getTotal());\n\n\n        return result.getRecords();\n    }\n}\n<\/code><\/pre>\n\n\n\n
package com.wms.service.impl;\n\nimport com.baomidou.mybatisplus.core.metadata.IPage;\nimport com.wms.entity.User;\nimport com.wms.mapper.UserMapper;\nimport com.wms.service.UserService;\nimport com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;\nimport jakarta.annotation.Resource;\nimport org.springframework.stereotype.Service;\n\n\/**\n * <p>\n *  \u670d\u52a1\u5b9e\u73b0\u7c7b\n * <\/p>\n *\n * @author wms\n * @since 2024-11-19\n *\/\n@Service\npublic class UserServiceImpl extends ServiceImpl<UserMapper, User> implements UserService {\n\n    @Resource\n    private UserMapper userMapper;\n    @Override\n    public IPage pageC(IPage<User> page) {\n        return userMapper.pageC(page);\n    }\n}<\/code><\/pre>\n\n\n\n
package com.wms.mapper;\n\nimport com.baomidou.mybatisplus.core.metadata.IPage;\nimport com.wms.entity.User;\nimport com.baomidou.mybatisplus.core.mapper.BaseMapper;\nimport org.apache.ibatis.annotations.Mapper;\n\n\/**\n * <p>\n *  Mapper \u63a5\u53e3\n * <\/p>\n *\n * @author wms\n * @since 2024-11-19\n *\/\n@Mapper\npublic interface UserMapper extends BaseMapper<User> {\n\n    IPage <User> pageC(IPage<User> page);\n}\n<\/code><\/pre>\n\n\n\n
<?xml version=\"1.0\" encoding=\"UTF-8\"?>\n<!DOCTYPE mapper PUBLIC \"-\/\/mybatis.org\/\/DTD Mapper 3.0\/\/EN\" \"http:\/\/mybatis.org\/dtd\/mybatis-3-mapper.dtd\">\n<mapper namespace=\"com.wms.mapper.UserMapper\">\n\n    <!-- \u901a\u7528\u67e5\u8be2\u6620\u5c04\u7ed3\u679c -->\n    <resultMap id=\"BaseResultMap\" type=\"com.wms.entity.User\">\n        <id column=\"id\" property=\"id\" \/>\n        <result column=\"no\" property=\"no\" \/>\n        <result column=\"name\" property=\"name\" \/>\n        <result column=\"password\" property=\"password\" \/>\n        <result column=\"age\" property=\"age\" \/>\n        <result column=\"sex\" property=\"sex\" \/>\n        <result column=\"phone\" property=\"phone\" \/>\n        <result column=\"role_id\" property=\"roleId\" \/>\n        <result column=\"isvalid\" property=\"isvalid\" \/>\n    <\/resultMap>\n\n    <!-- \u901a\u7528\u67e5\u8be2\u7ed3\u679c\u5217 -->\n    <sql id=\"Base_Column_List\">\n        id, no, name, password, age, sex, phone, role_id, isvalid\n    <\/sql>\n\n    <select id=\"pageC\" resultType=\"com.wms.entity.User\">\n        select * from user\n    <\/select>\n<\/mapper>\n<\/code><\/pre>\n\n\n\n
package com.wms.service;\n\nimport com.baomidou.mybatisplus.core.metadata.IPage;\nimport com.baomidou.mybatisplus.extension.plugins.pagination.Page;\nimport com.wms.entity.User;\nimport com.baomidou.mybatisplus.extension.service.IService;\n\n\/**\n * <p>\n *  \u670d\u52a1\u7c7b\n * <\/p>\n *\n * @author wms\n * @since 2024-11-19\n *\/\npublic interface UserService extends IService<User> {\n\n    IPage pageC(IPage<User> page);\n}\n<\/code><\/pre>\n\n\n\n
 \u5982\u679c\u6211\u4eec\u81ea\u5b9a\u4e49SQL\u7528wrapper\u4f1a\u975e\u5e38\u65b9\u4fbf\uff0c\u4e0d\u7528\u518d\u5199\u4ec0\u4e48select * from user where name = ' '? <\/p>\n\n\n\n
\u4f7f\u7528 Wrapper \u81ea\u5b9a\u4e49 SQL | MyBatis-Plus<\/a><\/p>\n\n\n\n
\u4fee\u6539pageCC\u5e76\u4e14\u628alambdaquerywrapper\u52a0\u5165\uff08\u6ce8\u91ca\u89e3\u653e\uff09usercontroller.java<\/p>\n\n\n\n
@PostMapping(\"\/listPageC\")\n    \/\/public List<User>listPage(@RequestBody HashMap map){\n    public List<User>listPageCC(@RequestBody QueryPageParam query) {\n        HashMap param = query.getParam();\n        String name = (String) param.get(\"name\");\n        System.out.println(\"name===\" + (String) param.get(\"name\"));\n\n        Page<User> page = new Page();\n        page.setCurrent(query.getPageNum());\n        page.setSize(query.getPageSize());\n\n        LambdaQueryWrapper<User> lambdaQueryWrapper = new LambdaQueryWrapper();\n        lambdaQueryWrapper.like(User::getName, name);\n\n\n        \/\/IPage result=userService.pageC(page);\n        IPage result=userService.pageCC(page,lambdaQueryWrapper);\n        System.out.println(total==\"+result.getTotal());\n\n\n        return result.getRecords();\n    }<\/code><\/pre>\n\n\n\n
userservice.java  \u9009\u62e9baomidou\u7684\u90a3\u4e2a\u65b9\u6cd5\u7c7b<\/p>\n\n\n\n
public interface UserService extends IService<User> {\n\n    IPage pageC(IPage<User> page);\n\n    IPage pageCC (IPage<User> page,Wrapper<User> wrapper);\n}\n<\/code><\/pre>\n\n\n\n
\"\"\u00a0userserviceimpl\u9009\u62e9pagecc\u5c31\u81ea\u52a8\u751f\u6210\u7684\u4e86<\/p>\n\n\n\n
\"\"<\/figure>\n\n\n\n
\u8fd8\u662fuserserviceimpl\u4e2d\uff0c\u6839\u636e \u5b98\u7f51return\u76f8\u5e94\u7684\u6570\u636e\uff0c\u5e76\u201c\u5728usermapper\u4e2d\u521b\u5efa\u65b9\u6cd5pageCC\u201d<\/p>\n\n\n\n
\"\"<\/figure>\n\n\n\n
usermapper\u4e2d\u9009\u62e9select statement \u3002\u8df3\u8f6c\u5230usermapper.xml\u4e2d\uff0cusermapper.java\u90e8\u5206\u4ee3\u7801\u5982\u4e0b<\/p>\n\n\n\n
\"\"<\/figure>\n\n\n\n
@Mapper\npublic interface UserMapper extends BaseMapper<User> {\n\n    IPage <User> pageC(IPage<User> page);\n\n    IPage pageCC(IPage<User> page, @Param(Constants.WRAPPER)Wrapper<User> wrapper);\n}\n<\/code><\/pre>\n\n\n\n
 \u5199\u5b8cxml\u4e2d\u7684\u90e8\u5206\u5982\u4e0b<\/p>\n\n\n\n
<select id=\"pageCC\" resultType=\"com.baomidou.mybatisplus.core.metadata.IPage\">\n        select * from user ${ew.customSqlSegment}\n    <\/select><\/code><\/pre>\n\n\n\n
\u6210\u529f\u4f7f\u7528\uff0c\u8c03\u7528\u7684\u63a5\u53e3\u662f\/user\/pageC \u4f46\u91cc\u9762\u7684\u65b9\u6cd5\u662fpageCC \u6240\u4ee5\u7528\u7684\u5c31\u662fpageCC\u65b9\u6cd5<\/strong><\/p>\n\n\n\n
\u8fd9\u91cc\u6559\u4e863\u4e2a\u65b9\u6cd5\uff0c\u4e00\u4e2a\u662f\u9ed8\u8ba4\u751f\u6210\u7684\uff0c\u4e00\u4e2a\u662f\u5199\u7684\u4f9d\u8d56\uff0cselect * from xxx\u7684\uff0c\u4e00\u4e2a\u662f\u81ea\u5df1\u5199\u7684select * from XXX where xxx\uff1b\u5206\u9875\u548c\u67e5\u8be2\u6761\u4ef6\u7684\u7ed3\u5408\u8fd4\u56de\u7b26\u5408\u6761\u4ef6\u7684\u5206\u9875\u4fe1\u606f\uff0c<\/p>\n\n\n\n
\u516d\u3001\u8fd4\u7ed9\u524d\u7aef\u6570\u636e\u7684\u5c01\u88c5 <\/h1>\n\n\n\n
\u8ba9\u524d\u7aef\u6536\u5230\u7edf\u4e00\u7684\u6570\u636e\uff0c\u65b9\u4fbf\u5904\u7406<\/p>\n\n\n\n
{\n    Code:200\/\/400\n    Msg:\"\u6210\u529f\u3001\u5931\u8d25\u201d\uff0c\n    Total:10\n    Data:[] {}\n}<\/code><\/pre>\n\n\n\n
\u5728com.wms.common\u4e0b\u65b0\u5efa\u4e00\u4e2a\u7c7bResult<\/p>\n\n\n\n
package com.wms.common;\n\nimport lombok.Data;\n\n@Data\npublic class Result {\n    private int code;\/\/200 or 400\n    private String msg;\/\/true or false\n    private Long total;\/\/\u603b\u8bb0\u5f55\u6570\n    private Object data;\/\/data\n\n    public static Result fail(){\n        return result(400,\"\u5931\u8d25\",0L,null);\n    }\n    public static Result success(){\n        return result(200,\"\u6210\u529f\",0L,null);\n    }\n    public static Result success(Object data){\n        return result(200,\"\u6210\u529f\",0L,data);\n    }\n    public static Result success(Object data,Long total){\n        return result(200,\"\u6210\u529f\",total,data);\n    }\n\n\n    private static Result result(int code, String msg, Long total, Object data) {\n           Result res = new Result();\n           res.setData(data);\n           res.setMsg(msg);\n           res.setCode(code);\n           res.setTotal(total);\n           return res;\n\n    }\n}\n<\/code><\/pre>\n\n\n\n
Usercontroller\u65b0\u52a0\u4e00\u4e2a\u65b9\u6cd5<\/p>\n\n\n\n
@PostMapping(\"\/listPageC1\")\n    \/\/public List<User>listPage(@RequestBody HashMap map){\n    public Result listPageC1(@RequestBody QueryPageParam query) {\n        HashMap param = query.getParam();\n        String name = (String) param.get(\"name\");\n        System.out.println(\"name===\" + (String) param.get(\"name\"));\n\n        Page<User> page = new Page();\n        page.setCurrent(query.getPageNum());\n        page.setSize(query.getPageSize());\n\n        LambdaQueryWrapper<User> lambdaQueryWrapper = new LambdaQueryWrapper();\n        lambdaQueryWrapper.like(User::getName, name);\n\n\n        \/\/IPage result=userService.pageC(page);\n        IPage result=userService.pageCC(page,lambdaQueryWrapper);\n        System.out.println(\"total==\"+result.getTotal());\n\n\n        return Result.success(result.getRecords(),result.getTotal());\n    }<\/code><\/pre>\n\n\n\n
\u975e\u5e38\u4f24\u5fc3\uff0c\u5931\u8d25\u4e86<\/p>\n\n\n\n
\"\"<\/figure>\n\n\n\n
\u6839\u636e\u63d0\u4f9b\u7684\u4fe1\u606f\uff0c\u95ee\u9898\u51fa\u5728MyBatis Plus\u5c1d\u8bd5\u901a\u8fc7\u53cd\u5c04\u521b\u5efaIPage\u5bf9\u8c61\u65f6\u627e\u4e0d\u5230\u65e0\u53c2\u6784\u9020\u51fd\u6570\u3002\u8fd9\u662f\u4e00\u4e2a\u5e38\u89c1\u7684\u95ee\u9898\uff0c\u901a\u5e38\u662f\u7531\u4e8e\u914d\u7f6e\u6216\u4f7f\u7528\u65b9\u5f0f\u4e0d\u6b63\u786e\u5f15\u8d77\u7684\u3002<\/p>\n\n\n\n
\u5206\u6790\u4e0e\u89e3\u51b3\u65b9\u6848
1. \u68c0\u67e5IPage\u7684\u4f7f\u7528
\u5728\u60a8\u7684XML\u6620\u5c04\u6587\u4ef6\u4e2d\uff0cpageCC\u65b9\u6cd5\u7684\u8fd4\u56de\u7c7b\u578b\u88ab\u8bbe\u7f6e\u4e3aIPage\uff0c\u8fd9\u662f\u4e0d\u6b63\u786e\u7684\u3002IPage\u662f\u4e00\u4e2a\u63a5\u53e3\uff0c\u800c\u4e0d\u662f\u5177\u4f53\u7684\u5b9e\u73b0\u7c7b\u3002MyBatis Plus\u5728\u5904\u7406\u5206\u9875\u67e5\u8be2\u65f6\uff0c\u4f1a\u81ea\u52a8\u5c06\u7ed3\u679c\u5c01\u88c5\u5230\u5177\u4f53\u7684\u5206\u9875\u5bf9\u8c61\u4e2d\uff0c\u4f8b\u5982Page\u3002<\/p>\n\n\n\n
2. \u4fee\u6539XML\u6620\u5c04\u6587\u4ef6
\u5c06pageCC\u65b9\u6cd5\u7684\u8fd4\u56de\u7c7b\u578b\u4eceIPage\u6539\u4e3a\u5177\u4f53\u7684\u5b9e\u4f53\u7c7b\u578b\uff0c\u4f8b\u5982User\u3002<\/p>\n\n\n\n
\u55f7\u55f7\u4fee\u6539\u90e8\u5206xml\u5982\u4e0b\uff0c\u6210\u529f\u8fd0\u884c\uff01\uff01<\/p>\n\n\n\n
<select id=\"pageCC\" resultType=\"com.wms.entity.User\"><!--com.baomidou.mybatisplus.core.metadata.IPage-->\n        select * from user ${ew.customSqlSegment}\n    <\/select><\/code><\/pre>\n\n\n\n
\"\"<\/figure>\n","protected":false},"excerpt":{"rendered":"
\u4e00\u3001\u521b\u5efa\u540e\u7aef\u9879\u76ee 1. \u521b\u5efa\u6587\u4ef6\u5939spring_vue_wms2. \u6253\u5f00\u8fd9\u4e2a\u6587\u4ef6\u59393. \u53f3\u952e\u70b9\u51fb\u521b\u5efa\u65b0\u6a21\u5757(springboot) …<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"emotion":"","emotion_color":"","title_style":"","license":"","footnotes":""},"categories":[3],"tags":[19,20],"class_list":["post-716","post","type-post","status-publish","format-standard","hentry","category-3","tag-java","tag-20"],"_links":{"self":[{"href":"https:\/\/eve2333.top\/index.php?rest_route=\/wp\/v2\/posts\/716","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/eve2333.top\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/eve2333.top\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/eve2333.top\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/eve2333.top\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=716"}],"version-history":[{"count":2,"href":"https:\/\/eve2333.top\/index.php?rest_route=\/wp\/v2\/posts\/716\/revisions"}],"predecessor-version":[{"id":734,"href":"https:\/\/eve2333.top\/index.php?rest_route=\/wp\/v2\/posts\/716\/revisions\/734"}],"wp:attachment":[{"href":"https:\/\/eve2333.top\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=716"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/eve2333.top\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=716"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/eve2333.top\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=716"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}