Mybatis list做条件查询

来源:互联网 发布:淘宝手机版 编辑:程序博客网 时间:2024/05/24 05:11

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>

0 0
原创粉丝点击