ibatis插入时间显示时分秒

　一、insert直接命名为sysdate：

　　<insert id="insert" parameterClass="com.hanpeng.base.phone.model.TDocument"> INSERT INTO T_DOCUMENT ( ROW_NO , CLASS_NAME , TITLE , CONTENT_INTRODUCTION , KEYWORDS , CREATE_DATE , EXAMPLE1 , EXAMPLE2 , EXAMPLE3 , ROW_NOFK , FILE_PATH ) VALUES ( #rowNo:VARCHAR# , #className:VARCHAR# , #title:VARCHAR# , #contentIntroduction:VARCHAR# , #keywords:VARCHAR# , #createDate:sysdate# , #example1:VARCHAR# , #example2:VARCHAR# , #example3:VARCHAR# , #rowNofk:VARCHAR# , #filePath:VARCHAR# ) </insert>

二、直接插入sysdate，系统时间：

　　1.修改xml(TBussinessSafe.xml)，date赋值时直接给sysdate,且必须是<isNotEmpty>

　　<update id="update" parameterClass="com.hanpeng.base.phone.model.TBussinessSafe"> UPDATE T_BUSSINESS_SAFE SET <isNotNull prepend=" " property="bussinessId"> BUSSINESS_ID = #bussinessId# </isNotNull> <isNotNull prepend="," property="bussinessNote"> BUSSINESS_NOTE = #bussinessNote# </isNotNull> <isNotEmpty prepend="," property="bussinessNoteDate"> BUSSINESS_NOTE_DATE = sysdate </isNotEmpty> <isNotNull prepend="," property="bussinessNoteState"> BUSSINESS_NOTE_STATE = #bussinessNoteState# </isNotNull> <isNotNull prepend="," property="state"> STATE = #state# </isNotNull> WHERE BUSSINESS_ID=#bussinessId# </update>

三、不插入系统时间但是还要显示 年-月-日 时:分:秒    DATE->TIMESTAMP

　　1.sqlMap文件

　　<update id="update" parameterClass="com.hanpeng.base.phone.model.TBussinessSafe"> UPDATE T_BUSSINESS_SAFE SET <isNotNull prepend=" " property="bussinessId"> BUSSINESS_ID = #bussinessId# </isNotNull> <isNotEmpty prepend="," property="bussinessNoteDate"> BUSSINESS_NOTE_DATE = sysdate </isNotEmpty> <isNotNull prepend="," property="bussinessLastDate"> BUSSINESS_LAST_DATE = #bussinessLastDate:TIMESTAMP# </isNotNull> <isNotNull prepend="," property="bussinessPassReset"> BUSSINESS_PASS_RESET = #bussinessPassReset:DATE# </isNotNull> <isNotNull prepend="," property="bussinessComm"> BUSSINESS_COMM = #bussinessComm:NUMERIC# </isNotNull> <isNotNull prepend="," property="bussinessCommDefault"> BUSSINESS_COMM_DEFAULT = #bussinessCommDefault:NUMERIC# </isNotNull> WHERE BUSSINESS_ID=#bussinessId# </update>

　　###把BUSSINESS_LAST_DATE = #bussinessLastDate:DATE# 改为 TIMESTAMP