researchlist.asp

来自「一个互联网络公司网站源码」· ASP 代码 · 共 73 行

ASP
73
字号
<%@LANGUAGE="VBSCRIPT" CODEPAGE="936"%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>文章添加</title>
<link href="../images/css.css" rel="stylesheet" type="text/css">
<!--#include file="../conn.asp" -->
</head>

<body>
<div class="div1">
<table width="100%" border="0" cellspacing="1">
  <tr class="tb_title">
    <td colspan="6">调查列表</td>
  </tr>
  <tr class="tb_head">
    <td width="20" align="right">&nbsp;</td>
    <td align="center">问题标题</td>
    <td width="150" align="center">问题1</td>
    <td width="150" align="center">问题2</td>
    <td width="100" align="center">是否有效</td>
    <td width="100" align="center">操作</td>
  </tr>
  <%
  	sql="select * from research where 1=1 order by id desc"
  	set rs=server.CreateObject("adodb.recordset")
	rs.open sql,conn,1,1
	currentPage=Request.QueryString("page")
	if not isnumeric(currentPage) then
		currentPage=1
	end if
	currentPage=cint(currentPage)
	if currentPage<1 then
		currentPage=1
	end if
	if currentPage>rs.pagecount then
		currentPage=rs.pagecount
	end if
	PageCounts=rs.pagecount
	recordCounts=Rs.RecordCount
	if not rs.eof then
		rs.absolutepage=currentPage
	for i=1 to rs.recordcount
	if rs.eof then exit for
  %>
  
  <tr class="tr_list1">
    <td align="right">&nbsp;</td>
    <td><%=rs("question")%></td>
    <td><%=rs("title1")%></td>
    <td align="center"><%=rs("title2")%></td>
    <td align="center"><%if rs("isvalid")=1 then%>是<%else%>否<%end if%></td>
    <td align="center"><a href="research.asp?id=<%=rs("id")%>" target="_blank">查看</a> <a href="researchEdit.asp?id=<%=rs("id")%>">修改</a> <a href="articleDel.asp?id=<%=rs("ID")%>">删除</a></td>
  </tr>
  <%
  	rs.movenext
	next
	rs.close
  %>
  <tr class="tr_list1">
    <td colspan="6" align="right"><!--#include file="../turnpage.asp" --></td>
  </tr>
  
 <%else%>
  <tr class="tr_list1">
    <td colspan="6" align="center">没有检索到数据</td>
  </tr>
 <%end if%>
</table>
</div></body>
</html>

⌨️ 快捷键说明

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