Mysql中实现多对多的查询

最新推荐文章于 2024-07-07 21:56:46 发布

yk_good

最新推荐文章于 2024-07-07 21:56:46 发布

阅读量1.4k

点赞数

本文链接：https://blog.csdn.net/yangkai363873125/article/details/81782407

版权

1.Mybatis中：

			<if  test="constructionOfficeIdList != null and constructionOfficeIdList.size >0">
				AND (
				<foreach collection="constructionOfficeIdList" item="const" index="index">
					<if test="index ==0">
						 FIND_IN_SET(${const},a.construction_office_ids)
					</if>
					<if test="index >0">
						OR FIND_IN_SET(${const},a.construction_office_ids)
					</if>
				</foreach>
				)
			</if>

2.java后台中

		if (StringUtils.isNotBlank(transportQuery.getWarningTypeString())) {
			String[] split = transportQuery.getWarningTypeString().split(",");
			for (int i = 0; i < split.length; i++) {
				if (i == 0 && 0 == split.length - 1) {
					sqlMaps.append("and (FIND_IN_SET(" + split[i] + ",a.warning_type))");
				}
				if (i == 0 && 0 != split.length - 1) {
					sqlMaps.append("and (FIND_IN_SET(" + split[i] + ",a.warning_type)");
				}
				if (i != 0 && i != split.length - 1) {
					sqlMaps.append(" or FIND_IN_SET(" + split[i] + ",a.warning_type)");
				}
				if (i != 0 && i == split.length - 1) {
					sqlMaps.append(" or FIND_IN_SET(" + split[i] + ",a.warning_type))");
				}
			}
		}
		transportQuery.setSqlMaps(sqlMaps.toString());