{"id":751,"date":"2020-02-01T11:26:12","date_gmt":"2020-02-01T03:26:12","guid":{"rendered":"http:\/\/prayerlaputa.com\/?p=751"},"modified":"2020-02-01T11:26:39","modified_gmt":"2020-02-01T03:26:39","slug":"mybatis-plus-select%e4%b8%8d%e5%88%97%e5%87%ba%e5%85%a8%e9%83%a8%e5%ad%97%e6%ae%b5%ef%bc%8c%e5%8f%aa%e6%9f%a5%e8%af%a2%e9%83%a8%e5%88%86%e5%ad%97%e6%ae%b5","status":"publish","type":"post","link":"http:\/\/prayerlaputa.com\/?p=751","title":{"rendered":"Mybatis-Plus select\u4e0d\u5217\u51fa\u5168\u90e8\u5b57\u6bb5\uff0c\u53ea\u67e5\u8be2\u90e8\u5206\u5b57\u6bb5"},"content":{"rendered":"

mybatis-plus select\u67e5\u8be2\u8bed\u53e5\u9ed8\u8ba4\u662f\u67e5\u5168\u90e8\u5b57\u6bb5\uff0c\u6709\u4e24\u79cd\u65b9\u6cd5\u53ef\u4ee5\u6307\u5b9a\u8981\u67e5\u8be2\u7684\u5b57\u6bb5<\/p>\n

\u5047\u5b9a\u8868\u7ed3\u6784\u5982\u4e0b\uff1a<\/p>\n

CREATE TABLE `user` (\r\n  `id` bigint(20) NOT NULL COMMENT '\u4e3b\u952e',\r\n  `name` varchar(30) DEFAULT NULL COMMENT '\u59d3\u540d',\r\n  `age` int(11) DEFAULT NULL COMMENT '\u5e74\u9f84',\r\n  `email` varchar(50) DEFAULT NULL COMMENT '\u90ae\u7bb1',\r\n  `manager_id` bigint(20) DEFAULT NULL COMMENT '\u76f4\u5c5e\u4e0a\u7ea7id',\r\n  `create_time` datetime DEFAULT NULL COMMENT '\u521b\u5efa\u65f6\u95f4'\r\n) ENGINE=InnoDB DEFAULT CHARSET=utf8;\r\n<\/code><\/pre>\n
\u5047\u8bbe\u76ee\u524d\u4ec5\u9700\u8981\u67e5\u8be2name,age\u4e24\u4e2a\u5b57\u6bb5\u3002<\/p>\n
\u65b9\u6cd51\uff1a\u53ea\u9700\u8981\u67e5\u8be2\u51faname\u548cage\u4e24\u4e2a\u5b57\u6bb5:\u4f7f\u7528queryWrapper\u7684select()\u65b9\u6cd5\u6307\u5b9a\u8981\u67e5\u8be2\u7684\u5b57\u6bb5<\/h3>\n
    @Test\r\n    public void selectByWrapper1() {\r\n        QueryWrapper<User> queryWrapper = new QueryWrapper<>();\r\n        queryWrapper.select(\"name\", \"age\").like(\"name\", \"\u96e8\");\r\n        List<User> users = userMapper.selectList(queryWrapper);\r\n        users.forEach(System.out::println);\r\n    }\r\n<\/code><\/pre>\n
\u65b9\u6cd52\uff1a\u67e5\u8be2\u51fa\u9664manager_id\u548ccreate_time\u5916\u5176\u5b83\u6240\u6709\u5b57\u6bb5\u7684\u6570\u636e\uff1a\u540c\u6837\u4f7f\u7528queryWrapper\u7684select()\u65b9\u6cd5<\/h3>\n
    @Test\r\n    public void selectByWrapper2() {\r\n        QueryWrapper<User> queryWrapper = new QueryWrapper<>();\r\n        queryWrapper.select(User.class, info -> !info.getColumn().equals(\"manager_id\")\r\n                && !info.getColumn().equals(\"create_time\"));\r\n        List<User> users = userMapper.selectList(queryWrapper);\r\n        users.forEach(System.out::println);\r\n    }\r\n<\/code><\/pre>\n
\u53c2\u8003\u8d44\u6599<\/h3>\n