我的错误是
Cause: com.baomidou.mybatisplus.core.exceptions.MybatisPlusException: Error: Method queryTotal execution error of sql : 这些是sql语句
首先 sql语句在数据库里直接运行是没有问题的,而且在我的本地运行项目也没有报这种错误,到了服务器上就会报错,我本地和服务器环境一致,这种问题也是出现多次了
经历了三个小时的反复测试终于成功
我修改后的mapper文件
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.bjbss.bbcsupport.mapper.BbcZsbankMapper">
<resultMap id="ResultMap" type="com.bjbss.bbcsupport.domain.BbcZsbank">
<result column="batch_number" property="batchNumber"/>
<result column="tname" property="name"/>
<result column="id_card" property="idCard"/>
<result column="trelation" property="relation"/>
<result column="recognizee_name" property="recognizeeName"/>
<result column="recognizeeCard" property="recognizeeCard"/>
<result column="coverages" property="coverages"/>
</resultMap>
<select id="findPage" resultMap="ResultMap">
select min(name) as tname,id_card,min(relation) as trelation ,recognizee_name,min(recognizee_card) as recognizeeCard,SUM(coverage) as coverages
from bbc_zsbank where id_card = #{params.idCard}
GROUP BY recognizee_name,id_card
</select>
</mapper>
修改前文件代码
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.bjbss.bbcsupport.mapper.BbcZsbankMapper">
<resultMap id="ResultMap" type="com.bjbss.bbcsupport.domain.BbcZsbank">
<result column="batch_number" property="batchNumber"/>
<result column="name" property="name"/>
<result column="id_card" property="idCard"/>
<result column="relation" property="relation"/>
<result column="recognizee_name" property="recognizeeName"/>
<result column="recognizee_card" property="recognizeeCard"/>
<result column="coverages" property="coverages"/>
</resultMap>
<select id="findPage" resultMap="ResultMap">
select name,id_card,relation ,recognizee_name,recognizee_card,SUM(coverage) as coverages
from bbc_zsbank where id_card = #{params.idCard}
GROUP BY recognizee_name,id_card
</select>
</mapper>
给不是 group by 条件的字段加了 min函数 起了别名让这个字段脱离数据库属性