src/edu/jmi/mapper/PaperMapper.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.PaperDao">
 <resultMap id="BaseResultMap" type="edu.jmi.model.Paper">
    <id column="id" jdbcType="INTEGER" property="id" />
    <result column="pName" jdbcType="VARCHAR" property="pName" /> 
     <result column="kName" jdbcType="VARCHAR" property="kName" />
     <result column="author" jdbcType="VARCHAR" property="author" />
     <result column="ptype" jdbcType="VARCHAR" property="ptype" />
       <result column="integral" jdbcType="VARCHAR" property="integral" /> 
        <result column="guider" jdbcType="VARCHAR" property="guider" />
         <result column="info" jdbcType="VARCHAR" property="info" />
          <result column="pUrl" jdbcType="VARCHAR" property="pUrl" />
    <result column="createTime" jdbcType="VARCHAR" property="createTime" />
  </resultMap>
 
 <select id="selectAll"  parameterType="edu.jmi.model.Paper" resultMap="BaseResultMap">
    select * from paper
    order by id asc
  </select>
  
  <select id="findByAuthor" parameterType="edu.jmi.model.Paper" resultMap="BaseResultMap">
  select * from paper where author=#{author}
  </select>

   <select id="findBypName" parameterType="edu.jmi.model.Paper" resultMap="BaseResultMap">
    select * from paper
    <where>
    	<if test="pName!=null and pName!=''">
    	AND pName LIKE CONCAT(CONCAT('%',#{pName},'%'))
    	</if>
    </where>
  	   ORDER BY id
  </select>
  
  <select id="findById" parameterType="edu.jmi.model.Paper" resultMap="BaseResultMap">
  select * from paper where id=#{id}
  </select>
  
  <insert id="insert" parameterType="edu.jmi.model.Paper" >
    insert into paper (pName,kName,author,ptype,integral,guider,info,pUrl,createTime)
    values (#{pName,jdbcType=VARCHAR},#{kName,jdbcType=VARCHAR}, #{author,jdbcType=VARCHAR}, 
    #{ptype,jdbcType=VARCHAR},#{integral,jdbcType=VARCHAR},#{guider,jdbcType=VARCHAR}, 
    #{info,jdbcType=VARCHAR},#{pUrl,jdbcType=VARCHAR},#{createTime,jdbcType=VARCHAR})
  </insert>
  
  <update id="update" parameterType="edu.jmi.model.Paper">
    update paper set 
      pName = #{record.pName,jdbcType=VARCHAR},
      kName = #{record.kName,jdbcType=VARCHAR},
      author = #{record.author,jdbcType=VARCHAR},
      ptype = #{record.ptype,jdbcType=VARCHAR},
      integral = #{record.integral,jdbcType=VARCHAR},
      guider = #{record.guider,jdbcType=VARCHAR},
      info = #{record.info,jdbcType=VARCHAR},
      pUrl = #{record.pUrl,jdbcType=VARCHAR},
      createTime = #{record.createTime,jdbcType=VARCHAR}
      where id=#{id}
  </update>