这个坑一般是在用注解时,因为换行导致的,以下是例子
这个是有问题的:
@Select("SELECT teamMasterId, projectName, teamName, teamLeadName, stakeholderName, responsiblePersonName" + "FROM list WHERE teamName LIKE CONCAT('%', #{teamName}, '%')")
正确的换行用法应该是这样的:
@Select("SELECT teamMasterId, projectName, teamName, teamLeadName, stakeholderName, responsiblePersonName " + "FROM list " + "WHERE teamName LIKE CONCAT('%', #{teamName}, '%')")
或者在IDEA中写成一行也是正确的:
@Select("SELECT teamMasterId, projectName, teamName, teamLeadName, stakeholderName, responsiblePersonName FROM list WHERE teamName LIKE CONCAT('%', #{teamName}, '%')")
总结:使用mybatis SQL注解时,如果用到了换行,格式要求很严格,不换行则不会
----------------------------------------------------------------------------------------------------
还有一种错误是字符串拼接的时候末尾没有加空格