src/edu/jmi/mapper/PatentMapper.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.PatentDao">
 <resultMap id="BaseResultMap" type="edu.jmi.model.Patent">
    <id column="id" jdbcType="INTEGER" property="id" />
    <result column="patentName" jdbcType="VARCHAR" property="patentName" /> 
     <result column="pNo" jdbcType="VARCHAR" property="pNo" /> 
     <result column="fname" jdbcType="VARCHAR" property="fname" />
     <result column="ptype" jdbcType="VARCHAR" property="ptype" />
     <result column="geter" jdbcType="VARCHAR" property="geter" />
     <result column="info" jdbcType="VARCHAR" property="info" />
      <result column="url" jdbcType="VARCHAR" property="url" />
    <result column="createTime" jdbcType="VARCHAR" property="createTime" />
  </resultMap>
 
 <select id="selectAll"  parameterType="edu.jmi.model.Patent" resultMap="BaseResultMap">
    select * from patent
    order by id asc
  </select>  
   <select id="findBypaTentName" parameterType="edu.jmi.model.Patent" resultMap="BaseResultMap">
    select * from patent
    <where>
    	<if test="patentName!=null and patentName!=''">
    	AND patentName LIKE CONCAT(CONCAT('%',#{patentName},'%'))
    	</if>
    </where>
  	   ORDER BY id
  </select>
  
  <select id="findById" parameterType="edu.jmi.model.Patent" resultMap="BaseResultMap">
  select * from patent where id=#{id}
  </select>
  
  <insert id="insert" parameterType="edu.jmi.model.Patent" >
    insert into patent (patentName,fname,pNo,ptype,geter,info,url,createTime)
    values (#{patentName,jdbcType=VARCHAR},#{fname,jdbcType=VARCHAR},  #{pNo,jdbcType=VARCHAR},
      #{ptype,jdbcType=VARCHAR},#{geter,jdbcType=VARCHAR}, 
      #{info,jdbcType=VARCHAR},#{url,jdbcType=VARCHAR},#{createTime,jdbcType=VARCHAR})
  </insert>
  
  <update id="update" parameterType="edu.jmi.model.Patent">
    update patent set 
      patentName = #{record.patentName,jdbcType=VARCHAR},
     <!--  fname = #{record.fname,jdbcType=VARCHAR}, -->
       pNo = #{record.pNo,jdbcType=VARCHAR},
      ptype = #{record.ptype,jdbcType=VARCHAR},
     geter = #{record.geter,jdbcType=VARCHAR},
       info = #{record.info,jdbcType=VARCHAR},
      <!--  url = #{record.url,jdbcType=VARCHAR}, -->
       createTime = #{record.createTime,jdbcType=VARCHAR}
      where id=#{id}
 
  </update>
 
 
 <delete id="delete" parameterType="java.lang.Integer">
    delete from patent
    where id = #{id}
  </delete>