新浪移植1nutz接口,三张表的关联
原来新浪写的几篇都移植过来。
情景:一个线下活动OfflineActivity,每个线下活动对应一个问卷调查SurveyInfo,一个问卷对应多个问题SurveyQuestion,一个问题对应多个选项SurveyOptions。 注意: 1.实体类的关系设置问题:一对一,一对多 ---我参考的博客 http://gevin.iteye.com/blog/1134823 2.查询的时候不需要加事务,,但是修改时需要,,其他情况自己分辨。 3.这个框架用的有点懵,在每个操作,特别像这种多层关联的情况,保存的时候需要绑定多次。 OfflineActivity SurveyInfo SurveyOptions SurveyQuestion BaseBean接口的增删改查。。
Module1.查询单个问卷: 接口:http://localhost:8080/ivsadmin/api/v1/survey_info/? 方式:GET 入参:将”?”改为已存在的问卷id 成功出参: { "httpStatus": 200, "data": { "surveyInfo": { "id": "53962720f9b24b93a181791f83838d6b", "offlineActivityList": [], "name": "问卷名test称", "introduce": "问卷的test简单介绍", "surveyQuestionList": [ { "id": "316154aca3c9416aa37cf2eb47343600", "survey_info_id": "53962720f9b24b93a181791f83838d6b", "content": "题目的内容", "pic_imageid": "题目图片", "type": "2", "surveyOptionsList": [ { "id": "df97e695488642c481a72ef8c13a5eb4", "survey_question_id": "316154aca3c9416aa37cf2eb47343600", "content": "选项的内容1", "sequence": 1, "delete_flag": false, "insert_time": "2017-11-16 17:58:46", "update_time": "2017-11-16 17:59:29" }, { "id": "8c6588f271654dc195639776f55577d4", "survey_question_id": "316154aca3c9416aa37cf2eb47343600", "content": "选项的内容2", "sequence": 2, "delete_flag": false, "insert_time": "2017-11-16 17:58:46", "update_time": "2017-11-16 17:59:29" } ], "sequence": 1, "delete_flag": false, "insert_time": "2017-11-16 17:58:46", "update_time": "2017-11-16 17:59:29" }, { "id": "9bd8c29031984f24a7536df7464646ee", "survey_info_id": "53962720f9b24b93a181791f83838d6b", "content": "题目的内容", "pic_imageid": "题目图片", "type": "1", "surveyOptionsList": [ { "id": "d13743191e7e46e19c8ffb52f23d77d3", "survey_question_id": "9bd8c29031984f24a7536df7464646ee", "content": "选项的内容1", "sequence": 1, "delete_flag": false, "insert_time": "2017-11-16 17:58:46", "update_time": "2017-11-16 17:59:29" }, { "id": "d40d606988204c42a87c9e628fba9ee9", "survey_question_id": "9bd8c29031984f24a7536df7464646ee", "content": "选项的内容2", "sequence": 2, "delete_flag": false, "insert_time": "2017-11-16 17:58:46", "update_time": "2017-11-16 17:59:29" } ], "sequence": 2, "delete_flag": false, "insert_time": "2017-11-16 17:58:46", "update_time": "2017-11-16 17:59:29" } ], "delete_flag": false, "is_template": 1, "insert_time": "2017-11-16 17:58:46", "update_time": "2017-11-16 17:59:29" } }, "isSuccess": true } 失败:数据库未找到 { "httpStatus": 200, "data": {}, "isSuccess": true } 失败:json数据未匹配,或者访问方式不正确,或者接口链接不正确 nutz接口,三张表的关联 2.查询全部问卷: 接口:http://localhost:8080/ivsadmin/api/v1/survey_info/ 方式:GET 入参:无 成功出参: { "httpStatus": 200, "data": { "list": [ { "id": "53962720f9b24b93a181791f83838d6b", "offlineActivityList": [], "name": "问卷名test称", "introduce": "问卷的test简单介绍", "surveyQuestionList": [ { "id": "316154aca3c9416aa37cf2eb47343600", "survey_info_id": "53962720f9b24b93a181791f83838d6b", "content": "题目的内容", "pic_imageid": "题目图片", "type": "2", "surveyOptionsList": [ { "id": "df97e695488642c481a72ef8c13a5eb4", "survey_question_id": "316154aca3c9416aa37cf2eb47343600", "content": "选项的内容1", "sequence": 1, "delete_flag": false, "insert_time": "2017-11-16 17:58:46", "update_time": "2017-11-16 17:59:29" }, { "id": "8c6588f271654dc195639776f55577d4", "survey_question_id": "316154aca3c9416aa37cf2eb47343600", "content": "选项的内容2", "sequence": 2, "delete_flag": false, "insert_time": "2017-11-16 17:58:46", "update_time": "2017-11-16 17:59:29" } ], "sequence": 1, "delete_flag": false, "insert_time": "2017-11-16 17:58:46", "update_time": "2017-11-16 17:59:29" }, { "id": "9bd8c29031984f24a7536df7464646ee", "survey_info_id": "53962720f9b24b93a181791f83838d6b", "content": "题目的内容", "pic_imageid": "题目图片", "type": "1", "surveyOptionsList": [ { "id": "d13743191e7e46e19c8ffb52f23d77d3", "survey_question_id": "9bd8c29031984f24a7536df7464646ee", "content": "选项的内容1", "sequence": 1, "delete_flag": false, "insert_time": "2017-11-16 17:58:46", "update_time": "2017-11-16 17:59:29" }, { "id": "d40d606988204c42a87c9e628fba9ee9", "survey_question_id": "9bd8c29031984f24a7536df7464646ee", "content": "选项的内容2", "sequence": 2, "delete_flag": false, "insert_time": "2017-11-16 17:58:46", "update_time": "2017-11-16 17:59:29" } ], "sequence": 2, "delete_flag": false, "insert_time": "2017-11-16 17:58:46", "update_time": "2017-11-16 17:59:29" } ], "delete_flag": false, "is_template": 1, "insert_time": "2017-11-16 17:58:46", "update_time": "2017-11-16 17:59:29" } ] }, "isSuccess": true } 出参:无数据 { "httpStatus": 200, "data": {}, "isSuccess": true } 失败:json数据未匹配,或者访问方式不正确,或者接口链接不正确 nutz接口,三张表的关联 3.删除单个问卷: 接口: http://localhost:8080/ivsadmin/api/v1/survey_info/? 方式:PUT 入参:将”?”改为已存在的问卷id 成功出参: { "httpStatus": 200, "data": { "callBackId": "9092a886fb0748d096ed2eb5c514432a" }, "isSuccess": true } 失败:未找到该id { "errorMessage": "未找到该问卷!", "errorId": "8fe2a43781424d0788c450e5ace42bcd", "errorCode": "E8001001", "httpStatus": 400, "isSuccess": false, "date": "2017-11-16 01:35:54" } 失败:json数据未匹配,或者访问方式不正确,或者接口链接不正确 nutz接口,三张表的关联 4.新增按单个问卷: 接口: http://localhost:8080/ivsadmin/api/v1/survey_info/ 方式:POST 入参: { "surveyInfo":{ "is_template":"1", "name":"问卷名称", "introduce":"问卷的简单介绍", "surveyQuestionList":[{ "content":"题目的内容", "pic_imageid":"题目图片", "type":"1", "surveyOptionsList":[{ "content":"选项的内容2", "sequence":"2" },{ "content":"选项的内容1", "sequence":"1" }], "sequence":"2" }, {"content":"题目的内容", "pic_imageid":"题目图片", "type":"2", "surveyOptionsList":[{ "content":"选项的内容1", "sequence":"1" },{ "content":"选项的内容2", "sequence":"2" }], "sequence":"1" } ]} } 成功出参: { "httpStatus": 200, "data": { "callBackId": "7461510f1e8f4ed6ad6ca8038ce485d1" }, "isSuccess": true }失败:入参key输入错误,或者某些部分设为空值 { "errorMessage": "题目的内容和序号不能为空!", "errorId": "f692a87f609f4a4b857ccdce5c05b248", "errorCode": "E8001001", "httpStatus": 400, "isSuccess": false, "date": "2017-11-16 17:57:16" } 失败:json数据未匹配,或者访问方式不正确,或者接口链接不正确 nutz接口,三张表的关联 5.修改单个问卷: 接口: http://localhost:8080/ivsadmin/api/v1/survey_info/update 方式:PUT 入参:未传入id的字段统一视为新增。 修改要该类型的id,比如修改question,则需要question的id,其中的options如果是修改也需要传入options的id。 下例中:改了第一个问题的两个选项,并新增了一个选项;新增了一个问题及其两个选项。 { "surveyInfo": { "id":"745c964f0dea498abe6e3ae0e405cc3d", "name": "问卷名称test", "introduce": "问卷的简单介绍test", "surveyQuestionList": [ { "id": "8173bdf80c854156911297f6e5994bf0", "content": "题目的内容test", "pic_imageid": "题目图片test", "type": "1", "surveyOptionsList": [ { "id": "2e9131e81d8c4ec4a70f794d03b3967d" "content": "选项的内容1test", "sequence": 1, "delete_flag": false }, { "id": "5be4c2a71e5045e3880d2dfcb813e5c3" "content": "选项的内容2test", "sequence": 2, "delete_flag": false }, { "content": "选项的内容3 test新增", "sequence": 3, "delete_flag": false } ], "sequence": 2, "delete_flag": false }, { "content": "题目的内容 test新增", "pic_imageid": "题目图片 test新增", "type": "2", "surveyOptionsList": [ { "content": "选项的内容1 test新增", "sequence": 1, "delete_flag": false }, { "content": "选项的内容2 test新增", "sequence": 2, "delete_flag": false } ], "sequence": 1, "delete_flag": false } ], "delete_flag": false, "is_template": 1 } } 成功出参: { "httpStatus": 200, "data": { "callBackId": "53962720f9b24b93a181791f83838d6b" }, "isSuccess": true } 失败:未找到该id { "errorMessage": "空值", "errorId": "67902dc6ad7e4f708d11aa2774573e78", "errorCode": "E8001001", "httpStatus": 400, "isSuccess": false, "date": "2017-11-16 17:59:59" }接口文档