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

来源:互联网 发布:高考大数据 编辑:程序博客网 时间:2024/06/05 03:07
<?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>    

0 0