ibatis插入和更新

<?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>