mybatis--增删查改的基本mapper的xml配置

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapper 
    PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" 
    "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
    
<mapper namespace="com.test.jobs">
      <!-- select查询 -->
      <select id="JOBS_SELECT" parameterType="map" resultType="map">
        select JOB_ID,JOB_TITLE,MIN_SALARY,MAX_SALARY from JOBS where JOB_ID = #{JOB_ID,jdbcType=VARCHAR}
      </select>
      
      <!-- insert插入 -->
      <insert id="JOBS_INSERT" parameterType="map">
        insert into JOBS(JOB_ID,JOB_TITLE,MIN_SALARY,MAX_SALARY)
        values(#{JOB_ID,jdbcType=VARCHAR},#{JOB_TITLE,jdbcType=VARCHAR},#{MIN_SALARY,jdbcType=VARCHAR},#{MAX_SALARY,jdbcType=VARCHAR})
      </insert>
        
      
      <!-- update更新 -->
      <update id="JOBS_UPDATE" parameterType="map">
        update JOBS 
        set JOB_TITLE=#{JOB_TITLE,jdbcType=VARCHAR},
	        MIN_SALARY=#{MIN_SALARY,jdbcType=VARCHAR},
	        MAX_SALARY=#{MAX_SALARY,jdbcType=VARCHAR} 
        where JOB_ID=#{JOB_ID,jdbcType=VARCHAR}
      </update>
      
      <!-- delete删除 -->
      <delete id="JOBS_DELETE" parameterType="map">
         delete from JOBS where JOB_ID=#{JOB_ID,jdbcType=VARCHAR}
      </delete>
      
</mapper>