📄 wenzhangx.jsp

📁 为html格式的静态网页形式
💻 JSP
字号:
<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<title>无标题文档!!</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<style type="text/css">
<!--
body,td,th {
	font-size: 12px;
}
a:link {
	text-decoration: none;
}
a:visited {
	text-decoration: none;
}
a:hover {
	text-decoration: none;
}
a:active {
	text-decoration: none;
}
-->
</style></head>

<body>
<jsp:useBean id="ConBean" scope="session" class="com.bitc.ch13.DBCon"/>	
<%
String uid = new String(request.getParameter("id").getBytes("ISO-8859-1"),"GBK");
int EveryPage=12;//每页显示的记录数；
int OnPage=1; //当前显示的页数；
int Total=0;//记录的总数；
int TotalPage=0;//记录的总页
Connection con = ConBean.getConnection();
Statement stmt=con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
ResultSet rs=stmt.executeQuery("SELECT * FROM jsp8_news WHERE lishu = '"+uid+"'");
rs.last();//移到最后一条记录;
Total=rs.getRow();//记录的总数；
if(Total%EveryPage==0)
TotalPage=Total/EveryPage;
else
TotalPage=Total/EveryPage+1;
String Pages=request.getParameter("Pages");
if(Pages!=null)
{
 OnPage=Integer.parseInt(Pages);
if(OnPage>TotalPage)
 {
  OnPage=TotalPage;
 }
 else if(OnPage<=0)
 {
  OnPage=1;
 }
}
rs.absolute((OnPage-1)*EveryPage+1);//指定指针的位置；
%>
<!--开始-->
<%
if(Total == 0){
out.println("<table width=779 height=250 border=0 cellpadding=0 cellspacing=0><tr><td align=center valign=middle>Sorry!!!没有找到相关文章！请添加后在查询！</td></tr></table>");
return;
}
out.println("<table width=779 height=76 border=1 bordercolor=#009999>");
out.println("<tr bgcolor=#F3F3F3><td width=350 height=24>标题</td><td width=50 height=24>置顶</td><td width=50 height=24>精华</td><td width=50 height=24>点击数</td>");
out.println("<td width=150>日期</td><td width=200>操作</td>");
int d = 0;
int jx = 0;
for(int i=0;i<=EveryPage;i++)
{
String id = rs.getString("id");
String ding = rs.getString("ding");
if(ding.equals("0")){
d = 1;
}
String jing = rs.getString("jing");
if(jing.equals("0")){jx = 1;}else{jx=0;}
String url = rs.getString("url");
String biaoti = rs.getString("biaoti");
String liuliang = rs.getString("liuliang");
String riqi = rs.getString("riqi");
out.println("</tr>");
out.println("<tr><td height=25>"+biaoti+"</td><td height=25>"+ding+"</td><td height=25>"+jing+"</td>");
out.println("<td>"+liuliang+"</td><td>"+riqi+"</td>");
out.println("<td><a href=jin.jsp?id="+id+"&uid="+uid+"&s="+jx+">精</a> <a href=ding.jsp?id="+id+"&uid="+uid+"&s="+d+">顶</a> <a href=CreateDelete.jsp?uid="+uid+"&s="+id+"&url="+url+">删</a> <a href=../news-mx.jsp?id="+id+"&uid="+uid+">修</a> <a href=../../html/"+url+" target=top>浏览</a></td>");
out.println("</tr>");
   if(!rs.next())
break;
}
out.println("</table>");
rs.close();
%>					
<TABLE cellSpacing=0 cellPadding=0 width=779 
                                border=0>
  <TBODY>
    <TR>
      <TD width=45 height="25" valign="top"><IMG height=25 
                                src="../image/login_img2.gif" width=45></TD>
      <TD width="707" align="center" vAlign=center 
                                background=../image/login_bg1.gif>共为您找到<font color="#FF0000"><%=Total%></font>个问题,共<font color="#FF0000"><%=TotalPage%></font>页当前在第<font color=red><%=OnPage%></font>页 <%
if(OnPage!=1)
{
%>
<a href=wenzhangx.jsp?Pages=1&id=<%=uid%>>第一页</a>&nbsp;&nbsp;
<a href=wenzhangx.jsp?Pages=<%=OnPage-1%>&id=<%=uid%>>上一页</a>&nbsp;&nbsp;
<%
}
if(OnPage!=TotalPage)
{
%>
<a href=wenzhangx.jsp?Pages=<%=OnPage+1%>&id=<%=uid%>>下一页</a>&nbsp;&nbsp;
<a href=wenzhangx.jsp?Pages=<%=TotalPage%>&id=<%=uid%>>最后一页</a>
<%
}
%></TD>
      <TD width="114" align="center" vAlign=center 
                                background=image/login_bg1.gif><table width="114" border="0" cellspacing="0" cellpadding="0">
        <form action=wenzhangx.jsp method=post><tr>
          <td background="../image/login_bg1.gif">
                    转到
  <input type="hidden"  name=id value=<%=uid%>>
        <input type="text" size=2 name=Pages value=<%=OnPage%>>
        页          </td>
        </tr></form>
      </table></TD>
      <TD width=19 valign="top"><IMG height=25 
                                src="../image/login_bg2.gif" 
                                width=15></TD>
    </TR>
  </TBODY>
</TABLE>

<%
stmt.close();
ConBean.close();
%>
</body>
</html>
⌨️ 快捷键说明

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