📄 list1.jsp
字号:
<%@ include file="conn.jsp"%>
<%String classid=request.getParameter("classid");
int tclassid;
String sql2;
String sql1="select parentid,layer from scott.class where classid='"+classid+"'";
ResultSet rs=stmt1.executeQuery(sql1);
if(rs.next()){
tclassid=rs.getInt("parentid"); %>
<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/deng<%=classid%>.gif" width="580" height="60"></td>
</tr>
</table>
<table border="0" style="border-collapse: collapse" width="569" cellpadding="0" id="table1" align="center">
<% sql1="select classid,class from scott.class where parentid='"+classid+"' order by rootid,ordersid";
rst=stmt1.executeQuery(sql1);
while(rst.next()) { %>
<tr>
<td height="35" background="images/lm.gif">
<table width=100%>
<tr>
<td> <a href="list.jsp?classid=<%=rst.getString("classid")%>" class="list3"><%=rst.getString("class")%></a></td>
<td align=right><a href="list.jsp?classid=<%=rst.getString("classid")%>" class="list3">更多
...</a></td>
</tr>
</table>
</td>
</tr>
<tr>
<td>
<table width="560" border="0" align="center" cellpadding="3" cellspacing="3" class="txt1" id="table1">
<% Statement stmt2=conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_UPDATABLE);
sql2="select articleid,title,addtime from scott.article where classid='"+rst.getString("classid")+"' order by addtime desc";
ii=0;
ResultSet rst2=stmt2.executeQuery(sql2);
while(rst2.next()&&ii<10) { %>
<tr>
<td width="4%"><img src="images/iocn1.gif" width="8" height="7"></td>
<td width="77%" class="txt1"><a href="show.jsp?id=<%=rst2.getString("articleid")%>" target="_blank" class="list3"><%=rst2.getString("title")%></a>
</td>
<td width="19%" class="txt3">[<%=rst2.getDate("addtime")%>]</td>
</tr>
<%ii++;
}
rst2.close();
%>
</table>
</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 + -