lambda四种表达形式
前言
使用了lambda表达式 可以通过方法引用的方式来使用实体字段名的操作,避免直接写数据库表字段名时的错写名字;
一、LambdaQueryWrapper<>
二、QueryWrapper<实体>().lambda()
三、Wrappers.<实体>lambdaQuery()
/** * lambda 条件构造器 * 生成的sql语句 SELECT id,name,age,email,manager_id,create_time FROM user WHERE name LIKE ? AND age < ? */ @Test public void selectLambda() { //创建lambda 条件构造器 的三种方法 // LambdaQueryWrapper<User> lambda2 = new LambdaQueryWrapper<>(); // LambdaQueryWrapper<User> lambda = new QueryWrapper<User>().lambda(); LambdaQueryWrapper<User> lambda3 = Wrappers.<User>lambdaQuery(); lambda3.like(User::getName, "雨").lt(User::getAge, 40); List<User> users = userMapper.selectList(lambda3); users.forEach(System.out::println);
<span class="token punctuation">}</span>
- 1
- 2
- 3
- 4
- 5
- 6
- 7
- 8
- 9
- 10
- 11
- 12
- 13
- 14
- 15
- 16
/** * 名字为王姓并且(年龄小于40并且邮箱不为空) * name like '王%' and (age <40 or email in not null) * 生成的sql语句 SELECT id,name,age,email,manager_id,create_time FROM user WHERE name LIKE ? AND age < ? */ @Test public void selectLambda2() { LambdaQueryWrapper<User> lambda3 = Wrappers.<User>lambdaQuery(); lambda3.likeRight(User::getName, "王").and(qw -> qw.lt(User::getAge, 40).or().isNotNull(User::getEmail));
List<span class="token generics function"><span class="token punctuation"><</span>User<span class="token punctuation">></span></span> users <span class="token operator">=</span> userMapper<span class="token punctuation">.</span><span class="token function">selectList</span><span class="token punctuation">(</span>lambda3<span class="token punctuation">)</span><span class="token punctuation">;</span> users<span class="token punctuation">.</span><span class="token function">forEach</span><span class="token punctuation">(</span>System<span class="token punctuation">.</span>out<span class="token operator">:</span><span class="token operator">:</span>println<span class="token punctuation">)</span><span class="token punctuation">;</span>
}
- 1
- 2
- 3
- 4
- 5
- 6
- 7
- 8
- 9
- 10
- 11
- 12
- 13
- 14
- 15
/** * 自定义sql 使用 * Dao层 代码: * * @Select("select * from ${ew.customSqlSegment}") * List<User> selectAll(@Param(Constants.WRAPPER)Wrapper<User> wrapper); */ @Test public void selectLambda4my() { LambdaQueryWrapper<User> lambda3 = Wrappers.<User>lambdaQuery(); lambda3.likeRight(User::getName, "王").and(qw -> qw.lt(User::getAge, 40).or().isNotNull(User::getEmail));
List<span class="token generics function"><span class="token punctuation"><</span>User<span class="token punctuation">></span></span> users <span class="token operator">=</span> userMapper<span class="token punctuation">.</span><span class="token function">selectAll</span><span class="token punctuation">(</span>lambda3<span class="token punctuation">)</span><span class="token punctuation">;</span> users<span class="token punctuation">.</span><span class="token function">forEach</span><span class="token punctuation">(</span>System<span class="token punctuation">.</span>out<span class="token operator">:</span><span class="token operator">:</span>println<span class="token punctuation">)</span><span class="token punctuation">;</span>
}
- 1
- 2
- 3
- 4
- 5
- 6
- 7
- 8
- 9
- 10
- 11
- 12
- 13
- 14
- 15
- 16
- 17
- 18
xml方式自定义sql 这里只是个单表演示application.yml 添加
mybatis-plus: mapper-locations: - com/mp/mapper/*
- 1
- 2
UserMapper 接口 添加方法
List<User> selectAll(@Param(Constants.WRAPPER) Wrapper<User> wrapper);IPage<User> selectUserPage(Page<User> page,@Param(Constants.WRAPPER)Wrapper<User> wrapper);
- 1
UserMpper.xml
<?xml version="1.0" encoding="UTF-8"?> <!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd"> <mapper namespace="com.mp.dao.UserMapper"> <select id="selectAll" resultType="com.mp.entity.User"> select * from user ${ew.customSqlSegment} </select>
<span class="token tag"><span class="token tag"><span class="token punctuation"><</span>select</span> <span class="token attr-name">id</span><span class="token attr-value"><span class="token punctuation">=</span><span class="token punctuation">"</span>selectUserPage<span class="token punctuation">"</span></span> <span class="token attr-name">resultType</span><span class="token attr-value"><span class="token punctuation">=</span><span class="token punctuation">"</span>com.mp.entity.User<span class="token punctuation">"</span></span><span class="token punctuation">></span></span> select * from user ${ew.customSqlSegment} <span class="token tag"><span class="token tag"><span class="token punctuation"></</span>select</span><span class="token punctuation">></span></span>
</mapper>
- 1
- 2
- 3
- 4
- 5
- 6
- 7
- 8
- 9
- 10
- 11
- 12
- 13
四、LambdaQueryChainWrapper<实体>(xxxxMapper)
/** * lambda 条件构造器第四种创建方式 MP 3.0.7 新增的方式 * 生成的sql语句 SELECT id,name,age,email,manager_id,create_time FROM user WHERE name LIKE ? AND age >= ? * 这个例子可以看出 代码更简洁了 * 生成的sql语句 SELECT id,name,age,email,manager_id,create_time FROM user WHERE name LIKE ? AND age >= ? */ @Test public void selectLambda3() { List<User> users = new LambdaQueryChainWrapper<User>(userMapper) .like(User::getName, "雨").ge(User::getAge, 20).list();
users<span class="token punctuation">.</span><span class="token function">forEach</span><span class="token punctuation">(</span>System<span class="token punctuation">.</span>out<span class="token operator">:</span><span class="token operator">:</span>println<span class="token punctuation">)</span><span class="token punctuation">;</span>
}
- 1
- 2
- 3
- 4
- 5
- 6
- 7
- 8
- 9
- 10
- 11
- 12
- 13
五、lambda在分页中的应用
MP的分页操作
baseMapper接口提供两种分页方法来实现物理分页(注:导包时导MP的包)第一个返回实体对象 允许null 第二个人返回map 对象多用于在指定放回字段时使用,避免为指定字段null值出现
IPage<T> selectPage(IPage<T> page, @Param("ew") Wrapper<T> queryWrapper);
IPage<span class="token operator"><</span>Map<span class="token generics function"><span class="token punctuation"><</span>String<span class="token punctuation">,</span> Object<span class="token punctuation">></span></span><span class="token operator">></span> <span class="token function">selectMapsPage</span><span class="token punctuation">(</span>IPage<span class="token generics function"><span class="token punctuation"><</span>T<span class="token punctuation">></span></span> page<span class="token punctuation">,</span> <span class="token annotation punctuation">@Param</span><span class="token punctuation">(</span><span class="token string">"ew"</span><span class="token punctuation">)</span> Wrapper<span class="token generics function"><span class="token punctuation"><</span>T<span class="token punctuation">></span></span> queryWrapper<span class="token punctuation">)</span><span class="token punctuation">;</span>
- 1
- 2
- 3
使用MP的分页需要配置 类
package com.mp.configuration;
import com.baomidou.mybatisplus.extension.plugins.PaginationInterceptor;
import org.springframework.context.annotation.Bean;
import org.springframework.context.annotation.Configuration;
@Configuration
public class MybatisPlusConfig {
<span class="token annotation punctuation">@Bean</span>
<span class="token keyword">public</span> PaginationInterceptor <span class="token function">paginationInterceptor</span><span class="token punctuation">(</span><span class="token punctuation">)</span> <span class="token punctuation">{<!-- --></span>
<span class="token keyword">return</span> <span class="token keyword">new</span> <span class="token class-name">PaginationInterceptor</span><span class="token punctuation">(</span><span class="token punctuation">)</span><span class="token punctuation">;</span>
<span class="token punctuation">}</span>
}
- 1
- 2
- 3
- 4
- 5
- 6
- 7
- 8
- 9
- 10
- 11
- 12
- 13
- 14
- 15
/** * 分页MP 分页插件 */ @Test public void selectPage() { QueryWrapper<User> queryWrapper = new QueryWrapper<User>(); queryWrapper.ge("age", 26); //后面参数false 表示不查询总记录数 Page<User> userPage = new Page<>(1, 2, false); /* IPage<User> iPage = userMapper.selectPage(userPage, queryWrapper); System.out.println("总页数"+iPage.getPages()); System.out.println("总记录数"+iPage.getTotal()); List<User> records = iPage.getRecords(); records.forEach(System.out::println); */ IPage<Map<String, Object>> iPage = userMapper.selectMapsPage(userPage, queryWrapper); System.out.println("总页数" + iPage.getPages()); System.out.println("总记录数" + iPage.getTotal()); List<Map<String, Object>> records = iPage.getRecords();
records<span class="token punctuation">.</span><span class="token function">forEach</span><span class="token punctuation">(</span>System<span class="token punctuation">.</span>out<span class="token operator">:</span><span class="token operator">:</span>println<span class="token punctuation">)</span><span class="token punctuation">;</span>
}
- 1
- 2
- 3
- 4
- 5
- 6
- 7
- 8
- 9
- 10
- 11
- 12
- 13
- 14
- 15
- 16
- 17
- 18
- 19
- 20
- 21
- 22
- 23
自定义分页
UserMapper接口
IPage<User> selectUserPage(Page<User> page,@Param(Constants.WRAPPER)Wrapper<User> wrapper);
- 1
UserMpper.xml 添加
<select id="selectUserPage" resultType="com.mp.entity.User">
select * from user ${ew.customSqlSegment}
</select>
- 1
- 2
- 3
/** * 自定义分页方法 */ @Test public void selectMyPage() { QueryWrapper<User> queryWrapper = new QueryWrapper<User>(); queryWrapper.ge("age", 26); //后面参数false 表示不查询总记录数 Page<User> page = new Page<>(1, 2);
IPage<span class="token generics function"><span class="token punctuation"><</span>User<span class="token punctuation">></span></span> iPage <span class="token operator">=</span> userMapper<span class="token punctuation">.</span><span class="token function">selectUserPage</span><span class="token punctuation">(</span>page<span class="token punctuation">,</span> queryWrapper<span class="token punctuation">)</span><span class="token punctuation">;</span> System<span class="token punctuation">.</span>out<span class="token punctuation">.</span><span class="token function">println</span><span class="token punctuation">(</span><span class="token string">"总页数"</span> <span class="token operator">+</span> iPage<span class="token punctuation">.</span><span class="token function">getPages</span><span class="token punctuation">(</span><span class="token punctuation">)</span><span class="token punctuation">)</span><span class="token punctuation">;</span> System<span class="token punctuation">.</span>out<span class="token punctuation">.</span><span class="token function">println</span><span class="token punctuation">(</span><span class="token string">"总记录数"</span> <span class="token operator">+</span> iPage<span class="token punctuation">.</span><span class="token function">getTotal</span><span class="token punctuation">(</span><span class="token punctuation">)</span><span class="token punctuation">)</span><span class="token punctuation">;</span> List<span class="token generics function"><span class="token punctuation"><</span>User<span class="token punctuation">></span></span> records <span class="token operator">=</span> iPage<span class="token punctuation">.</span><span class="token function">getRecords</span><span class="token punctuation">(</span><span class="token punctuation">)</span><span class="token punctuation">;</span> records<span class="token punctuation">.</span><span class="token function">forEach</span><span class="token punctuation">(</span>System<span class="token punctuation">.</span>out<span class="token operator">:</span><span class="token operator">:</span>println<span class="token punctuation">)</span><span class="token punctuation">;</span>
}
- 1
- 2
- 3
- 4
- 5
- 6
- 7
- 8
- 9
- 10
- 11
- 12
- 13
- 14
- 15
- 16
- 17