#LambdaQueryWrapper,QueryWrapper,lambda表达式,获取list集合
ProjectMsg projectMsg = new ProjectMsg();
projectMsg.setXqxmbm("123456789");
第一种使用lamdbaQueryWrapper
List<ProjectMsg> list = projectMsgService
.list(Wrappers.<ProjectMsg>query()
.lambda()
.eq(ProjectMsg::getXqxmbm, projectMsg.getXqxmbm())
.ne(ProjectMsg::getScbz, "1"));
for (ProjectMsg msg : list) {
System.out.println("msg = " + msg.toString());
//msg = ProjectMsg(ywwym=1, csxmmc=null, csxmbm=null, xqxmbm=123456789, kyxmbm=null, fxmbm=null, zxmbm=null, xmmc=需求项目, fxmmc=, zxmmc=null, bzdwbm=null, bzdwmc=null, bzrgh=001, bzrmc=null, bzdw=渤海新能, bzr=张三, sssgs=浙江, ssxgs=杭州, sssgsbm=null, ssxgsbm=null, dydj=10kV, sysdgf=架空, htyj=null, gds=浙江供电所, rwxdsj=Fri Sep 25 00:00:00 CST 2020, rwzt=未进行, jhnd=2020, jxnd=null, zycd=重要, xmjb=一级, zcxz=私有, xmlx=一般, gcjd=需求编制, ywbm=null, gfbm=null, scbz=0)
}
第一种拆分变为第二种
LambdaQueryWrapper<ProjectMsg> lambda = Wrappers.<ProjectMsg>query().lambda();
lambda.eq(ProjectMsg::getXqxmbm, projectMsg.getXqxmbm());
lambda.ne(ProjectMsg::getScbz,"1");
List<ProjectMsg> list1 = projectMsgService.list(lambda);
for (ProjectMsg msg : list1) {
System.out.println("msg1 = " + msg.toString());
//msg1 = ProjectMsg(ywwym=1, csxmmc=null, csxmbm=null, xqxmbm=123456789, kyxmbm=null, fxmbm=null, zxmbm=null, xmmc=需求项目, fxmmc=, zxmmc=null, bzdwbm=null, bzdwmc=null, bzrgh=001, bzrmc=null, bzdw=渤海新能, bzr=张三, sssgs=浙江, ssxgs=杭州, sssgsbm=null, ssxgsbm=null, dydj=10kV, sysdgf=架空, htyj=null, gds=浙江供电所, rwxdsj=Fri Sep 25 00:00:00 CST 2020, rwzt=未进行, jhnd=2020, jxnd=null, zycd=重要, xmjb=一级, zcxz=私有, xmlx=一般, gcjd=需求编制, ywbm=null, gfbm=null, scbz=0)
}
第三种使用wrapper构造器和lamdba
QueryWrapper<ProjectMsg> wrapper1 = new QueryWrapper<>();
LambdaQueryWrapper<ProjectMsg> wrapper2 = wrapper1.lambda().eq(ProjectMsg::getXqxmbm, projectMsg.getXqxmbm()).ne(ProjectMsg::getScbz, "2");
List<ProjectMsg> list3 = projectMsgService.list(wrapper2);
for (ProjectMsg msg : list3) {
System.out.println("msg3 = " + msg.toString());
//msg3 = ProjectMsg(ywwym=1, csxmmc=null, csxmbm=null, xqxmbm=123456789, kyxmbm=null, fxmbm=null, zxmbm=null, xmmc=需求项目, fxmmc=, zxmmc=null, bzdwbm=null, bzdwmc=null, bzrgh=001, bzrmc=null, bzdw=渤海新能, bzr=张三, sssgs=浙江, ssxgs=杭州, sssgsbm=null, ssxgsbm=null, dydj=10kV, sysdgf=架空, htyj=null, gds=浙江供电所, rwxdsj=Fri Sep 25 00:00:00 CST 2020, rwzt=未进行, jhnd=2020, jxnd=null, zycd=重要, xmjb=一级, zcxz=私有, xmlx=一般, gcjd=需求编制, ywbm=null, gfbm=null, scbz=0)
}
第四中只使用wrapper构造器,不适用lambda表达式
QueryWrapper<ProjectMsg> wrapper = new QueryWrapper<>();
wrapper.eq("xqxmbm",projectMsg.getXqxmbm());
wrapper.ne("scbz","1");
List<ProjectMsg> list2 = projectMsgService.list(wrapper);
for (ProjectMsg msg : list2) {
System.out.println("msg2 = " + msg.toString());
//msg2 = ProjectMsg(ywwym=1, csxmmc=null, csxmbm=null, xqxmbm=123456789, kyxmbm=null, fxmbm=null, zxmbm=null, xmmc=需求项目, fxmmc=, zxmmc=null, bzdwbm=null, bzdwmc=null, bzrgh=001, bzrmc=null, bzdw=渤海新能, bzr=张三, sssgs=浙江, ssxgs=杭州, sssgsbm=null, ssxgsbm=null, dydj=10kV, sysdgf=架空, htyj=null, gds=浙江供电所, rwxdsj=Fri Sep 25 00:00:00 CST 2020, rwzt=未进行, jhnd=2020, jxnd=null, zycd=重要, xmjb=一级, zcxz=私有, xmlx=一般, gcjd=需求编制, ywbm=null, gfbm=null, scbz=0)
}
三种获取List<实体>的方式,其结果一样