public static List<TeamModel> getTeamsByTeamsIds(int userId, List<Integer> list) { SqlSession session = MybatisWrapper.openSession(); List<TeamModel> result = null; try { TeamMapper mapper = session.getMapper(TeamMapper.class); Map<String, Object> parameters = new HashMap<String, Object>(); parameters.put("list", list); result = mapper.getTeamsByTeamIds(parameters); } catch (PersistenceException e) { logger.warn("Error occured while xxx, error: {}", userId, e); } finally { MybatisWrapper.closeSession(session); } return result; } WHERE t.team_id IN <foreach item="item" index="index" collection="list" open="(" separator="," close=")"> #{item} </foreach>