📄 14.jsp
字号:
<%@page language="java" //声明脚本语言的种类%>
<%@page contentType="text/html;charset=8859_1" //设置MIME类型%>
<%@page import="java.sql.*"%>
<%@page import="DBCon"%>
<% DBCon DBConBean=new DBCon(); %>
<%@page import="IdSelect"%>
<% IdSelect IdSelectBean=new IdSelect(); %>
<%@page import="DateText"%>
<% Connection conn = DBConBean.getConnection();
IdSelectBean.setConn(conn);%>
<%
// **************
// *文章内容及相关*
// **************
//从上一页取得wzid
//从wenzhang表中取得wz_id="wzid"的数据的lm_id、zt_id、s_jb_id、wz_name、wz_where、wz_nr、wz_auth、wz_lastdata、wz_colour_nr
//根据lm_id、s_jb_id取得此文章所在栏目的前五条精华文章的wz_id、wz_name
//向下一页传wzid、lmid、ztid
%>
<html>
<head>
<title>天津市教育委员会发展规划处</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<link rel="stylesheet" href="../style.css" type="text/css">
</head>
<body bgcolor="#FFFFFF" text="#000000" leftmargin="0" topmargin="0" marginwidth="0" marginheight="0">
<table width="62%" border="0" cellspacing="0" cellpadding="0" align="center">
<tr>
<td><img src="../images/top_01.gif" width="779" height="22" usemap="#Map2" border="0"></td>
</tr>
<tr>
<td><img src="../images/top_02.gif" width="779" height="93"></td>
</tr>
<tr>
<td><img src="../images/blank.gif" width="779" height="27" usemap="#Map" border="0">
<map name="Map">
<area shape="rect" coords="171,3,215,24" href="http://211.81.22.65:7001/others/63/index.jsp">
<area shape="rect" coords="260,5,326,24" href="http://211.81.22.65:7001/themes/lm/14.jsp?lm_id=53&s_jb_id=63&zt_id=0&lm_sid=0">
<area shape="rect" coords="367,4,432,23" href="http://211.81.22.65:7001/themes/lm/13.jsp?lm_id=54&s_jb_id=63&zt_id=0&lm_sid=0">
<area shape="rect" coords="474,4,540,24" href="http://211.81.22.65:7001/themes/lm/13.jsp?lm_id=55&s_jb_id=63&zt_id=0&lm_sid=0">
<area shape="rect" coords="581,4,647,23" href="http://211.81.22.65:7001/themes/lm/13.jsp?lm_id=56&s_jb_id=63&zt_id=0&lm_sid=0">
<area shape="rect" coords="697,4,763,22" href="http://211.81.22.65:7001/themes/lm/13.jsp?lm_id=57&s_jb_id=63&zt_id=0&lm_sid=0">
</map>
</td>
</tr>
<tr>
<td background="../images/bg_1.gif" height="498" valign="top" align="center">
<table width="100%" border="0" cellspacing="0" cellpadding="0" height="309">
<tr>
<td width="74%" valign="top" align="center" height="498"> <br>
<br>
<table width="90%" border="0" cellpadding="0" cellspacing="0">
<%
String lm_id="";
String zt_id="";
String s_jb_id="";
String wz_name="";
String wz_id="";
String wz_where="";
String wz_nr="";
String wz_auth="";
String wz_lastdata="";
String wz_colour_nr="";
//String wzid="";
wz_id = request.getParameter("wz_id");
String lm_moban_id = request.getParameter("lm_moban_id");
IdSelectBean.setIdName("wz_id");
IdSelectBean.setStrTableName("wenzhang");
IdSelectBean.setStrId(wz_id);
//s_jb_id+" and lm_id='"+lm_id+"'")
try {
ResultSet result = IdSelectBean.getResultSet();
while(result.next()) {
lm_id=result.getString("lm_id");
zt_id=result.getString("zt_id");
wz_name=result.getString("wz_name");
wz_nr=result.getString("wz_nr");
wz_where=result.getString("wz_where");
wz_auth=result.getString("wz_auth");
//wz_toped=result.getString("wz_toped");
wz_lastdata=result.getString("wz_lastdata");
//wz_jinghua=result.getString("wz_jinghua");
//wz_key=result.getString("wz_key");
s_jb_id=result.getString("s_jb_id");
String wz_colour_list=result.getString("wz_colour_list");
String wz_colour_topic=result.getString("wz_colour_topic");
wz_colour_nr=result.getString("wz_colour_nr");
%>
<tr>
<td colspan="3">
<h2 align="center"><font color="<%=wz_colour_list%>"><%= wz_name %></font></h2>
</td>
</tr>
<tr>
<td colspan="3">
<hr>
</td>
</tr>
<tr>
<td width="34%">出处：<%= wz_where %></td>
<td width="34%">作者：<%= wz_auth%></td>
<td width="32%">发布日期：<%= wz_lastdata %></td>
</tr>
<tr>
<td colspan="3">[文章内容]</td>
</tr>
<tr>
<td colspan="3" ><font color="<%=wz_colour_nr%>"><%=wz_nr%></font></td>
</tr>
<%
}
result.close();}
catch(Exception e) {DBConBean.closeAll();
e.printStackTrace();
}
%>
</table>
<br>
<br>
<table width="90%" border="0" cellpadding="0" cellspacing="0">
<tr>
<td>相关文章：</td>
</tr>
<tr>
<% IdSelectBean.setStrId(s_jb_id+" and lm_id='"+lm_id+"' and wz_qf='1'");
try {
ResultSet result1 = IdSelectBean.getReSet();
while(result1.next()) {
//System.out.print("ok");
String wzid= result1.getString("wz_id");
%>
<td><a href="../wz/<%=lm_moban_id%>.jsp?wz_id=<%=wzid%>&lm_moban_id=<%=lm_moban_id%>"><%= result1.getString("wz_name") %></a></td>
</tr>
<%
}
result1.close() ;}
catch(Exception e) {DBConBean.closeAll();
e.printStackTrace();
} DBConBean.closeAll();
%>
<tr>
<td>
<div align="right"></div>
</td>
</tr>
</table>
</td>
<td width="26%" valign="top" align="center" height="498">
<table width="85%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td height="5" colspan="2"><img src="../images/bb.gif" width="6" height="6"></td>
</tr>
<tr>
<td colspan="2"> </td>
</tr>
<tr>
<td width="5%" valign="top" align="center">
<li>
</td>
<td width="95%">浏览率最高文章列表</td>
</tr>
<tr>
<td colspan="2"> </td>
</tr>
<tr>
<td colspan="2"> </td>
</tr>
<tr>
<td colspan="2"> </td>
</tr>
<tr>
<td colspan="2"> </td>
</tr>
<tr>
<td colspan="2"> </td>
</tr>
</table>
</td>
</tr>
</table>
</td>
</tr>
<tr>
<td><img src="../images/boot_01.gif" width="779" height="13"></td>
</tr>
<tr>
<td background="../images/boot_bg.gif" align="center" valign="middle" height="93"><img src="../images/bootinfo.gif" width="302" height="56"></td>
</tr>
</table>
<map name="Map2">
<area shape="rect" coords="702,5,761,19" href="#">
</map>
</body>
</html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -