<?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
<!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
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货