如何在jsp页面中，显示如下图所示的分页

Question

嗯，好吧，我做的是首页，上一页，下一页，还有末页的，但是现在需要的是这一种，应该如何实现呢：

Answer 1

这个可以js+css 结合使用

<%@ page contentType="text/html" pageEncoding="GB2312" language="java"%>

<%@ page import="java.sql.*"%>

hello







<%!

public static final String DRIVER = "com.mysql.jdbc.Driver";

public static final String USER = "root";

public static final String PASS = "12345";

public static final String URL = "jdbc:mysql://localhost:3306/MLDN";

public static final int PAGESIZE = 5;

int pageCount;

int curPage = 1;

%>

<%

//一页放5个

String user = null;

String pass = null;

try{

Class.forName(DRIVER);

Connection con = DriverManager.getConnection(URL,USER,PASS);

String sql = "SELECT empno,ename,job,hiredate,sal,comm FROM emp";

PreparedStatement stat = con.prepareStatement(sql,ResultSet.TYPE_FORWARD_ONLY,ResultSet.CONCUR_READ_ONLY);

ResultSet rs = stat.executeQuery();

rs.last();

int size = rs.getRow();

pageCount = (size%PAGESIZE==0)?(size/PAGESIZE):(size/PAGESIZE+1);

String tmp = request.getParameter("curPage");

if(tmp==null){

tmp="1";

}

curPage = Integer.parseInt(tmp);

if(curPage>=pageCount) curPage = pageCount;

boolean flag = rs.absolute((curPage-1)*PAGESIZE+1);

out.println(curPage);

int count = 0;

    do{  
        if(count>=PAGESIZE)break;  
        int empno = rs.getInt(1);  
        String ename = rs.getString(2);  
        String job = rs.getString(3);  
        Date hiredate = rs.getDate(4);  
        float sal = rs.getFloat(5);  
        int comm = rs.getInt(6);  
        count++;  
        %>  
    <tr>  
        <td><%=empno%></td>  
        <td><%=ename%></td>  
        <td><%=job%></td>  
        <td><%=hiredate%></td>  
        <td><%=sal%></td>  
        <td><%=comm%></td>  
    </tr>  
        <%  
    }while(rs.next());  
    con.close();  
}  
catch(Exception e){  

}  

%>

首页

" >下一页