⭐ 欢迎来到虫虫下载站! | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站

📄 复件 index.jsp

📁 JSP+ORACLE网站开发实例(下).rar
💻 JSP
📖 第 1 页 / 共 2 页
字号:
<%@ include file="coon.jsp"%>
<html>
<head>
<title>新闻网</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<LINK href="images/css.css" rel=stylesheet type=text/css>
<style type="text/css">
<!--
body {
	background-image: url(images/pagebg1.gif);
	margin-left: 0px;
	margin-top: 0px;
	margin-right: 0px;
	margin-bottom: 0px;
}
-->
</style>
</head>

<body>
<table width="780" border="1" align="center" cellpadding="2" cellspacing="0" bordercolor="#CACACA">
  <tr>
    <td bgcolor="#FFFFFF"><%@ include file="top.inc"%>
      <table width="780" border="0" cellspacing="0" cellpadding="0">
        <tr>
          <td width="171" valign="top" bgcolor="F7EEE4">
				<table border="0" style="border-collapse: collapse" width="100%" cellpadding="0">
					<tr>
						<td height=20 align=center><script language="JavaScript"><!-- 
var dayNames = new Array("星期日","星期一","星期二","星期三","星期四","星期五","星期六"); 
Stamp = new Date(); 
document.write("" + Stamp.getYear()+"."+(Stamp.getMonth()+ 1)+"."+Stamp.getDate()+"."+ dayNames[Stamp.getDay()] +""); 
//--> 
</script> </td>
			</tr>
		</table>
		<%@ include file="left.inc"%>
          <table width="171" border="0" cellspacing="0" cellpadding="0">
            <tr>
              <td><img src="images/zhuan.gif" width="171" height="28" border="0" usemap="#Map8"></td>
            </tr>
            <tr>
              <td><table width="98%"  border="0" cellspacing="2" cellpadding="0">
               <%     
       String sql="select articleid,title,picurl from scott.article where classid=8 order by addtime desc";
	  ResultSet rst=stmt.executeQuery(sql); 
                                    	  int ii=0;
                                      while(ii<6&&rst.next()) {  
                                          %>			
                  <tr>               
                    <td valign="bottom" class="txt1" align="center"><img src="<%=rst.getString("picurl")%>" width="80" height="101"><br><a  target=_blank  href="renwu.jsp?id=<%=rst.getString("articleid")%>" class="list5" target=_blank><%=rst.getString("title")%></a></td>
                <%if(ii/2==0){
				out.print("</tr><tr>");}%>
                </tr>
                <%ii++;
				}%>
                  </table></td>
            </tr>
          </table>
          
          <table width="171" border="0" cellspacing="0" cellpadding="0">
            <tr>
              <td><img src="images/xuejie.gif" width="171" height="28" border="0" usemap="#Map10"></td>
            </tr>
            <tr>
              <td background="images/bg1.jpg"><table width="94%"  border="0" align="center" cellpadding="0" cellspacing="2">
          <%     
        sql="select classid,class from scott.class where parentid=11 order by rootid,ordersid";
	   rst=stmt.executeQuery(sql); 
                                    	  ii=0;
                                      while(ii<4&&rst.next()) {  
                                          %>
                        <tr>
                          <td class="txt1">·<a  target=_blank  href="list.jsp?classid=<%=rst.getString("classid")%>" class="list4" title="<%=rst.getString("class")%>"><%=rst.getString("class")%></a></td>
                        </tr>
                       <%ii++;
					   }%>

              </table></td>
            </tr>
          </table></td>
          <td width="609" valign="top"><table width="594" border="0" align="center" cellpadding="0" cellspacing="3">
            <tr>
              <td colspan="2"><img src="images/dong.gif" width="594" height="25" border="0" usemap="#Map2"></td>
            </tr>
            <tr>
             <%     
        sql="select articleid,picurl,title from scott.article,scott.class where class.classid=article.classid and class.parentid=3 and picurl is not null order by addtime desc";
	   rst=stmt.executeQuery(sql); 
        if(rst.next()){%>
		       <td width="190"><table width="100%"  border="0" cellspacing="3" cellpadding="0">
                <tr>
                  <td><a href="show.jsp?id=<%=rst.getString("articleid")%>" target=_blank><img src="<%=rst.getString("picurl")%>" width="180" height="133" border="0"></a></td>
                </tr>
                <tr>
                  <td align="center"> <a href="show.jsp?id=<%=rst.getString("articleid")%>" class="list2"><strong><%=rst.getString("title")%></strong></a></td>
                </tr>
              </table>
              <%}%></td>
              <td width="401"><table width="100%"  border="0" cellpadding="0" cellspacing="3" class="txt1">
                     <%     
        sql="select articleid,title,addtime from scott.article where  (classid=22 or classid=21) order by addtime desc";
	   rst=stmt.executeQuery(sql); 
                                    	  ii=0;
                                      while(ii<7&&rst.next()) {  
                                          %>			 
                <tr>
                  <td width="4%"><img src="images/iocn1.gif" width="7" height="7"></td>
                  <td width="77%" class="txt1"><a href="show.jsp?id=<%=rst.getString("articleid")%>" title="<%=rst.getString("title")%>" class="list1" target=_blank><%=rst.getString("title")%></a></td>
                  <td width="19%" class="txt3">[<%=rst.getString("addtime")%>]</td>
                </tr>
               <%ii++;
			   }%>              </table></td>
            </tr>
          </table>
          <table width="600" border="0" align="right" cellpadding="0" cellspacing="0">
            <tr>
              <td width="406" valign="top">                <table width="400" border="0" align="center" cellpadding="0" cellspacing="3">
                  <tr>
                    <td><img src="images/deng.gif" width="400" height="25" border="0" usemap="#Map"></td>
                  </tr>
                  <tr>
                    <td><table width="100%"  border="0" cellpadding="0" cellspacing="3" class="txt1">
                              <%     
        sql="select articleid,title,addtime from scott.article where  classid=9 order by addtime desc";
	   rst=stmt.executeQuery(sql); 
                                    	  ii=0;
                                      while(ii<5&&rst.next()) {  
                                          %>		
					  <tr>
                        <td width="4%"><img src="images/iocn1.gif" width="7" height="7"></td>
                        <td width="77%" class="txt1"><a href="show.jsp?id=<%=rst.getString("articleid")%>" title="<%=rst.getString("title")%>" class="list6" target=_blank><%=rst.getString("title")%></a></td>
                        <td width="19%" class="txt3">[<%=rst.getString("addtime")%>]</td>
                      </tr>
                      <tr>
                        <td background="images/iocn2.gif" height="1" colspan="3"></td>
                      </tr>
                      <%ii++;
					  }%> 
                    </table></td>
                  </tr>
                </table>
                <br>
                <table width="400" border="0" align="center" cellpadding="0" cellspacing="3">
                  <tr>
                    <td><img src="images/san.gif" width="400" height="25" border="0" usemap="#Map3"></td>
                  </tr>
                  <tr>
                    <td><table width="100%"  border="0" cellpadding="0" cellspacing="3" class="txt1">
                                      <%     
        sql="select articleid,title,addtime from scott.article where  classid=10 order by addtime desc";
	   rst=stmt.executeQuery(sql); 
                                    	  ii=0;
                                      while(ii<5&&rst.next()) {  
                                          %>	
					  <tr>
                        <td width="4%"><img src="images/iocn1.gif" width="7" height="7"></td>
                        <td width="77%" class="txt1"><a href="show.jsp?id=<%=rst.getString("articleid")%>" title="<%=rst.getString("title")%>" class="list6" target=_blank><%=rst.getString("title")%></a></td>
                        <td width="19%" class="txt3">[<%=rst.getString("addtime")%>]</td>
                      </tr>
                      <tr>
                        <td background="images/iocn2.gif" height="1" colspan="3"></td>
                      </tr>
                      <%ii++;
					  }%> 
                    </table></td>
                  </tr>
                </table>
                <br>
                <table width="400" border="0" align="center" cellpadding="0" cellspacing="3">
                  <tr>
                    <td><img src="images/gong.gif" width="400" height="25" border="0" usemap="#Map3Map"></td>
                  </tr>
                  <tr>
                    <td><table width="100%"  border="0" cellpadding="0" cellspacing="3" class="txt1">
                      <%     
        sql="select articleid,title,addtime from scott.article where  classid=5 order by addtime desc";
	   rst=stmt.executeQuery(sql); 
                                    	  ii=0;
                                      while(ii<6&&rst.next()) {  
                                          %>
					<tr>
                        <td width="4%"><img src="images/iocn1.gif" width="7" height="7"></td>
                        <td width="77%" class="txt1"><a href="show.jsp?id=<%=rst.getString("articleid")%>" title="<%=rst.getString("title")%>" class="list6" target=_blank><%=rst.getString("title")%></a></td>
                        <td width="19%" class="txt3">[<%=rst.getString("addtime")%>]</td>

⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -