메모

성난호랑이 시니철 ㅣ 2017. 10. 1. 00:10


DATE_FORMAT(NOW(), '%Y%m%d%H%i%s'),

   mysql> SELECT ROUND(-1.23);

      -> -1


 mysql> SELECT ROUND(-1.58);

      -> -2




<%@ taglib prefix="fmt" uri="http://java.sun.com/jsp/jstl/fmt" %>


<fmt:formatNumber value="${item.bloodSugarMeasureValue}" />

<c:out value="${fn:replace(item.menuEngNm, '<br />', ' ')}" />


<spring:eval var="today" expression="T(org.joda.time.LocalDate).now().toString('yyyyMMdd')" />



jquery after



 이메일 정규식 

var regExp = /^[0-9a-zA-Z]([-_.]?[0-9a-zA-Z])*@[0-9a-zA-Z]([-_.]?[0-9a-zA-Z])*.[a-zA-Z]{2,3}$/i;

if(regExp.test(managementId) == false) {

    alert("<spring:message code="mobile.phrase.pleaseInputTheEmail"/>");

    return false;

}

 



ie 11버전 작동 안할때 cache : false

$.ajax({

url: "<c:url value="/prescription/sub/getInfo.json" />",

dataType: 'json',

cache : false,

type:"get",

data: data,

success: function(data) {

}

});




insert updata

ON DUPLICATE KEY