帖子分类数据表

TopicClass

ID OleDbType.Integer 无备注
ForumID OleDbType.Integer 版块ID
c_name OleDbType.VarWChar(20) 分类名称
c_id OleDbType.Integer 分类ID
c_addTime OleDbType.Date 添加时间

 根据版块名称获取帖子分类:
GetDataOnForumID_TopicClass
SQL:
SELECT TopicClass.ID, TopicClass.c_name
FROM TopicClass
WHERE TopicClass.ForumID = [@ForumID];

添加帖子分类
AddData_TopicClass
SQL:
INSERT INTO TopicClass ( ForumID, c_name )
SELECT @ForumID AS 表达式1, @c_name AS 表达式2;

根据ID删除帖子分类:
DelOnID_TopicClass
SQL:
DELETE TopicClass.ID, *
FROM TopicClass
WHERE TopicClass.ID = @ID;

根据ID获取帖子分类数据
GetDataOnID_TopicClass
SQL:
SELECT  c_name
FROM TopicClass
WHERE ID = @ID 

根据ID更新帖子分类数据
UpdateOnID_TopicClass
SQL:
UPDATE TopicClass SET TopicClass.c_name = @c_name
WHERE TopicClass.ID = @ID;