SpringCloud微服务开发时报了一个错,请经验丰富的高手指教一下?

This application has no explicit mapping for /error, so you are seeing this as a fallback.
Tue Nov 27 09:52:19 CST 2018
There was an unexpected error (type=Internal Server Error, status=500).
status 500 reading ProcessApplyRemoteService#getCertListByAccttypeRemote(Byte); content: {"timestamp":1543283539684,"status":500,"error":"Internal Server Error","exception":"org.mybatis.spring.MyBatisSystemException","message":"nested exception is org.apache.ibatis.type.TypeException: Could not set parameters for mapping: ParameterMapping{property='accType', mode=IN, javaType=class java.lang.Object, jdbcType=null, numericScale=null, resultMapId='null', jdbcTypeName='null', expression='null'}. Cause: org.apache.ibatis.type.TypeException: Error setting non null for parameter #1 with JdbcType null . Try setting a different JdbcType for this parameter or a different configuration property. Cause: org.apache.ibatis.type.TypeException: Error setting non null for parameter #1 with JdbcType null . Try setting a different JdbcType for this parameter or a different configuration property. Cause: java.sql.SQLException: Parameter index out of range (1 > number of parameters, which is 0).","path":"/get/cert/list/by/accttype/remote/0"}

好吧!刚发的问题贴,立马自己解决了!也是没谁了。主要在于sql语句使用多表查询,在进行id获取时使用了on ,事实是需要使用in来指定所有的变量,不然就会出现查询返回结果为0,而数据库却明明存在该数据的尴尬局面

spring clord雷丰阳 大佬你把视频传给我白

猜想可能是你数据库是 int 类型的 但是插入给了 null 值, 总结来说就是类型不对应造成的