📄 daoru.asp
字号:
<%
session ("namea") = request("name1")
session ("passa") = request("pass")
Set Cnn = Server.CreateObject("ADODB.Connection")
set rs = Server.CreateObject("ADODB.recordset")
StrCnn = "Provider = Microsoft.Jet.OLEDB.4.0; Data Source=" & Server.MapPath("..\bbs\data\sj.mdb")
Cnn.Open StrCnn
rs.open "select * from ziliao where 姓名='" & session ("namea") & "' and 密码 = '" & session ("passa") & "'",cnn
jingyan = rs("经验值")
%>
<html>
<head>
<title>结果</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<link rel="stylesheet" href="format.css" type="text/css">
</head>
<body bgcolor="#FFFFFF" text="#000000">
<table width="300" border="0" cellspacing="0" cellpadding="0">
<% if rs.eof then
rs.close
cnn.close
%><tr>
<td align="center"><% response.write ("导入失败") %></td>
</tr>
<tr>
<td align="center">
<% response.write ("你输入的姓名及密码有误！")
response.end
end if %>
</td>
</tr>
<%rs.close
cnn.close
%>
<% StrCnn = "Provider = Microsoft.Jet.OLEDB.4.0; Data Source=" & Server.MapPath("base\dumm.mdb")
Cnn.Open StrCnn
rs.open "select * from 资料 where 昵称='" & session ("name1") & "'",cnn
%>
<% if rs ("导入状态") = 0 then %>
<% rs.close
rs.open "update 资料 set 经验值 = 经验值 + " &jingyan& ",导入状态 = 1 where 昵称 = '" & session ("name1") & "'",cnn
%>
<tr>
<td align="center"><% response.write ("恭喜！") %></td>
</tr>
<tr>
<td align="center">
<% response.write ("经验值已经成功导入！")
response.end %>
</td>
</tr>
<% else %>
<tr>
<td align="center"><% response.write ("导入失败！") %></td>
</tr>
<tr>
<td align="center">
<% response.write ("该名称已经导入过！") %>
</td>
</tr>
<% end if %>
</table>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -