Kang Donghun · @kang-dh · Kim Peace · Kang Donghun · Kang Donghun · Kang Donghun
--- a/ABVJE_BL/src/jp/agentec/abook/abv/bl/data/dao/ShopMemberDao.java
+++ b/ABVJE_BL/src/jp/agentec/abook/abv/bl/data/dao/ShopMemberDao.java
+		sql.append(" FROM ");
+		sql.append("      m_shop_member AS sm ");
+		sql.append(" WHERE ");
+		sql.append("      sm.login_id IN (");
+
+		ArrayList<String> whereSqlList = new ArrayList<String>();
+		for (String loginId : loginIdList) {
+			if (StringUtil.isNullOrEmpty(loginId)){
+				continue;
+			}
+			String whereSql = "'"+loginId+"' ";
+			whereSqlList.add(whereSql);
+		}
+		if (CollectionUtil.isNotEmpty(whereSqlList)) {
+			sql.append(StringUtil.join(" , ", whereSqlList) + ")");
+		}