📄 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 + -