用户组数据表

UserTeam

ID OleDbType.Integer 
t_name OleDbType.VarWChar(20) 无备注
t_time OleDbType.Date 添加时间
t_power OleDbType.SmallInt 权限

获取所有用户组:
GetData_UserTeam
SQL:
SELECT UserTeam.ID, UserTeam.t_name, UserTeam.t_power
FROM UserTeam;

根据ID更新用户组数据:
UpdateDataOnID_UserTeam
SQL:
UPDATE UserTeam
SET UserTeam.t_name = @t_name,
UserTeam.t_power = @t_power
WHERE UserTeam.ID = [@ID];

根据ID获取用户组数据:
GetDataOnID_UserTeam
SQL:
SELECT UserTeam.t_name, UserTeam.t_power
FROM UserTeam
WHERE UserTeam.ID = [@ID];

根据ID删除用户组
DelOnID_UserTeam
SQL:
DELETE *
FROM UserTeam
WHERE ID = @ID;