练手需求

自己根据下述描述，完成表结构设计、0-1的搭建，三次架构代码编写，并用JUnit完成测试时间要求：3H全景图读取数据简要描述获取场景锁定小区列表请求URL/gis/panorama/findCmCell请求方式POST参数

返回示例

Plain Text

复制代码

1

2

3

4

5

{

   "code": 200,

   "data":[],

   "message":""

 }

返回参数说明

备注selectCI,REGION_NAME,CITY_NAME,ENBAJ02,ENODEBNAME,ENBAG05,‘LTE’ NET_work,WORK_FRQBAND,RRU_SerialNO,‘’ RRU_NO,DEVICE_MODEL_LIST,ENBAH21,HEIGHT,ENBAH08,TOTAL_DOWNTILTfrom tdl_cm_cell ff WHERE ff.”TIME” =to_date(‘2024-08-31’,’yyyy-MM-dd’)UNION ALLselectNCI CI,REGION_NAME,CITY_NAME,CellName ENBAJ02,gNBNAME ENODEBNAME,gNB_ID ENBAG05,‘NR’ NET_work,WORK_FRQBAND,SerialNumber RRU_SerialNO,‘’ RRU_NO,VendorUnitTypeNumber DEVICE_MODEL_LIST,‘’ ENBAH21,HEIGHT,Azimuth ENBAH08,TOTAL_DOWNTILTfrom nrcell_cm cc WHERE time= to_date(‘2024-08-31’,’yyyy-MM-dd’)4GSELECT ci/nci FROM tdl_cm_cell WHERE RRU_SERIALNO =’219999741006’ AND “TIME” =to_date(‘2024-08-31’,’yyyy-MM-dd’)5GSELECT ci/nci FROM nrcell_cm WHERE RRU_SERIALNO =’219999741006’ AND “TIME” =to_date(‘2024-08-31’,’yyyy-MM-dd’)将二次查询的结果 ci/nci “，“隔开拼接到 RRU_NO 字段中更多返回错误代码请看首页的错误代码描述