SELECT "ID","学员姓名","学员班级","考试名称","题目名称","题号","准考证号","试卷","准考证图片","批改时间","阅卷老师","得分","问题","优点","自定义评语","满分","百分制得分","唯一标识","上传老师" FROM "阅卷表" WHERE "ID"==@id;
创建一个服务端命令sql查询,然后在第三方api接口中调用该服务端命令,根据id去查询数据,在我本地是没问题,查询结果:
{
"ErrCode": 0,
"Log": "16:51 执行'getExamInfo'命令, 请求方式OST, 用户:匿名\r\n参数:\r\nid = 3811\r\n执行SQL命令 用时:4毫秒。\r\n SQL语句: SELECT \"ID\",\"学员姓名\",\"学员班级\",\"考试名称\",\"题目名称\",\"题号\",\"准考证号\",\"试卷\",\"准考证图片\",\"批改时间\",\"阅卷老师\",\"得分\",\"问题\",\"优点\",\"自定义评语\",\"满分\",\"百分制得分\",\"唯一标识\",\"上传老师\" FROM \"阅卷表\" WHERE \"ID\"==@id;\r\n 创建变量 data = [{\"ID\":3811,\"学员姓名\":\"杨帆\",\"学员班级\":\"一班\",\"考试名称\":\"省考试卷二\",\"题目名称\":\"省笔试卷二02\",\"题号\":\"00002\",\"准考证号\":\"202301010080\",\"试卷\":\"cce957e8-e04b-4c69-810d-391f580dfb9f_20230102-00005_2.png\",\"准考证图片\":\"833bd43c-f5eb-4907-98ac-e99ce9116003_20230102-00005_5.jpg\",\"批改时间\":44931.70211216435,\"阅卷老师\":\"测试\",\"得分\":null,\"问题\":\"观点句不正确\",\"优点\":\"条理清晰\",\"自定义评语\":null,\"满分\":30.0,\"百分制得分\":null,\"唯一标识\":\"359d29c989444fc285d976c28c750231\",\"上传老师\":\"测试\"}]\r\n错误码: 0\r\n'getExamInfo'命令执行结束, 用时:4毫秒。\r\n"
}
但我自己接口部署到服务器上,再去查询,返回结果为:
{
"ErrCode": 0
}没返回数据,是什么原因呢,在本地都是好的,而且id确实是存在的
|