?? meet_list.jsp
字號:
<%@ page language="java" import="java.util.*,java.sql.*" pageEncoding="GB18030"%>
<jsp:useBean id="meet" scope="page" class="com.meet.bean.meeting" />
<HTML>
<HEAD>
<TITLE>會議管理系統---$--J2EE</TITLE>
<LINK href="images/site.css" rel=stylesheet>
</HEAD>
<script language="javascript" src="images/all.js"></script>
<BODY leftMargin="0" topMargin="0" background="../file/bg.jpg">
<%@ include file="top.jsp"%>
<%
//所需參數定義與說明
int perPage = 5; //每頁多少行
int totalRaw = 0; //合計總記錄數
int totalPage = 0; //合計總頁數
int cPage = 0; //當前頁整形數
int poolTmp = 0; //循環記錄用臨時變量
String cPageStr ; //當前頁字符串值
String str="select a.meet_ID,a.meet_title,a.meet_state,b.meettime,b.address,b.leader from base a,taile b where a.meet_ID=b.meet_ID";
ResultSet rs=meet.executeFind(str);
rs.last();
totalRaw = rs.getRow(); //計算總記錄數
totalPage = totalRaw%perPage==0?totalRaw/perPage:totalRaw/perPage+1; //計算總頁數
cPageStr=request.getParameter("page");//獲取當前頁字符串值,當前頁是超連接傳參數
if(cPageStr==null || "".equals(cPageStr)){
cPageStr="1";
}
cPage = Integer.parseInt(cPageStr); //獲取當前頁整形數,用于去計算
cPage = cPage<1?1:cPage; //當前頁<1時，按1計數
cPage = cPage>totalPage?totalPage:cPage; //當前頁大于總頁數時，按總頁數計數
if(cPage==1) rs.absolute((cPage-1)*perPage+1);
else rs.absolute((cPage-1)*perPage); //跳到結果集的指定行
%>
<TABLE border="0" cellPadding=1 cellSpacing=1 width=760 align="center">
<TBODY>
<tr>
<td align="left" width="25%">當前位置：-->會議列表</td>
<td align="left" width="50%"> <marquee direction="left" scrollamount="2" scrolldelay="90" width="400"> <script language="javascript" src="images/hello.js"></script></marquee></td>
<td align="left" width=25%> </td>
</tr>
<TR bgColor=#3399ff>
<TD height=1 colspan="6"></TD>
</TR>
<tr>
<td height=10 colspan="6"></td>
</tr>
</TBODY>
</TABLE>
<div align="center">
<center>
<p><font size="5"><b>會議列表</b></font></p>
<table border="2" width="800" bordercolorlight="#3399FF" bordercolordark="#FFFFFF">
<tr>
<td width="7%" align="center">ID號</td>
<td width="30%" align="center">會議主題</td>
<td width="10%" align="center">會議狀態</td>
<td width="23%" align="center">會議時間</td>
<td width="10%" align="center">會議地點</td>
<td width="10%" align="center">領導者</td>
<td width="10%" align="center">詳情</td>
</tr>
<%
while(rs!=null && rs.next()){
int id=rs.getInt("meet_ID");
if(poolTmp==perPage){//循環臨時變量poolTmp累加到等于每頁行數時，退出循環
poolTmp=0;
break;
}
%>
<tr>
<td ><%=id%></td>
<td ><%=rs.getString("meet_title")%></td>
<td ><%=rs.getString("meet_state")%></td>
<td ><%=rs.getDate("meettime")%></td>
<td ><%=rs.getString("address")%></td>
<td><%=rs.getString("leader") %></td>
<td><a href="detaile.jsp?id=<%=id%>">詳情</a></td>
</tr>
<%
poolTmp++;//循環臨時變量加1
}
%>
</table>
<form method="get" action="">
<table align="center" border="0" width="96%" cellspacing="0" cellpadding="0" >
<tr align="center">
<td width="25%">
共<%=totalPage%>頁 當前頁是：<%=cPage%>頁
</td>
<td width="35%">
<%if(cPage>1){//非主頁%>
<a href="meet_list.jsp?page=1">第一頁</a>
<a href="meet_list.jsp?page=<%=cPage-1%>">上一頁</a>
<%}if(cPage<totalPage){%>
<a href="meet_list.jsp?page=<%=cPage+1%>">下一頁</a>
<a href="meet_list.jsp?page=<%=totalPage%>">最后一頁</a>
<%}%>
</td>
<td width="20%">
到 <%for(poolTmp=1;poolTmp<=totalPage;poolTmp++){%>
<a href="meet_list.jsp?page=<%=poolTmp%>"><%=poolTmp%></a>
<%}%>頁
</td>
<td width="20%">
Go <select name="page" size="1" onchange="submit();">
<%for(poolTmp=1;poolTmp<=totalPage;poolTmp++){%>
<option <%=(cPage==poolTmp?"selected":"")%>><%=poolTmp%></option>
<%}%>
</select>
</td>
</tr>
</table>
</form>
</center>
</div>
<%@ include file="foot.jsp"%>
</body>
</html>
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -