代码拉取完成,页面将自动刷新
LambdaQuery 将支持通过Lambda进行多种数据源的查询 实现java端的简单数据的统一查询
<!--Mongo 查询器依赖-->
<dependency>
<groupId>com.github.xuejike</groupId>
<artifactId>lambda-query-mongo-starter</artifactId>
<version>${jkquery.version}</version>
</dependency>
<!--MybatisPlus 查询器依赖-->
<dependency>
<groupId>com.github.xuejike</groupId>
<artifactId>lambda-query-mybatis-plus-starter</artifactId>
<version>${jkquery.version}</version>
</dependency>
引入依赖
<!--Mongo 查询器依赖-->
<dependency>
<groupId>com.github.xuejike</groupId>
<artifactId>lambda-query-mongo</artifactId>
<version>${jkquery.version}</version>
</dependency>
<!--MybatisPlus 查询器依赖-->
<dependency>
<groupId>com.github.xuejike</groupId>
<artifactId>lambda-query-mybatis-plus</artifactId>
<version>${jkquery.version}</version>
</dependency>
初始化工厂类
// MongoDB 查询器初始化
@Bean
public MongoDaoFactory mongoDaoFactory(MongoTemplate mongoTemplate){
return new MongoDaoFactory(mongoTemplate);
}
// MybatisPlus 查询器初始化
@Bean
public MyBatisPlusDaoFactory myBatisPlusDaoFactory(Collection<BaseMapper> mapperCollection){
MyBatisPlusDaoFactory myBatisPlusDaoFactory = new MyBatisPlusDaoFactory(mapperCollection);
return myBatisPlusDaoFactory;
}
@Document("demo_doc")
@Data
// 采用mongo进行查询
@MongoDaoSelect
public class TestDoc {
@MongoId
private String id;
private String name;
private String title;
private Long num;
private List<Title> toc;
@Data
public static class Title{
private String title;
private String desc;
}
}
mybatis-plus 实体初始化
@Data
@TableName("u1")
@MyBatisPlusDaoSelect
public class U1 {
@TableId(type = IdType.AUTO)
private Long id;
private String name;
private String type;
}
@PostConstruct
public void init(){
LambdaQueryHttpConfig.getInstance().registerService("u1", U1.class);
HttpClientFactory httpClientFactory = new HttpClientFactory();
}
@HttpDaoSelect( serverAddress = "http://127.0.0.1:7000",path = "/lambda/u1/")
@Data
public class HttpEntity {
private Long id;
private String name;
private String type;
private Long u2Id;
}
@Test
public void list(){
JQuerys.lambdaQuery(HttpRequest.class).eq(HttpRequest::getName,"xxx").eq(HttpRequest::getUserName,"un").list();
}
/**
* == 查询
*/
@Test
public void testEq(){
List<TestDoc> list = JQuerys.lambdaQuery(TestDoc.class).eq(TestDoc::getName, "name_1").list();
Assertions.assertEquals(list.size(),1);
TestDoc testDoc = list.get(0);
Assertions.assertEquals(testDoc.getTitle(),"title_1");
}
/**
* 大于号查询
*
*/
@Test
public void testGt(){
List<TestDoc> list = JQuerys.lambdaQuery(TestDoc.class).gt(TestDoc::getNum,3 ).list();
Assertions.assertEquals(list.size(),1);
TestDoc testDoc = list.get(0);
Assertions.assertEquals(testDoc.getTitle(),"title_4");
}
/**
* 大于等于查询
*/
@Test
public void testGte(){
List<TestDoc> list = JQuerys.lambdaQuery(TestDoc.class).gte(TestDoc::getNum,4 ).list();
Assertions.assertEquals(list.size(),1);
TestDoc testDoc = list.get(0);
Assertions.assertEquals(testDoc.getTitle(),"title_4");
}
/**
* 小于号查询
*/
@Test
public void testLt(){
List<TestDoc> list = JQuerys.lambdaQuery(TestDoc.class).lt(TestDoc::getNum,1 ).list();
Assertions.assertEquals(list.size(),1);
TestDoc testDoc = list.get(0);
Assertions.assertEquals(testDoc.getTitle(),"title_0");
}
/**
* 小于等于查询
*/
@Test
public void testLte(){
List<TestDoc> list = JQuerys.lambdaQuery(TestDoc.class).lte(TestDoc::getNum,0 ).list();
Assertions.assertEquals(list.size(),1);
TestDoc testDoc = list.get(0);
Assertions.assertEquals(testDoc.getTitle(),"title_0");
}
/**
* In 查询
*/
@Test
public void testIn(){
List<TestDoc> list = JQuerys.lambdaQuery(TestDoc.class)
.in(TestDoc::getTitle,"title_0" ).list();
Assertions.assertEquals(list.size(),1);
TestDoc testDoc = list.get(0);
Assertions.assertEquals(testDoc.getTitle(),"title_0");
}
/**
* NotIn 查询
*/
@Test
public void testNotIn(){
List<TestDoc> list = JQuerys.lambdaQuery(TestDoc.class)
.notIn(TestDoc::getTitle,"title_0","title_1","title_2","title_3" ).list();
Assertions.assertEquals(list.size(),1);
TestDoc testDoc = list.get(0);
Assertions.assertEquals(testDoc.getTitle(),"title_4");
}
/**
* or 查询
*/
@Test
public void testOr(){
List<TestDoc> list = JQuerys.lambdaQuery(TestDoc.class).or().eq(TestDoc::getNum, 0).or().eq(TestDoc::getNum, 1).list();
Assertions.assertEquals(list.size(),2);
list = JQuerys.lambdaQuery(TestDoc.class).or(it->{
it.eq(TestDoc::getNum,0).eq(TestDoc::getName,"name_0");
}).or(it->{
it.eq(TestDoc::getNum,1).eq(TestDoc::getName,"name_1");
}).list();
Assertions.assertEquals(list.size(),2);
}
/**
* 排序查询
*/
@Test
public void testOrder(){
List<TestDoc> list = JQuerys.lambdaQuery(TestDoc.class).in(TestDoc::getNum, 1, 2).orderAsc(TestDoc::getNum).list();
Assertions.assertEquals(list.size(),2);
Assertions.assertEquals(list.get(0).getNum(),1);
Assertions.assertEquals(list.get(1).getNum(),2);
list = JQuerys.lambdaQuery(TestDoc.class).in(TestDoc::getNum, 1, 2).orderDesc(TestDoc::getNum).list();
Assertions.assertEquals(list.size(),2);
Assertions.assertEquals(list.get(0).getNum(),2);
Assertions.assertEquals(list.get(1).getNum(),1);
}
/**
* 二级字段查询
*/
@Test
public void testSubField(){
List<TestDoc> list = JQuerys.lambdaQuery(TestDoc.class).eq(of().subList(TestDoc::getToc).sub(TestDoc.Title::getTitle), "sub_title_0_0").list();
Assertions.assertEquals(list.size(),1);
Assertions.assertEquals(list.get(0).getNum(),0);
}
public CascadeField<TestDoc,TestDoc> of(){
return new CascadeField<>();
}
采用selectIn 和并行计算方式进行 join查询合并
@GetMapping("list")
public Object testList(){
JLambdaQuery<HttpEntity> query = JQuerys.lambdaQuery(HttpEntity.class);
Object list = query.or().eq(HttpEntity::getName,"name1").or()
.eq(HttpEntity::getName,"name2")
// 属性 u2Id 关联实体 U2 的id字段,并映射结果到U1Vo
.loadRef(HttpEntity::getU2Id, U2.class,U2::getId).map(U1Vo.class).list();
return list;
}
@Data
public class U1Vo {
private Long id;
private String name;
private String type;
@SetRefValue("u2")
private Long u2Id;
@RefValue("#u2.name")
private String u2Name;
}
此处可能存在不合适展示的内容,页面不予展示。您可通过相关编辑功能自查并修改。
如您确认内容无涉及 不当用语 / 纯广告导流 / 暴力 / 低俗色情 / 侵权 / 盗版 / 虚假 / 无价值内容或违法国家有关法律法规的内容,可点击提交进行申诉,我们将尽快为您处理。