NutzCN Logo
问答 自定义sql返回异常
发布于 2189天前 作者 动物园里的程序猿 1315 次浏览 复制 上一个帖子 下一个帖子
标签: nutzwk
List<NutMap> bwarns = fBlinkWarningService.selectWarnNum(StringUtil.getPlatformUid());
 public List<NutMap> selectWarnNum(String uid){
        List<Map<String, Object>> map = new ArrayList<>();
        Sql sql = fm.create("selectWarnNum");
        sql.setParam("id",uid);
        sql.setCallback(Sqls.callback.maps());
        this.dao().execute(sql);
        List<NutMap> fmap = sql.getList(NutMap.class);
        return fmap;
    }

数据库显示这条sql查不到结果 但是给我返回了一个这样的map

[{num=0, id=null, name=null}]
8 回复

日志发一下?

[INFO ] 16:53:59.742 com.alibaba.dubbo.registry.support.AbstractRegistry.register(AbstractRegistry.java:273) -  [DUBBO] Register: consumer://192.168.168.195/cn.wizzer.app.sys.modules.services.SysConfigService?application=wk-nb-web-platform&category=consumers&check=false&dubbo=2.6.2&interface=cn.wizzer.app.sys.modules.services.SysConfigService&methods=updateWithVersion,data,insertRelation,insertWith,insertOrUpdate,dao,getMaxId,getSubPath,query,count,getField,vDelete,list,execute,fetchx,getMap,updateAndIncrIfMatch,updateLinks,fetchLinks,updateRelation,fastInsert,getAllList,update,insert,insertLinks,getParentPath,delete,updateIgnoreNull,getData,clear,getEntity,updateWith,fetch,exists,listPage&pid=10332&side=consumer&timestamp=1543308839718, dubbo version: 2.6.2, current host: 192.168.168.195
[INFO ] 16:53:59.782 com.alibaba.dubbo.registry.support.AbstractRegistry.subscribe(AbstractRegistry.java:298) -  [DUBBO] Subscribe: consumer://192.168.168.195/cn.wizzer.app.sys.modules.services.SysConfigService?application=wk-nb-web-platform&category=providers,configurators,routers&dubbo=2.6.2&interface=cn.wizzer.app.sys.modules.services.SysConfigService&methods=updateWithVersion,data,insertRelation,insertWith,insertOrUpdate,dao,getMaxId,getSubPath,query,count,getField,vDelete,list,execute,fetchx,getMap,updateAndIncrIfMatch,updateLinks,fetchLinks,updateRelation,fastInsert,getAllList,update,insert,insertLinks,getParentPath,delete,updateIgnoreNull,getData,clear,getEntity,updateWith,fetch,exists,listPage&pid=10332&side=consumer&timestamp=1543308839718, dubbo version: 2.6.2, current host: 192.168.168.195
[INFO ] 16:53:59.863 com.alibaba.dubbo.registry.support.AbstractRegistry.notify(AbstractRegistry.java:387) -  [DUBBO] Notify urls for subscribe url consumer://192.168.168.195/cn.wizzer.app.sys.modules.services.SysConfigService?application=wk-nb-web-platform&category=providers,configurators,routers&dubbo=2.6.2&interface=cn.wizzer.app.sys.modules.services.SysConfigService&methods=updateWithVersion,data,insertRelation,insertWith,insertOrUpdate,dao,getMaxId,getSubPath,query,count,getField,vDelete,list,execute,fetchx,getMap,updateAndIncrIfMatch,updateLinks,fetchLinks,updateRelation,fastInsert,getAllList,update,insert,insertLinks,getParentPath,delete,updateIgnoreNull,getData,clear,getEntity,updateWith,fetch,exists,listPage&pid=10332&side=consumer&timestamp=1543308839718, urls: [dubbo://192.168.168.195:18886/cn.wizzer.app.sys.modules.services.SysConfigService?anyhost=true&application=wk-nb-dubbo-sys&dubbo=2.6.2&generic=false&interface=cn.wizzer.app.sys.modules.services.SysConfigService&methods=updateWithVersion,data,insertRelation,insertWith,insertOrUpdate,dao,getMaxId,getSubPath,query,count,getField,vDelete,list,execute,fetchx,getMap,updateAndIncrIfMatch,updateLinks,fetchLinks,updateRelation,fastInsert,getAllList,update,insert,insertLinks,getParentPath,delete,updateIgnoreNull,getData,clear,getEntity,updateWith,fetch,exists,listPage&pid=8980&side=provider&timestamp=1543298492401, empty://192.168.168.195/cn.wizzer.app.sys.modules.services.SysConfigService?application=wk-nb-web-platform&category=configurators&dubbo=2.6.2&interface=cn.wizzer.app.sys.modules.services.SysConfigService&methods=updateWithVersion,data,insertRelation,insertWith,insertOrUpdate,dao,getMaxId,getSubPath,query,count,getField,vDelete,list,execute,fetchx,getMap,updateAndIncrIfMatch,updateLinks,fetchLinks,updateRelation,fastInsert,getAllList,update,insert,insertLinks,getParentPath,delete,updateIgnoreNull,getData,clear,getEntity,updateWith,fetch,exists,listPage&pid=10332&side=consumer&timestamp=1543308839718, empty://192.168.168.195/cn.wizzer.app.sys.modules.services.SysConfigService?application=wk-nb-web-platform&category=routers&dubbo=2.6.2&interface=cn.wizzer.app.sys.modules.services.SysConfigService&methods=updateWithVersion,data,insertRelation,insertWith,insertOrUpdate,dao,getMaxId,getSubPath,query,count,getField,vDelete,list,execute,fetchx,getMap,updateAndIncrIfMatch,updateLinks,fetchLinks,updateRelation,fastInsert,getAllList,update,insert,insertLinks,getParentPath,delete,updateIgnoreNull,getData,clear,getEntity,updateWith,fetch,exists,listPage&pid=10332&side=consumer&timestamp=1543308839718], dubbo version: 2.6.2, current host: 192.168.168.195
[INFO ] 16:53:59.864 com.alibaba.dubbo.config.ReferenceConfig.createProxy(ReferenceConfig.java:425) -  [DUBBO] Refer dubbo service cn.wizzer.app.sys.modules.services.SysConfigService from url zookeeper://127.0.0.1:2181/com.alibaba.dubbo.registry.RegistryService?anyhost=true&application=wk-nb-web-platform&check=false&dubbo=2.6.2&generic=false&interface=cn.wizzer.app.sys.modules.services.SysConfigService&methods=updateWithVersion,data,insertRelation,insertWith,insertOrUpdate,dao,getMaxId,getSubPath,query,count,getField,vDelete,list,execute,fetchx,getMap,updateAndIncrIfMatch,updateLinks,fetchLinks,updateRelation,fastInsert,getAllList,update,insert,insertLinks,getParentPath,delete,updateIgnoreNull,getData,clear,getEntity,updateWith,fetch,exists,listPage&pid=10332&register.ip=192.168.168.195&remote.timestamp=1543298492401&side=consumer&timestamp=1543308839718, dubbo version: 2.6.2, current host: 192.168.168.195
[INFO ] 16:53:59.903 com.alibaba.dubbo.registry.support.AbstractRegistry.register(AbstractRegistry.java:273) -  [DUBBO] Register: consumer://192.168.168.195/cn.wizzer.app.sys.modules.services.SysRouteService?application=wk-nb-web-platform&category=consumers&check=false&dubbo=2.6.2&interface=cn.wizzer.app.sys.modules.services.SysRouteService&methods=updateWithVersion,data,insertRelation,insertWith,insertOrUpdate,dao,getMaxId,getSubPath,query,count,getField,vDelete,list,execute,fetchx,getMap,updateAndIncrIfMatch,updateLinks,fetchLinks,updateRelation,fastInsert,update,insert,insertLinks,getParentPath,delete,updateIgnoreNull,getData,clear,getEntity,updateWith,fetch,exists,listPage&pid=10332&side=consumer&timestamp=1543308839882, dubbo version: 2.6.2, current host: 192.168.168.195
[INFO ] 16:53:59.936 com.alibaba.dubbo.registry.support.AbstractRegistry.subscribe(AbstractRegistry.java:298) -  [DUBBO] Subscribe: consumer://192.168.168.195/cn.wizzer.app.sys.modules.services.SysRouteService?application=wk-nb-web-platform&category=providers,configurators,routers&dubbo=2.6.2&interface=cn.wizzer.app.sys.modules.services.SysRouteService&methods=updateWithVersion,data,insertRelation,insertWith,insertOrUpdate,dao,getMaxId,getSubPath,query,count,getField,vDelete,list,execute,fetchx,getMap,updateAndIncrIfMatch,updateLinks,fetchLinks,updateRelation,fastInsert,update,insert,insertLinks,getParentPath,delete,updateIgnoreNull,getData,clear,getEntity,updateWith,fetch,exists,listPage&pid=10332&side=consumer&timestamp=1543308839882, dubbo version: 2.6.2, current host: 192.168.168.195
[INFO ] 16:54:00.097 com.alibaba.dubbo.registry.support.AbstractRegistry.notify(AbstractRegistry.java:387) -  [DUBBO] Notify urls for subscribe url consumer://192.168.168.195/cn.wizzer.app.sys.modules.services.SysRouteService?application=wk-nb-web-platform&category=providers,configurators,routers&dubbo=2.6.2&interface=cn.wizzer.app.sys.modules.services.SysRouteService&methods=updateWithVersion,data,insertRelation,insertWith,insertOrUpdate,dao,getMaxId,getSubPath,query,count,getField,vDelete,list,execute,fetchx,getMap,updateAndIncrIfMatch,updateLinks,fetchLinks,updateRelation,fastInsert,update,insert,insertLinks,getParentPath,delete,updateIgnoreNull,getData,clear,getEntity,updateWith,fetch,exists,listPage&pid=10332&side=consumer&timestamp=1543308839882, urls: [dubbo://192.168.168.195:18886/cn.wizzer.app.sys.modules.services.SysRouteService?anyhost=true&application=wk-nb-dubbo-sys&dubbo=2.6.2&generic=false&interface=cn.wizzer.app.sys.modules.services.SysRouteService&methods=updateWithVersion,data,insertRelation,insertWith,insertOrUpdate,dao,getMaxId,getSubPath,query,count,getField,vDelete,list,execute,fetchx,getMap,updateAndIncrIfMatch,updateLinks,fetchLinks,updateRelation,fastInsert,update,insert,insertLinks,getParentPath,delete,updateIgnoreNull,getData,clear,getEntity,updateWith,fetch,exists,listPage&pid=8980&side=provider&timestamp=1543298491085, empty://192.168.168.195/cn.wizzer.app.sys.modules.services.SysRouteService?application=wk-nb-web-platform&category=configurators&dubbo=2.6.2&interface=cn.wizzer.app.sys.modules.services.SysRouteService&methods=updateWithVersion,data,insertRelation,insertWith,insertOrUpdate,dao,getMaxId,getSubPath,query,count,getField,vDelete,list,execute,fetchx,getMap,updateAndIncrIfMatch,updateLinks,fetchLinks,updateRelation,fastInsert,update,insert,insertLinks,getParentPath,delete,updateIgnoreNull,getData,clear,getEntity,updateWith,fetch,exists,listPage&pid=10332&side=consumer&timestamp=1543308839882, empty://192.168.168.195/cn.wizzer.app.sys.modules.services.SysRouteService?application=wk-nb-web-platform&category=routers&dubbo=2.6.2&interface=cn.wizzer.app.sys.modules.services.SysRouteService&methods=updateWithVersion,data,insertRelation,insertWith,insertOrUpdate,dao,getMaxId,getSubPath,query,count,getField,vDelete,list,execute,fetchx,getMap,updateAndIncrIfMatch,updateLinks,fetchLinks,updateRelation,fastInsert,update,insert,insertLinks,getParentPath,delete,updateIgnoreNull,getData,clear,getEntity,updateWith,fetch,exists,listPage&pid=10332&side=consumer&timestamp=1543308839882], dubbo version: 2.6.2, current host: 192.168.168.195
[INFO ] 16:54:00.097 com.alibaba.dubbo.config.ReferenceConfig.createProxy(ReferenceConfig.java:425) -  [DUBBO] Refer dubbo service cn.wizzer.app.sys.modules.services.SysRouteService from url zookeeper://127.0.0.1:2181/com.alibaba.dubbo.registry.RegistryService?anyhost=true&application=wk-nb-web-platform&check=false&dubbo=2.6.2&generic=false&interface=cn.wizzer.app.sys.modules.services.SysRouteService&methods=updateWithVersion,data,insertRelation,insertWith,insertOrUpdate,dao,getMaxId,getSubPath,query,count,getField,vDelete,list,execute,fetchx,getMap,updateAndIncrIfMatch,updateLinks,fetchLinks,updateRelation,fastInsert,update,insert,insertLinks,getParentPath,delete,updateIgnoreNull,getData,clear,getEntity,updateWith,fetch,exists,listPage&pid=10332&register.ip=192.168.168.195&remote.timestamp=1543298491085&side=consumer&timestamp=1543308839882, dubbo version: 2.6.2, current host: 192.168.168.195
[INFO ] 16:54:00.247 org.nutz.boot.NbApp.execute(NbApp.java:213) - wk-nb-web-platform started : 5181ms
[INFO ] 16:54:00.700 org.apache.shiro.session.mgt.AbstractValidatingSessionManager.enableSessionValidation(AbstractValidatingSessionManager.java:233) - Enabling session validation scheduler...
[INFO ] 16:54:00.933 com.alibaba.dubbo.registry.support.AbstractRegistry.register(AbstractRegistry.java:273) -  [DUBBO] Register: consumer://192.168.168.195/cn.wizzer.app.krobot.modules.services.FPricelistWarningService?application=wk-nb-web-platform&category=consumers&check=false&dubbo=2.6.2&interface=cn.wizzer.app.krobot.modules.services.FPricelistWarningService&methods=updateWithVersion,data,insertRelation,updateAllWarning,insertWith,insertOrUpdate,dao,getMaxId,countNum,getSubPath,query,count,getField,vDelete,list,execute,fetchx,getMap,updateAndIncrIfMatch,getWarningNum,updateLinks,fetchLinks,updateRelation,fastInsert,update,insert,insertLinks,getParentPath,delete,updateIgnoreNull,updateRobotWarning,getData,updateState,clear,getEntity,updateWith,fetch,exists,listPage&pid=10332&side=consumer&timeout=3000000&timestamp=1543308840910, dubbo version: 2.6.2, current host: 192.168.168.195
[INFO ] 16:54:00.993 com.alibaba.dubbo.registry.support.AbstractRegistry.subscribe(AbstractRegistry.java:298) -  [DUBBO] Subscribe: consumer://192.168.168.195/cn.wizzer.app.krobot.modules.services.FPricelistWarningService?application=wk-nb-web-platform&category=providers,configurators,routers&dubbo=2.6.2&interface=cn.wizzer.app.krobot.modules.services.FPricelistWarningService&methods=updateWithVersion,data,insertRelation,updateAllWarning,insertWith,insertOrUpdate,dao,getMaxId,countNum,getSubPath,query,count,getField,vDelete,list,execute,fetchx,getMap,updateAndIncrIfMatch,getWarningNum,updateLinks,fetchLinks,updateRelation,fastInsert,update,insert,insertLinks,getParentPath,delete,updateIgnoreNull,updateRobotWarning,getData,updateState,clear,getEntity,updateWith,fetch,exists,listPage&pid=10332&side=consumer&timeout=3000000&timestamp=1543308840910, dubbo version: 2.6.2, current host: 192.168.168.195
[INFO ] 16:54:01.056 com.alibaba.dubbo.registry.support.AbstractRegistry.notify(AbstractRegistry.java:387) -  [DUBBO] Notify urls for subscribe url consumer://192.168.168.195/cn.wizzer.app.krobot.modules.services.FPricelistWarningService?application=wk-nb-web-platform&category=providers,configurators,routers&dubbo=2.6.2&interface=cn.wizzer.app.krobot.modules.services.FPricelistWarningService&methods=updateWithVersion,data,insertRelation,updateAllWarning,insertWith,insertOrUpdate,dao,getMaxId,countNum,getSubPath,query,count,getField,vDelete,list,execute,fetchx,getMap,updateAndIncrIfMatch,getWarningNum,updateLinks,fetchLinks,updateRelation,fastInsert,update,insert,insertLinks,getParentPath,delete,updateIgnoreNull,updateRobotWarning,getData,updateState,clear,getEntity,updateWith,fetch,exists,listPage&pid=10332&side=consumer&timeout=3000000&timestamp=1543308840910, urls: [dubbo://192.168.168.195:12641/cn.wizzer.app.krobot.modules.services.FPricelistWarningService?anyhost=true&application=wk-nb-dubbo-krobot&dubbo=2.6.2&generic=false&interface=cn.wizzer.app.krobot.modules.services.FPricelistWarningService&methods=updateWithVersion,data,insertRelation,updateAllWarning,insertWith,insertOrUpdate,dao,getMaxId,countNum,getSubPath,query,count,getField,vDelete,list,execute,fetchx,getMap,updateAndIncrIfMatch,getWarningNum,updateLinks,fetchLinks,updateRelation,fastInsert,update,insert,insertLinks,getParentPath,delete,updateIgnoreNull,updateRobotWarning,getData,updateState,clear,getEntity,updateWith,fetch,exists,listPage&pid=10888&side=provider&timestamp=1543307710239, empty://192.168.168.195/cn.wizzer.app.krobot.modules.services.FPricelistWarningService?application=wk-nb-web-platform&category=configurators&dubbo=2.6.2&interface=cn.wizzer.app.krobot.modules.services.FPricelistWarningService&methods=updateWithVersion,data,insertRelation,updateAllWarning,insertWith,insertOrUpdate,dao,getMaxId,countNum,getSubPath,query,count,getField,vDelete,list,execute,fetchx,getMap,updateAndIncrIfMatch,getWarningNum,updateLinks,fetchLinks,updateRelation,fastInsert,update,insert,insertLinks,getParentPath,delete,updateIgnoreNull,updateRobotWarning,getData,updateState,clear,getEntity,updateWith,fetch,exists,listPage&pid=10332&side=consumer&timeout=3000000&timestamp=1543308840910, empty://192.168.168.195/cn.wizzer.app.krobot.modules.services.FPricelistWarningService?application=wk-nb-web-platform&category=routers&dubbo=2.6.2&interface=cn.wizzer.app.krobot.modules.services.FPricelistWarningService&methods=updateWithVersion,data,insertRelation,updateAllWarning,insertWith,insertOrUpdate,dao,getMaxId,countNum,getSubPath,query,count,getField,vDelete,list,execute,fetchx,getMap,updateAndIncrIfMatch,getWarningNum,updateLinks,fetchLinks,updateRelation,fastInsert,update,insert,insertLinks,getParentPath,delete,updateIgnoreNull,updateRobotWarning,getData,updateState,clear,getEntity,updateWith,fetch,exists,listPage&pid=10332&side=consumer&timeout=3000000&timestamp=1543308840910], dubbo version: 2.6.2, current host: 192.168.168.195
[INFO ] 16:54:01.067 com.alibaba.dubbo.remoting.transport.AbstractClient.connect(AbstractClient.java:282) -  [DUBBO] Successed connect to server /192.168.168.195:12641 from NettyClient 192.168.168.195 using dubbo version 2.6.2, channel is NettyChannel [channel=[id: 0x26a0e0c1, /192.168.168.195:52640 => /192.168.168.195:12641]], dubbo version: 2.6.2, current host: 192.168.168.195
[INFO ] 16:54:01.067 com.alibaba.dubbo.remoting.transport.AbstractClient.<init>(AbstractClient.java:91) -  [DUBBO] Start NettyClient Admin-PC/192.168.168.195 connect to the server /192.168.168.195:12641, dubbo version: 2.6.2, current host: 192.168.168.195
[INFO ] 16:54:01.068 com.alibaba.dubbo.config.ReferenceConfig.createProxy(ReferenceConfig.java:425) -  [DUBBO] Refer dubbo service cn.wizzer.app.krobot.modules.services.FPricelistWarningService from url zookeeper://127.0.0.1:2181/com.alibaba.dubbo.registry.RegistryService?anyhost=true&application=wk-nb-web-platform&check=false&dubbo=2.6.2&generic=false&interface=cn.wizzer.app.krobot.modules.services.FPricelistWarningService&methods=updateWithVersion,data,insertRelation,updateAllWarning,insertWith,insertOrUpdate,dao,getMaxId,countNum,getSubPath,query,count,getField,vDelete,list,execute,fetchx,getMap,updateAndIncrIfMatch,getWarningNum,updateLinks,fetchLinks,updateRelation,fastInsert,update,insert,insertLinks,getParentPath,delete,updateIgnoreNull,updateRobotWarning,getData,updateState,clear,getEntity,updateWith,fetch,exists,listPage&pid=10332&register.ip=192.168.168.195&remote.timestamp=1543307710239&side=consumer&timeout=3000000&timestamp=1543308840910, dubbo version: 2.6.2, current host: 192.168.168.195
[INFO ] 16:54:01.102 com.alibaba.dubbo.registry.support.AbstractRegistry.register(AbstractRegistry.java:273) -  [DUBBO] Register: consumer://192.168.168.195/cn.wizzer.app.blink.modules.services.FBlinkWarningService?application=wk-nb-web-platform&category=consumers&check=false&dubbo=2.6.2&interface=cn.wizzer.app.blink.modules.services.FBlinkWarningService&methods=updateWithVersion,data,insertRelation,insertWith,insertOrUpdate,dao,selectWarnNum,getMaxId,countNum,getSubPath,query,count,getField,vDelete,list,execute,fetchx,getMap,updateAndIncrIfMatch,updateLinks,fetchLinks,updateRelation,fastInsert,dealWith,update,insert,insertLinks,getParentPath,delete,updateIgnoreNull,getData,clear,getEntity,updateWith,fetch,exists,listPage&pid=10332&side=consumer&timeout=3000000&timestamp=1543308841085, dubbo version: 2.6.2, current host: 192.168.168.195
[INFO ] 16:54:01.121 com.alibaba.dubbo.registry.support.AbstractRegistry.subscribe(AbstractRegistry.java:298) -  [DUBBO] Subscribe: consumer://192.168.168.195/cn.wizzer.app.blink.modules.services.FBlinkWarningService?application=wk-nb-web-platform&category=providers,configurators,routers&dubbo=2.6.2&interface=cn.wizzer.app.blink.modules.services.FBlinkWarningService&methods=updateWithVersion,data,insertRelation,insertWith,insertOrUpdate,dao,selectWarnNum,getMaxId,countNum,getSubPath,query,count,getField,vDelete,list,execute,fetchx,getMap,updateAndIncrIfMatch,updateLinks,fetchLinks,updateRelation,fastInsert,dealWith,update,insert,insertLinks,getParentPath,delete,updateIgnoreNull,getData,clear,getEntity,updateWith,fetch,exists,listPage&pid=10332&side=consumer&timeout=3000000&timestamp=1543308841085, dubbo version: 2.6.2, current host: 192.168.168.195
[INFO ] 16:54:01.231 com.alibaba.dubbo.registry.support.AbstractRegistry.notify(AbstractRegistry.java:387) -  [DUBBO] Notify urls for subscribe url consumer://192.168.168.195/cn.wizzer.app.blink.modules.services.FBlinkWarningService?application=wk-nb-web-platform&category=providers,configurators,routers&dubbo=2.6.2&interface=cn.wizzer.app.blink.modules.services.FBlinkWarningService&methods=updateWithVersion,data,insertRelation,insertWith,insertOrUpdate,dao,selectWarnNum,getMaxId,countNum,getSubPath,query,count,getField,vDelete,list,execute,fetchx,getMap,updateAndIncrIfMatch,updateLinks,fetchLinks,updateRelation,fastInsert,dealWith,update,insert,insertLinks,getParentPath,delete,updateIgnoreNull,getData,clear,getEntity,updateWith,fetch,exists,listPage&pid=10332&side=consumer&timeout=3000000&timestamp=1543308841085, urls: [dubbo://192.168.168.195:14475/cn.wizzer.app.blink.modules.services.FBlinkWarningService?anyhost=true&application=wk-nb-dubbo-blink&dubbo=2.6.2&generic=false&interface=cn.wizzer.app.blink.modules.services.FBlinkWarningService&methods=updateWithVersion,data,insertRelation,insertWith,insertOrUpdate,dao,selectWarnNum,getMaxId,countNum,getSubPath,query,count,getField,vDelete,list,execute,fetchx,getMap,updateAndIncrIfMatch,updateLinks,fetchLinks,updateRelation,fastInsert,dealWith,update,insert,insertLinks,getParentPath,delete,updateIgnoreNull,getData,clear,getEntity,updateWith,fetch,exists,listPage&payload=115570500&pid=13576&side=provider&timestamp=1543307886042, empty://192.168.168.195/cn.wizzer.app.blink.modules.services.FBlinkWarningService?application=wk-nb-web-platform&category=configurators&dubbo=2.6.2&interface=cn.wizzer.app.blink.modules.services.FBlinkWarningService&methods=updateWithVersion,data,insertRelation,insertWith,insertOrUpdate,dao,selectWarnNum,getMaxId,countNum,getSubPath,query,count,getField,vDelete,list,execute,fetchx,getMap,updateAndIncrIfMatch,updateLinks,fetchLinks,updateRelation,fastInsert,dealWith,update,insert,insertLinks,getParentPath,delete,updateIgnoreNull,getData,clear,getEntity,updateWith,fetch,exists,listPage&pid=10332&side=consumer&timeout=3000000&timestamp=1543308841085, empty://192.168.168.195/cn.wizzer.app.blink.modules.services.FBlinkWarningService?application=wk-nb-web-platform&category=routers&dubbo=2.6.2&interface=cn.wizzer.app.blink.modules.services.FBlinkWarningService&methods=updateWithVersion,data,insertRelation,insertWith,insertOrUpdate,dao,selectWarnNum,getMaxId,countNum,getSubPath,query,count,getField,vDelete,list,execute,fetchx,getMap,updateAndIncrIfMatch,updateLinks,fetchLinks,updateRelation,fastInsert,dealWith,update,insert,insertLinks,getParentPath,delete,updateIgnoreNull,getData,clear,getEntity,updateWith,fetch,exists,listPage&pid=10332&side=consumer&timeout=3000000&timestamp=1543308841085], dubbo version: 2.6.2, current host: 192.168.168.195
[INFO ] 16:54:01.240 com.alibaba.dubbo.remoting.transport.AbstractClient.connect(AbstractClient.java:282) -  [DUBBO] Successed connect to server /192.168.168.195:14475 from NettyClient 192.168.168.195 using dubbo version 2.6.2, channel is NettyChannel [channel=[id: 0x729f8887, /192.168.168.195:52647 => /192.168.168.195:14475]], dubbo version: 2.6.2, current host: 192.168.168.195
[INFO ] 16:54:01.240 com.alibaba.dubbo.remoting.transport.AbstractClient.<init>(AbstractClient.java:91) -  [DUBBO] Start NettyClient Admin-PC/192.168.168.195 connect to the server /192.168.168.195:14475, dubbo version: 2.6.2, current host: 192.168.168.195
[INFO ] 16:54:01.241 com.alibaba.dubbo.config.ReferenceConfig.createProxy(ReferenceConfig.java:425) -  [DUBBO] Refer dubbo service cn.wizzer.app.blink.modules.services.FBlinkWarningService from url zookeeper://127.0.0.1:2181/com.alibaba.dubbo.registry.RegistryService?anyhost=true&application=wk-nb-web-platform&check=false&dubbo=2.6.2&generic=false&interface=cn.wizzer.app.blink.modules.services.FBlinkWarningService&methods=updateWithVersion,data,insertRelation,insertWith,insertOrUpdate,dao,selectWarnNum,getMaxId,countNum,getSubPath,query,count,getField,vDelete,list,execute,fetchx,getMap,updateAndIncrIfMatch,updateLinks,fetchLinks,updateRelation,fastInsert,dealWith,update,insert,insertLinks,getParentPath,delete,updateIgnoreNull,getData,clear,getEntity,updateWith,fetch,exists,listPage&payload=115570500&pid=10332&register.ip=192.168.168.195&remote.timestamp=1543307886042&side=consumer&timeout=3000000&timestamp=1543308841085, dubbo version: 2.6.2, current host: 192.168.168.195
[{num=0, id=null, name=null}]
[{num=0, id=null, name=null}]
[{num=0, id=null, name=null}]

控制台没报错

打印一下fmap 的值, 在这个实现方法里面

fmap[{num=0, id=null, name=null}]
fmap[{num=0, id=null, name=null}]
fmap[{num=0, id=null, name=null}]
fmap[{num=0, id=null, name=null}]
fmap[{num=0, id=null, name=null}]
fmap[{num=0, id=null, name=null}]
fmap[{num=0, id=null, name=null}]
fmap[{num=0, id=null, name=null}]
fmap[{num=0, id=null, name=null}]

那看来是sql的问题,查询结果并非0条,用存储过程做的?

不是啊 就是一个简单的关联查询

select count(t.id) num, t.robot_id id,t.rname name from f_blink_warning t ,sys_user_path a,sys_user_path b
                WHERE t.opBy = b.userid
                AND b.path LIKE CONCAT(a.path, '%')
                AND a.userid = @id
                and t.status = 0

我晕,既然有count,那肯定有结果集呀

添加回复
请先登陆
回到顶部