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

Question

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"}

Answer 1

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