📄 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);
//String lm_sid=request.getParameter("lm_sid");
//String pages=request.getParameter("pages");
//String pages=request.getParameter("pages");
// **************
// *文章内容及相关*
// **************
//从上一页取得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.gif" height="498" valign="top" align="center">
<table width="100%" border="0" cellspacing="0" cellpadding="0" height="309">
<tr>
<td width="25%" valign="top" align="center" height="498">
<table width="59%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td height="2"><img src="../images/bb.gif" width="6" height="6"></td>
</tr>
<tr>
<td><img src="../images/2_left_1.gif" width="186" height="18"></td>
</tr>
<tr>
<td background="../images/left_bg.gif" height="449" valign="top" align="center">
<table width="90%" border="0">
<%
String lm_id = request.getParameter("lm_id");
String s_jb_id=request.getParameter("s_jb_id");//"60";
String lm_sid="";//lm_sid;
IdSelectBean.setIdName("lm_del");
IdSelectBean.setStrTableName("lanmu");
IdSelectBean.setStrId("'0' and lm_type='"+lm_id+"' and s_jb_id='"+s_jb_id+"'");
try {
ResultSet result = IdSelectBean.getResultSet();
%>
<tr>
<td>
<%
while(result.next()) {
lm_sid=result.getString("lm_id");
String lm_type=result.getString("lm_type");
String lm_name=result.getString("lm_name");
s_jb_id=result.getString("s_jb_id");
String lm_moban_id=result.getString("lm_moban_id");
%>
◎ <a href="../lm/<%=lm_moban_id%>.jsp?lm_id=<%=lm_id%>&s_jb_id=<%=s_jb_id%>&zt_id=0&lm_sid=<%=lm_sid%>"><%= lm_name %></a><br>
<%
}
result.close() ;}
catch(Exception e) {DBConBean.closeAll();
e.printStackTrace();
}
%>
</td>
</tr>
<tr>
<td> </td>
</tr>
</table></td>
</tr>
<tr>
<td><img src="../images/left_2.gif" width="186" height="17"></td>
</tr>
</table>
</td>
<td valign="top" align="center" height="498">
<table width="90%" border="0" align="center">
<tr>
<td>标题</td>
</tr>
<%
String lm_sid_new=request.getParameter("lm_sid");
if(lm_sid_new.equals("0")){lm_sid_new=lm_sid;}else{}
//String wz_power=(String)session.getValue("s_user_id");
//System.out.print(wz_power);
//String lm_id="58";
String zt_id="0";
String lm_moban_id="";
String lm_line="";
String lm_win="";
//String lm_id=request.getParameter("lmid");
//String zt_id=request.getParameter("ztid");
IdSelectBean.setIdName("lm_id");
IdSelectBean.setStrTableName("lanmu");
IdSelectBean.setStrId(lm_sid_new+" and lm_del=0");
try {
ResultSet result = IdSelectBean.getResultSet();
while(result.next()) {
lm_line=result.getString("lm_line");
lm_win=result.getString("lm_win");
lm_moban_id=result.getString("lm_moban_id");
}
result.close() ;}
catch(Exception e) {DBConBean.closeAll();
e.printStackTrace();
}
//String s_jb_id =(String)session.getValue("s_jb_id");
int pagesize=Integer.parseInt(lm_line);
String pages=request.getParameter("pages");
if ((pages==null)||(pages=="")){pages="1";}else{}
int pages_new = Integer.parseInt(pages);
IdSelectBean.setStrTableName("wenzhang");
IdSelectBean.setStrId("wz_del='0' and lm_id='"+lm_sid_new+"'");
int count = IdSelectBean.getCount();
int pageline=(count%pagesize)==0?(count/pagesize):(count/pagesize)+1;
if (pages_new<=0){pages_new=1;}else{
if (pages_new>pageline){pages_new=pageline;}else{}}
IdSelectBean.setIdName("wz_del");
IdSelectBean.setStrTableName("wenzhang");
if(lm_id.equals("0"))
{IdSelectBean.setStrId("'0' and wz_qf='1' and zt_id='"+zt_id+"'");}
else{IdSelectBean.setStrId("'0' and wz_qf='1' and lm_id='"+lm_sid_new+"' order by wz_toped desc");}
//wz_power='10' and lm_id='32' and zt_id='2'"); and wz_power='"+wz_power+"'
String wz_name="";
String wz_id="";
String wz_bei2="";
try {
ResultSet result = IdSelectBean.getResultSet();
//System.out.print("ok");
int i=1;
//利用while循环将数据表中的记录列出
while(result.next()) {i=i+1;
//System.out.print("ok");
wz_id= result.getString("wz_id");
String wz_colour_list= result.getString("wz_colour_list"); if((i>((pages_new-1)*pagesize))&&(i<(pages_new*pagesize+1))){
%>
<tr>
<td> <a href="../wz/<%=lm_moban_id%>.jsp?wz_id=<%=wz_id%>&lm_moban_id=<%=lm_moban_id%>&lm_sid=<%=lm_id%>"><font color="<%=wz_colour_list%>"><%= result.getString("wz_name") %></font></a>
<%wz_bei2=result.getString("wz_bei2");
if (wz_bei2.equals("1")){out.println("<img src='../../../../img/1.gif'>");}
else
{if (wz_bei2.equals("0")){out.println("<img src='../../../../img/2.gif'>");}
else
{if (wz_bei2.equals("2")){out.println("<img src='../../../../img/3.gif'>");}
else
{if (wz_bei2.equals("3")){out.println("<img src='../../../../img/4.gif'>");}
else{}}}}
%>
</td>
</tr>
<%
}else{}}
result.close() ;}
catch(Exception e) {DBConBean.closeAll();
e.printStackTrace();
} DBConBean.closeAll();int j=pages_new-1;int h=pages_new+1;
%>
<tr>
<td> 共<%=(count%pagesize)==0?(count/pagesize):(count/pagesize)+1%>页 <a href="<%=lm_moban_id%>.jsp?pages=<%=j%>&lm_id=<%=lm_id%>&zt_id=0&lm_moban_id=<%=lm_moban_id%>&lm_sid=0&s_jb_id=<%=s_jb_id%>">上一页</a> <a href="<%=lm_moban_id%>.jsp?pages=<%=h%>&lm_id=<%=lm_id%>&zt_id=0&lm_moban_id=<%=lm_moban_id%>&lm_sid=0&s_jb_id=<%=s_jb_id%>">下一页</a> 本页是第<%=pages_new%>页
<input type="text" name="pages" style="width:20px">
<input type="button" name="Submit" value="GO" onClick="subb()">
</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>
<script language="javascript">
function subb() {
if(document.form1.pages.value==""){alert("请输入你需要的页号");}else{
document.form1.action="<%=lm_moban_id%>.jsp?pages="+document.form1.pages.value+"&lm_id=<%=lm_id%>&zt_id=0&lm_moban_id=<%=lm_moban_id%>"
form1.submit();
}}
</script>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -