In the ssm framework of java, in the mapper interface, if the interface name is the same and the parameters are different, how to distinguish it in xml?

    int updateDepartmentManagerState(@Param("id")String id,@Param("code")String code,@Param("time")String time);
    int updateDepartmentManagerState(@Param("id")String id,@Param("code")String code,@Param("time")String time,@Param("reason")String reason);
Mar.03,2021

cannot be overloaded, because


you can use if in xml to determine whether the parameter exists, and concatenate different sql,


can not be overloaded. XML has no overloaded statement

.
MySQL Query : SELECT * FROM `codeshelper`.`v9_news` WHERE status=99 AND catid='6' ORDER BY rand() LIMIT 5
MySQL Error : Disk full (/tmp/#sql-temptable-64f5-1b39e7f-2b71b.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
MySQL Errno : 1021
Message : Disk full (/tmp/#sql-temptable-64f5-1b39e7f-2b71b.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
Need Help?