用户数据表

UserDB

ID  OleDbType.Integer
UserName OleDbType.VarWChar(20) 用户名
Password OleDbType.VarWChar(20) 密码
UserAge  OleDbType.SmallInt 用户年龄
UserIP  OleDbType.VarWChar(17) 用户IP
UserQQ  OleDbType.VarWChar(20) 用户QQ
UserCent OleDbType.Integer 用户积分
UserEmail OleDbType.VarWChar(30) 电子信箱
UserWeb  OleDbType.VarWChar(255) 用户个人主页
UserImg  OleDbType.VarWChar(255) 用户图片
UserProvince OleDbType.VarWChar(10) 用户省份
UserCity OleDbType.VarWChar(10) 用户城市
UserBio  OleDbType.VarWChar(255) 个人简介
RegisterTime OleDbType.Date  注册时间
SendTopicNum OleDbType.Integer 用户统计发帖数
RevertTopic OleDbType.Integer 用户统计回复数
UserMetier OleDbType.VarWChar(50) 用户职业
UserRank OleDbType.VarWChar(20) 用户等级
UserExperience OleDbType.Integer 用户经验
UserUnderwrite OleDbType.VarWChar 个性签名
UserSex  OleDbType.VarWChar(1) 用户性别
UserBirthday OleDbType.VarWChar(14) 用户生日
UserPrestige OleDbType.Integer 声望
UserLastTime OleDbType.Date  最后活动时间
UserHonor OleDbType.VarWChar(10) 头衔
PassQuestion OleDbType.VarWChar(50) 密码提示问题
PassAnswer OleDbType.VarWChar(50) 密码答案
UserTeam OleDbType.SmallInt 用户组
UserMoney OleDbType.Integer

 

根据ID更新用户数据:
UpdateOnID_UserDB
SQL;
UPDATE UserDB
SET [Password] = [@Password],
UserAge = [@UserAge],
UserQQ = [@UserQQ],
UserCent = [@UserCent],
UserEmail = [@UserEmail],
UserWeb = [@UserWeb],
UserImg = [@UserImg],
UserProvince = [@UserProvince],
UserCity = [@UserCity],
UserBio = [@UserBio],
UserMetier = [@UserMetier],
UserRank = [@UserRank],
UserExperience = [@UserExperience],
UserUnderwrite = [@UserUnderwrite],
UserSex = [@UserSex],
UserBirthday = [@UserBirthday],
UserPrestige = [@UserPrestige],
UserHonor = [@UserHonor],
PassQuestion = [@PassQuestion],
PassAnswer = [@PassAnswer],
UserTeam = [@UserTeam]
WHERE ID=[@ID];

根据用户组获取统计值:
GetCountIdOnTeam_UserDB
SQL:
SELECT count([ID])
FROM UserDB
WHERE UserTeam=[@UserTeam];

根据ID获取用户详细数据:
GetDataOnID_UserDB
SQL:
SELECT *
FROM UserDB
WHERE UserDB.ID = @ID;

根据ID获取用户详细信息
GetDataOnID_UserDB
SQL:
SELECT *
FROM UserDB
WHERE UserDB.ID = @ID;

获取最新注册用户
GetNewUser_UserDB
SQL:
SELECT TOP 1 ID, UserName
FROM UserDB
ORDER BY ID DESC;

根据用户名获取用户ID
GetIdOnName_UserDB
SQL:
SELECT ID
FROM UserDB
WHERE UserName = @UserName;

添加新用户
InsertData_UserDB
SQL:
INSERT INTO UserDB ( UserName, [Password], UserEmail, UserSex, PassQuestion, PassAnswer )
VALUES ([@UserName], [@Password], [@UserEmail], [@UserSex], [@PassQuestion], [@PassAnswer]);

获取统计值
GetCountID_UserDB
SQL:
SELECT count([ID])
FROM UserDB;