BrbiwsFtd9zDGZqB's recent timeline updates BrbiwsFtd9zDGZqB's recent timeline updates |
BrbiwsFtd9zDGZqBV2EX member #327781, joined on 2018-07-08 22:05:46 +08:00 |
 |
Per BrbiwsFtd9zDGZqB's settings, the topics list is hidden |
Deals info, including closed deals, is not hidden
BrbiwsFtd9zDGZqB's recent replies
Oct 31, 2024 Replied to a topic by irisdev › Java › 请教后台接口如何根据前台的筛选条件动态构造查询 sql |
巧了, lz 你说的这个东西我实现过.
我理解你的问题关键点不在于 sql 拼接, 而是如何将 动态的 json 转换为查询逻辑, 因为 sql 拼接有很多方式, mybatis 也好 jpa 也好 都是在转换为查询逻辑之后的具体实现.
所以我最终的实现方式中使用了 visitor 模式去分片组织查询逻辑.
```json
{
"paginate": true,
"page": 1,
"size": 20,
"sort": [
{
"field": "createdDate",
"direction": "DESC"
}
],
"filter": {
"match": "ALL",
"rules": [
{
"field": "name",
"operator": "LK",
"value": "111"
},
{
"match": "ANY",
"rules": [
{
"field": "title",
"operator": "EQ",
"value": "111"
},
{
"field": "isbn",
"operator": "EQ",
"value": "1"
}
]
}
]
}
}
```
```sql
SELECT
*
FROM
book
WHERE
"name" LIKE ? ESCAPE''
AND ( title =? OR isbn =? )
ORDER BY
created_date DESC OFFSET ? ROWS FETCH FIRST ? ROWS ONLY
```
我理解你的问题关键点不在于 sql 拼接, 而是如何将 动态的 json 转换为查询逻辑, 因为 sql 拼接有很多方式, mybatis 也好 jpa 也好 都是在转换为查询逻辑之后的具体实现.
所以我最终的实现方式中使用了 visitor 模式去分片组织查询逻辑.
```json
{
"paginate": true,
"page": 1,
"size": 20,
"sort": [
{
"field": "createdDate",
"direction": "DESC"
}
],
"filter": {
"match": "ALL",
"rules": [
{
"field": "name",
"operator": "LK",
"value": "111"
},
{
"match": "ANY",
"rules": [
{
"field": "title",
"operator": "EQ",
"value": "111"
},
{
"field": "isbn",
"operator": "EQ",
"value": "1"
}
]
}
]
}
}
```
```sql
SELECT
*
FROM
book
WHERE
"name" LIKE ? ESCAPE''
AND ( title =? OR isbn =? )
ORDER BY
created_date DESC OFFSET ? ROWS FETCH FIRST ? ROWS ONLY
```
Aug 15, 2024 Replied to a topic by puzzle9 › 问与答 › 记得有个 删除别人开发环境 让对方重新配置的 github 仓库 |
有印象, 但我也找不到了 😥
Nov 10, 2023 Replied to a topic by TomPig0216 › 问与答 › 老哥们戒烟的过程中有无做梦都在抽烟的时候 |
正常, 戒烟有五年了, 有时还会梦到.
Dec 29, 2022 Replied to a topic by foreverstandbyu › 问与答 › 行车记录仪有在用的吗。买哪家的好一些。 |
viofo 119 mini
Apr 18, 2022 Replied to a topic by jimisun › 问与答 › Java 如何通用化查询逻辑应对复杂的查询需求？ |
1. mybatis, 用 myabtis-plus 的 QueryWrapper, 动态拼接一下查询条件.
https://baomidou.com/pages/10c804
2. jpa, 看文档 4.8.2 那一节, Querydsl Web Support.
https://docs.spring.io/spring-data/jpa/docs/current/reference/html
实现后接口大概是这样: http://your.api/user?name=Alice&page=0&size=20&sort=age,asc
https://baomidou.com/pages/10c804
2. jpa, 看文档 4.8.2 那一节, Querydsl Web Support.
https://docs.spring.io/spring-data/jpa/docs/current/reference/html
实现后接口大概是这样: http://your.api/user?name=Alice&page=0&size=20&sort=age,asc
Mar 19, 2022 Replied to a topic by BrbiwsFtd9zDGZqB › 分享发现 › 百度你想干什么 |
Jun 22, 2021 Replied to a topic by qanniu › 分享发现 › Android 刷机包从定制到放弃. 不折腾了, 回老苹果. -- 一个中年大叔的吐槽 |
从智能机出现开始一直用安卓, 也是各种折腾.
今年突发奇想换到了 iPhone.
总的来说, 真香. iPhone 真省心, 累了折腾不动了.
唯一的痛点就是没有通话录音
今年突发奇想换到了 iPhone.
总的来说, 真香. iPhone 真省心, 累了折腾不动了.
唯一的痛点就是没有通话录音
May 25, 2021 Replied to a topic by qwerthhusn › 程序员 › 分享一个 Spring Boot 工程打 Docker 镜像非常方便的 pom，你也 Docker 的距离就差一个好用的生成镜像的工具，求大佬点评改进！ |
同 1 楼, 推荐 google 的 jib
May 6, 2021 Replied to a topic by Grande › 云计算 › 阿里云， HK 节点轻量应用服务器这是上新了，不知线路如何？ |
啊这, 旧版不支持升级?
Select Language