讨论组数据表

ForumTeamDB

ID OleDbType.Integer 
f_parentID OleDbType.Integer 父ID
f_name OleDbType.VarWChar(20) 讨论组名称
f_describe OleDbType.VarWChar(255) 组描述
f_img OleDbType.VarWChar(255) 组图片

添加讨论组:
AddData_ForumTeamDB
SQL:
INSERT INTO ForumTeamDB ( f_parentID, f_name, f_describe, f_img )
VALUES ([@f_parentID], [@f_name], [@f_describe], [@f_img]);

根据ID更新讨论组:
UpdateOnID_ForumTeamDB
SQL:
UPDATE ForumTeamDB
SET f_parentID = 0,
f_name = [@f_name],
f_describe = [@f_describe],
f_img = [@f_img]
WHERE ID=[@ID];

根据ID获取讨论组数据:
GetDataOnID_ForumTeamDB
SQL:
SELECT [f_name], [f_describe], [f_img]
FROM ForumTeamDB
WHERE ID=[@ID];

根据ID删除讨论组:
DelOnID_ForumTeamDB
SQL:
DELETE *
FROM ForumTeamDB
WHERE ID=[@ID];

获取所有讨论组数据:
GetData_ForumTeamDB
SQL:
SELECT *
FROM ForumTeamDB;