-- 执行完整的SQL脚本
source e:/yushu/yushu/yushu-backend/sql/new-message-system.sql
cd e:/yushu/yushu/yushu-backend
mvn spring-boot:run
# 登录获取token
curl -X POST http://localhost:8080/login \
-H "Content-Type: application/json" \
-d '{"username":"admin","password":"admin123"}'
curl -X GET http://localhost:8080/system/notification/my \
-H "Authorization: Bearer YOUR_TOKEN"
预期结果: 返回2条系统通知
curl -X GET http://localhost:8080/system/notification/unread/count \
-H "Authorization: Bearer YOUR_TOKEN"
预期结果: 返回未读数量
curl -X PUT http://localhost:8080/system/notification/1/read \
-H "Authorization: Bearer YOUR_TOKEN"
预期结果: 成功标记已读
curl -X GET http://localhost:8080/chat/conversations \
-H "Authorization: Bearer YOUR_TOKEN"
预期结果: 返回会话列表(可能为空,需要先创建)
curl -X POST http://localhost:8080/chat/conversation/private/2 \
-H "Authorization: Bearer YOUR_TOKEN"
预期结果: 返回会话ID
curl -X GET "http://localhost:8080/chat/conversation/conv_1_2/messages?pageNum=1&pageSize=50" \
-H "Authorization: Bearer YOUR_TOKEN"
预期结果: 返回消息列表
curl -X POST http://localhost:8080/chat/conversation/conv_1_2/message \
-H "Authorization: Bearer YOUR_TOKEN" \
-H "Content-Type: application/json" \
-d '{"content":"这是一条测试消息"}'
预期结果: 消息发送成功
curl -X PUT http://localhost:8080/chat/conversation/conv_1_2/remark \
-H "Authorization: Bearer YOUR_TOKEN" \
-H "Content-Type: application/json" \
-d '{"remarkName":"我的好友"}'
预期结果: 备注设置成功
原因: 没有创建会话或数据库数据问题 解决:
原因: 会话ID不正确或后端接口问题 解决:
原因: 前端数据映射问题或API返回格式问题 解决:
-- 查看所有会话
SELECT * FROM sys_conversation;
-- 查看会话成员
SELECT * FROM sys_conversation_member;
-- 查看对话消息
SELECT * FROM sys_chat_message;
-- 查看系统通知
SELECT * FROM sys_notification;
-- 查看通知接收记录
SELECT * FROM sys_notification_receiver;
-- 查看测试用户
SELECT user_id, user_name, nick_name FROM sys_user WHERE user_id IN (1,2,3);
测试完成后,请反馈遇到的具体问题,我会进一步协助解决!