📄 getcard.jsp

📁 在线教育平台：从小学
💻 JSP
字号:
<%@ page language="java" contentType="text/html; charset=gb2312"
	pageEncoding="GB2312"%>
<%@page import="java.sql.*"%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<jsp:useBean id="card" scope="page" class="edu.CardBean" />
<title>卡号管理</title>
<link rel="stylesheet" href="style.css" type="text/css">
<style type="text/css">
<!--
.STYLE2 {
	color: #FFFFFF;
	font-size: 14px;
	font-weight: bold;
}
.STYLE3 {color: #FF0000}
-->
</style>
<script language=JavaScript>

function openWindow(url){
	window.open(url,'', 'height=200, width=350, top=200, left=400, toolbar=no, menubar=no, scrollbars=no, resizable=no,location=no, status=no');
}   
</script>
</head>
<body>
<%
int id;
String number="",psw="";
int day=0;
int use=0;
int unuse=0;
int usednumber=0;
unuse=card.cardCount_unuse();
usednumber=card.cardCount()-unuse;
int allrow=0,pagesize=20, intpage=1;
String sort="";
try{
	sort=session.getAttribute("sort").toString();
}catch(NullPointerException e){}
if(!sort.equals("admin"))
	response.sendRedirect("error_ad.jsp");
try{
	intpage=Integer.valueOf(request.getParameter("intpage")).intValue();
	}catch(NumberFormatException e){}
	allrow=card.cardCount();
	int allpage = (allrow+pagesize-1) / pagesize; 
//	调整待显示的页码 
	if(intpage>allpage) intpage = allpage;
	if(intpage<1) intpage = 1;
	int startrow=(intpage-1)*pagesize;

	card.setStartpage(startrow);
	card.setPagesize(pagesize);
%>

<table width="750" height="30" border="0" align="center" cellpadding="0"
	cellspacing="0">
	<tr>
		<td width="250">&nbsp;</td>
		<td width="250">
		<div align="center"><font size="+2" face="华文行楷">卡号管理</font></div>
		</td>
		<td>
		<div align="right"><a href="javascript:openWindow('addcard.jsp')"><strong>添加新卡</strong></a></div>
		</td>
	</tr>
</table>
<table width="750" border="0" align="center" cellspacing="1"
	bgcolor="#EBEBEB">
	<tr bgcolor="#FF9966">
	  <td width="289" height="25">		<div align="center" class="STYLE2">卡号</div></td>
		<td width="288" height="25" bgcolor="#FF9966">		<div align="center" class="STYLE2">密码</div></td>
		<td width="80" bgcolor="#FF9966"><div align="center" class="STYLE2">面值</div></td>
		<td width="80" height="25">		<div align="center" class="STYLE2">是否已使用</div></td>
	</tr>
	<%
 ResultSet rs = card.getCard();
  while(rs.next())
  {
	id=rs.getInt("c_id");
  	number=rs.getString("c_no");
	psw=rs.getString("c_psw");
	day=rs.getInt("c_day");
	use=rs.getInt("c_allow");
	String used="";
	if(use==0)used="未使用";
	if(use==1)used="已使用";
  %>
	<tr>
		<td bgcolor="#FFFFFF"><div align="center"><%=number %></div></td>
		<td bgcolor="#FFFFFF"><div align="center"><%=psw %></div></td>
		<td bgcolor="#FFFFFF"><div align="center"><%=day %></div></td>
		<td bgcolor="#FFFFFF"><div align="center"><%=used %></div></td>
	</tr>
	<%
  }rs.close();
  %>
</table>
<div align="center">
<table width="750" border="0">
	<tr>
	<td width="15%" nowrap>	  <div align="center">共<span class="STYLE3"><%=allrow %></span>张卡 <br>
	      已使用<span class="STYLE3"><%=usednumber %></span>张&nbsp;&nbsp; <br>
	    还剩<span class="STYLE3"><%=unuse %></span>张未使用</div></td>
		<td width="18%"><div align="right">当前第<span class="STYLE3"><%=intpage %></span>页/共<span class="STYLE3"><%=allpage %></span>页</div></td>
		<td width="67%"><div align="center"><a href="getcard.jsp">首页</a>&nbsp;&nbsp;
	      <%
	      int tenpage=((int)(intpage/10))*10;
	      if(intpage-10>0) {%>
		      <a href="getcard.jsp?intpage=<%=intpage-10%>">上十页</a>&nbsp;&nbsp;
	      <%} %>
		      <a href="getcard.jsp?intpage=<%=intpage-1%>">上一页</a>&nbsp;&nbsp;
          <%if(tenpage+10<=allpage){
		  for(int i=1;i<=10;i++){%>
		  <a href="getcard.jsp?intpage=<%=tenpage+i %>"><%=tenpage+i %></a>
	      <%}}if(tenpage+10>allpage){
			  for(int i=1;i+tenpage<=allpage;i++){%>
		  <a href="getcard.jsp?intpage=<%=tenpage+i %>"><%=tenpage+i %></a>&nbsp;&nbsp;
		  <%}} %>
		        <a href="getcard.jsp?intpage=<%=intpage+1%>">下一页</a>&nbsp;&nbsp;
          <%if(intpage+10<=allpage) {%>
		        <a href="getcard.jsp?intpage=<%=intpage+10%>">下十页</a>&nbsp;&nbsp;
          <%} %>
	          <a href="getcard.jsp?intpage=<%=allpage%>">尾页</a></div></td>
	</tr>
</table>
</div>

</body>
</html>
⌨️ 快捷键说明

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