private String makeSZ_IDX(String cCode, String cPhone, String zoneFlag) { Vector<String> sqlBox = new Vector<String>(); sqlBox.addElement(cCode); sqlBox.addElement(zoneFlag); Vector<Properties> resultBox = new Vector<Properties>(); sqlSetUp.getPrimaryKey(sqlBox, resultBox); String sz_idx = null; if (zoneFlag.equals("0")) { // 안심존 if (resultBox.size() >= 3) { sz_idx = null; } else { boolean firstFlag = true; boolean secondFlag = true; boolean thirdFlag = true; for (int i = 0; i < resultBox.size(); ++i) { Properties prop = resultBox.elementAt(i); String pk = prop.getProperty("SZ_IDX"); if (pk.indexOf("s01") >= 0) { firstFlag = false; } else if (pk.indexOf("s02") >= 0) { secondFlag = false; } else if (pk.indexOf("s03") >= 0) { thirdFlag = false; } } if (firstFlag) { sz_idx = cPhone + "_s01"; } else if (secondFlag) { sz_idx = cPhone + "_s02"; } else if (thirdFlag) { sz_idx = cPhone + "_s03"; } } } else if (zoneFlag.equals("1")) { if (resultBox.size() >= 1) { sz_idx = null; } else { sz_idx = cPhone + "_d01"; } } return sz_idx; }