}
3.实体类
import lombok.Getter;
import lombok.Setter;
import java.util.Date;
import java.util.UUID;
/**
- @author xiejianwei
*/
@Getter
@Setter
public class MessageRecord {
/**
- 主键ID
*/
private Long id;
/**
- 业务数据ID
/
private String businessId;
/* - 业务类型
/
private int businessType;
/* - 消息ID
/
private String messageId;
/* - 重试次数
/
private int retriesNumber;
/* - 消息状态 (0.失败,1成功)
/
private int status;
/* - 创建时间
*/
private Date createTime;
public MessageRecord() {
}
public MessageRecord(String businessId, int businessType) {
this.businessId = businessId;
this.businessType = businessType;
this.messageId = UUID.randomUUID().toString().replace(“-”, “”).toLowerCase();
this.retriesNumber = 0;
this.createTime = new Date();
this.status = 0;
}
}
import java.math.BigDecimal;
/**
- @author xiejianwei
*/
@Getter
@Setter
public class Order extends SerializableDto {
/**
- 订单编号
*/
private String orderId;
/**
- 订单金额
*/
private BigDecimal amount;
/**
- 做简单的例子就不关联业务ID了
*/
private String productName;
}
4.业务实现
import com.xjw.entity.pojo.MessageRecord;
import com.xjw.entity.pojo.Order;
import com.xjw.service.MessageRecordService;
import com.xjw.service.OrderService;
import lombok.extern.slf4j.Slf4j;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import org.springframework.transaction.annotation.Transactional;
/**
- @author xiejianwei
*/
@Service
@Slf4j
public class OrderServiceImpl implements OrderService {
@Autowired
public MessageRecordService messageRecordService;
/**
- 模拟发起一个简单的订单
- @param order
- @return
*/
@Override
@Transactional(rollbackFor = Exception.class)
public boolean start(Order order) {
//触发保存本地消息表
MessageRecord messageRecord = new MessageRecord(order.getOrderId(), 1);
messageRecordService.preCommit(messageRecord);
log.info(“这里可以做本地业务操作”);
log.info(“下单中,请稍等-----”);
log.info(“恭喜您,下单成功,订单号:{}”, order.getOrderId());
// 操作本地事务成功则commit 消息,如果处理本地事务异常,则会有定时任务回调
messageRecordService.commit(messageRecord.getMessageId(), true);
return true;
}
}
import com.alibaba.fastjson.JSON;
import com.xjw.config.constant.RabbitmqConstant;
import com.xjw.entity.pojo.MessageRecord;
import com.xjw.mapper.MessageRecordMapper;
import com.xjw.service.MessageRecordService;
import com.xjw.service.RabbitmqService;
import org.springframework.amqp.rabbit.connection.CorrelationData;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import java.util.List;
/**
- @author xiejianwei
*/
@Service
public class MessageRecordServiceImpl implements MessageRecordService {
@Autowired
public MessageRecordMapper messageRecordMapper;
@Autowired
public RabbitmqService rabbitmqService;
@Override
public boolean preCommit(MessageRecord messageRecord) {
return messageRecordMapper.insert(messageRecord);
}
@Override
public boolean commit(String messageId, boolean commitFlag) {
/**
- 不提交则代表回滚
/
if (!commitFlag) {
messageRecordMapper.delete(messageId);
return true;
}
// 提交消息到MQ
MessageRecord messageRecord = messageRecordMapper.find(messageId);
/* - 发送MQ消息
- 将唯一消息ID设置给CorrelationData
- 回调时可以用这个ID查找到数据对应的消息记录
*/
rabbitmqService.sendMessage(RabbitmqConstant.ORDER_EXCHANGE, RabbitmqConstant.ORDER_ROUTING_KEY, JSON.toJSONString(messageRecord), new CorrelationData(messageRecord.getMessageId()));
return true;
}
@Override
public void update(String messageId) {
messageRecordMapper.update(messageId);
}
@Override
public MessageRecord find(String messageId) {
return messageRecordMapper.find(messageId);
}
@Override
public List findAll(int status) {
return messageRecordMapper.findAll(status);
}
}
import com.xjw.callback.RabbitMqConfirmCallback;
import com.xjw.service.RabbitmqService;
import org.springframework.amqp.rabbit.connection.CorrelationData;
import org.springframework.amqp.rabbit.core.RabbitTemplate;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
/**
- @author xiejianwei
- @ClassName RabbitmqServiceImpl
- @Description 发送mq消息
*/
@Service
public class RabbitmqServiceImpl implements RabbitmqService {
@Autowired
private RabbitTemplate rabbitTemplate;
@Autowired
private RabbitMqConfirmCallback rabbitMqConfirmCallback;
/**
- 发送消息到mq(单个)
- @param exchange 交换机的名称
- @param routingKey 路由key值
- @param messages 消息的附件消息
/
@Override
public void sendMessage(String exchange, String routingKey, String messages, CorrelationData correlationData) {
/* - 设置回调
*/
rabbitTemplate.setConfirmCallback(rabbitMqConfirmCallback);
rabbitTemplate.convertAndSend(exchange, routingKey, messages, correlationData);
}
}
5.接口管理
import com.xjw.entity.pojo.Order;
import com.xjw.entity.vo.R;
import com.xjw.service.OrderService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.validation.annotation.Validated;
import org.springframework.web.bind.annotation.PostMapping;
import org.springframework.web.bind.annotation.RequestBody;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RestController;
import java.math.BigDecimal;
import java.util.UUID;
/**
- 订单接口管理
- @author xiejianwei
*/
@RestController
@RequestMapping(“/order”)
@Validated
public class OrderController {
@Autowired
public OrderService orderService;
@PostMapping(“/start”)
public R page(@RequestBody String productName) {
Order order = new Order();
order.setAmount(BigDecimal.valueOf(5000));
order.setProductName(productName);
order.setOrderId(UUID.randomUUID().toString().replace(“-”, “”).toLowerCase());
orderService.start(order);
return R.success();
}
}
6.mq/本地消息回调
import com.alibaba.fastjson.JSON;
import com.xjw.config.constant.RabbitmqConstant;
import com.xjw.entity.pojo.MessageRecord;
import com.xjw.service.MessageRecordService;
import com.xjw.service.RabbitmqService;
import org.springframework.amqp.rabbit.connection.CorrelationData;
import org.springframework.amqp.rabbit.core.RabbitTemplate;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Component;
/**
- @author xiejianwei
*/
@Component
public class RabbitMqConfirmCallback implements RabbitTemplate.ConfirmCallback {
@Autowired
private MessageRecordService messageRecordService;
@Autowired
public RabbitmqService rabbitmqService;
/**
- @param correlationData 相关配置信息
- @param ack 交换机是否成功收到消息
- @param cause 错误信息
/
@Override
public void confirm(CorrelationData correlationData, boolean ack, String cause) {
/* - 这个就是我们发送消息设置的messageId
*/
String messageId = correlationData.getId();
// 未发送成功
if (!ack) {
MessageRecord messageRecord = messageRecordService.find(messageId);
if (null != messageRecord) {
// 重发
rabbitmqService.sendMessage(RabbitmqConstant.ORDER_EXCHANGE, RabbitmqConstant.ORDER_ROUTING_KEY, JSON.toJSONString(messageRecord), new CorrelationData(messageRecord.getMessageId()));
}
} else {
// 修改消息状态为成功
messageRecordService.update(messageId);
}
}
}
/**
- 根据具体的业务,判断是否需要提交或者回滚消息
- @author xiejianwei
*/
@Component
public class OrderMessageRecordConfirm implements MessageRecordCallback {
@Override
public boolean confirm(MessageRecord messageRecord) {
String messageId = messageRecord.getMessageId();
/**
- 根据具体的业务,判断是否需要提交或者回滚消息
*/
if (“1212321”.equals(messageId)) {
自我介绍一下,小编13年上海交大毕业,曾经在小公司待过,也去过华为、OPPO等大厂,18年进入阿里一直到现在。
深知大多数Java工程师,想要提升技能,往往是自己摸索成长或者是报班学习,但对于培训机构动则几千的学费,着实压力不小。自己不成体系的自学效果低效又漫长,而且极易碰到天花板技术停滞不前!
因此收集整理了一份《2024年Java开发全套学习资料》,初衷也很简单,就是希望能够帮助到想自学提升又不知道该从何学起的朋友,同时减轻大家的负担。
既有适合小白学习的零基础资料,也有适合3年以上经验的小伙伴深入学习提升的进阶课程,基本涵盖了95%以上Java开发知识点,真正体系化!
由于文件比较大,这里只是将部分目录截图出来,每个节点里面都包含大厂面经、学习笔记、源码讲义、实战项目、讲解视频,并且会持续更新!
如果你觉得这些内容对你有帮助,可以扫码获取!!(备注Java获取)
总结
本文从基础到高级再到实战,由浅入深,把MySQL讲的清清楚楚,明明白白,这应该是我目前为止看到过最好的有关MySQL的学习笔记了,我相信如果你把这份笔记认真看完后,无论是工作中碰到的问题还是被面试官问到的问题都能迎刃而解!
MySQL50道高频面试题整理:
《互联网大厂面试真题解析、进阶开发核心学习笔记、全套讲解视频、实战项目源码讲义》点击传送门即可获取!
s/e5c14a7895254671a72faed303032d36.jpg" alt=“img” style=“zoom: 33%;” />
总结
本文从基础到高级再到实战,由浅入深,把MySQL讲的清清楚楚,明明白白,这应该是我目前为止看到过最好的有关MySQL的学习笔记了,我相信如果你把这份笔记认真看完后,无论是工作中碰到的问题还是被面试官问到的问题都能迎刃而解!
MySQL50道高频面试题整理:
[外链图片转存中…(img-yaFwAdu9-1713733253389)]
《互联网大厂面试真题解析、进阶开发核心学习笔记、全套讲解视频、实战项目源码讲义》点击传送门即可获取!