<?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.mapper.PatientBasicInfoMapper"> 
 <!--PatientBasicInfo与bean的映射 -->
  <resultMap type="com.bean.PatientBasicInfo" id="patientbasicinfo">
     <result property="patId" column="patId" jdbcType="Integer" javaType="java.lang.Integer"/>
     <result property="serialNum" column="serialNum"/>
     <result property="patName" column="patName"/>
     <result property="idCard" column="idCard"/>
       </resultMap>
<!-- 查询所有跟进数据 -->
<select id="patientBasicInfoList" resultMap="patientbasicinfo">
 select * from patientbasicinfo f order by patId asc
</select>
<!-- 查询跟进数据 -->
<select id="searchPatientBasicInfo" resultMap="patientbasicinfo" parameterType="com.bean.PatientBasicInfo">  
     select * from patientbasicinfo f where patId like CONCAT('%', #{idCard}, '%') and tel_id like CONCAT('%', #{patName}, '%') order by id asc      
</select>
<!-- 删除跟进数据 -->  
<delete id="deleteOnePatientBasicInfo" parameterType="java.lang.Integer">
  delete from patientbasicinfo where patId = #{patId}
</delete>
<!-- 查询一个跟进数据 - -->
<select id="selectOnePatientBasicInfo" resultMap="patientbasicinfo" parameterType="java.lang.Integer">
  select * from patientbasicinfo f where patId=#{patId}
</select>
<!-- 添加跟进数据 -->
<insert id="addPatientBasicInfo" parameterType="com.bean.PatientBasicInfo">
insert into patientbasicinfo 
   ( patId,
   serialNum,
   patName,
   idCard,
      )values(
   #{patId},
   #{serialNum},
   #{patName},
   #{idCard},
      )
</insert> <!-- 更新跟进数据信息 -->
    <update id="updatePatientBasicInfo"  parameterType="com.bean.PatientBasicInfo">
     update patientbasicinfo set
   serialNum=#{patName},
   patName=#{patName},
   idCard=#{idCard},
       where patId=#{patId}
   </update>
</mapper>
服务其启动不了  配置什么都是好的 mapper