📄 wenti.asp
字号:
<!--#include file="../conn.asp"-->
<!--#include file="../check.asp"-->
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>学生心理测试管理界面</title>
<link href="../teacher.css" rel="stylesheet" type="text/css">
</head>
<body>
<div align="center">学生心理问题解答</div>
<%
Dim sql,rs,absolutepage,pagecount,i,huifu
call LinkData()
sql="select * from wenti"
set rs=server.createobject("adodb.recordset")
rs.open sql,conn,1,1
if rs.eof then
%>
<table border="0" width="100%" cellspacing="1" cellpadding="0">
<tr>
<td>
<p align="center">还没有任何问题</a>！</td>
</tr>
</table>
<%
response.end
else
rs.PageSize=5
absolutepage=request("absolutepage")
if absolutepage="" then absolutepage=1
rs.AbsolutePage=absolutepage
pagecount=rs.PageCount
%>
<table width="100%" border="0" align="center" cellpadding="2" cellspacing="2">
<tr>
<form name=form2 action="wenti.asp">
<td align="center">每页<%=rs.PageSize%>条 当前页<%=absolutepage%>/<%=pagecount %>
<%if cint(absolutepage)>1 then %>
<a href="wenti.asp?absolutepage=1">首页</a>
<%else %>
首页
<%end if%>
<%if cint(absolutepage)>1 then %>
<a href="wenti.asp?absolutepage=<%=cint(absolutepage)-1%>">前页</a>
<%else %>
前页
<%end if%>
<%if cint(absolutepage)<cint(pagecount) then %>
<a href="wenti.asp?absolutepage=<%=cint(absolutepage)+1%>">后页</a>
<%else Response.Write "后页" end if%>
<%if cint(absolutepage)<cint(pagecount) then %>
<a href="wenti.asp?absolutepage=<%=pagecount%>">末页</a>
<%else Response.Write "末页" end if%> </td>
</form>
</tr>
<tr>
<td align="center">
<table border="1" align="center" width="100%" cellpadding="0" cellspacing="0">
<%
for i=1 to rs.PageSize
if rs.EOF then exit for
%>
<tr >
<td align="center">姓名</td>
<td align="center">学号</td>
<td align="center">班级</td>
<td align="center">专业</td>
<td align="center">提问时间</td>
<td align="center">回复时间</td>
<td align="center">回复老师</td>
<td align="center"><a href=wentihf.asp?wid=<%=rs("wid")%>>回复</a></td>
</tr>
<tr>
<td align="center"><%=rs("mingzi")%></td>
<td><%=rs("xuehao")%></td>
<td align="center"><%=rs("banji")%></td>
<td align="center"><%=rs("zhuanye")%></td>
<td align="center"><%=rs("wtriqi")%></td>
<td align="center"><%=rs("hfriqi")%></td>
<td align="center"><%=rs("laoshi")%></td>
<td align="center"><a href="wentidelete.asp?wid=<%=rs("wid")%>">删除</a></td>
</tr>
<tr>
<td align="center">内容</td>
<td colspan="7"><%=rs("neirong")%></td>
</tr>
<tr>
<td align="center">回复 </td>
<td colspan="7"><%=rs("huifu")%></td>
</tr>
<tr>
<td colspan="8" align="center"> </td>
</tr>
<%
rs.MoveNext
next
%>
</table>
</form> </td>
</tr>
</table>
</body>
</html>
<%
rs.close
call CloseData()
'call Timenum()
end if
%>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -