剛開(kāi)源了一個(gè)經(jīng)過(guò)完整測(cè)試的Java工具類(lèi)。
地址如下：
https://github.com/Jimmy-Shi/bean-query
使用說(shuō)明如下：
Bean-query
Click Here for English version.
BeanQuery 是一個(gè)把對(duì)象轉(zhuǎn)換為Map的Java工具庫(kù)。支持選擇Bean中的一些屬性，對(duì)結(jié)果進(jìn)行排序和按照條件查詢(xún)。不僅僅可以作用于頂層對(duì)象，也可以作用于子對(duì)象。
BeanQuery的使用非常簡(jiǎn)單也很直接，例子代碼如下：
1 //靜態(tài)導(dǎo)入BeanQuery
2 import static cn.jimmyshi.beanquery.BeanQuery.*;
3
4
5 //使用 select、from、where、orderBy、desc和asc來(lái)組裝一個(gè)Query，然后執(zhí)行execute方法來(lái)獲得結(jié)果。
6 List<Map<String, Object>> result = select("price,name,mainAuthor.name as mainAuthorName")
7 .from(bookCollection)
8 .where(
9 //for books name is Book2 or starts with Book1
10 anyOf(
11 value("name", startsWith("Book1")),
12 value("name", is("Book2"))
13 ),
14 //for books price between (53,65)
15 allOf(
16 value("price", greaterThan(53d)),
17 value("price",lessThan(65d))
18 )
19 )
20 .orderBy("name").desc()
21 .execute();
在上面的例子中，bookCollection的內(nèi)容如下所示(json格式)
[
{
"price":55.55,
"name":"Book1",
"mainAuthor":{
"name":"Book1-MainAuthor",
"address":{
"address":"Shenzhen Guangdong China",
"postCode":"518000"
},
"birthDate":"1982-01-30T14:52:39"
}
},
{
"price":52.55,
"name":"Book12",
"mainAuthor":{
"name":"Book1-MainAuthor",
"address":{
"address":"Shenzhen Guangdong China",
"postCode":"518000"
},
"birthDate":"1982-01-30T14:52:39"
}
},
{
"price":53.55,
"name":"Book13",
"mainAuthor":{
"name":"Book13-MainAuthor",
"address":{
"address":"Shenzhen Guangdong China",
"postCode":"518000"
},
"birthDate":"1982-01-30T14:52:39"
}
},
{
"price":60.0,
"name":"Book14",
"mainAuthor":{
"name":"Book14-MainAuthor",
"address":{
"address":"Shenzhen Guangdong China",
"postCode":"518000"
},
"birthDate":"1982-01-30T14:52:39"
}
},
{
"price":50.55,
"name":"Book15",
"mainAuthor":{
"name":"Book1-MainAuthor",
"address":{
"address":"Shenzhen Guangdong China",
"postCode":"518000"
},
"birthDate":"1982-01-30T14:52:39"
}
},
{
"price":77.77,
"name":"Book3",
"mainAuthor":{
"name":"Book3-MainAuthor",
"address":{
"address":"Shenzhen Guangdong China",
"postCode":"518005"
},
"birthDate":"1982-01-30T14:52:39"
}
}
,
{
"price":66.66,
"name":"Book2",
"mainAuthor":{
"name":"Book2-MainAuthor",
"address":{
"address":"Shenzhen Guangdong China",
"postCode":"518005"
},
"birthDate":"1982-01-30T14:52:39"
}
}
]
執(zhí)行完之后，則result的內(nèi)容如下所示(json格式)
[
{
"price":60.0,
"name":"Book14",
"mainAuthorName":"Book14-MainAuthor"
},
{
"price":53.55,
"name":"Book13",
"mainAuthorName":"Book13-MainAuthor"
},
{
"price":55.55,
"name":"Book1",
"mainAuthorName":"Book1-MainAuthor"
}
]