28,391
社区成员
发帖
与我相关
我的任务
分享
<%
'获取当前用户名
dim Username,id,stats,sql
Username = request.Cookies("Tem")("temp_Username")
Response.Write Username
'对数据库进行查找操作
set rs_findByUsername = server.CreateObject("adodb.recordset")
rs_findByUsername.open "select * from [userb] where username='" & Username & "'",conn,1,3
If rs_findByUsername.BOF And rs_findByUsername.EOF Then
Response.Write "没有找到用户名"
Response.End
Else
id = rs_findByUsername("id") '把用户索引获取出来
stats = rs_findByUsername("status").value '把用户当前状态值获取出来,状态status字段是整型
If IsNumeric(stats) Then
stats = Cint(stats)
Select Case stats
Case 0 rs_findByUsername("status") = 1
Case 1 rs_findByUsername("status") = 2
Case 2 rs_findByUsername("status") = 3
End Select
rs_findByUsername.update
Else
Response.Write "status is null"
End If
End If
rs_findByUsername.close
set rs_findByUsername = Nothing
conn.Close
%>
'对用户状态值进行判断
if stats = 0 then
sql = "update [userb] set status=0 where id = "&id&" order by id desc"
end if
if stats = 1 then
sql = "update [userb] set status=1 where id = "&id&" order by id desc"
end if
if stats = 2 then
sql = "update [userb] set status=2 where id = "&id&" order by id desc"
end if
conn.execute(sql)
'如果后面没有数据库操作就关闭连接
conn.close
set conn=nothing