博客展示了使用iBATIS进行数据插入的代码示例，具体是向TWIMB_HTTPREQUEST表插入HTTP请求相关数据，包含请求ID、浏览器、IP等信息，通过SQL语句实现数据插入操作。
<insert id="insertHTTPRequest" parameterClass="HTTPRequest">
INSERT INTO TWIMB_HTTPREQUEST
(
HTTPREQUEST_ID,
HTTPREQUEST_BROWSER,
HTTPREQUEST_IP,
HTTPREQUEST_TYPE,
HTTPREQUEST_ENTITYNUM,
HTTPREQUEST_STARTDATE,
HTTPREQUEST_ENDDATE,
HTTPREQUEST_RESULT
)
VALUES
(
SEQ_WIMB_HTTPREQUEST.NEXTVAL,
#Browser#,
#Ip#,
#RType#,
#EntityNum#,
TO_DATE(#StartDate#,'MM-DD-YYYY'),
TO_DATE(#EndDate#,'MM-DD-YYYY'),
#Result#
)
</insert>
INSERT INTO TWIMB_HTTPREQUEST
(
HTTPREQUEST_ID,
HTTPREQUEST_BROWSER,
HTTPREQUEST_IP,
HTTPREQUEST_TYPE,
HTTPREQUEST_ENTITYNUM,
HTTPREQUEST_STARTDATE,
HTTPREQUEST_ENDDATE,
HTTPREQUEST_RESULT
)
VALUES
(
SEQ_WIMB_HTTPREQUEST.NEXTVAL,
#Browser#,
#Ip#,
#RType#,
#EntityNum#,
TO_DATE(#StartDate#,'MM-DD-YYYY'),
TO_DATE(#EndDate#,'MM-DD-YYYY'),
#Result#
)
</insert>
扫一扫
8487
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
