updata1.asp

流溪网络办公系统：管理员： 用户名:admin 密码：

<!--#include file="connsf.asp" -->
<!--#include file="md5.inc" -->
<%
  str="select * from user_teacher"
  set rs=conn.execute(str)

  do while not rs.eof
    old_zw=rs("职务")
    old_zw=replace(old_zw," ","")
    new_zw="|"&old_zw
    new_zw=replace(new_zw,",","|")
    if right(new_zw,1)<>"|" then new_zw=new_zw&"|"
    up_id=rs("id")

    new_pass=ucase(md5("111111"))
    str="update user_teacher set 职务='"&new_zw&"' where id="&up_id&""
    conn.execute(str)
    
    rs.movenext
  loop

  rs.close
  conn.close
%>