<!--#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>
这是加入首页代码。