mysql在JSP页面中分页查看的解决(4)

                ps.setInt(2, pageSize); 

                rs = ps.executeQuery(); 

                while (rs.next()) { 

                    String fname = rs.getString(1); 

                    String lname = rs.getString(2); 

            %> 

            <tr> 

                <td><%=fname%></td> 

                <td><%=lname%></td> 

            </tr> 

            <% 

                } 

            %> 

        </table> 

        <% 

            //关闭连接 

            if (ps != null) { 

                ps.close(); 

            } 

            if (rs != null) { 

                rs.close(); 

            } 

            if (conn != null) { 

                conn.close(); 

            } 

        %> 

        当前第<%=view.getCurrentPage()%>页，一共<%=view.getPageCount()%>页<br/> 

        <a href="index.jsp?page=1">首页</a> 

        <%