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

📄 allmess.jsp

📁 网上购物系统
💻 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>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>无标题文档</title>
<style type="text/css">
<!--
a:link {
	text-decoration: none;
}
a:visited {
	text-decoration: none;
}
a:hover {
	text-decoration: none;
}
a:active {
	text-decoration: none;
}
body,td,th {
	font-size: 12px;
}
-->
</style></head>

<body> <table width="559" height="169" border="0" cellpadding="0" cellspacing="0">
                  <tr>
                    <td align="left" valign="top"><table width="200" height="21" border="0" cellpadding="0" cellspacing="0">
                      <tr>
                        <td bgcolor="#CCFF66">您共有【<span class="style2">1</span>】条新信息</td>
                      </tr>
                    </table>
                      <table width="557" height="63" border="0" cellpadding="0" cellspacing="0">
                        <tr bgcolor="#33CCCC">
                          <td width="193" height="20" align="center">标题</td>
                          <td width="54" align="center">状态</td>
                          <td width="53" align="center">发信人</td>
                          <td width="213" align="center">时间</td>
                          <td width="44" align="center">操作</td>
                        </tr>
<jsp:useBean id="ConBean" scope="session" class="com.bitc.ch13.DBCon"/>
<%
request.setCharacterEncoding("gb2312");
String sid = request.getParameter("id");
int EveryPage=10;//每页显示的记录数；
int OnPage=1; //当前显示的页数；
int Total=0;//记录的总数；
int TotalPage=0;//记录的总页数；
String id = "";
Connection con = ConBean.getConnection();
Statement stmt = con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
ResultSet rs = stmt.executeQuery("SELECT id,biaoti,guanliyuanzhuangtai,faxinren,convert(varchar(19),riqi,120)as thistime FROM jsp8_mess WHERE guanliyuanzhuangtai = '"+sid+"' order by id");
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){
}else{
for(int i=0;i<=EveryPage;i++){
id =rs.getString("id");
%>
<tr> <td height="43" align="left"><a href="viewmess.jsp?id=<%=id%>"><%=rs.getString("biaoti")%></a></td>
<td width="54" align="center"><%=rs.getString("guanliyuanzhuangtai")%></td>
<td width="53" align="center"><%=rs.getString("faxinren")%></td>
<td width="213" align="center"><%=rs.getString("thistime")%></td>
<td width="44" align="center"><a href="delmess.jsp?id=<%=id%>&h=<%=sid%>">删除</a></td>
</tr>
<%
if(!rs.next())
break;
}
out.println("<tr><td height=18 colspan=5 align=left>");
int tt =TotalPage+1; 
for(int iq=1;iq<tt;iq++){
out.println("<a href=allmess.jsp?id="+id+"&Pages="+iq+">"+iq+"</a>&nbsp;&nbsp;");
}
out.println("</td></tr>");
}
rs.close();
stmt.close();
ConBean.close();
%>
                      </table></td>
                  </tr>
                </table>
				
</body>
</html>

⌨️ 快捷键说明

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