九阴真经


基本查询

<h3>MyBatisPlus基础查询使用:</h3> <ul> <li> <p>1:多条件查询&amp;排序:</p> <pre><code>QueryWrapper&lt;User&gt; queryWrapper = new QueryWrapper&lt;&gt;(); queryWrapper.lambda().ge(User::getId, 100).orderByDesc(User::getId); list = userService.list(queryWrapper);</code></pre> </li> <li> <p>2:模糊查询:</p> <pre><code>QueryWrapper&lt;User&gt; queryWrapper=new QueryWrapper&lt;&gt;(); queryWrapper.lambda().like(User::getId,12); List&lt;User&gt; list = userService.list(queryWrapper); for (User user : list) { System.out.println(user.toString()); }</code></pre> </li> <li>3:根据Wrapper更新:</li> </ul> <pre><code>//根据wrapper 更新 LambdaQueryWrapper&lt;User&gt; updateWrapper = new QueryWrapper&lt;User&gt;().lambda().eq(User::getId, 101); User user = new User(); user.setUsername("东方不败"); user.setCreateDate(new Date()); boolean update_flag = userService.update(user, updateWrapper);</code></pre> <ul> <li>4:只查询一行:</li> </ul> <pre><code>LambdaQueryWrapper&lt;User&gt; queyr = new LambdaQueryWrapper&lt;User&gt;().eq(User::getId, 1); User one = userService.getOne(queyr);</code></pre> <ul> <li>5:统计:</li> </ul> <pre><code> LambdaQueryWrapper&lt;User&gt; queyr = new LambdaQueryWrapper&lt;User&gt;().eq(User::getId, 1); int count = userService.count(queyr);</code></pre>

页面列表

ITEM_HTML