db 데이터 조회시 조회 후에 특정 컬럼 한줄로 합칠때 사용하는 함수?...
--오라클
LISTAGG(aaa,',') WITHIN GROUP(ORDER BY aaa) AS aaa,
--단순히 aaa필드를 , 구분값으로 합친다
regexp_replace(LISTAGG( bbb|| ',' ) WITHIN GROUP ( ORDER BY bbb), '([^,]+)(,\1)+', '\1') bbb,
--bbb 필드 한줄로 합칠경우 중복 제거 후 합친다
mysql 버전
group_concat(distinct(aaa)) AS aaa
--aaa필드 한줄로 합칠경우 중복 제거 후 합친다
soap 개발했을때 쓴소스
대충로직이 wsdl 바로 불러와서쓴듯.
public String retrieveIDMSCustIdfyNo(String address, String custDivCd, String custId) throws java.lang.Exception {
String ipin_ci = "";
URL wsdlURL = CustInfoRetvWebSvcService.WSDL_LOCATION;
try {
/** cdm 연동 URL
* 개발 /SIT : http://10.217.157.95:5000/SoapGateway/
* 운용 : http://10.219.3.190:5000/SoapGateway/
*
*/
wsdlURL = new URL("file:///user/webims/idmsd/ktws/src/kt/idss/ktws/cdm/wsdl/PL_CustInfoRetvWebSvc_20151113.wsdl"); //TODO 운용/SIT
//wsdlURL = new URL("file:///user/develop/idmsd/ktws/webapp/WEB-INF/classes/kt/idss/ktws/cdm/wsdl/PL_CustInfoRetvWebSvc_20151113.wsdl"); //TODO 개발
}catch(Exception e){
throw e;
}
kt.idss.ktws.cdm.CustInfoRetvWebSvcService custInfoRetvWebSvcService = new CustInfoRetvWebSvcService(wsdlURL);
kt.idss.ktws.cdm.PLCustInfoRetvWebSvcPort binding= custInfoRetvWebSvcService.getPLCustInfoRetvWebSvcPort();
/* trDate/trTime/lgDateTime/globaTime 세팅*/
SimpleDateFormat date = new SimpleDateFormat("yyyyMMddHHmmssSSSS");
String trDate = date.format(new Date()).substring(0, 8); //YYYYMMDD
String trTime = date.format(new Date()).substring(8, 17); //yyyyMMddHHmmssSSSS (년월일 제외 시간부터 뒷자리) hh(24)missttt
String lgDateTime = date.format(new Date()).substring(0,14); //YYYYMMDDHH(24)MISS
String globaTime = date.format(new Date());
/*clntIp No 세팅*/
InetAddress ip = InetAddress.getLocalHost();
String clntIp = ip.getHostAddress();
/*global No rand 세팅*/
String randglobalNo = null;
randglobalNo=getRandomKey(14);
StringBuffer globalNoBuf = new StringBuffer();
globalNoBuf.append(randglobalNo); //14자리
globalNoBuf.append(globaTime); //18자리
String globalNo =globalNoBuf.toString(); //32자리
/*commonHeaderHolder set*/
javax.xml.ws.Holder<CommonHeader> commonHeader = new javax.xml.ws.Holder<CommonHeader>();
CommonHeader setHeader = new CommonHeader();
setHeader.setAppName("NBSS_CDM");
setHeader.setSvcName("/CDM/PipelineSVC/NCST/CustInfoAdm/PL_CustInfoRetvWebSvc");
setHeader.setFnName("retrieveIDMSCustIdfyNo");
setHeader.setFnCd("");
setHeader.setGlobalNo(globalNo);
setHeader.setChnlType("IM");
setHeader.setEnvrFlag("");
setHeader.setTrFlag("T");
setHeader.setTrDate(trDate);
setHeader.setTrTime(trTime);
setHeader.setClntIp(clntIp);
setHeader.setResponseType("");
setHeader.setResponseCode("");
setHeader.setResponseLogcd("");
setHeader.setResponseTitle("");
setHeader.setResponseBasc("");
setHeader.setResponseDtal("");
setHeader.setResponseSystem("");
setHeader.setUserId("91129295");
setHeader.setRealUserId("91129295");
setHeader.setFiller("");
setHeader.setLangCode("");
setHeader.setOrgId("SPT8050");
setHeader.setSrcId("IDMSWSCDMA0");
setHeader.setCurHostId("");
setHeader.setLgDateTime(lgDateTime);
setHeader.setTokenId("");
setHeader.setCmpnCd("KTF");
setHeader.setLockType("");
setHeader.setLockId("");
setHeader.setLockTimeSt("");
setHeader.setBusinessKey("");
setHeader.setArbitraryKey("");
setHeader.setResendFlag("");
setHeader.setPhase("PA1");
commonHeader.value = setHeader;
/** TODO Value Check ******************/
BizHeader reqBizHeader = new BizHeader();
reqBizHeader.setOrderId ("orderid");
reqBizHeader.setCbSvcName ("/CDM/PipelineSVC/NCST/CustInfoAdm/PL_CustInfoRetvWebSvc");
reqBizHeader.setCbFnName ("retrieveIDMSCustIdfyNo");
/***************************************/
CustIdDTO custIdDTO = new CustIdDTO();
custIdDTO.setCustDivCd(custDivCd);
custIdDTO.setCustId(custId);
IoCCsm1200QS ioCCsm1200QS = new IoCCsm1200QS();
ioCCsm1200QS.setCustId(custId);
RetrieveIDMSCustIdfyNorequestType request = new RetrieveIDMSCustIdfyNorequestType();
request.setBizHeader(reqBizHeader);
request.setCustIdDTO(custIdDTO);
try {
logger.info("***** PL_CustInfoRetvWebSvc Start.......");
RetrieveIDMSCustIdfyNoresponseType IDMSresponse =null;
BizHeader repBizHeader = null;
IDMSCustBasInfoDTO custBasInfoDTO = null;
logger.info("***** retrieveIDMSCustIdfyNo Start.......");
IDMSresponse=binding.retrieveIDMSCustIdfyNo(commonHeader, request);
logger.info("***** retrieveIDMSCustIdfyNo end.......");
if (IDMSresponse != null) {
repBizHeader = IDMSresponse.getBizHeader();
if (repBizHeader != null) {
logger.info("\t orderId : " + repBizHeader.getOrderId ());
logger.info("\t cbSvcName : " + repBizHeader.getCbSvcName ());
logger.info("\t cbFnName : " + repBizHeader.getCbFnName ());
}
custBasInfoDTO = IDMSresponse.getCustBasInfoDTO();
logger.debug("\t confResltCd : " + custBasInfoDTO.getConfResltCd ());
logger.debug("\t custDivCd : " + custBasInfoDTO.getCustDivCd ());
if ("0".equals(custBasInfoDTO.getConfResltCd())) {
logger.debug("\t custId : " + custBasInfoDTO.getCustId ());
logger.debug("\t iciCustId : " + custBasInfoDTO.getIcisCustId ());
logger.debug("\t nstepCustId : " + custBasInfoDTO.getNstepCustId ());
logger.debug("\t custNm : " + custBasInfoDTO.getCustNm ());
logger.debug("\t custIdfyNoDivCd : " + custBasInfoDTO.getCustIdfyNoDivCd ());
logger.debug("\t custTypeCd : " + custBasInfoDTO.getCustTypeCd ());
logger.debug("\t custIdfyNo : " + custBasInfoDTO.getCustIdfyNo ());
logger.debug("\t interNm : " + custBasInfoDTO.getInterNm ());
logger.debug("\t apdCustUdfyNoDivCd : " + custBasInfoDTO.getApdCustIdfyNoDivCd ());
logger.debug("\t apdCustUdfyNo : " + custBasInfoDTO.getApdCustIdfyNo ());
logger.debug("\t rnmAthnYn : " + custBasInfoDTO.getRnmAthnYn ());
logger.debug("\t rnmAthnDt : " + custBasInfoDTO.getRnmAthnDt ());
logger.debug("\t ipinCi : " + custBasInfoDTO.getIpinCi ());
logger.debug("\t ipinDi : " + custBasInfoDTO.getIpinDi ());
logger.debug("\t personSexDivCd : " + custBasInfoDTO.getPersonSexDivCd ());
logger.debug("\t bthdayDate : " + custBasInfoDTO.getBthdayDate ());
ipin_ci=custBasInfoDTO.getIpinCi();
}
}
logger.info("***** PL_CustInfoRetvWebSvc End.......");
} catch (Exception e) {
throw e;
}
return ipin_ci;
}
jsp 에서 c 문법 사용하기
해더부분에
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %>
추가
<c:forEach items="${list}" var="dao">
</c:forEach>
자바서블릿 : 자바내에서 html
자바스크립트 : HTML내에서 java
'JAVA' 카테고리의 다른 글
| 업무중 배운것들 (0) | 2021.07.27 |
|---|---|
| JPA 공부 (0) | 2020.12.10 |
| [스프링 게시판 만들기.2] 오라클 연동 DBCP 이용 방법 (0) | 2017.07.31 |
| Spring WEB 한글깨짐 수정방법 (0) | 2017.07.25 |
| 스프링 기초.1 (0) | 2017.06.19 |
