🎉PG开放接口文档发布啦~如果还有更多建议欢迎加入QQ群反馈🎉
- PGOpenAPI简介
- 接口分级说明
- 请求测试
- 签名认证
- OpenAPI
- 邮局
- 对象存储
- 点鸭赛事
- 转发代理
- PG登录
- 点鸭数据表
- OpenSDK
[2]获取指定赛事的指定答卷
POST
contest/get_answer
最后修改时间：2024-02-20 05:13:02
责任人：冷鱼闲风
【[2]个人级别】#
该响应数据适用于layui表格。
请求参数
Query 参数
Header 参数
Body 参数application/x-www-form-urlencoded
请求示例代码
Shell
JavaScript
Java
Swift
Go
PHP
Python
HTTP
C
C#
Objective-C
Ruby
OCaml
Dart
R
请求示例请求示例
Shell
JavaScript
Java
Swift
curl --location --request POST 'https://api.pgaot.com/contest/get_answer?id=1705298115&t=1705591908' \
--header 'X-Pgaot-Token: eyJ1aWQiOiIxMDAwMSIsIm5pY2tuYW1lIjoiXHU1MWI3XHU5YzdjXHU0ZTBlXHU3MGVkXHU3MzJiIiwiYXZhdGFyIjoiaHR0cHM6XC9cL3ExLnFsb2dvLmNuXC9nP2I9cXEmbms9Mjk5MTg4MzI4MCZzPTY0MCZ1PTEiLCJiY21pZCI6Ijg0MzgxOCIsImRhb2lkIjoiODMzNTQiLCJlbWFpbCI6IjI5OTE4ODMyODBAcXEuY29tIiwiaWF0IjoxNzA4MzExNjQwLCJleHAiOjE3MDk1MjEyNDAsInRva2VuIjoiMDY2MzJjOThmZGFlMDFmZWEzYTU0YTQwMGFkMmNiMDUiLCJqdGkiOiJjdk9Fd20zSGNYUzJzQXdqODlIbnVuK21KeFpOcSt1TU96YXFoTmJDYmJFXC9iSlZDcDd1U1Noc05XQXFpdVJXQUgwWFVPVURoTXExTlA2RVpaREtxY2hzUk1uWlhNTDFzdHV5UHo0ak53cGd0T2RiOVFwUFlBZ3FYNEVkZ2s4XC9MTzZEaERORzNBUm1vYnd6M2U0OTZORDVWeG5hME02OVdPeml0Sk5ReWtjM0tGR29UZVFZZStYcFY3UE5ydldoeFRxdzZuZEFLcUY1TGtyRnU0aytPMjJ6NXIyUG1xN0VFcUc4TTkzdVBlalFXV1JxRzNMZlwvN3cwU0JmZEdKaU9CY3g0c2Y2Z1NpRkdzdExSeFRCa2YzQ2pWdW85ZlJISWVPbVpjNCtjSGRNK0pHMFwvU3IxWThJWHNjUHNIOWJYWjNWMnB4XC9XejhmbWh2eGZCVnRFNkVRMk9qUVR3SEdQajlvZnY3TFhsUWN4RFwvVXZhREJFZWhmT01lMEo5U2VwaElSZ0pNNFp0ZjRGMVlQRTg5NkJmdE9GK0xyXC9hd3RVbE8ifQ==' \
--data-urlencode 'page=1' \
--data-urlencode 'limit=10'返回响应
🟢200成功
application/json
Body
示例
{
"code": 0,
"msg": "赛事答卷信息请求查询成功",
"count": 5,
"data": [
{
"type": "文本题",
"title": "<p>欢迎来到点鸭数据表&SQL基础测试，</p><p>在本场考试中，我们只会在一张数据表里面查询，不会涉及多表查询，</p><p>以下是本场考试的数据表内容，你可以随时回到本题查看表内容。</p><p>下方数据纯属虚构，姓名是随机生成的，如有雷同敬请谅解。</p><p>（点击图片可以放大，鼠标滚轮可放大缩小）</p><p><br></p><p><img src=\"https://static.codemao.cn/bcx/B1cU6wzt6.png?hash=FqPAUfrv2lST916KPtf601Zkbzpq\" alt=\"\" data-href=\"#\" style=\"\"/></p>",
"issue": "",
"scores": "0",
"answer": "",
"times": "1705307372",
"id": "3ee499323b3d064d903db4d856b1454a",
"examanswer": "",
"actualscore": ""
},
{
"type": "单选题",
"title": "<p>【SQL基础】：查询姓名叫\"吴珣\"的同学，输出所有字段的内容。</p><p><br></p><h2>A：</h2><pre><code class=\"language-sql\">SELECT * FROM `pgaotdbs` WHERE 姓名=\"吴珣\"</code></pre><h2>B：</h2><pre><code class=\"language-sql\">SELECT 姓名,性别 FROM `pgaotdbs` WHERE 姓名=\"吴珣\"</code></pre><h2>C：</h2><pre><code class=\"language-sql\">SELECT * FROM `pgaotdbs` WHERE 姓名<>\"吴珣\"</code></pre><h2>D：</h2><pre><code class=\"language-sql\">SELECT * FROM `pgaotdbs` WHERE 姓名==\"吴珣\"</code></pre><p><br></p>",
"issue": "A<br>B<br>C<br>D",
"scores": "5",
"answer": "A",
"times": "1705307657",
"id": "b1cd1550a912dbb2f62057d1f1617dac",
"examanswer": "",
"actualscore": 0,
"actualscorecause": "答案不符，得0分"
},
{
"type": "单选题",
"title": "<p>【SQL基础】：查询第二组的同学选修日语的数量，输出姓名字段的内容。</p><p><br></p><h2>A：</h2><pre><code class=\"language-sql\">SELECT count(姓名) FROM `pgaotdbs` WHERE 小组=\"第二组\" OR 选修课程=\"日语\"</code></pre><h2>B：</h2><pre><code class=\"language-sql\">SELECT 姓名 FROM `pgaotdbs` WHERE 小组=\"第二组\" AND 选修课程=\"日语\"</code></pre><h2>C：</h2><pre><code class=\"language-sql\">SELECT count(姓名) FROM `pgaotdbs` WHERE 小组=\"第二组\" AND 选修课程=\"日语\"</code></pre><h2>D：</h2><pre><code class=\"language-sql\">SELECT count(姓名) FROM `pgaotdbs` WHERE 小组=\"第二组\" AND NOT 选修课程=\"日语\"</code></pre><p><br></p>",
"issue": "A<br>B<br>C<br>D",
"scores": "5",
"answer": "C",
"times": "1705308246",
"id": "a2b9687b6b29ba789c5e98d23123d65d",
"examanswer": "",
"actualscore": 0,
"actualscorecause": "答案不符，得0分"
},
{
"type": "单选题",
"title": "<p>【SQL基础】：查询不及格（<60）的选修课程的同学，输出所有字段。</p><p><br></p><h2>A：</h2><pre><code class=\"language-sql\">SELECT * FROM `pgaotdbs` WHERE NOT 平均分<60</code></pre><h2>B：</h2><pre><code class=\"language-sql\">SELECT * FROM `pgaotdbs` WHERE 平均分<60</code></pre><h2>C：</h2><pre><code class=\"language-sql\">SELECT * FROM `pgaotdbs` WHERE 平均分>60</code></pre><h2>D：</h2><pre><code class=\"language-sql\">SELECT * FROM `pgaotdbs` WHERE 平分>60</code></pre><p><br></p>",
"issue": "A<br>B<br>C<br>D",
"scores": "5",
"answer": "B",
"times": "1705308770",
"id": "c1551785f319ab76c8c682326822c38f",
"examanswer": "",
"actualscore": 0,
"actualscorecause": "答案不符，得0分"
},
{
"type": "单选题",
"title": "<p>【SQL基础】：查询没学过\"Perfect\"老师讲授的课程的学生姓名，但第二组除外和\"董为恬\"和\"伊熹能\"除外，输出姓名字段的内容。</p><p><br></p><h2>A：</h2><pre><code class=\"language-sql\">SELECT 姓名 FROM `pgaotdbs` WHERE 授课教师<>\"Perfect\" AND 小组<>'第二组' AND 姓名 NOT IN(\"伊熹能\",\"贡梁淞\")</code></pre><h2>B：</h2><pre><code class=\"language-sql\">SELECT 姓名 FROM `pgaotdbs` WHERE 授课教师<>\"Perfect\" AND 小组<>'第二组' OR 姓名 NOT IN(\"伊熹能\",\"董为恬\")</code></pre><h2>C：</h2><pre><code class=\"language-sql\">SELECT 姓名 FROM `pgaotdbs` WHERE 授课教师<>\"Perfect\" AND 小组<>'第二组' AND 姓名 IN(\"伊熹能\",\"董为恬\")</code></pre><h2>D：</h2><pre><code class=\"language-sql\">SELECT 姓名 FROM `pgaotdbs` WHERE 授课教师<>\"Perfect\" AND 小组<>'第二组' AND 姓名 NOT IN(\"伊熹能\",\"董为恬\")</code></pre><p><br></p>",
"issue": "A<br>B<br>C<br>D",
"scores": "5",
"answer": "D",
"times": "1705309066",
"id": "3acd6afaa003a984104bd6e26a518837",
"examanswer": "",
"actualscore": 0,
"actualscorecause": "答案不符，得0分"
},
{
"type": "单选题",
"title": "<p>【SQL基础】：修改姓名叫\"温冰宏\"的同学，小组改为\"第三组\"。</p><h2>A：</h2><pre><code class=\"language-sql\">UPDATE `pgaotdbs` SET 小组=\"第组\" WHERE 姓名=\"温冰宏\"</code></pre><h2>B：</h2><pre><code class=\"language-sql\">UPDATE `pgaotdbs` SET 小组=\"第三组\" WHERE 1</code></pre><h2>C：</h2><pre><code class=\"language-sql\">UPDATE `pgaotdbs` SET 小组=\"第三组\" WHERE 姓名=\"温冰宏\"</code></pre><h2>D：</h2><pre><code class=\"language-sql\">UPDATE `pgaotdbs` SET 小组=\"第三组\" WHERE NOT 姓名=\"温冰宏\"</code></pre><p><br></p>",
"issue": "A<br>B<br>C<br>D",
"scores": "5",
"answer": "C",
"times": "1705309725",
"id": "8d0684f2444ce3328e5efe1130e4c319",
"examanswer": "",
"actualscore": 0,
"actualscorecause": "答案不符，得0分"
},
{
"type": "单选题",
"title": "<p>【SQL基础】：查询不是\"英语\"的课程分数小于60，按分数降序排列的学生信息</p><h2>A：</h2><pre><code class=\"language-sql\">SELECT * FROM `pgaotdbs` WHERE 选修课程<>\"英语\" AND 平均分<60 </code></pre><h2>B：</h2><pre><code class=\"language-sql\">SELECT * FROM `pgaotdbs` WHERE 选修课程<>\"英语\" AND 平均分<60 ORDER BY 平均分 DESC</code></pre><h2>C：</h2><pre><code class=\"language-sql\">SELECT * FROM `pgaotdbs` WHERE 选修课程<>\"英语\" AND 平均分<60 ORDER BY 平均分 ASC</code></pre><h2>D：</h2><pre><code class=\"language-sql\">SELECT * FROM `pgaotdbs` WHERE 选修课程<>\"英语\" OR 平均分<60 ORDER BY 平均分 ASC</code></pre><p><br></p>",
"issue": "A<br>B<br>C<br>D",
"scores": "5",
"answer": "B",
"times": "1705311231",
"id": "f03cd6033ed2c85cbaa92a53e98d2629",
"examanswer": "",
"actualscore": 0,
"actualscorecause": "答案不符，得0分"
},
{
"type": "单选题",
"title": "<p>【SQL基础】：查询祖籍为\"广\"字开头的同学，输出\"授课教师\"字段的内容。</p><p><br></p><h2>A：</h2><pre><code class=\"language-sql\">SELECT * FROM `pgaotdbs` WHERE 祖籍 LIKE '%广'</code></pre><h2>B：</h2><pre><code class=\"language-sql\">SELECT * FROM `pgaotdbs` WHERE 祖籍='广'</code></pre><h2>C：</h2><pre><code class=\"language-sql\">SELECT * FROM `pgaotdbs` WHERE 祖籍 LIKE '广'</code></pre><h2>D：</h2><pre><code class=\"language-sql\">SELECT * FROM `pgaotdbs` WHERE 祖籍 LIKE '广%'</code></pre><p><br></p>",
"issue": "A<br>B<br>C<br>D",
"scores": "5",
"answer": "D",
"times": "1705311909",
"id": "13bd49d47f8bfc251e63a64712e5c860",
"examanswer": "",
"actualscore": 0,
"actualscorecause": "答案不符，得0分"
},
{
"type": "单选题",
"title": "<p>【点鸭数据表基础】：查询平均成绩大于等于 60 分的同学的学生授课教师和学生姓名和平均成绩，并以降序的方式输出。</p><p>SELECT <span style=\"font-size: 13px;\"><u>[fields]</u></span> FROM `pgaotdbs` WHERE <span style=\"font-size: 13px;\"><u>[filter]</u></span><span style=\"font-size: 13px;\"> ORDER BY </span><span style=\"font-size: 13px;\"><u>[sort]</u></span></p><ul><li style=\"text-align: left;\"><span style=\"font-size: 13px;\"><u>[fields]【SELECT】字段筛选</u></span></li><li style=\"text-align: left;\"><span style=\"font-size: 13px;\"><u>[filter]【SELECT】条件筛选</u></span></li><li style=\"text-align: left;\"><span style=\"font-size: 13px;\"><u>[sort] 【SELECT】字段排序</u></span></li></ul><h2>A：</h2><pre><code >fields=授课教师,姓名,平均分\nfilter=平均分>=60\nsort=平均分 DESC</code></pre><h2>B：</h2><pre><code >fields=授课教师,姓名,平均分\nfilter=平均分=60\nsort=平均分 DESC</code></pre><h2>C：</h2><pre><code >fields=*\nfilter=平均分>=60\nsort=平均分 DESC</code></pre><h2>D：</h2><pre><code >fields=授课教师,姓名,平均分\nfilter=平均分>=60\nsort=平均分 ASC</code></pre><p><br></p>",
"issue": "A<br>B<br>C<br>D",
"scores": "5",
"answer": "A",
"times": "1705312178",
"id": "8875439f3afb181231875612ef244053",
"examanswer": "",
"actualscore": 0,
"actualscorecause": "答案不符，得0分"
},
{
"type": "单选题",
"title": "<p>【点鸭数据表基础】：查询没学过\"Perfect\"老师讲授的课程的学生姓名，但第二组除外和\"董为恬\"和\"伊熹能\"除外，输出姓名字段的内容。</p><h2>A：</h2><pre><code >fields=姓名\nfilter=授课教师<>\"Perfect\" AND 小组<>'第二组' AND 姓名 NOT IN(\"伊熹能\",\"贡梁淞\")</code></pre><h2>B：</h2><pre><code >fields=姓名\nfilter=授课教师<>\"Perfect\" AND 小组<>'第二组' OR 姓名 NOT IN(\"伊熹能\",\"董为恬\")</code></pre><h2>C：</h2><pre><code >fields=*\nfilter=授课教师<>\"Perfect\" AND 小组<>'第二组' AND 姓名 IN(\"伊熹能\",\"董为恬\")</code></pre><h2>D：</h2><pre><code >fields=姓名\nfilter=授课教师<>\"Perfect\" AND 小组<>'第二组' AND 姓名 NOT IN(\"伊熹能\",\"董为恬\")</code></pre><p><br></p>",
"issue": "A<br>B<br>C<br>D",
"scores": "5",
"answer": "D",
"times": "1705315455",
"id": "5ee715e271ee356629b70ab498dc9ebd",
"examanswer": "",
"actualscore": 0,
"actualscorecause": "答案不符，得0分"
},
{
"type": "单选题",
"title": "<p>【点鸭数据表基础】：删除第一组的同学</p><ul><li>[filter]【UPDATE】条件筛选</li></ul><h2>A：</h2><pre><code >filter=小组=\"第一组\"</code></pre><h2>B：</h2><pre><code >filter=小组=\"第二组\"</code></pre><h2>C：</h2><pre><code >filter=小组<>\"第一组\"</code></pre><h2>D：</h2><pre><code >filter=1</code></pre><p><br></p>",
"issue": "A<br>B<br>C<br>D",
"scores": "5",
"answer": "A",
"times": "1705316462",
"id": "2f022cbd5e032bf43028b33cc199e873",
"examanswer": "",
"actualscore": 0,
"actualscorecause": "答案不符，得0分"
},
{
"type": "单选题",
"title": "<p>【点鸭数据表基础】：新增一位新同学，祖籍\"河北\"，姓名\"凌志豪\"</p><p>INSERT INTO `pgaotdbs`(<span style=\"font-size: 13px;\">[fields]</span>) VALUES (<span style=\"font-size: 13px;\">[filter]</span>)</p><ul><li><span style=\"font-size: 13px;\">[fields]【INSERT】需要设置的字段</span></li><li><span style=\"font-size: 13px;\">[filter]【INSERT】需要设置的值</span></li></ul><h2>A：</h2><pre><code >fields=祖籍,姓名\nfilter=河北,凌志豪</code></pre><h2>B：</h2><pre><code >fields=祖籍,姓名\nfilter=\"河北\",\"凌志豪\"</code></pre><h2>C：</h2><pre><code >fields=*\nfilter=\"河北\",\"凌志豪\"</code></pre><h2>D：</h2><pre><code >fields=祖籍\nfilter=\"河北\"</code></pre><p><br></p>",
"issue": "A<br>B<br>C<br>D",
"scores": "5",
"answer": "B",
"times": "1705316813",
"id": "92f072ea3fe7717d3abe157d369b370d",
"examanswer": "",
"actualscore": 0,
"actualscorecause": "答案不符，得0分"
},
{
"type": "单选题",
"title": "<p>【点鸭数据表基础】：修改名字为\"傅凡慧\"的成绩为 80 分</p><p>UPDATE `pgaotdbs` SET <span style=\"font-size: 13px;\"><u>[fields]</u></span> WHERE <span style=\"font-size: 13px;\"><u>[filter]</u></span><span style=\"font-size: 13px;\"> </span></p><ul><li style=\"text-align: left;\"><span style=\"font-size: 13px;\"><u>[fields]【UPDATE】需要设置的字段和值</u></span></li><li style=\"text-align: left;\"><span style=\"font-size: 13px;\"><u>[filter]【SELECT】条件筛选</u></span></li></ul><h2>A：</h2><pre><code >fields=平均分=80\nfilter=姓名=\"傅凡慧\"</code></pre><h2>B：</h2><pre><code >fields=平均分=80\nfilter=姓名<>\"傅凡慧\"</code></pre><h2>C：</h2><pre><code >fields=姓名=80\nfilter=平均分=\"傅凡慧\"</code></pre><h2>D：</h2><pre><code >fields=平均分=50\nfilter=姓名=\"傅凡慧\"</code></pre><p><br></p>",
"issue": "A<br>B<br>C<br>D",
"scores": "5",
"answer": "A",
"times": "1705317783",
"id": "440d900c6879c7d8fd4eb75f528d582c",
"examanswer": "",
"actualscore": 0,
"actualscorecause": "答案不符，得0分"
},
{
"type": "操作题",
"title": "<p>【点鸭数据表基础】： 查询任何一门课程成绩在 60 分以上的姓名、课程名称和分数，并按照分数降序处理。</p><p>运行结果参考：</p><p><img src=\"https://static.codemao.cn/bcx/SkDRJjMYp.png?hash=FlIgG_bJvgUGP58ESsWA4X1BWbIF\" alt=\"\" data-href=\"#\" style=\"width: 758.00px;height: 418.67px;\"/></p>",
"issue": "21",
"scores": "10",
"answer": "姓名,选修课程,平均分 || 平均分 DESC || 平均分>60",
"times": "1705320136",
"id": "252fa8ea192a417d018d39fff52363a8",
"examanswer": "",
"actualscore": ""
},
{
"type": "操作题",
"title": "<p>【点鸭数据表基础】： 查询名字中「贺」开头的姓名的学生信息</p><p>运行结果参考：</p><p><img src=\"https://static.codemao.cn/bcx/Bk-YZoMFp.png?hash=FtDkiWFFwLfbSTgdNkfyIw0HGVIp\" alt=\"\" data-href=\"#\" style=\"width: 697.00px;height: 109.20px;\"/></p><p><br></p>",
"issue": "21",
"scores": "5",
"answer": "|| 姓名 LIKE \"贺%\" ",
"times": "1705320610",
"id": "df181d8bf9f988ffead5d5382ef14384",
"examanswer": "",
"actualscore": ""
},
{
"type": "操作题",
"title": "<p>【点鸭数据表基础】：查询没学过\"Davida\"老师讲授的课程的学生姓名，除了\"温冰宏\"和\"傅凡慧\"，和平均分大于等于80的。</p><p>运行结果参考：</p><p><img src=\"https://static.codemao.cn/bcx/HJzDQozY6.png?hash=FkKOiw3HRfDSs2s76FA17KNIBRlu\" alt=\"\" data-href=\"#\" style=\"width: 839.00px;height: 240.48px;\"/></p>",
"issue": "21",
"scores": "10",
"answer": "姓名 || 授课教师<>\"Davida\" AND 平均分<80 AND 姓名 NOT IN(\"温冰宏\",\"傅凡慧\")",
"times": "1705320874",
"id": "41c9179900e7d3796b19d61a6940c955",
"examanswer": "",
"actualscore": ""
},
{
"type": "操作题",
"title": "<p>【点鸭数据表基础】：计算所有同学英语平均分的平均分</p><p>运行结果参考：</p><p><img src=\"https://static.codemao.cn/bcx/r1gmrjMta.png?hash=Fum5X3O2d2a_E7pK9HzzSJIuqZv7\" alt=\"\" data-href=\"#\" style=\"width: 661.00px;height: 76.31px;\"/></p>",
"issue": "21",
"scores": "5",
"answer": "AVG(平均分)",
"times": "1705321350",
"id": "9568b094670bf991ea8799e9e1739013",
"examanswer": "",
"actualscore": ""
},
{
"type": "操作题",
"title": "<p>【点鸭数据表基础】： 查询第二组和第三组的英语最高分的同学，以姓名，小组，平均分方式输出</p><p>运行结果参考：</p><p><img src=\"https://static.codemao.cn/bcx/SJPQ8iMta.png?hash=Fqa6uaQhPSWq9Fuf4RmvIzvmsCVR\" alt=\"\" data-href=\"#\" style=\"width: 735.00px;height: 106.56px;\"/></p>",
"issue": "21",
"scores": "10",
"answer": "姓名,小组,MAX(平均分) || 小组 IN(\"第二组\",\"第三组\") ",
"times": "1705321773",
"id": "2fab70cdd37c0b9754d7382546f35be0",
"examanswer": "",
"actualscore": ""
}
],
"totalRow": {
"score": 0
}
}修改于 2024-02-20 05:13:02