JSP分页之假分页及MVC实现

 MVC是由模型层，视图层，控制层组成，MVC提高了开发效率，便于维护

分页是Web开发中的一个重要的功能，那怎样实现分页呢？？？

假分页是指查询出所有的数据，只显示需要的数据，它完全由程序实现，开发效率不高，但容易实现

代码如下:

 

一.模型层

UserInfo(JavaBean的实现，传递数据）

package com.feng.test; import java.io.Serializable; public class UserInfo implements Serializable { private int userid; private String username; private String password; public int getUserid() { return userid; } public void setUserid(int userid) { this.userid = userid; } public String getUsername() { return username; } public void setUsername(String username) { this.username = username; } public String getPassword() { return password; } public void setPassword(String password) { this.password = password; } }

 

 

二.数据层

 DataBae(数据库的连接)

package com.feng.test; import java.sql.Connection; import java.sql.DriverManager; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.sql.SQLException; public final class DataBase { private final static String DRIVER = "oracle.jdbc.driver.OracleDriver"; private final static String URL = "jdbc:oracle:thin:@localhost:1521:Oracle9i"; private final static String USER = "scott"; private final static String PWD = "tiger"; private DataBase() { } public static Connection getConnection() { Connection conn = null; try { Class.forName(DRIVER); conn = DriverManager.getConnection(URL, USER, PWD); } catch (Exception e) { e.printStackTrace(); } return conn; } public static void closeConnection(Connection conn) { try { if (conn != null) { if (!conn.isClosed()) { conn.close(); } } } catch (SQLException e) { e.printStackTrace(); } } public static PreparedStatement getPreparedStatement(Connection conn, String sql) { PreparedStatement pstmt = null; try { pstmt = conn.prepareStatement("sql"); } catch (Exception e) { e.printStackTrace(); } return pstmt; } public static void closePreparedStatement(PreparedStatement pstmt) { try { pstmt.close(); } catch (Exception e) { e.printStackTrace(); } } public static ResultSet getResultSet(PreparedStatement pstmt) { ResultSet rs = null; try { rs = pstmt.executeQuery(); } catch (Exception e) { e.printStackTrace(); } return rs; } public static boolean Exec(PreparedStatement pstmt) { boolean flag = false; try { int result = pstmt.executeUpdate(); if (result > 0) { flag = true; } } catch (Exception e) { e.printStackTrace(); } return flag; } public static void closeResult(ResultSet rs) { try { rs.close(); } catch (Exception e) { e.printStackTrace(); } } }

 

 

三.控制层

User_Interface(接口，提供所有需要的方法)

package com.feng.house_interface; import java.util.List; import java.util.Map; import com.feng.database.DataBase; //所有的实现类均继承此接口 public interface House_Interface { // 增加，删除，修改方法 public boolean Exec(Map className, int methodIntName, DataBase database) throws Exception; // 查询方法 public List Query(Map className, DataBase database) throws Exception; }

 

 

 

User_Impl(实现类，实现所有的方法)

package com.feng.test; import java.sql.Connection; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.util.ArrayList; import java.util.List; public class User_Impl implements User_Interface { public int getAllCount() { Connection conn = null; PreparedStatement pstmt = null; String sql = "select count(*) as count from userInfo"; ResultSet rs = null; int count = 0; try { conn = DataBase.getConnection(); pstmt = DataBase.getPreparedStatement(conn, sql); rs = DataBase.getResultSet(pstmt); if (rs.next()) { count = rs.getInt("count"); } } catch (Exception e) { e.printStackTrace(); } finally { DataBase.closeResult(rs); DataBase.closePreparedStatement(pstmt); DataBase.closeConnection(conn); } return count; } public List<UserInfo> queryUser(int currPage, int pageSize) { Connection conn = null; PreparedStatement pstmt = null; ResultSet rs = null; List<UserInfo> list = new ArrayList<UserInfo>(); String sql = "select * from userInfo"; try { conn = DataBase.getConnection(); pstmt = DataBase.getPreparedStatement(conn, sql); rs = DataBase.getResultSet(pstmt); // currPage表示当前是第几页 // pageSize表示每页显示多少条数据 for (int i = 0; i < (currPage - 1) * pageSize; i++) {// 空出前面的数据，读取后面的，需要的数据 rs.next(); } // 读取需要的数据 for (int i = 0; i < pageSize; i++) { if (!rs.next()) {// 如果当前数据为最后一条，则停止循环，否则继续读取数据 break; } UserInfo userInfo = new UserInfo();// 将读取出来的数据放到类中 userInfo.setUserid(rs.getInt("userid")); userInfo.setUsername(rs.getString("username")); userInfo.setPassword(rs.getString("password")); list.add(userInfo);// 将类添加到list集合中 } } catch (Exception e) { e.printStackTrace(); } finally { // 关闭所有的连接，按照先打开后关闭，后打开先关闭原则 DataBase.closeResult(rs); DataBase.closePreparedStatement(pstmt); DataBase.closeConnection(conn); } return list; } }

 

 

 

UserServlet(Servlet,控制层的核心)

package com.feng.test; import java.io.IOException; import java.util.List; import javax.servlet.ServletException; import javax.servlet.http.HttpServlet; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; public class UserServlet extends HttpServlet { public void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { User_Interface user_Method = new User_Impl(); int currPage = 1;//当前第几页 int pageSize = 15;//每页几条数据 try { currPage = Integer.valueOf(request.getParameter("currPage")); int allCount = user_Method.getAllCount();//总共多少条数据 int pageCount = (allCount - 1) / pageSize + 1;//分为几页 if (currPage < 1) { currPage = 1; } if (currPage > pageCount) { currPage = pageCount; } List<UserInfo> list = user_Method.queryUser(currPage, pageSize); request.setAttribute("currPage", currPage); request.setAttribute("allCount", allCount); request.setAttribute("pageCount", pageCount); request.getSession().setAttribute("userInfo", list); request.getRequestDispatcher("index.jsp") .forward(request, response); } catch (Exception e) { e.printStackTrace(); } } public void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { doGet(request, response); } }

 

四.视图层

  index.jsp

  <%@ page language="java" import="java.util.*" pageEncoding="GB18030"%> <%@ taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c"%> <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"> <html> <head> <title>假分页</title> </head> <body> <c:choose> <table border="1"> <tr> <th> 用户编号 </th> <th> 用户名 </th> <th> 密码 </th> </tr> <c:when test="${not empty userInfo}"> <c:forEach items="${userInfo}" var="user"> <tr> <td> ${user.userid } </td> <td> ${user.username } </td> <td> ${user.password } </td> </tr> </c:forEach> </c:when> <c:otherwise> <tr> <td colspan="3"> 对不起，没有如何数据!!! </td> </tr> </c:otherwise> </table> </c:choose> <table> <tr> <td> <a href="UserServlet?currPage=1" mce_href="UserServlet?currPage=1">首页</a> </td> </tr> <tr> <td> <a href="UserServlet?currPage=${currPage-1 }" mce_href="UserServlet?currPage=${currPage-1 }">上一页</a> </td> </tr> <tr> <td> <a href="UserServlet?currPage=${currPage+1 }" mce_href="UserServlet?currPage=${currPage+1 }">下一页</a> </td> </tr> <tr> <td> <a href="UserServlet?currPage=${allCount }" mce_href="UserServlet?currPage=${allCount }">最后一页</a> </td> </tr> </table> </body> </html>

 

 

五.配置文件

   Web.xml

<?xml version="1.0" encoding="UTF-8"?> <web-app version="2.4" xmlns="http://java.sun.com/xml/ns/j2ee" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://java.sun.com/xml/ns/j2ee http://java.sun.com/xml/ns/j2ee/web-app_2_4.xsd"> <servlet> <servlet-name>UserServlet</servlet-name> <servlet-class>com.feng.test.UserServlet</servlet-class> </servlet> <servlet-mapping> <servlet-name>UserServlet</servlet-name> <url-pattern>/UserServlet</url-pattern> </servlet-mapping> <welcome-file-list> <welcome-file>index.jsp</welcome-file> </welcome-file-list> </web-app>