好友数据表

FriendTB

ID OleDbType.Integer
f_userID OleDbType.Integer 用户ID
f_friendName OleDbType.VarWChar(20) 好友名称
f_friendID OleDbType.Integer 好友ID
f_addTime OleDbType.Date  添加时间

添加好友
AddData_FriendTB
SQL:
INSERT INTO FriendTB
( f_userID, f_friendName, f_friendID )
SELECT @f_userID AS 表达式1, @f_friendName AS 表达式2, @f_friendID AS 表达式3;

根据用户ID获取好友统计
GetCountIdOnUserID_FriendTB
SQL:
SELECT count([ID])
FROM FriendTB
WHERE f_userID=[@f_userID];

根据用户ID和好友ID删除好友
DelOnIdUid_FriendTB
SQL:
DELETE FriendTB.ID, FriendTB.f_userID, *
FROM FriendTB
WHERE FriendTB.ID =@ID
AND FriendTB.f_userID = @f_userID;

根据用户ID获取所有好友
GetDataOnUserID_FriendTB
SQL:
SELECT FriendTB.f_friendName
FROM FriendTB
WHERE FriendTB.f_userID = @f_userID;