📄 cjcx.asp
字号:
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<meta name="GENERATOR" content="Microsoft FrontPage 4.0">
<meta name="ProgId" content="FrontPage.Editor.Document">
<title>New Page 1</title>
</head>
<body>
<%
Dim cn,rs
set cn=server.createobject("ADODB.Connection")
cn.Open= "DRIVER={SQL SERVER};SERVER=SUNZY;Database=pubs;UID=sa;PWD=;"
set rs=server.createobject("ADODB.Recordset")
rs.open= "SELECT * FROM 基本信息 where 学号='020320620'",cn
if rs.eof and rs.b0f then
response.write(rs.(姓名))
response.write(rs.(性别))
response.write(rs.(出生日期))
response.write(rs.(家庭住址))
response.write(rs.(电话))
response.write(rs.(QQ))
%>
<%
rs.close
set rs=nothing
cn.close
set cn=nothing
%>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -