list_all_user_1.jsp

来自「jsp的技术教程」· JSP 代码 · 共 201 行

<%@ include file="header.inc"%> 
<jsp:useBean id='clock' scope='page' class='dates.JspCalendar' type="dates.JspCalendar" />      
<%@ page language="java" import="java.sql.*" %>
<%
String sDBDriver = "sun.jdbc.odbc.JdbcOdbcDriver";
String sConnStr = "jdbc:odbc:faq";
Connection conn = null;
ResultSet rs = null;
Statement stmt = null;

try 
{
	Class.forName(sDBDriver); 
}
catch(Exception e) 
{
	out.println(e.getMessage());
}

try 
{
	conn = DriverManager.getConnection(sConnStr); 
	stmt = conn.createStatement();
			
} 
catch(Exception ex) 
{ 
	out.println(ex.getMessage());
}
%>
<%!
public String getStr(String str)
{
	try
	{
		String temp_p=str;
		byte[] temp_t=temp_p.getBytes("GBK");
		String temp=new String(temp_t,"ISO8859_1");
		return temp;
	}
	catch(Exception e)
	{
	 
	}
	return "null";
}
%>        


<TABLE border=0 cellPadding=0 cellSpacing=0 width=760 align="center">
  <TBODY>
  <tr><td align="left" height=25><%if(session.getAttribute("username")!=null){out.println(session.getAttribute("username"));}%>  当前位置：<a href="../index.jsp">首页</a> -&gt; 成员服务  </td>
  <td align="right"> <%//@ include file="date.inc"%> </td>
  </tr>
  <TR bgColor=#3399ff>
    <TD height=1 colspan="2"><IMG height=1 src="images/spacer.gif" 
  width=16></TD></TR>
  <tr><td height=10 colspan="2"><IMG height=1 src="images/spacer.gif" 
  width=16></td></tr>
  </TBODY></TABLE>

  <table align="center" border="0" width="760" cellspacing="0" cellpadding="0" height="355">                  
	<tr>                  
		<td width="150" height="355" valign="top">                  
			<%//include file="table.inc"%>               
		</td>                  
		<td width="10" height="100%"></td>
		<td width="1" height="100%" bgcolor="#3399ff"></td>
		<td width="10" height="100%"></td>
		<td width="589" height="331" valign="top" background="images/bg1.gif">                       
        <table border="0" width="100%" cellspacing="0" cellpadding="0" height="307">                  
          <tr>                  
            <td width="100%" colspan="2" height="20" bgcolor="#3399ff">&nbsp;<font color="#ffffff">成员列表</font>       
			</td>
		  </tr>

	<tr><td align="right" height="32" width="40%">
	<font color=red></font>	
	</td>
	</tr>
	  <%
	  ///////////////算出共多少页
		int t;
		int mtotal;
		int size;
		t=0;
		//每页显示三个用户(可修改) 
		size=3;
		String strSQLsize="SELECT id FROM member";
		ResultSet RSsize = stmt.executeQuery(strSQLsize);
		while(RSsize.next()){
			t=t+1;
		}
		//out.println(t/3);
		//out.println(t%3>0);
		//如果纪录总数除以每页的显示个数,余数大于0,那么
		//逻辑页数应该为商+1
		if((t%3)>0){
			mtotal=t/3+1;
		}else mtotal=t/3;
	//	out.println(mtotal);
		%>
			
	<%!String pageNo, mTmp;
		int i, j, k;
	%>
	<%
		pageNo = request.getParameter("pageNo");
		//out.println(pageNo);=========null
		if(pageNo == null){
		    pageNo = "1";
		}
			j = Integer.parseInt(pageNo);
//		out.println(pageNo);=========1
//		out.println(j);==========1
		if(j < 1)
		    j = 1;
		if(j > mtotal)
		    j = mtotal;
//out.println(j);
	%>	
	<%
		


		String strSQL="SELECT * FROM member order by id desc";
		ResultSet RSa = stmt.executeQuery(strSQL);
		
		for(k = 0;k < (j-1)*3;k++)
		{	//out.println(RSa.next());

			RSa.next();
		}

		i = 0;
		k = 1;
		while (RSa.next()) {
			//out.println("ok"+i+"ok");
			i = i + 1;
		    //超过3条
		    if(i == 4)
		    {
		        k = 0;
		        break;
		    }     

				out.print("<tr height='23'><td><li><a href=article.jsp?id="+RSa.getInt("id"));
				out.print(">"+getStr(RSa.getString("logname"))+"</a></td><td>"+getStr(RSa.getString("realname"))+"</td><td>"+RSa.getString("email")+"</td><td align='center'>"+RSa.getInt("gender")+"</td></tr>");
			
			}
			i = i - k;
		//out.println("i de zhi::"+i);
		RSa.close();

	%>
<%////////////////////////////////////////////////
	if(j > 1)
{
%>
    <a href="list_all_user.jsp?pageNo=1">第一页</a>
<%
    int ii = Integer.parseInt(pageNo,10);
//	out.println(ii);
    if(ii > 1)
        ii = ii -1;
    String ssTmp = Integer.toString(ii);
%>
    <a href="list_all_user.jsp?pageNo=<%=ssTmp%>">上一页</a>
<%
}
if(j < mtotal)
{
    int ii = Integer.parseInt(pageNo,10);
    if(ii < mtotal)
        ii = ii + 1;
    String ssTmp = Integer.toString(ii);
%>
    <a href="list_all_user.jsp?pageNo=<%=ssTmp%>">下一页</a>
    <a href="list_all_user.jsp?pageNo=<%=mtotal%>">最后页</a>
<%
}
if(mtotal < j)
    j = mtotal;        
%>
结果共<%=mtotal%>页,显示第<%=j%>页
<%////////////////////////////////////////////%>
						<tr> 
			  <td colspan="2" align="right">&nbsp;</td>

			</tr>
	   
        </table>                  


        </td>
    </tr>
  </table>
<%@ include file="footer.inc"%>