index.jsp
来自「JSP+ORACLE网站开发实例（下）.rar」· JSP 代码 · 共 539 行 · 第 1/2 页
JSP
539 行
<%@ include file="mzconst.jsp"%>
<%@ include file="rscoon.jsp"%>
<%@ include file="totalcount.jsp"%>
<% String toptitle="政府网欢迎您！"; %>
<%@ include file="mztop.jsp"%>
<TABLE width=766 border=1 align=center cellPadding=0 cellSpacing=0 bordercolor="#E7E7E7" background="images/tpbg1.gif">
<TBODY>
<TR>
<TD height=33 vAlign=center>
<TABLE width="100%" height="100%" border=0 align="center" cellPadding=0 cellSpacing=0>
<TBODY>
<TR>
<TD width="12%" height="31" vAlign=bottom> </TD>
<TD vAlign=bottom><img height=9 src="images/tpbgtp.gif"
width=16> <span><font color="#006633"><%=toppic%></font></span></TD>
<TD width="20%" vAlign=bottom>
<marquee direction=left height=5 id=tt6
onMouseOut=tt6.start() onMouseOver=tt6.stop()
scrollamount=1 scrolldelay=60
width=95%>
</marquee>
<span class="3dfont">您是第<FONT color=red><%=totalcount%></FONT>位访客</span></TD>
</TR></TBODY></TABLE></TD></TR></TBODY></TABLE>
<TABLE align=center bgColor=#ffffff border=0 cellPadding=0 cellSpacing=0
width=766>
<TBODY>
<TR>
<TD background=images/l-bg1.gif height=575 vAlign=top width=187>
<TABLE align=center border=0 cellPadding=0 cellSpacing=0 height=13
width=167>
<TBODY>
<TR>
<TD><IMG height=32 src="images/zcfg1.gif"
width=186></TD></TR></TBODY></TABLE>
<TABLE width=167 border=0 align=center cellPadding=0 cellSpacing=0>
<TBODY>
<TR>
<TD vAlign=top><IMG height=5 src="images/zcfg-tp1.gif"
width=100%></TD>
</TR>
<TR>
<TD height=193 vAlign=top> <TABLE
width="99%" border=1 align=center cellPadding=0 cellSpacing=0 bordercolor="#999999">
<TBODY>
<TR> <TD height="188" valign="middle">
<%
sql="select sort,id from scott.allsort order by id";
rst=stmt.executeQuery(sql);
while(rst.next()) {
%>
<FONT
color=#ff0000>·</FONT><a href="sorts.jsp?id=<%=rst.getString("id")%>"><%=rst.getString("sort")%></a>
<%}%>
</TD>
</TR>
</TBODY>
</TABLE></TD>
</TR>
<TR>
<TD vAlign=top><IMG height=5 src="images/zcfg-tp3.gif"
width=100%></TD>
</TR></TBODY></TABLE>
<TABLE border=0 cellPadding=0 cellSpacing=0 height=3 width="100%">
<TBODY>
<TR>
<TD></TD></TR></TBODY></TABLE>
<TABLE border=0 cellPadding=0 cellSpacing=0 width="98%">
<TBODY>
<TR>
<TD bgColor=#f7f7f7 height=174 vAlign=top>
<TABLE border=0 cellPadding=0 cellSpacing=0 width="100%">
<TBODY>
<TR>
<td height="30" background="images/zsdwwz.gif">
<div align="center"><strong><font color="#FFFF00">媒体关注</font></strong></div></td>
</TR></TBODY></TABLE>
<TABLE
width="100%" border=1 align=right cellPadding=0 cellSpacing=0 bordercolor="#5698CD">
<TBODY>
<%
sql="select nstitle, id from scott.news order by clicks desc";
rst=stmt.executeQuery(sql);
int ii=1;
while(ii<7&&rst.next()) {
%>
<TR>
<TD height=20 ><IMG border=0 height=8
src="images/zxzctp4.gif" width=6><a href ="listnews.jsp?id=<%=rst.getString("id")%>"><%=rst.getString("nstitle")%></a></TD>
</TR>
<%ii++; } %>
<TR>
<TD align=left colSpan=2 height=20> <div align="right"><A href="listallns.jsp?act=click" target=_blank>更多信息>>..</A>
</div></TD>
</TR>
</TBODY>
</TABLE>
</TD></TR></TBODY></TABLE>
<TABLE border=0 cellPadding=0 cellSpacing=0 width="98%">
<TBODY>
<TR>
<TD bgColor=#f7f7f7 height=165 vAlign=top>
<br>
<TABLE border=0 cellPadding=0 cellSpacing=0 width="100%">
<TBODY>
<TR>
<td height="30" background="images/mzdc.gif">
<div align="center"><strong><font color="#FFFF00">视频点播</font></strong></div></td>
</TR></TBODY></TABLE>
<TABLE
width="100%" border=1 align=right cellPadding=0 cellSpacing=0 bordercolor="#78AC55">
<TBODY>
<%
sql="select id,vdtitle from scott.video order by times desc";
rst=stmt.executeQuery(sql);
ii=1;
while(ii<6&&rst.next()) {
%>
<TR>
<TD colSpan=3 height=20><IMG border=0
height=8 src="images/zxzctp4.gif" width=6><a href="movie.jsp?id=<%=rst.getString("id")%>" target="_blank"><%=rst.getString("vdtitle")%></a></TD>
</TR>
<% ii++; } %>
<TR>
<TD width="49%">
<DIV align=right></DIV></TD>
<TD width="51%"><div align="right"><a href="listallvideo.jsp" target="_blank">更多信息>>..</a></div></TD>
</TR>
</TBODY>
</TABLE></TD>
</TR></TBODY></TABLE>
<TABLE width="98%" border=1 cellPadding=0 cellSpacing=0 bordercolor="#C98247">
<TBODY>
<TR>
<TD bgColor=#e1f5ff height=90 vAlign=top>
<TABLE border=0 cellPadding=0 cellSpacing=0 width="100%">
<TBODY>
<TR>
<td height="28" background="images/spdb.gif">
<div align="center"><strong>民政统计</strong></div></td>
</TR></TBODY></TABLE>
<TABLE border=0 cellPadding=0 cellSpacing=0 width="100%">
<TBODY>
<%
sql="select tjtitle,tjid from scott.mztj order by tjtime desc";
rst=stmt.executeQuery(sql);
ii=1;
while(ii<6&&rst.next()) {
%>
<TR>
<TD width="19%" height=22> <DIV align=center><IMG height=10
src="images/zczx-tp.gif" width=8></DIV></TD>
<TD width="81%" height=22><A href="dismztj.jsp?id=<%=rst.getString("tjid")%>"><%=rst.getString("tjtitle")%></A></TD>
</TR>
<% ii++;} %>
<tr>
<td colspan="2"><div align="right"><a href="listalltj.jsp" target="_blank">更多信息>>..</a></div></td>
</tr>
</TBODY>
</TABLE></TD></TR></TBODY></TABLE>
<TABLE border=0 cellPadding=0 cellSpacing=0 width="98%">
<TBODY>
<TR>
<TD height=130 vAlign=top>
<TABLE border=0 cellPadding=0 cellSpacing=0 width="100%">
<TBODY>
<TR>
<TD><IMG height=31 src="images/znjs.gif"
width=186></TD></TR></TBODY></TABLE>
<TABLE border=0 cellPadding=0 cellSpacing=0 width="100%">
<TBODY>
<TR>
<TD>
<FORM action="searchs.jsp" method="post"
onsubmit="return checkForm(this);" target="_blank">
<TABLE border=0 cellPadding=0 cellSpacing=5 width="100%">
<TBODY>
<TR>
<TD height=25>
<DIV align=right>检索范围：</DIV></TD>
<TD><SELECT name="channel">
<option value="1">政策法规</option>
<option value="2">国家政策</option>
<option value="3">民政新闻</option>
<option value="4">视频教程</option>
<option value="5">民政统计</option>
<option value="6">网上办事</option>
</SELECT></TD></TR>
<TR>
<TD>
<DIV align=right>关键字：</DIV></TD>
<TD><INPUT name="keyword" size=10></TD></TR>
<TR>
<TD colSpan=2>
<DIV align=center><INPUT border=0 height=21
src="images/cx11.gif" type=image width=54>
</DIV></TD></TR></TBODY></TABLE></FORM></TD></TR></TBODY></TABLE></TD></TR></TBODY></TABLE></TD>
<TD vAlign=top width=579><TABLE width="100%" border=0 align="center" cellPadding=0 cellSpacing=0>
<TBODY>
<TR>
<TD width=20></TD>
<TD vAlign=top width=555>
<TABLE border=0 cellPadding=0 cellSpacing=0 width=546>
<TBODY>
<TR>
<TD vAlign=top width=389>
<TABLE border=0 cellPadding=0 cellSpacing=0 width="100%">
<TBODY>
<TR>
<TD background=images/zxzctp3.gif height=23
vAlign=top>
<TABLE border=0 cellPadding=0 cellSpacing=0
width="100%">
<TBODY>
<TR>
<TD 2 width="9%">
<DIV align=center><IMG height=12
src="images/zxzctp1.gif"
width=13></DIV></TD>
<TD width="72%"><strong><font color="#FFFFFF">民政新闻</font></strong></TD>
<TD width="19%"><a href="listallns.jsp?act=times"><IMG src="images/more.gif" width=40 height=13 border="0"></a></TD>
</TR></TBODY></TABLE></TD></TR></TBODY></TABLE>
<TABLE bgColor=#ebebeb border=0 cellPadding=0 cellSpacing=3
width="100%">
<TBODY>
<TR>
<TD bgColor=#f6f6f6 vAlign=top>
<TABLE border=0 cellPadding=0 cellSpacing=0
width="100%">
<TBODY>
<%
sql="select nstitle,times,id from scott.news order by times desc";
rst=stmt.executeQuery(sql);
ii=1;
while(ii<10&&rst.next()) {
%>
<TR>
<TD width="10%"> <DIV align=center><IMG height=10
src="images/zczx-tp.gif" width=8></DIV></TD>
<TD width="50%"><a href="listnews.jsp?id=<%=rst.getString("id")%>"><%=rst.getString("nstitle")%></a></TD>
<TD width="30%"><a href="listnews.jsp?id=<%=rst.getString("id")%>">(<%=rst.getString("times")%>)</a> </TD>
</TR>
<% ii++;}%>
<TR>
<TD height=20> <DIV align=center></DIV></TD>
<TD> </TD>
<TD height=20><DIV align=right><A
href="listallns.jsp?act=times" target=_blank>更多信息</A>
<IMG
src="images/xxxx1.gif" width=15 height=15 align="absmiddle">
</DIV></TD>
</TR>
</TBODY>
</TABLE></TD></TR></TBODY></TABLE>
<br>
<TABLE border=0 cellPadding=0 cellSpacing=0 width="100%">
<TBODY>
<TR>
<TD background=images/zxzctp3.gif height=23
vAlign=top>
<TABLE border=0 cellPadding=0 cellSpacing=0
width="100%">
<TBODY>
<TR>
<TD height=22 width="9%">
<DIV align=center><IMG height=12
src="images/zxzctp1.gif"
width=13></DIV></TD>
<TD width="72%"><strong><font color="#FFFFFF">热点透视</font></strong></TD>
⌨️ 快捷键说明
复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?