'전체 글'에 해당되는 글 452건

function setCookie(name, value, expiredays) {

var today = new Date();

today.setDate(today.getDate() + expiredays);

document.cookie = name + "=" + escape(value) + "; path=/; secure=true ; httponly=true; expires=" + today.toGMTString() + ";";

}

$('#dialog').dialog({

modal:true

,title:'확인'

,dialogClass:'dialog'

,width:'auto'

,position: ({

  my: "center",

  at: "center",

  of: window

})

,buttons:{

'예': function(){

$(this).dialog("close");

if(fnObj1!=undefined && fnObj1!=null){

        $(fnObj1);

        }

}

,'아니오': function(){

$(this).dialog("close");

if(fnObj2!=undefined && fnObj2!=null){

        $(fnObj2);

        }

}

,'취소': function(){

$(this).dialog("close");

if(fnObj3!=undefined && fnObj3!=null){

        $(fnObj3);

        }

}

}

,open: function (event, ui) {

$(':button.ui-dialog-titlebar-close').focus();

        }

   });

ibatis든 mybatis든 update 태그로 감싸줘야됨

<update id="spvisionViewPageSave" parameterClass="java.util.Map">

이런식으로

MERGE INTO INQUERY A /*질문서(INQUERY) 저장*/ 

USING

(

SELECT C.VICTIM_ID FROM

) C

GROUP BY C.VICTIM_ID

) B

ON

(

A.VICTIM_ID = B.VICTIM_ID

                           --추가할거면 AND 로

)

--일치하는게 있다면 업데이트

WHEN MATCHED THEN

UPDATE SET A.INQUERYITEM2_1 = INQUERYITEM2_1

,A.UUSER = B.UPDT_USER_ID

,A.UDATE = SYSDATE

--업다면 인서트

WHEN NOT MATCHED THEN

INSERT

(

VICTIM_ID

,RECEIVE_NO

)

VALUES

(

B.VICTIM_ID

,B.RECEIVE_NO

)

@SuppressWarnings("unchecked")

public static List<Map<String, Object>> jsonArrStrToList(String jsonArrString) {

/** Local Value Object */

ObjectMapper mapper = null;

List<Map<String, Object>> bizList = null;

/** Business Logic */

//예외처리

if(isEmpty(jsonArrString)){

return null;

}

// Jackson Mapper 선언

   mapper = new ObjectMapper();

//JSONArrayString을 List로 변환

   try {

bizList = mapper.readValue(jsonArrString, List.class);

} catch (JsonParseException e) {

LOGGER.error(String.format(LogFormat.ERROR, e));

} catch (JsonMappingException e) {

LOGGER.error(String.format(LogFormat.ERROR, e));

} catch (IOException e) {

LOGGER.error(String.format(LogFormat.ERROR, e));

}

/** Return Logic*/

return bizList;

}

$.ajax({

url : "url써주기",

type : "POST",

contentType : "application/x-www-form-urlencoded; charset=UTF-8",

data : $("#폼아이디").serialize(),

dataType : "json",

success : function(response) {

if (response != null) {

if (response.status != 'error') {

alert("저장 되었습니다.");

var form = document

.getElementById('폼아이디');

form.action = "url써주기";

form.submit();

}

else {

alert(response.message);

}

}

},

error : function(request, status, erreo) {

         alert(request.reponseText);

}

});

$('img[src*="btn_cancel"]').click(function(){

$('#폼아이디')[0].reset();

//취소 완료 메시지 표시

alert("변경된 정보가 초기화 되었습니다.");

});

function fn_autoNextFocus() {

   $("input").keyup (function () {

       var charLimit = $(this).attr("maxlength");

       if (this.value.length >= charLimit) {

           $(this).next("input").focus();

           return false;

       }

   })

};

WITH A AS (SELECT '011-2222-3333' AS P FROM DUAL)
SELECT SUBSTR(P,1,INSTR(P,'-',1,1)-1) AS FIRST
,SUBSTR(P,INSTR(P,'-',1,1)+1,INSTR(P,'-',1,2)-INSTR(P,'-',1,1)-1) AS MIDDLE
,SUBSTR(P,INSTR(P,'-',1,2)+1) AS LAST
FROM A;