摘要：delphi update 语法错误问题报告编号为SPR HSPR7CX73U标题为：Old password doesn t get inactive immediately after chan...

delphi update 语法错误

问题报告编号为SPR #HSPR7CX73U标题为：Old password doesn"t get inactive immediately after changing DWA password开发团队认为这种行为是符合设计的：When Web users change their Internet passwords, the Domino HTTP server remembers the new Internet password in its cache, as well as the old password. Caching is useful because it can take some time for the password change to take effect, as the change must be processed by the Domino administration server and replicated throughout the Domino environment. Password caching allows the HTTP server to immediately recognize the user"s new Internet password and accept it for login, even though the password change information may not be finished replicating in the Domino environment. Prior to Domino 6.0.3, password change caching was available only for single session authentication. Password changes can now be cached when the HTTP server is configured for SSO. The referenced tech note is incorrect (I have submitted a request to have the tech note updated to say that this feature was implemented for SSO users in 6.0.3).Without password caching, then the user can only login by supplying the password that can be verified against the password information found by the server in the Domino Directory. The server Notes.ini parameter HTTP_PWD_CHANGE_CACHE_HOURS can be configured to be 0 to avoid password caching. If there is no password caching, the user cannot know for sure whether the server"s directory in the environment has the password update. In the case where the Domino directory replica has not yet been updated, the user cannot use the new password and must continue to use the old password.Domino 提供了 HTTP 密码缓存功能并非产品缺陷。

在 HTTP 任务未重启的前提下，48 小时内再次登录时新老密码均有效。

C# update方法更新数据库

使用方法：string delStr = ＂update Users set UserPassword = "＂+ textBox2.Text +＂",UserSort="＂+textBox3.Text+＂ " where UserID = ＂ + textBox1.Text ;int ni= mycom.ExecuteNonQuery();if(ni>0){MessageBox.Show（＂修改成功＂， ＂提示＂）；}else{MessageBox.Show（＂修改失败＂， ＂提示＂）；}UPDATE语句用于更新修改指定记录的数据，对符合条件的记录，更新修改指定字段的值。

若没有WHERE条件限定，则对所有记录进行更新修改。

...

如何修改sql sa 密码

/**1.对于转发，只能转发一次，否则抛出异常.2.你的判断重名的逻辑有问题，你的逻辑是与list里面所有名字比较，只要不相同就入库并转发.这将导致入库很多次，转发了很多次.而转发多次将抛出异常正确的逻辑是应该先遍历完list，才能确定是否用户重名，最后转发一次.3.判断逻辑有问题，应该先遍历完list，才能确定是否用户重名，一旦重名转发，并return结束**///下面的代码是我修改的部分.if (password.equals(confirmPassword)) {for (int i = 0; i user = (User) list.get(i);if (user.getUsername().equals(username)) {request.setAttribute(＂message＂，＂用户名已经被注册！＂)；request.getRequestDispatcher(＂/admin/login.jsp＂).forward(request,response);return；//必须判断完整个list列表才能确定是否重名.}}sql = ＂insert into users(username,password) values(?,)＂;String params[] = { username,password };qr = DbHelper.getQueryRunner();try {qr.update(sql,params);} catch (SQLException e) {e.printStackTrace();}request.setAttribute(＂message＂，＂注册成功！＂)；request.getRequestDispatcher(＂/admin/login.jsp＂).forward(request,response);}else {request.setAttribute(＂message＂，＂两次密码不一样，请重新输入＂)；request.getRequestDispatcher(＂/admin/reg.jsp＂).forward(request,response);} }