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

📄 jj.jsp

📁 JSP+ORACLE网站开发实例(下).rar
💻 JSP
字号:
<%@ include file="conn.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"><%@ include file="left.inc"%></td>
          <td width="609" valign="top"><table width="580" border="0" align="center" cellpadding="5" cellspacing="5">
            <tr>
              <td width="590" colspan="2"><img src="images/deng2.gif" width="580" height="60"></td>
            </tr>
          </table>   <b>&nbsp;&nbsp;&nbsp; 中心领导:</b>         
			<table width="560"  border="0" align="center" cellpadding="3" cellspacing="3" class="txt1" id="table1">
            <tr><%  sql="select articleid,title,picurl from scott.article where classid=20 order by addtime desc"; 
  rst=stmt.executeQuery(sql); 
  ii=1;
 while(rst.next()) {
           %>                   
              <td>
				<table width="98%"  border="0" cellspacing="4" cellpadding="4" id="table2">
                  <tr>
                    <td align="center" class="txt1"><a href="renwu.jsp?id=<%=rst.getString("articleid")%>"><img src="<%=rst.getString("picurl")%>" width="80" height="101" border="0"></a> </td>
                  </tr>
                  <tr>
                    <td align="center"><a href="renwu.jsp?id=<%=rst.getString("articleid")%>" class="list5"><%=rst.getString("title")%></a></td>
                  </tr>
              </table></td>
              <% if(ii%4==0){%>
			  </tr><tr>
			  <%}
			  ii++;
			  }%>
              
            </table> &nbsp;&nbsp;&nbsp;&nbsp; <b>中心介绍:</b><br>
            <table width="560"  border="0" align="center" cellpadding="3" cellspacing="3" class="txt1">
              <%sql="select articleid,title,addtime from scott.article where classid=2 order by addtime desc"; 
  rst=stmt.executeQuery(sql);  
 while(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")%>" target="_blank" class=list3><%=rst.getString("title")%></a> 
                 </td>
                <td width="19%" class="txt3">[<%=rst.getDate("addtime")%>]</td>
              </tr>
              <%}%>              
            </table>
          </td>
        </tr>
      </table>
     <%@ include file="end.inc"%> </td>
  </tr>
</table>
</body>
</html>

⌨️ 快捷键说明

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