附錄附錄A啟動類代碼@SpringBootApplication@MapperScan(basePackages={"com.dao"})publicclassSpringbootSchemaApplicationextendsSpringBootServletInitializer{publicstaticvoidmain(String[]args){SpringApplication.run(SpringbootSchemaApplication.class,args);}@OverrideprotectedSpringApplicationBuilderconfigure(SpringApplicationBuilderapplicationBuilder){returnapplicationBuilder.sources(SpringbootSchemaApplication.class);}}附錄B通用接口控制層代碼/***通用接口*/@RestControllerpublicclassCommonController{@AutowiredprivateCommonServicecommonService;privatestaticAipFaceclient=null;@AutowiredprivateConfigServiceconfigService;/***獲取table表中的column列表(聯(lián)動接口)*@paramtable*@paramcolumn*@return*/@IgnoreAuth@RequestMapping("/option/{tableName}/{columnName}")publicRgetOption(@PathVariable("tableName")StringtableName,@PathVariable("columnName")StringcolumnName,@RequestParam(required=false)StringconditionColumn,@RequestParam(required=false)StringconditionValue,Stringlevel,Stringparent){Map<String,Object>params=newHashMap<String,Object>();params.put("table",tableName);params.put("column",columnName);if(StringUtils.isNotBlank(level)){params.put("level",level);}if(StringUtils.isNotBlank(parent)){params.put("parent",parent);}if(StringUtils.isNotBlank(conditionColumn)){params.put("conditionColumn",conditionColumn);}if(StringUtils.isNotBlank(conditionValue)){params.put("conditionValue",conditionValue);}List<String>data=commonService.getOption(params);returnR.ok().put("data",data);}/***根據(jù)table中的column獲取單條記錄*@paramtable*@paramcolumn*@return*/@IgnoreAuth@RequestMapping("/follow/{tableName}/{columnName}")publicRgetFollowByOption(@PathVariable("tableName")StringtableName,@PathVariable("columnName")StringcolumnName,@RequestParamStringcolumnValue){Map<String,Object>params=newHashMap<String,Object>();params.put("table",tableName);params.put("column",columnName);params.put("columnValue",columnValue);Map<String,Object>result=commonService.getFollowByOption(params);returnR.ok().put("data",result);}/***修改table表的sfsh狀態(tài)*@paramtable*@parammap*@return*/@RequestMapping("/sh/{tableName}")publicRsh(@PathVariable("tableName")StringtableName,@RequestBodyMap<String,Object>map){map.put("table",tableName);commonService.sh(map);returnR.ok();}/***獲取需要提醒的記錄數(shù)*@paramtableName*@paramcolumnName*@paramtype1:數(shù)字2:日期*@parammap*@return*/@IgnoreAuth@RequestMapping("/remind/{tableName}/{columnName}/{type}")publicRremindCount(@PathVariable("tableName")StringtableName,@PathVariable("columnName")StringcolumnName,@PathVariable("type")Stringtype,@RequestParamMap<String,Object>map){map.put("table",tableName);map.put("column",columnName);map.put("type",type);if(type.equals("2")){SimpleDateFormatsdf=newSimpleDateFormat("yyyy-MM-dd");Calendarc=Calendar.getInstance();DateremindStartDate=null;DateremindEndDate=null;if(map.get("remindstart")!=null){IntegerremindStart=Integer.parseInt(map.get("remindstart").toString());c.setTime(newDate());c.add(Calendar.DAY_OF_MONTH,remindStart);remindStartDate=c.getTime();map.put("remindstart",sdf.format(remindStartDate));}if(map.get("remindend")!=null){IntegerremindEnd=Integer.parseInt(map.get("remindend").toString());c.setTime(newDate());c.add(Calendar.DAY_OF_MONTH,remindEnd);remindEndDate=c.getTime();map.put("remindend",sdf.format(remindEndDate));}}intcount=commonService.remindCount(map);returnR.ok().put("count",count);}/***單列求和*/@IgnoreAuth@RequestMapping("/cal/{tableName}/{columnName}")publicRcal(@PathVariable("tableName")StringtableName,@PathVariable("columnName")StringcolumnName){Map<String,Object>params=newHashMap<String,Object>();params.put("table",tableName);params.put("column",columnName);Map<String,Object>result=commonService.selectCal(params);returnR.ok().put("data",result);}/***分組統(tǒng)計*/@IgnoreAuth@RequestMapping("/group/{tableName}/{columnName}")publicRgroup(@PathVariable("tableName")StringtableName,@PathVariable("columnName")StringcolumnName){Map<String,Object>params=newHashMap<String,Object>();params.put("table",tableName);params.put("column",columnName);List<Map<String,Object>>result=commonService.selectGroup(params);SimpleDateFormatsdf=newSimpleDateFormat("yyyy-MM-dd");for(Map<String,Object>m:result){for(Stringk:m.keySet()){if(m.get(k)instanceofDate){m.put(k,sdf.format((Date)m.get(k)));}}}returnR.ok().put("data",result);}/***（按值統(tǒng)計）*/@IgnoreAuth@RequestMapping("/value/{tableName}/{xColumnName}/{yColumnName}")publicRvalue(@PathVariable("tableName")StringtableName,@PathVariable("yColumnName")StringyColumnName,@PathVariable("xColumnName")StringxColumnName){Map<String,Object>params=newHashMap<String,Object>();params.put("table",tableName);params.put("xColumn",xColumnName);params.put("yColumn",yColumnName);List<Map<String,Object>>result=commonService.selectValue(params);SimpleDateFormatsdf=newSimpleDateFormat("yyyy-MM-dd");for(Map<String,Object>m:result){for(Stringk:m.keySet()){if(m.get(k)instanceofDate){m.put(k,sdf.format((Date)m.get(k)));}}}returnR.ok().put("data",result);}/***（按值統(tǒng)計）時間統(tǒng)計類型*/@IgnoreAuth@RequestMapping("/value/{tableName}/{xColumnName}/{yColumnName}/{timeStatType}")publicRvalueDay(@PathVariable("tableName")StringtableName,@PathVariable("yColumnName")StringyColumnName,@PathVariable("xColumnName")StringxColumnName,@PathVariable("timeStatType")StringtimeStatType){Map<String,Object>params=newHashMap<String,Object>();params.put("table",tableName);params.put("xColumn",xColumnName);params.put("yColumn",yColumnName);params.put("timeStatType",timeStatType);List<Map<String,Object>>result=commonService.selectTimeStatValue(params);SimpleDateFormatsdf=newSimpleDateFormat("yyyy-MM-dd");for(Map<String,Object>m:result){for(Stringk:m.keySet()){if(m.get(k)instanceofDate){m.put(k,sdf.format((Date)m.get(k)));}}}returnR.ok().put("data",result);}/***人臉比對**@paramface1人臉1*@paramface2人臉2*@return*/@RequestMapping("/matchFace")@IgnoreAuthpublicRmatchFace(Stringface1,Stringface2,HttpServletRequestrequest){if(client==null){/*StringAppID=configService.selectOne(newEntityWrapper<ConfigEntity>().eq("name","AppID")).getValue();*/StringAPIKey=configService.selectOne(newEntityWrapper<ConfigEntity>().eq("name","APIKey")).getValue();StringSecretKey=configService.selectOne(newEntityWrapper<ConfigEntity>().eq("name","SecretKey")).getValue();Stringtoken=BaiduUtil.getAuth(APIKey,SecretKey);if(token==null){returnR.error("請在配置管理中正確配置APIKey和SecretKey");}client=newAipFace(null,APIKey,SecretKey);client.setConnectionTimeoutInMillis(2000);client.setSocketTimeoutInMillis(60000);}JSONObjectres=null;try{Filepath=newFile(ResourceUtils.getURL("classpath:static").getPath());if(!path.exists()){path=newFile("");}Fileupload=newFile(path.getAbsolutePath(),"/upload/");