makeindex.asp: <!--#include file="articleconn.asp"--> <% '判断是否正确登陆 IF not(Session("KEY")="super" or session("KEY")="check" or Session("KEY")="input") THEN response.redirect "mymanage.asp" response.end END IF %> <html>
<head> <meta http-equiv="Content-Type" content="text/html; charset=gb2312"> <meta name="GENERATOR" content="Microsoft FrontPage 3.0"> <title><%=title2%></title> <link rel="stylesheet" type="text/css" href="css.css"> </head>
<body>
<form method="POST" action="makeindexsave.asp"> <div align="center"><center> <table border="0" cellspacing="1" width="758" bordercolorlight="#000000" bordercolordark="#FFFFFF" cellpadding="0" bgcolor="#000000"> <tr> <td width="100%" bgcolor="#000066" height="20"> <p align="center"><b class="unnamed2"><font color="#FFFFFF">文章首页添加</font></b> </td> </tr> <tr align="center"> <td width="100%"> <table border="0" cellspacing="0" width="100%" cellpadding="0"> <tr> <td width="15%" align="right" valign="middle" class="unnamed2" bgcolor="#FFFFFF">文章分类:</td> <td width="85%" bgcolor="#FFFFFF"> <select class="unnamed2" name="typeid" size="1"> <% '查询数据库,显示出来所有栏目,这里是将所有栏目放在下拉框中 dim rs,sql,sel set rs=server.createobject("adodb.recordset") sql="select * from type" rs.open sql,conn,1,1 do while not rs.eof sel="selected" response.write "<option " & sel & " value='"+CStr(rs("typeID"))+"' name=typeid>"+rs("type")+"</option>"+chr(13)+chr(10) rs.movenext loop rs.close %> </select> </td> </tr> <tr> <td width="15%" align="right" valign="middle" class="unnamed2" bgcolor="#FFFFFF">新闻模版:</td> <td width="85%" bgcolor="#FFFFFF"> <select class="unnamed2" name="Example" size="1"> <% '查询数据库,显示所有新闻模板,也是在下拉框中显示 dim rs1,sql1,sl set rs1=server.createobject("adodb.recordset") sql1="select * from Example" rs1.open sql1,conn,1,1 do while not rs1.eof sl="selected" response.write "<option " & sl & " value='"+CStr(rs1("ID"))+"' name=id>"+rs1("name")+"</option>"+chr(13)+chr(10) rs1.movenext loop rs1.close %> </select> </td> </tr> </table> </td> </tr> </table> </center></div><div align="center"><center><p> <input type="submit" value=" 添 加 " name="cmdok" class="unnamed5"> <input type="reset" value=" 清 除 " name="cmdcancel" class="unnamed5"> </p> </center></div> </form></body> </html>