mysql注解之Select

 @Select({
   
            "<script>",
            "select p.path " ,
            "from ds_permission p " ,
            "LEFT JOIN ds_role_permission rp on p.ID = rp.PID ",
            "LEFT JOIN ds_role r on rp.RID = r.ID ",
            "where r.ROLE_NAME  in ",
            "<foreach collection = 'roles' item='role' open='(' separator = ',' close = ')'>" ,
            "#{role}" ,
            "</foreach>" ,
            "</script>"
    })
    List<String> findAuthorityByUserName(@Param("roles"