{"id":1707,"date":"2021-04-05T23:01:59","date_gmt":"2021-04-05T15:01:59","guid":{"rendered":"https:\/\/199604.com\/?p=1707"},"modified":"2021-04-05T23:04:42","modified_gmt":"2021-04-05T15:04:42","slug":"mybatis-plus%e4%bd%bf%e7%94%a8%e6%8a%80%e5%b7%a7","status":"publish","type":"post","link":"https:\/\/199604.com\/1707","title":{"rendered":"MyBatis-Plus\u4f7f\u7528\u6280\u5de7"},"content":{"rendered":"

\u6700\u8fd1\u5728\u7528 Mybatis-Plus\uff0c\u55ef\uff0c\u662f\u771f\u4ed6\u5988\u9999\uff01\uff01\uff01\u4eca\u5929\u5c31\u6765\u8bf4\u8bf4 Mybatis-Plus \u7684\u90a3\u4e9b\u4f7f\u7528\u6280\u5de7<\/strong><\/p>\n

\u521b\u5efauser\u8868<\/h4>\n
DROP TABLE IF EXISTS user;\r\nCREATE TABLE user\r\n(\r\nid BIGINT(20) NOT NULL COMMENT '\u4e3b\u952eID',\r\nname VARCHAR(30) NULL DEFAULT NULL COMMENT '\u59d3\u540d',\r\nage INT(11) NULL DEFAULT NULL COMMENT '\u5e74\u9f84',\r\nemail VARCHAR(50) NULL DEFAULT NULL COMMENT '\u90ae\u7bb1',\r\nPRIMARY KEY (id)\r\n);\r\nINSERT INTO user (id, name, age, email) VALUES\r\n(1, 'glj1', 18, 'test1@199604.com'),\r\n(2, 'glj1', 20, 'test2@199604.com'),\r\n(3, 'glj1', 28, 'test3@199604.com'),\r\n(4, 'glj1', 21, 'test4@199604.com'),\r\n(5, 'glj1', 24, 'test5@199604.com');\r\n<\/code><\/pre>\n
\u6ce8\u610f\uff1a– \u771f\u5b9e\u5f00\u53d1\u4e2d\u5f80\u5f80\u90fd\u4f1a\u6709\u8fd9\u56db\u4e2a\u5b57\u6bb5\uff0cversion\uff08\u4e50\u89c2\u9501\uff09\u3001deleted\uff08\u903b\u8f91\u5220\u9664\uff09\u3001gmt_create\uff08\u521b\u5efa\u65f6\u95f4\uff09\u3001gmt_modified\uff08\u4fee\u6539\u65f6\u95f4\uff09<\/p>\n
\u5bfc\u5165\u4f9d\u8d56<\/strong><\/h4>\n
<!-- \u6570\u636e\u5e93\u9a71\u52a8 -->\r\n<dependency>\r\n\t<groupId>mysql<\/groupId>\r\n\t<artifactId>mysql-connector-java<\/artifactId>\r\n<\/dependency>\r\n<!-- lombok -->\r\n<dependency>\r\n\t<groupId>org.projectlombok<\/groupId>\r\n\t<artifactId>lombok<\/artifactId>\r\n<\/dependency>\r\n<!-- mybatis-plus -->\r\n<!-- mybatis-plus \u662f\u81ea\u5df1\u5f00\u53d1\uff0c\u5e76\u975e\u5b98\u65b9\u7684\uff01-->\r\n<dependency>\r\n\t<groupId>com.baomidou<\/groupId>\r\n\t<artifactId>mybatis-plus-boot-starter<\/artifactId>\r\n\t<version>3.4.2<\/version>\r\n<\/dependency>\r\n<\/code><\/pre>\n
\u521b\u5efaapplication.yml<\/strong><\/h4>\n
spring:\r\n  datasource:\r\n    url: jdbc:mysql:\/\/127.0.0.1:3306\/txds?useUnicode=true&characterEncoding=UTF-8&zeroDateTimeBehavior=convertToNull&allowMultiQueries=true&useSSL=false\r\n#    driver-class-name: com.mysql.jdbc.Driver\r\n    username: root\r\n    password: root\r\n    driver-class-name: com.mysql.cj.jdbc.Driver\r\n<\/code><\/pre>\n
\u4e1a\u52a1\u4ee3\u7801<\/strong><\/h4>\n
\u5b9e\u4f53\u7c7b<\/h5>\n
package com.glj.securitydemo.pojo;\r\n\r\nimport com.baomidou.mybatisplus.annotation.*;\r\nimport lombok.AllArgsConstructor;\r\nimport lombok.Data;\r\nimport lombok.NoArgsConstructor;\r\n\r\nimport java.util.Date;\r\n\r\n\/**\r\n * Created with IntelliJ IDEA.\r\n *\r\n * @Author: GuoLiangJun\r\n * @Date: 2021\/3\/26\r\n * @Time: 17:26\r\n *\/\r\n@Data\r\n@AllArgsConstructor\r\n@NoArgsConstructor\r\npublic class User {\r\n    @TableId(type = IdType.AUTO)\r\n    private Long id;\r\n    private String name;\r\n    private Integer age;\r\n    private String email;\r\n}\r\n\r\n<\/code><\/pre>\n
mapper\u63a5\u53e3<\/h5>\n
package com.glj.securitydemo.mapper;\r\n\r\nimport com.baomidou.mybatisplus.core.mapper.BaseMapper;\r\nimport com.glj.securitydemo.pojo.User;\r\nimport org.springframework.stereotype.Repository;\r\n\r\n\/**\r\n * @author jiomer\r\n *\/\r\n@Repository\r\npublic interface UserMapper extends BaseMapper<User> {\r\n\r\n}\r\n\r\n<\/code><\/pre>\n
\u6ce8\u610f\u70b9\uff0c\u6211\u4eec\u9700\u8981\u5728\u4e3b\u542f\u52a8\u7c7b\u4e0a\u53bb\u626b\u63cf\u6211\u4eec\u7684mapper\u5305\u4e0b\u7684\u6240\u6709\u63a5\u53e3 @MapperScan(value = “com.glj.securitydemo.mapper”)<\/p><\/blockquote>\n
\u6d4b\u8bd5<\/h4>\n
@RunWith(SpringRunner.class)\r\n@SpringBootTest\r\npublic class SecuritydemoApplicationTests {\r\n\r\n    @Autowired\r\n    private UserMapper userMapper;\r\n\r\n    @Test\r\n    public void testSelect() {\r\n        List<User> userList = userMapper.selectList(null);\r\n        userList.forEach(System.out::println);\r\n    }\r\n}    \r\n<\/code><\/pre>\n
\u914d\u7f6e\u65e5\u5fd7<\/strong><\/h4>\n
application.yml\u6587\u4ef6\u6dfb\u52a0\u65e5\u5fd7\u914d\u7f6e:<\/p>\n
mybatis-plus:\r\n  configuration:\r\n    log-impl: org.apache.ibatis.logging.stdout.StdOutImpl\r\n<\/code><\/pre>\n
Mybatis-plus\u7684CRUD<\/h4>\n
\u63d2\u5165\u64cd\u4f5c<\/strong><\/h5>\n
\t@Test\r\n    public void testInsertUser(){\r\n        User user = new User();\r\n        user.setName(\"glj1\");\r\n        user.setAge(24);\r\n        user.setEmail(\"admin@199604.com\");\r\n        int result = userMapper.insert(user);\r\n        System.out.println(\"result:\"+result);\r\n        System.out.println(\"user:\"+user);\r\n    }\r\n<\/code><\/pre>\n
\u770b\u5230id\u4f1a\u81ea\u52a8\u586b\u5145\u3002\u6570\u636e\u5e93\u63d2\u5165\u7684id\u7684\u9ed8\u8ba4\u503c\u4e3a\uff1a\u5168\u5c40\u7684\u552f\u4e00id<\/p>\n
\u4e3b\u952e\u751f\u6210\u7b56\u7565<\/strong><\/h6>\n
1\uff09\u4e3b\u952e\u81ea\u589e 1\u3001\u5b9e\u4f53\u7c7b\u5b57\u6bb5\u4e0a @TableId(type = IdType.AUTO)<\/p>\n
@Tableid<\/strong><\/p>\n