src/edu/jmi/mapper/AchievementMapper.xml

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

<?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="edu.jmi.dao.AchievementDao">
 <resultMap id="BaseResultMap" type="edu.jmi.model.Achievement">
    <id column="id" jdbcType="INTEGER" property="id" />
    <result column="aname" jdbcType="VARCHAR" property="aname" /> 
     <result column="fname" jdbcType="VARCHAR" property="fname" />
     <result column="company" jdbcType="VARCHAR" property="company" />
     <result column="atype" jdbcType="VARCHAR" property="atype" />
       <result column="level" jdbcType="VARCHAR" property="level" /> 
        <result column="grade" jdbcType="VARCHAR" property="grade" />
         <result column="info" jdbcType="VARCHAR" property="info" />
          <result column="aUrl" jdbcType="VARCHAR" property="aUrl" />
    <result column="gaveTime" jdbcType="VARCHAR" property="gaveTime" />
  </resultMap>
 
 <select id="selectAll"  parameterType="edu.jmi.model.Achievement" resultMap="BaseResultMap">
    select * from achievement
    order by id asc
  </select>
  
 

   <select id="findByaName" parameterType="edu.jmi.model.Achievement" resultMap="BaseResultMap">
    select * from achievement
    <where>
    	<if test="aname!=null and aname!=''">
    	AND aname LIKE CONCAT(CONCAT('%',#{aname},'%'))
    	</if>
    </where>
  	   ORDER BY id
  </select>
  
  <select id="findById" parameterType="edu.jmi.model.Achievement" resultMap="BaseResultMap">
  select * from achievement where id=#{id}
  </select>
  
  <insert id="insert" parameterType="edu.jmi.model.Achievement" >
    insert into achievement (aname,fname,company,atype,level,grade,info,aUrl,gaveTime)
    values (#{aname,jdbcType=VARCHAR},#{fname,jdbcType=VARCHAR}, #{company,jdbcType=VARCHAR}, 
    #{atype,jdbcType=VARCHAR},#{level,jdbcType=VARCHAR},#{grade,jdbcType=VARCHAR}, 
    #{info,jdbcType=VARCHAR},#{aUrl,jdbcType=VARCHAR},#{gaveTime,jdbcType=VARCHAR})
  </insert>
  
  <update id="update" parameterType="edu.jmi.model.Achievement">
    update achievement set 
      aname = #{record.aname,jdbcType=VARCHAR},
      
      company = #{record.company,jdbcType=VARCHAR},
      atype = #{record.atype,jdbcType=VARCHAR},
      level = #{record.level,jdbcType=VARCHAR},
      grade = #{record.grade,jdbcType=VARCHAR},
      info = #{record.info,jdbcType=VARCHAR},
      
      gaveTime = #{record.gaveTime,jdbcType=VARCHAR}
      where id=#{id}
  </update>
 
 
 <delete id="delete" parameterType="java.lang.Integer">