suitmyself / snsweb Goto Github PK

Feature　发布状态
Condition　内容包含单引号（'）（Ux0027）
Current behavior　抛出MySQLSyntaxErrorException
Expected behavior　正常发布
Cause　SQL语句未处理特殊字符；INSERT INTO t_sns.post (re_id, username, content) VALUES (-1,'daniel','It'snice!')

Brova!!!
I think it's time to finish our work.
I have done a lot of CSS working to make our web page prety.
@daniel-dong you can now check our work again.

[发布状态] 定时刷新时丢失正在编辑的状态/回复

Feature　系统消息
Condition　查看“添加好友”系统消息，验证信息包含中文字符
Current behavior　中文字符乱码（显示为??）
Expected behavior　正常显示

Feature　添加好友
Condition　对方已经是好友
Current behavior　在搜索结果中仍然出现；“加为好友”按钮可点击，后续步骤与正常情况无异；但最后提示“失败”。
Expected behavior　(1)在搜索结果中不出现；或(2)在搜索结果中出现，但标明“已是好友”，“加为好友”按钮失效。建议采用(2)，因为同时实现了查找已添加好友的功能。

Feature　添加好友
Condition　在“请输入验证信息”界面点击“取消”。
Current behavior　请求仍被发送。
Expected behavior　不发送请求。

1. 建议：在每条系统消息上显示时间戳（system_message.ts）。
2. 建议：系统消息显示顺序：分两类，先未读，后已读；每一类则按时间戳降序排列（ORDER BY DESC）。

The Linux linefeed (ASCII code: 0A) is ignored in all posts and replies.

There is an error in submitReply.jsp file:
Post stmt = conn.createPost();
the " Post" can't be resolved to be a type, @daniel-dong, do you mean:
Statement stmt = conn.createStatement();

PS: I have fixed another error in checkRegister.jsp which was modified by @daniel-dong , now we can register normally.
thx, and good luck.