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

	<resultMap id="email" type="com.ken.wms.domain.Email">
		<id property="emailId" column="emailId"/>
		<result property="emailName" column="emailName"/>
		<result property="emailAddress" column="emailAddress"/>
		<result property="emailCreatTime" column="emailCreatTime"/>
	</resultMap>


	<!--查询所有的邮箱-->
	<select id="selectAllByEmail" resultMap="email">
		select
		email_id as emailId,
		email_name as emailName,
		email_address as emailAddress,
		email_creatime as emailCreatTime
		from
		wms_email
	</select>

	<!--查询所有的突发事件记录-->
	<select id="selectByEmailTaskName" resultMap="email">
		select
		email_id as emailId,
		email_name as emailName,
		email_address as emailAddress,
		email_creatime as emailCreatTime
		from
		wms_email
		where
		email_name = #{emailName}
	</select>

	<!--查询指定编号的突发事件信息-->
	<select id="selectByEmailID" resultMap="email">
		select
		email_id as emailId,
		email_name as emailName,
		email_address as emailAddress,
		email_creatime as emailCreatTime
		from
		wms_email
		where
		email_id = #{emailId}
	</select>

	<!--邮箱-->
	<insert id="addNewEmail">
		insert into wms_email
		(
			email_name,
			email_address,
			email_creatime
		)