📄 viewword.asp

📁 西风班级信息管理系统 v1.1的源码
💻 ASP
字号:
<!--#include file="inc/db.inc"-->
<%
id=request("id")
set rs= Server.CreateObject("ADODB.RECORDSET")
sql="select * from loveword where id="&id
rs.open sql,conn,1,1
callid=rs("userid")
title=rs("title")
content=rs("content")
posttime=rs("posttime")
set rs=nothing
mysql="select * from [txluser] where userid='"&callid&"'"
set rs= Server.CreateObject("ADODB.RECORDSET")
rs.open mysql,conn,1,1
if rs("sex")="男" then
ibar="ibar0b"
tbcolor="#f8fcff"
else
ibar="ibar0a"
tbcolor="#FFFCF6"
end if
%>
<html>
<head>
<title><%=title%></title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<STYLE type=text/css>.sf {
	FONT-SIZE: 12px; COLOR: #ee55bb; LINE-HEIGHT: 17px
}
.sfs {
	FONT-SIZE: 12px; COLOR: #615d5c; LINE-HEIGHT: 21px
}
.sft {
	FONT-SIZE: 12px; COLOR: #305158; LINE-HEIGHT: 21px
}
.sfh {
	FONT-SIZE: 12px; COLOR: #5588bb
}
.sfa {
	FONT-SIZE: 12px; COLOR: #cc3399
}
.sfb {
	FONT-SIZE: 12px; COLOR: #1144dd
}
.sfta {
	FONT-SIZE: 12px; COLOR: #ff88c0
}
.sftb {
	FONT-SIZE: 12px; COLOR: #6fa0e0
}
.mfa {
	FONT-SIZE: 14px; COLOR: #cc3399
}
.mfb {
	FONT-SIZE: 14px; COLOR: #1144dd
}
.r {
	COLOR: #ff0000
}
INPUT {
	FONT-SIZE: 12px
}
SELECT {
	FONT-SIZE: 12px
}
A:link {
	COLOR: #ee55bb; TEXT-DECORATION: none
}
A:visited {
	COLOR: #ee55bb; TEXT-DECORATION: none
}
A:hover {
	COLOR: red; TEXT-DECORATION: underline
}
A.a:link {
	COLOR: #dd44aa; TEXT-DECORATION: none
}
A.a:visited {
	COLOR: #dd44aa; TEXT-DECORATION: none
}
A.a:hover {
	COLOR: red; TEXT-DECORATION: underline
}
A.b:link {
	COLOR: #1144dd; TEXT-DECORATION: none
}
A.b:visited {
	COLOR: #1144dd; TEXT-DECORATION: none
}
A.b:hover {
	COLOR: red; TEXT-DECORATION: underline
}
A.t:link {
	COLOR: #305158; TEXT-DECORATION: none
}
A.t:visited {
	COLOR: #305158; TEXT-DECORATION: none
}
A.t:hover {
	COLOR: red; TEXT-DECORATION: underline
}
</STYLE>
</head>

<body topmargin="0">
<TABLE id=mytab width=560 border=0 cellPadding=0 cellSpacing=0>
  <TBODY>
  <TR>
    <TD width=5 background=images/<%=ibar%>1.gif height=5></TD>
    <TD width=550 background=images/<%=ibar%>2.gif></TD>
    <TD width=5 background=images/<%=ibar%>3.gif></TD></TR>
  <TR vAlign=top align=middle>
    <TD width=5 background=images/<%=ibar%>4.gif></TD>
    <TD width=550 bgColor=<%=tbcolor%>>
<TABLE width=550 border=0 align="center" cellPadding=10 cellSpacing=0 class=mfb>
  <TBODY>
        <TR>
          <TD width=330>　<IMG height=32 src="<%=rs("headpic")%>" width=32 
            align=absMiddle>&nbsp;<FONT class=mfb><%=rs("userid")%></FONT><FONT 
            class=sfb>『<%=rs("truename")%>』</FONT></TD>
          <TD class=sfb align=middle width=40></TD>
          <TD width=50>
		  <%
		  Dim a(11)
		  a(0)="白羊座"
		  a(1)="处女座"
		  a(2)="金牛座"
		  a(3)="巨蟹座"
		  a(4)="山羊座"
		  a(5)="人马座"
		  a(6)="狮子座"
		  a(7)="双鱼座"
		  a(8)="双子座"
		  a(9)="水瓶座"
		  a(10)="天秤座"
		  a(11)="天蝎座"
		  for i=0 to 11
		  if a(i)=rs("xingzuo") then
		  exit for
		  end if
		  next
		  %><IMG height=57 alt="<%=rs("xingzuo")%>" src="images/xing<%=i+1%>.gif" width=49 
            align=absMiddle border=0></TD>
          <TD width=50>
		  <%
		  a(0)="狗"
		  a(1)="猴"
		  a(2)="虎"
		  a(3)="鸡"
		  a(4)="龙"
		  a(5)="马"
		  a(6)="牛"
		  a(7)="蛇"
		  a(8)="鼠"
		  a(9)="兔"
		  a(10)="羊"
		  a(11)="猪"
		  for i=0 to 11
		  if a(i)=rs("snxiao") then
		  exit for
		  end if
		  next
		  %><IMG height=57 alt="<%=rs("snxiao")%>" src="images/sheng<%=i+1%>.gif" width=49 
            align=absMiddle border=0></TD></TD></TR></TBODY></TABLE>
      
<TABLE width=550 border=0 align="center" cellPadding=5 cellSpacing=5 class=sftb>
  <TBODY>
    <TR> 
      <TD width=128>性别：<FONT class=sfb><%=rs("sex")%></FONT></TD>
      <TD width=128>生日：<FONT class=sfb><%=rs("birthday")%></TD>
      <TD width=128>电话：<FONT class=sfb><%=rs("telephone")%></FONT></TD>
      <TD width=128>OICQ：<FONT class=sfb><%=rs("oicq")%></FONT></TD>
    </TR>
    <TR> 
      <TD width=128>血型：<FONT class=sfb><%=rs("blood")%></FONT> </TD>
      <TD width=128>手机：<FONT class=sfb><%=rs("mobile")%></FONT></TD>
      <TD colspan="2">地址：<%=rs("address")%>(<%=rs("zipcode")%>)</TD>
    </TR>
  </TBODY>
</TABLE>
      
<TABLE width=550 border=0 align="center" cellPadding=5 cellSpacing=5 class=sftb>
  <TBODY>
    <TR> 
      <TD width="50%">信箱：<A class=b href="mailto:<%=rs("email")%>" 
            target=_blank><%=rs("email")%></A></TD>
      <TD width="50%">主页：<A class=b href="<%=rs("page")%>" 
            target=_blank><%=rs("page")%></A></TD>
    </TR>
    <TR> 
      <TD>崇拜偶像：<FONT class=sfb><%=rs("idol")%></FONT></TD>
      <TD>最喜欢的音乐：<FONT class=sfb><%=rs("music")%></FONT></TD>
    </TR>
    <TR> 
      <TD>最难忘的格言：<FONT class=sfb><%=rs("geyan")%></FONT></TD>
      <TD>最喜欢的运动：<FONT class=sfb><%=rs("sports")%></FONT></TD>
    </TR>
    <TR> 
      <TD>最向往的职业：<FONT class=sfb><%=rs("job")%></FONT></TD>
      <TD>最喜欢的食物：<FONT class=sfb><%=rs("loveat")%></FONT></TD>
    </TR>
    <TR> 
      <TD colSpan=2>最爱去的地方：<FONT class=sfb><%=rs("goaddress")%></font></TD>
    </TR>
    <TR> 
      <TD colSpan=2>爱好：<FONT class=sfb><%=rs("aihao")%></FONT></TD>
    </TR>
    <TR> 
      <TD colSpan=2>性格：<FONT class=sfb><%=rs("xinge")%></FONT></TD>
    </TR>
    <TR> 
      <TD colSpan=2>送你的赠言：<FONT class=sfb><%=title%></FONT></TD>
    </TR>
    <TR> 
      <TD class=mfb colSpan=2><%=content%></TD>
    </TR>
    <TR> 
      <TD align=right colSpan=2><%=posttime%><a href="javascript:window.close();">[关闭窗口]</a></TD>
    </TR>
  </TBODY>
</TABLE>
</TD>
    <TD width=5 background=images/<%=ibar%>5.gif></TD></TR>
  <TR>
    <TD background=images/<%=ibar%>6.gif height=5></TD>
    <TD background=images/<%=ibar%>7.gif></TD>
    <TD background=images/<%=ibar%>8.gif></TD></TR></TBODY></TABLE>
<%set rs=nothing%>
</body>
</html>
⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -