index.jsp
来自「JSP+ORACLE网站开发实例（下）.rar」· JSP 代码 · 共 539 行 · 第 1/2 页
JSP
539 行
<TD width="19%"><a href="sorts.jsp"><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 id,title,clickcount from scott.allarti order by clickcount desc";
rst=stmt.executeQuery(sql);
ii=1;
while(ii<7&&rst.next()) {
%>
<TR>
<TD height=20 width="10%"> <DIV align=center><IMG height=10
src="images/zczx-tp.gif" width=8></DIV></TD>
<TD height=20 width="71%"><a href="listarti.jsp?id=<%=rst.getString("id")%>"><%=rst.getString("title")%></a> </TD>
<TD width="19%">(<font color="#FF0000">人气:<%=rst.getString("clickcount")%></font>)</TD>
</TR>
<%ii++; }%>
<TR>
<TD height=20> <DIV align=center></DIV></TD>
<TD height=20 colspan="2"><DIV align=right><a href="sorts.jsp">更多信息</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=25>
<TABLE border=0 cellPadding=0 cellSpacing=0
width="100%">
<TBODY>
<TR>
<TD 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%"><img src="images/more.gif" width="40" height="13" border="0"></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>
<TR>
<TD vAlign=top width="48%">
<TABLE border=0 cellPadding=0 cellSpacing=0
width="100%">
<TBODY>
<%
sql="select webaddr,zwname from scott.aboutlink";
rst=stmt.executeQuery(sql);
ii=0;
while(rst.next()) {
if(ii%2==0){out.print("</tr><tr>");}
%>
<TD height=20 width="30">
<DIV align=center><IMG height=11
src="images/tp1.gif" width=11></DIV></TD>
<TD height=20><A
href="<%=rst.getString("webaddr")%>" target=_blank><%=rst.getString("zwname")%></A> </TD>
<% ii++;} %>
</TABLE></TD>
</TR></TBODY></TABLE></TD></TR></TBODY></TABLE></TD>
<TD vAlign=top width=173>
<TABLE border=0 cellPadding=0 cellSpacing=0 width="100%">
<TBODY>
<TR>
<TD width="12%"> </TD>
<TD width="88%"><IMG src="images/wsbs.gif"
width=100%></TD>
</TR>
<TR>
<TD > </TD>
<TD vAlign=top>
<TABLE
width="97%" border=0 align=center cellPadding=0 cellSpacing=0 bgcolor="#ededed">
<TBODY>
<%
sql="select id,nettitle from scott.worknet order by nettime desc";
rst=stmt.executeQuery(sql);
ii=1;
while(ii<9&&rst.next()) {
%>
<TR>
<TD height=20><SPAN ><a href="worknet.jsp?id=<%=rst.getString("id")%>">
<li><%=rst.getString("nettitle")%></a></SPAN></TD>
</TR>
<% ii++;}%>
<TR>
<TD height=10>
<div align="right">
<p><a href="listworknet.jsp" target="_blank">--更多<br>
<br>
</a></p>
</div></TD>
</TR>
</TBODY>
</TABLE></TD></TR></TBODY></TABLE>
<TABLE border=0 cellPadding=0 cellSpacing=0 width="100%">
<TBODY>
<TR>
<TD width="12%"> </TD>
<TD width="88%"><IMG height=32
src="images/mjzzgg.gif" width=100%></TD>
</TR>
<TR>
<TD > </TD>
<TD vAlign=top>
<TABLE
width="97%" border=0 align=center cellPadding=0 cellSpacing=0 bgcolor="#ededed">
<TBODY>
<%
sql="select title,id from scott.allarti where frominto=15 order by times desc";
rst=stmt.executeQuery(sql);
ii=1;
while(ii<8&&rst.next()) {
%>
<TR>
<TD height=20> <a href="listarti.jsp?id=<%=rst.getString("id")%>"><%=rst.getString("title")%></a></TD>
</TR>
<%ii++;}%>
<TR>
<TD height=10>
<DIV
align=right><a href="sorts.jsp?id=15" target="_blank">--更多</a></DIV></TD>
</TR>
</TBODY>
</TABLE></TD></TR></TBODY></TABLE>
<TABLE border=0 cellPadding=0 cellSpacing=0 width="100%">
<TBODY>
<TR>
<TD width="12%"> </TD>
<TD width="88%"><IMG height=32
src="images/wsdc.gif" width=100%></TD>
</TR>
<TR>
<TD > </TD>
<TD vAlign=top>
<TABLE bgColor=#f6f6f6 border=0 cellPadding=0
cellSpacing=0 width="100%">
<FORM action="votes.jsp?action=poll" method=post>
<INPUT name=voteID type=hidden value=6>
<TBODY>
<TR>
<%
sql="select title,id from scott.stat where isvote='true'";
rst=stmt.executeQuery(sql);
if(rst.next()) {
%>
<TD align="center"> <%=rst.getString("title")%> <input type="hidden" name="statid" value="<%=rst.getString("id")%>">
</TD>
<%}%>
</TR>
<TR>
<TD> <TABLE border=0 cellPadding=0 cellSpacing=0
width="100%">
<TBODY>
<%
sql="select voteid,votetitle from scott.votes where fromid='16' order by counts desc";
rst=stmt.executeQuery(sql);
while(rst.next()) {
%>
<TR>
<TD height=20 width="29%"> <DIV align=center>
<INPUT name=rv type=radio value=<%=rst.getString("voteid")%>>
</DIV></TD>
<TD height=20 width="71%"><%=rst.getString("votetitle")%></TD>
</TR>
<% }%>
</TBODY>
</TABLE></TD>
</TR>
<TR valign="top">
<TD> <TABLE border=0 cellPadding=0 cellSpacing=0
width="100%">
<TBODY>
<TR>
<TD vAlign=top></TD>
<TD></TD>
</TR>
<TR>
<TD vAlign=top> <DIV align=center>
<INPUT height=21 src="images/tp.gif" type=image width=60>
</DIV></TD>
<TD vAlign=top> <DIV align=center><a href="#" onClick="window.open('votes.jsp?action=look','','width=400,height=300,top='+(screen.availHeight-240)/2+',left='+(screen.availWidth-400)/2)"><IMG border=0 height=21 src="images/ck.gif" width=60></a>
</DIV></TD>
</TR>
</TBODY>
</TABLE></TD>
</TR>
</TBODY>
</FORM>
</TABLE></TD></TR></TBODY></TABLE>
</TD>
</TR></TBODY></TABLE>
</TD>
</TR></TBODY></TABLE>
<br>
<TABLE border=0 cellPadding=0 cellSpacing=0 width="100%">
<TBODY>
<tr>
<td height="27" colspan="2" background="images/rj-bg4.gif"><div align="center"><strong>最新国家政策</strong></div></td>
</tr>
<TR>
<%
sql="select id,pytitle,pybody,pyimg from scott.policy order by times desc";
rst=stmt.executeQuery(sql);
if(rst.next()) {
%>
<TD> <IMG
src="images/noname.gif" alt="q" width=150 height=120 border="0"></TD>
<TD align=left height=145 width="100%"><br>
<div align="center"><%=rst.getString("pytitle")%></div>
<br>
<a href="listpy.jsp?id=<%=rst.getString("id")%>" target="_blank"><%=rst.getString("pybody")%></a> <BR>
<DIV align=right><A href="listallpy.jsp" target=_blank>更多信息</A> <IMG src="images/xxxx1.gif" alt="w3" width=15 height=15 align="absmiddle"> </DIV></TD>
<%}%>
</TR>
</TBODY>
</TABLE>
<TABLE
width="100%" height="100" border=0 align="left" cellPadding=0 cellSpacing=0 bordercolor="#FFFFFF">
<TBODY>
<tr>
<td width="24%" height="22" background="images/title_7_1.gif"> <strong>站内公告</strong></td>
<td width="76%"> </td>
</tr>
<TR>
<TD height="72" colspan="2" vAlign=bottom><table width="100%" height="100%" border="1" cellpadding="1" cellspacing="1" bordercolor="#CCCCCC">
<tr>
<td>
<%
sql="select title,body from scott.affiche order by aftime desc";
rst=stmt.executeQuery(sql);
if(rst.next()) {
%>
<marquee direction=up height=100% id=tt666
onMouseOut=tt666.start() onMouseOver=tt666.stop()
scrollamount=1 scrolldelay=10
width=95%>
<div align="center"><%=rst.getString("title")%></div>
<br>
<%=rst.getString("body")%>
</marquee>
<% } %>
</td>
</tr>
</table></TD>
</TR>
</TBODY>
</TABLE></TD></TR></TBODY></TABLE>
<%@ include file="foot.jsp"%>
⌨️ 快捷键说明
复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?