条件查询出问题对象

<p>[TOC]</p> <h5>简要描述</h5> <ul> <li>条件限制查询出问答对象</li> </ul> <h5>请求URL</h5> <ul> <li><code>localhost:9000/answer/questions/listPage/{currentPage}/{pageSize}</code></li> </ul> <h5>请求方式</h5> <ul> <li>GET </li> </ul> <h5>参数</h5> <table> <thead> <tr> <th style="text-align: left;">参数名</th> <th style="text-align: left;">必选</th> <th style="text-align: left;">类型</th> <th>说明</th> </tr> </thead> <tbody> <tr> <td style="text-align: left;">currentPage</td> <td style="text-align: left;">是</td> <td style="text-align: left;">Interger</td> <td>哪一页开始查询</td> </tr> <tr> <td style="text-align: left;">pageSize</td> <td style="text-align: left;">是</td> <td style="text-align: left;">string</td> <td>查询的每页内容</td> </tr> </tbody> </table> <h5>返回示例</h5> <pre><code>{ "msg": "success", "code": 200, "data": [ { "id": 2, "title": "四川成都", "content": "成都", "viewnum": 15, "thumbsupnum": 45, "starnum": 45, "replynum": 24, "state": 1, "destId": 2, "userId": 3, "qualityScore": 54, "createTime": "2023-01-14", "updateTime": "2023-01-14", "destinationName": "埃及", "destName": null, "userName": null, "goodCommentId": "1" }, { "id": 6, "title": "四川", "content": "四川绵阳", "viewnum": 12, "thumbsupnum": 54, "starnum": 45, "replynum": 232, "state": 1, "destId": 1, "userId": 1, "qualityScore": 25, "createTime": "2023-01-12", "updateTime": "2023-01-12", "destinationName": "中国", "destName": null, "userName": null, "goodCommentId": "7" }, { "id": 27, "title": "西安什么地方好玩?", "content": "西安哪里的东西好吃", "viewnum": 0, "thumbsupnum": 0, "starnum": 0, "replynum": 0, "state": -1, "destId": 503, "userId": 1, "qualityScore": null, "createTime": "2023-01-13", "updateTime": "2023-01-13", "destinationName": "西安", "destName": null, "userName": null, "goodCommentId": null }, { "id": 29, "title": "重庆", "content": "重庆洪崖洞", "viewnum": 0, "thumbsupnum": 0, "starnum": 0, "replynum": 0, "state": 0, "destId": 2, "userId": 6, "qualityScore": null, "createTime": "2023-01-13", "updateTime": null, "destinationName": "埃及", "destName": null, "userName": null, "goodCommentId": null }, { "id": 30, "title": "重庆测试aop", "content": "重庆洪崖洞", "viewnum": 0, "thumbsupnum": 0, "starnum": 0, "replynum": 0, "state": 0, "destId": 2, "userId": 6, "qualityScore": null, "createTime": "2023-01-13", "updateTime": null, "destinationName": "埃及", "destName": null, "userName": null, "goodCommentId": null }, { "id": 31, "title": "重庆测试aop2", "content": "重庆洪崖洞", "viewnum": 0, "thumbsupnum": 0, "starnum": 0, "replynum": 0, "state": 0, "destId": 2, "userId": 1, "qualityScore": null, "createTime": "2023-01-13", "updateTime": null, "destinationName": "埃及", "destName": null, "userName": null, "goodCommentId": null }, { "id": 33, "title": "北京测试aop2", "content": "北京首都", "viewnum": 0, "thumbsupnum": 0, "starnum": 0, "replynum": 0, "state": 0, "destId": 1, "userId": 1, "qualityScore": null, "createTime": "2023-01-13", "updateTime": null, "destinationName": "中国", "destName": null, "userName": null, "goodCommentId": null }, { "id": 34, "title": "上海", "content": "测试id为34的question修改数据同步", "viewnum": 0, "thumbsupnum": 0, "starnum": 0, "replynum": 0, "state": 0, "destId": 1, "userId": 1, "qualityScore": null, "createTime": "2023-01-13", "updateTime": "2023-01-13", "destinationName": "中国", "destName": null, "userName": null, "goodCommentId": null }, { "id": 35, "title": "天津", "content": "天津有什么吃的", "viewnum": 0, "thumbsupnum": 0, "starnum": 0, "replynum": 0, "state": -2, "destId": 1, "userId": 1, "qualityScore": null, "createTime": "2023-01-13", "updateTime": null, "destinationName": "中国", "destName": null, "userName": null, "goodCommentId": null }, { "id": 36, "title": "天津1", "content": "天津有什么吃的", "viewnum": 0, "thumbsupnum": 0, "starnum": 0, "replynum": 0, "state": 0, "destId": 1, "userId": 6, "qualityScore": null, "createTime": "2023-01-13", "updateTime": null, "destinationName": "中国", "destName": null, "userName": null, "goodCommentId": null } ] }</code></pre> <h5>返回参数说明</h5> <p>状态码 <strong>200</strong></p> <table> <thead> <tr> <th>名称</th> <th>类型</th> <th>必选</th> <th>约束</th> <th>中文名</th> <th>说明</th> </tr> </thead> <tbody> <tr> <td>msg</td> <td>string</td> <td>true</td> <td>none</td> <td>消息</td> <td>none</td> </tr> <tr> <td>code</td> <td>integer</td> <td>true</td> <td>none</td> <td>状态码</td> <td>200 成功</td> </tr> <tr> <td>data</td> <td>[object]</td> <td>true</td> <td>none</td> <td>响应数据</td> </tr> <tr> <td>id</td> <td>integer</td> <td>true</td> <td>none</td> <td>问题id</td> <td>none</td> </tr> <tr> <td>title</td> <td>string</td> <td>true</td> <td>none</td> <td>问题标题</td> <td>none</td> </tr> <tr> <td>content</td> <td>string</td> <td>true</td> <td>none</td> <td>问题内容</td> <td>none</td> </tr> <tr> <td>viewnum</td> <td>integer</td> <td>true</td> <td>none</td> <td>浏览量</td> <td>none</td> </tr> <tr> <td>thumbsupnum</td> <td>integer</td> <td>true</td> <td>none</td> <td>点赞量</td> <td>none</td> </tr> <tr> <td>starnum</td> <td>integer</td> <td>true</td> <td>none</td> <td>收藏(关注)量</td> <td>none</td> </tr> <tr> <td>replynum</td> <td>integer</td> <td>true</td> <td>none</td> <td>回答量</td> <td>none</td> </tr> <tr> <td>state</td> <td>integer</td> <td>true</td> <td>none</td> <td>状态</td> <td>-2 关闭 -1 删除 0 草稿 1 已发布</td> </tr> <tr> <td>destId</td> <td>integer</td> <td>true</td> <td>none</td> <td>目的地id</td> <td>none</td> </tr> <tr> <td>userId</td> <td>integer</td> <td>true</td> <td>none</td> <td>用户id</td> <td>none</td> </tr> <tr> <td>qualityScore</td> <td>integer¦null</td> <td>true</td> <td>none</td> <td>问题质量分数</td> <td>none</td> </tr> <tr> <td>createTime</td> <td>string</td> <td>true</td> <td>none</td> <td>发表时间</td> <td>none</td> </tr> <tr> <td>updateTime</td> <td>string¦null</td> <td>true</td> <td>none</td> <td>修改时间</td> <td>none</td> </tr> <tr> <td>destinationName</td> <td>string</td> <td>false</td> <td>none</td> <td>目的地名字</td> <td>none</td> </tr> <tr> <td>destName</td> <td>null</td> <td>false</td> <td>none</td> <td>目的地名字</td> <td>none</td> </tr> <tr> <td>userName</td> <td>null</td> <td>false</td> <td>none</td> <td>用户名字</td> <td>none</td> </tr> <tr> <td>goodCommentId</td> <td>string¦null</td> <td>true</td> <td>none</td> <td>goodCommentId</td> <td>none</td> </tr> </tbody> </table> <h5>备注</h5> <ul> <li>当es进行初始化的时候需要从mysql中查询出数据,但由于数据过大所以进行分页的查询,然后再保存在es中</li> </ul>