index.asp

晴和教务管理系统

<!--#include file="../inc/top.asp"-->
<!--1-->
<div align="center">
<table width="760" align="center" border="0" cellspacing="0" cellpadding="0" class="table-zuoyou" bordercolor="#CCCCCC">
<tr>
<!--left--> 
<td width="180" valign="top" bordercolor="#FFFFFF" bgcolor="#FFFFFF" class="table-you">
<!--#include file="../loginout.asp"-->
<table width=100% border=0 align=center cellpadding=0 cellspacing=0>
<tr>
<td height="35" bgcolor="f1f1f1" background="/jw/images/menu_10.gif" align="right" valign="bottom">
新 闻 搜 索&nbsp;&nbsp;&nbsp;&nbsp;</td>
</tr>
<tr>
<td class="table-xia">
<table width="90%" border="0" cellspacing="0" cellpadding="2" align="center">
<form name="34" method="post" action="searchnews.asp">
<tr> 
<td align="center"><font color="#999999">输入搜索内容所包含的关键字</font></td>
</tr>
<tr> 
<td align="center">关键字： 
<input type="text" class="wenbenkuang" name="key" size="14">
</td>
</tr>
<tr> 
<td align="center">搜索类别： 
<select size="1" name="lx">
	<option selected value="">所有类别</option>
	<option value="教务公告">教务公告</option>
	<option value="校园动态">校园动态</option>
</select></td>
</tr>
<tr> 
<td align="center" height="38"> 
<input class=go-wenbenkuang name="imageField" value="搜 索" type=submit onFocus="this.blur()">
<input class=go-wenbenkuang type=reset value="重 新 输 入" name=Submit2>
</td>
</tr>
</form>
</table>
</td>
</tr>
</table>

</td>
<!--center-->
<td width="400" valign="top" align="center" bordercolor="#FFFFFF" bgcolor="#FFFFFF"> 
<!--1-->
<table width="100%" border="0" cellspacing="0" cellpadding="0" align="center">
<TR>
<td class="table-shangxia" bgcolor="#ffffff" height="35">
<img src="/jw/images/menu_06.gif" width="41" height="33" align="absmiddle"> <a href="/jw/index.asp">教学系统</a> 
&gt;&gt; &gt;&gt; 标题新闻
</td>
</tr>
<%
set rs=server.CreateObject("adodb.recordset")
rs.open "select * from Jw_news where btnews = 1 and lock = 0 order by adddate desc",conn,1,3
%>
<TR>
<td bgcolor="#ffffff" height="35">
<table width="100%" border="0" cellspacing="0" cellpadding="0" align="center" height="200">
<TR>
<td bgcolor="#ffffff" height="35" width="5%" rowspan="2"></td>
<td bgcolor="#ffffff" height="35" align="center">
<p align="center"><% =rs("newsname")%></td>
<td bgcolor="#ffffff" height="35" width="4%" rowspan="2"></td>
</tr>
<TR>
<td bgcolor="#ffffff">
<img border="0" src="<% =rs("img")%>" width="160" height="115" align="left"><a href="dispnews.asp?newsid=<% =rs("newsid")%>"><% =left(rs("newscontent"),200)%>……</a></td>
</tr>
<%
rs.close
set rs=nothing
%>
</table>
</td>
</tr>
</table>
<!--2-->
<table width="100%" border="0" cellspacing="0" cellpadding="0" align="center">
<TR>
<td class="table-shangxia" bgcolor="#ffffff" height="35">
<img src="/jw/images/menu_06.gif" width="41" height="33" align="absmiddle"> <a href=index.asp>教学系统</a> 
&gt;&gt; &gt;&gt; 教务公告
</td>
<td class="table-shangxia" bgcolor="#ffffff" height="35" width="50"><a href="morenews.asp?lx=教务公告">更多</a></td>
</tr>
<TR>
<td bgcolor="#ffffff" height="25" colspan="2">
<table width="100%" border="0" cellspacing="0" cellpadding="0" align="center">
<TR>
<td bgcolor="#ffffff" height="21" rowspan="7" width="5%"></td>
<td bgcolor="#ffffff" height="5" colspan="2"></td>
<td bgcolor="#ffffff" height="21" rowspan="7" width="6%"></td>
</tr>
<%
set rs=server.CreateObject("adodb.recordset")
rs.open "select top 10 * from Jw_news where lx = '教务公告' and lock = 0 order by adddate desc",conn,1,3
do while not rs.eof
newsname=rs("newsname")
If Len(newsname)>25 Then newsname=Left(newsname,20)&"……"
%>
<TR>
<td bgcolor="#ffffff" height="25" width="75%"><img border="0" src="/jw/images/list01.gif" width="9" height="9"> <a href="dispnews.asp?newsid=<% =rs("newsid")%>"><% =newsname%></a> [<font color=red><% =rs("viewcount")%></font>]</td>
<td bgcolor="#ffffff" height="25" width="20%" align="center"><%=year(rs("adddate"))&"-"&month(rs("adddate"))&"-"&day(rs("adddate"))%></td>
</tr>
<%
rs.movenext
loop
rs.close
set rs=nothing
%>
</table>
</td>
</tr>
</table>
<!--3-->
<table width="100%" border="0" cellspacing="0" cellpadding="0" align="center">
<TR>
<td class="table-shangxia" bgcolor="#ffffff" height="35">
<img src="/jw/images/menu_06.gif" width="41" height="33" align="absmiddle"> <a href=index.asp>教学系统</a> 
&gt;&gt; &gt;&gt; 校园动态
</td>
<td class="table-shangxia" bgcolor="#ffffff" height="35" width="50"><a href="morenews.asp?lx=校园动态">更多</a></td>
</tr>
<TR>
<td bgcolor="#ffffff" height="25" colspan="2">
<table width="100%" border="0" cellspacing="0" cellpadding="0" align="center">
<TR>
<td bgcolor="#ffffff" height="21" rowspan="7" width="5%"></td>
<td bgcolor="#ffffff" height="5" colspan="2"></td>
<td bgcolor="#ffffff" height="21" rowspan="7" width="6%"></td>
</tr>
<%
set rs=server.CreateObject("adodb.recordset")
rs.open "select top 10 * from Jw_news where lx = '校园动态' and lock = 0 order by adddate desc",conn,1,3
do while not rs.eof
newsname=rs("newsname")
If Len(newsname)>20 Then newsname=Left(newsname,20)&"……"
%>
<TR>
<td bgcolor="#ffffff" height="25" width="75%"><img border="0" src="/jw/images/list01.gif" width="9" height="9"> <a href="dispnews.asp?newsid=<% =rs("newsid")%>"><% =newsname%></a> [<font color=red><% =rs("viewcount")%></font>]</td>
<td bgcolor="#ffffff" height="25" width="20%" align="center"><%=year(rs("adddate"))&"-"&month(rs("adddate"))&"-"&day(rs("adddate"))%></td>
</tr>
<%
rs.movenext
loop
rs.close
set rs=nothing
%>
</table>
</td>
</tr>
</table>
</td>
<!--right-->
<td width="180" bordercolor="#FFFFFF" bgcolor="#FFFFFF"  valign="top" class="table-zuo">

<table width=100% border=0 align=center cellpadding=0 cellspacing=0>
<tr>
<td height="35" bgcolor="f1f1f1" background="/jw/images/menu_11.gif" align="right" valign="bottom">热 门 新 闻&nbsp;&nbsp;&nbsp;&nbsp;</td>
</tr>
<tr>
<td>
<table width="100%" border="0" cellspacing="0" cellpadding="0" align="center">
<%
set rs=server.CreateObject("adodb.recordset")
rs.open "select top 20 * from Jw_news where lock = 0 order by viewcount desc",conn,1,3
do while not rs.eof
%>
<TR>
<td bgcolor="#ffffff"width="3%"></td>
<td bgcolor="#ffffff" height="25" width="93%"><img border="0" src="/jw/images/list01.gif" width="9" height="9"> <a href="dispnews.asp?newsid=<% =rs("newsid")%>"><% =rs("newsname")%></a></td>
<td bgcolor="#ffffff"width="1%"></td>
</tr>
<%
rs.movenext
loop
rs.close
set rs=nothing
conn.close
set conn=nothing
%>
</table>
</td>
</tr>
</table>

</td>
<!--end-->
</tr>
</table>
</div>
<!--#include file="../inc/end.asp"-->