<insert id="addDeviceAndRuleSend">
<selectKey keyProperty="id" resultType="java.lang.Integer" order="AFTER" statementType="STATEMENT">
SELECT LAST_INSERT_ID() AS id FROM DUAL
</selectKey>
INSERT INTO <include refid="Table"/>
(DEVICE_CODE, CHANNEL_SEQ, RULE_ID, SEND_DATA)
VALUES
(#{deviceCode}, #{channelSeq}, #{ruleId}, #{sendData})
</insert>
void addDeviceAndRuleSend (@Param("deviceCode")String deviceCode,
@Param("channelSeq") Integer channelSeq,
@Param("ruleId")Integer ruleId,
@Param("sendData") String sendData);
sleepLeaveRuleDeviceSendMapper.addDeviceAndRuleSend(sendInfo.getDeviceCode(), sendInfo.getChannelSeq(), sendInfo.getRuleId(), sendInfo.getSendData());
Integer id = sendInfo.getId();