update [T_User] set Password = @Password where Password=(select Password from [T_User] where UserID=(select UserID from [T_TeacherWorkLog] where Condition = '已登录'))
由于这个SQL语句比较长,不太好看,所以给它换个行会更好一点:
"update [T_User] set Password = @Password where Password " +
"=(select Password from [T_User] where UserID=(select UserID "+
"from [T_TeacherWorkLog] where Condition = '已登录'))"