<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE sqlMap PUBLIC "-//iBATIS.com//DTD SQL Map 2.0//EN"
"http://www.ibatis.com/dtd/sql-map-2.dtd">
<!-- 2del: sqlmap-mapping-calculationbizjob.xml -->
<sqlMap namespace="schedule.ScheduleJobParam">
<insert id="schedule.insertSingleJobParam" parameterClass="com.schedule.framework.dto.ScheduleJobParamDTO" >
INSERT INTO SCHEDULE_JOB_PARAM
(JOB_ID,
PARAM_KEY,
PARAM_DESC,
IS_AVAILABEL,
PARAM_TYPE,
DEFAULT_VALUE)
VALUES
(#job_id#,
#param_key#,
#param_desc#,
#is_availabel#,
#param_type#,
#default_value#)
</insert>
<!--入参 出参 可以为javabean ,入参可以为map-->
<select id="schedule.getSingleJobParamByJobID" parameterClass="java.util.HashMap" resultClass="com.schedule.framework.dto.ScheduleJobParamDTO" >
Select
PARAM_KEY,
PARAM_DESC,
IS_AVAILABEL,
PARAM_TYPE,
DEFAULT_VALUE
FROM SCHEDULE_JOB_PARAM
WHERE 1=1 AND JOB_ID=#job_id#
</select>
</sqlMap>
ibatis插入和更新
最新推荐文章于 2021-02-16 04:38:57 发布