[mybatis] 파라미터 바인딩 / Type / update문

1. 파라미터가 한개일때 

Mapper.java

Integer updateEmailAddress(String emailAddress);

Mapper.xml

<update id="updateEmailAddress" parameterType="String" >
     UPDATE tb_admins SET email=#{_parameter}
</update>

2. 파라미터가 한개이상일때

Mapper.java

Integer updateEmailAddress(@Param("emailAddress") String emailAddress, @Param("adminId") String adminIdId);

Mapper.xml

<update id="updateEmailAddress" parameterType="String" >
    UPDATE tb_admins SET email=#{emailAddress} WHERE admin_id =#{adminId}
</update>

3. 파라미터 형식

scheduler.java 

SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
Date toDate = new Date();
settingMapper.updateLastEmailDt(sdf.format(toDate));

Mapper.java

Integer updateLastEmailDt(@Param("lastEmailDt") String lastEmailDt);

Integer updateLastEmailDt(String lastEmailDt);

Mapper.xml

<update id="updateLastEmailDt" parameterType="String" >
          UPDATE tb_admins SET last_email_dt = #{lastEmailDt}
</update>

처음에 이렇게 했는데 postgresql 오류남

column is of type timestamp without time zone but expression is of type character varying
last_email_dt 가 Timestamp로 되어있어서 형변환 해줘야한다고 한다.

<update id="updateLastEmailDt" parameterType="String" >
          UPDATE tb_admins SET last_email_dt = TO_TIMESTAMP(#{lastEmailDt}, 'YYYY-MM-DD HH24:MI:SS')
</update>

<update id="updateLastEmailDt" parameterType="String" >
          UPDATE tb_admins SET last_email_dt = TO_TIMESTAMP(#{_parameter}, 'YYYY-MM-DD HH24:MI:SS')
</update>