}
Update操作,修改用户信息:
public bool ModifyUser() { DBAccess modifyUserDBAccess = new DBAccess(); StringBuilder sqlStr = new StringBuilder(); sqlStr.Append( "update userTable set "); sqlStr.Append( " usrName = "); sqlStr.Append( "''''" + usrName + "'''',"); sqlStr.Append( " name ="); sqlStr.Append( "''''" + name + "'''',"); sqlStr.Append( " pwd ="); sqlStr.Append( "''''" + pwd + "'''',"); sqlStr.Append( " depart ="); sqlStr.Append( "''''" + depart + "'''',"); sqlStr.Append( " role ="); sqlStr.Append( "''''" + role + "''''"); sqlStr.Append( " where usrID = "); sqlStr.Append(id); modifyUserDBAccess.UpdateCommand = sqlStr.ToString(); modifyUserDBAccess.Open(); try { if (!modifyUserDBAccess.ExecuteCommand()) { errMsg = modifyUserDBAccess.ErrorMessage; return false; } else { return true; } } finally { modifyUserDBAccess.Close(); }
Delete操作,删除用户: public static bool DelUser(int usrID) { DBAccess delUserDBAccess = new DBAccess(); StringBuilder sqlStr = new StringBuilder(); sqlStr.Append( "update userTable set "); sqlStr.Append( " available ="); sqlStr.Append(0); sqlStr.Append( " where usrID = "); sqlStr.Append(usrID); delUserDBAccess.UpdateCommand = sqlStr.ToString(); delUserDBAccess.Open(); try { if (!delUserDBAccess.ExecuteCommand()) { return false; } else { return true; } } finally { delUserDBAccess.Close(); }
上一页 [1] [2] [3] [4]
Copyright @ 2007-2012 敏韬网(敏而好学,文韬武略--MinTao.Net)(学习笔记) Inc All Rights Reserved. 闵涛 E_mail:admin@mintao.net(欢迎提供学习资源)
鄂公网安备 42011102001154号
站长:MinTao ICP备案号:鄂ICP备11006601号-18