Mybatis list做条件查询

decamincow

于 2015-05-07 19:38:46 发布

阅读量3.4k

点赞数

CC 4.0 BY-SA版权

分类专栏： JAVA

本文链接：https://blog.youkuaiyun.com/guoren12/article/details/45565517

JAVA 专栏收录该内容

14 篇文章

订阅专栏

本文介绍如何使用MyBatis从数据库中通过团队ID批量获取团队成员信息的方法。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

	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>