src/main/java/com/ken/wms/dao/SpecialMaterialMapper.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="com.ken.wms.dao.SpecialMaterialMapper">

	<resultMap id="speialMaterial" type="com.ken.wms.domain.SpecialMaterial">
		<id property="specialMaterialId" column="specialMaterialId"/>
		<result property="specialMaterialRegion" column="specialMaterialRegion"/>
		<result property="specialMaterialRescueNum" column="specialMaterialRescueNum"/>
		<result property="specialMaterialPharmacyNum" column="specialMaterialPharmacyNum"/>
		<result property="specialMaterialHospitalNum" column="specialMaterialHospitalNum"/>
		<result property="specialMaterialCreatTime" column="specialMaterialCreatTime"/>
		<result property="specialMaterialDirector" column="specialMaterialDirector"/>
	</resultMap>

	<!--查询所有的邮箱-->
	<select id="selectAllBySpecialMaterial" resultMap="speialMaterial">
		select
		sm_id as specialMaterialId,
		sm_region as specialMaterialRegion,
		sm_rescue_num as specialMaterialRescueNum,
		sm_pharmacy_num as specialMaterialPharmacyNum,
		sm_hospital_num as specialMaterialHospitalNum,
		sm_creattime as specialMaterialCreatTime,
		sm_director as specialMaterialDirector
		from
		wms_special_material
	</select>

	<!--查询所有的突发事件记录-->
	<select id="selectBySpecialMaterialName" resultMap="speialMaterial">
		select
		sm_id as specialMaterialId,
		sm_region as specialMaterialRegion,
		sm_rescue_num as specialMaterialRescueNum,
		sm_pharmacy_num as specialMaterialPharmacyNum,
		sm_hospital_num as specialMaterialHospitalNum,
		sm_creattime as specialMaterialCreatTime,
		sm_director as specialMaterialDirector
		from
		wms_special_material
		where
		sm_director = #{specialMaterialDirector}
	</select>

	<!--查询指定编号的突发事件信息-->
	<select id="selectBySpecialMaterialID" resultMap="speialMaterial">
		select
		sm_id as specialMaterialId,
		sm_region as specialMaterialRegion,
		sm_rescue_num as specialMaterialRescueNum,
		sm_pharmacy_num as specialMaterialPharmacyNum,
		sm_hospital_num as specialMaterialHospitalNum,
		sm_creattime as specialMaterialCreatTime,
		sm_director as specialMaterialDirector
		from
		wms_special_material
		where