<%@ page contentType="text/html;charset=gb2312" import="java.sql.*"%>
<%@ include file="check.jsp"%>
<jsp:useBean id="conn" class="dbBean.DBBean" scope="session"/>
<%!
//每頁(yè)顯示的記錄個(gè)數(shù)
int size = 8;
//當(dāng)前頁(yè)號(hào)
int p = 1;
//全部的頁(yè)數(shù)
int totalPage = 1;
String str = "";
//顯示頁(yè)號(hào)為p的一頁(yè)
public String printPage(ResultSet rs, int p, int size,int logId) 
{
	  str = "";
	  //將訪問(wèn)游標(biāo)定位到頁(yè)號(hào)為p的頁(yè)要顯示的第一條記錄的位置
	  try {
	  	for(int k=0;k<(p-1)*size;k++)	
			rs.next();
	  }
	  catch(SQLException e) {   }
	  for(int iPage=1; iPage<=size; iPage++) {
	     str += printRow(rs,iPage,p,logId);
	     try {
		 if(!rs.next()) break;
	     }
	     catch(Exception e) {   }
	  }
	  return str;
}	
//顯示單行記錄
public String printRow( ResultSet rs ,int i,int p,int logId) 
{
	String temp = "";
	try {
		if(i%2==1)
			temp+="<tr bgcolor='#e7e7e7'>";
		else
			temp+="<tr bgcolor='#f7f7f7'>";   
		String id=rs.getString("id");

		if(logId<10001)
			temp+="<td><a href='update.jsp?updateid="+id+"&p="+p+"' target='left'>"+id+"</a></td>";
		else
			temp+="<td>"+id+"</td>";
		temp+="<td>"+rs.getString("name")+"</td>";
		temp+="<td>"+rs.getString("sex")+"</td>";
		temp+="<td>"+rs.getString("age")+"</td>";
		temp+="<td>"+rs.getString("phone")+"</td>";
		temp+="<td>"+rs.getString("email")+"</td>";
		temp+="<td>"+rs.getString("address")+"</td>";
	        temp += "</tr>";
	}
	catch(SQLException e) {   }
		return temp;
}
%>

<%
	request.setCharacterEncoding("gb2312");
	String type="";
	String key="";
	if(request.getParameter("stype")!=null)
	{
		type=request.getParameter("stype");
		session.setAttribute("stype",type);
	}
	if(request.getParameter("skey")!=null)
	{
		key=request.getParameter("skey");
		session.setAttribute("skey",key);
	}
	ResultSet rs=null;
	String sql="select * from user";
	if(session.getAttribute("stype")!=null)
		type=(String)session.getAttribute("stype");
	if(session.getAttribute("skey")!=null)
		key=(String)session.getAttribute("skey");
	if(type!=null && key!=null && !type.equals("") && !key.equals(""))
	{
		if(type.equals("id")||type.equals("age"))
			sql += " where "+type+"="+key;
		else
			sql += " where "+type+"='"+key+"'";
	}
	sql+=" order by id asc";	
	rs=conn.executeQuery(sql);
%>
<center>
<table border="1" borderColorDark="#ffffec" borderColorLight="#5e5e00" width="100%">
<tr bgcolor="#cccccc" align="center">
<th>id號(hào)</th><th>用戶名</th><th>性別</th><th>年齡</th><th>聯(lián)系電話</th><th>電子郵件</th><th>地址</th>
<%
	ResultSet rsTmp=null;
	String sql2="select count(*) from user";
	if(type!=null && key!=null && !type.equals("") && !key.equals(""))
	{
		if(type.equals("id")||type.equals("age"))
			sql2 += " where "+type+"="+key;
		else
			sql2 += " where "+type+"='"+key+"'";
	}
	rsTmp = conn.executeQuery(sql2);
	int totalrecord=0;
	if(rsTmp.next())
		totalrecord = rsTmp.getInt(1);
	// 如果是當(dāng)前頁(yè)碼的整數(shù)倍	
	if(totalrecord % size ==0) totalPage = totalrecord / size;  
	// 如果最后還空余一頁(yè)
	else  totalPage = (int) Math.floor( totalrecord / size ) + 1;   
	if(totalPage == 0) totalPage = 1;
	rsTmp.close();
	try {
		if(request.getParameter("p")==null|| request.getParameter("p").equals("")) 
		{
		   if(session.getAttribute("rightp")==null)
			p = 1;
		   else
			p = ((Integer)session.getAttribute("rightp")).intValue();
		}
		else
		{
		   p = Integer.parseInt(request.getParameter("p"));			   session.setAttribute("rightp",new Integer(p));
		}
	} 
	// 捕獲用戶從瀏覽器地址攔直接輸入非數(shù)字信息而引起的異常
	catch(NumberFormatException e) {  
		   p = 1;
	}
	if(p < 1)  p = 1;
	if(p > totalPage) p = totalPage;
	if(rs.next())
	{
		int logId=Integer.parseInt((String)session.getAttribute("loginId"));
		out.println(printPage(rs,p,size,logId));
	}
%>
</table>
<form Action="right.jsp" Method="GET">
<%
  for(int i=1;i<=totalPage;i++) {
      out.println("<a href=right.jsp?p=" + i +">" + i + "</a>&nbsp;&nbsp;");
  }
%>
  <p>輸入頁(yè)數(shù)：<input type="text" name="p" size="3"> 
     頁(yè)數(shù)：<font color="red"><%=p%>/<%=totalPage%></font> 
  </p>
</form>
</center>
<%
	rs.close();
	conn.close();
%>