黄色网址大全免费-黄色网址你懂得-黄色网址你懂的-黄色网址有那些-免费超爽视频-免费大片黄国产在线观看

專注Java教育14年 全國(guó)咨詢/投訴熱線:400-8080-105
動(dòng)力節(jié)點(diǎn)LOGO圖
始于2009,口口相傳的Java黃埔軍校
首頁(yè) hot資訊 SSM框架分頁(yè)的實(shí)現(xiàn)方法

SSM框架分頁(yè)的實(shí)現(xiàn)方法

更新時(shí)間:2021-06-24 13:38:53 來(lái)源:動(dòng)力節(jié)點(diǎn) 瀏覽1454次

1.首先創(chuàng)建一個(gè)分頁(yè)的工具類

package cn.page.po; 
import java.io.Serializable; 
public class Page implements Serializable {
    private static final long serialVersionUID = -3198048449643774660L;        
    private int pageNow = 1; // 當(dāng)前頁(yè)數(shù)    
    private int pageSize = 4; // 每頁(yè)顯示記錄的條數(shù)    
    private int totalCount; // 總的記錄條數(shù)    
    private int totalPageCount; // 總的頁(yè)數(shù)    
    @SuppressWarnings("unused") 
    private int startPos; // 開(kāi)始位置,從0開(kāi)始         
    /**
     * 通過(guò)構(gòu)造函數(shù) 傳入  總記錄數(shù)  和  當(dāng)前頁(yè)
     * @param totalCount
     * @param pageNow
     */ 
    public Page(int totalCount, int pageNow) { 
        this.totalCount = totalCount; 
        this.pageNow = pageNow; 
    }        
    /**
     * 取得總頁(yè)數(shù),總頁(yè)數(shù)=總記錄數(shù)/每頁(yè)顯示記錄的條數(shù)  
     * @return
     */ 
    public int getTotalPageCount() { 
        totalPageCount = getTotalCount() / getPageSize(); 
        return (totalCount % pageSize == 0) ? totalPageCount  //總頁(yè)數(shù)
                : totalPageCount + 1; 
    }    
    public void setTotalPageCount(int totalPageCount) { 
        this.totalPageCount = totalPageCount; 
    }    
    public int getPageNow() { 
        return pageNow; 
    }    
    public void setPageNow(int pageNow) { 
        this.pageNow = pageNow; 
    }    
    public int getPageSize() { 
        return pageSize; 
    }    
    public void setPageSize(int pageSize) { 
        this.pageSize = pageSize; 
    }    
    public int getTotalCount() { 
        return totalCount; 
    }    
    public void setTotalCount(int totalCount) { 
        this.totalCount = totalCount; 
    } 
    /**
     * 取得選擇記錄的初始位置
     * @return
     */ 
    public int getStartPos() { 
        return (pageNow - 1) * pageSize; 
    }    
    public void setStartPos(int startPos) { 
        this.startPos = startPos; 
    }    
}

2.寫mapper.xml文件

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapper
PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
"http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="cn.page.mapper.UserMapper">
<resultMap type="cn.page.po.User" id="userMap">
        <id property="id" column="id" />
        <result property="emplnumb" column="emplnumb" />
        <result property="username" column="username" />
        <result property="password" column="password" />
        <result property="address" column="address" />     
</resultMap>
    <!-- 分頁(yè)SQL語(yǔ)句 --> 
    <select id="selectUserByPage" resultMap="userMap"> 
        select * 
        from user limit #{startPos},#{pageSize}  
    </select> 
<!-- 取得記錄的總數(shù) --> 
<select id="getUserCount" resultType="long">
        SELECT COUNT(*) FROM user  
</select>
</mapper>

3.mapper接口

/**
 * 使用注解方式傳入多個(gè)參數(shù)
 * @param page
 * @return startPos},#{pageSize}
 */
public List<User> selectUserByPage(@Param(value="startPos") Integer startPos,
        @Param(value="pageSize") Integer pageSize); 
/**
 * 用戶總數(shù)
 */
public long getUserCount();

4.service接口與實(shí)現(xiàn)類

void showUserByPage(HttpServletRequest request,Model model); 
@Autowired
private UserMapper userMapper;
    @Override
    public void showUserByPage(HttpServletRequest request, Model model) {
        // TODO Auto-generated method stub
        String pageNow = request.getParameter("pageNow");            
        Page page = null;        
        List<User> user = new ArrayList<User>(); 
      //查詢用戶總數(shù)
        int totalCount = (int) userMapper.getUserCount();       
        if (pageNow != null) { 
            page = new Page(totalCount, Integer.parseInt(pageNow)); 
            user = this.userMapper.selectUserByPage(page.getStartPos(), page.getPageSize()); 
        } else { 
            page = new Page(totalCount, 1); 
            user = this.userMapper.selectUserByPage(page.getStartPos(), page.getPageSize()); 
        }        
        model.addAttribute("user", user); 
        model.addAttribute("page", page); 
    }

5.controller方法

@Controller
public class UserController {
    @Autowired
    private UserService userService;
    @RequestMapping("/pagingUser.action")
    public String pagingUser(HttpServletRequest request,Model model){
        userService.showUserByPage(request, model);
        return "pagingUser";         
    }
}

6.頁(yè)面顯示

<c:forEach items="${user }" var="user">
        <tr>
            <td>${user.emplnumb }</td>
            <td>${user.username }</td>
            <td>${user.address }</td>
            <td>${user.telephone }</td>
        </tr>
    </c:forEach>
</table> 
 <div align="center"> 
        <font size="2">共 ${page.totalPageCount} 頁(yè)</font> <font size="2">第 
            ${page.pageNow} 頁(yè)</font> <a href="${pageContext.request.contextPath}/pagingUser.action?pageNow=1">首頁(yè)</a> 
        <c:choose> 
            <c:when test="${page.pageNow - 1 > 0}"> 
                <a href="${pageContext.request.contextPath}/pagingUser.action?pageNow=${page.pageNow - 1}">上一頁(yè)</a> 
            </c:when> 
            <c:when test="${page.pageNow - 1 <= 0}"> 
                <a href="${pageContext.request.contextPath}/pagingUser.action?pageNow=1">上一頁(yè)</a> 
            </c:when> 
        </c:choose> 
        <c:choose> 
            <c:when test="${page.totalPageCount==0}"> 
                <a href="${pageContext.request.contextPath}/pagingUser.action?pageNow=${page.pageNow}">下一頁(yè)</a> 
            </c:when> 
            <c:when test="${page.pageNow + 1 < page.totalPageCount}"> 
                <a href="${pageContext.request.contextPath}/pagingUser.action?pageNow=${page.pageNow + 1}">下一頁(yè)</a> 
            </c:when> 
            <c:when test="${page.pageNow + 1 >= page.totalPageCount}"> 
                <a href="${pageContext.request.contextPath}/pagingUser.action?pageNow=${page.totalPageCount}">下一頁(yè)</a> 
            </c:when> 
        </c:choose> 
        <c:choose> 
            <c:when test="${page.totalPageCount==0}"> 
                <a href="${pageContext.request.contextPath}/pagingUser.action?pageNow=${page.pageNow}">尾頁(yè)</a> 
            </c:when> 
            <c:otherwise> 
                <a href="${pageContext.request.contextPath}/pagingUser.action?pageNow=${page.totalPageCount}">尾頁(yè)</a> 
            </c:otherwise> 
        </c:choose> 
    </div> 

以上就是動(dòng)力節(jié)點(diǎn)小編介紹的"SSM框架分頁(yè)的實(shí)現(xiàn)方法",希望對(duì)大家有幫助,想了解更多可觀看SSM實(shí)戰(zhàn)視頻教程學(xué)習(xí),如有疑問(wèn),請(qǐng)?jiān)诰€咨詢,有專業(yè)老師隨時(shí)為您服務(wù)。

提交申請(qǐng)后,顧問(wèn)老師會(huì)電話與您溝通安排學(xué)習(xí)

  • 全國(guó)校區(qū) 2025-05-15 搶座中
  • 全國(guó)校區(qū) 2025-06-05 搶座中
  • 全國(guó)校區(qū) 2025-06-26 搶座中
免費(fèi)課程推薦 >>
技術(shù)文檔推薦 >>
主站蜘蛛池模板: 日韩视频高清 | 亚洲黄色网址大全 | 亚洲成年看片在线观看男男 | 国产成人精品免费视频网页大全 | 欧美一二三区视频 | 一本中文字幕一区 | 免费观看一级成人毛片软件 | 黄色大片视频在线观看 | 日本三级香港三级少妇 | 国产成人午夜精品5599 | 国产欧美在线观看 | 中国成熟xxx视频 | 国产精品成人观看视频网站 | 中国一级一级全黄 | 免看一级a毛片一片成人不卡 | 一级福利视频 | 天天摸天天澡天天碰天天弄 | 最新99国产成人精品视频免费 | 色片免费 | 夜夜添夜夜添夜夜摸夜夜摸 | 性美国xxxxx| 成人精品视频 | 久久99精品久久久久久欧洲站 | 嘿嘿嘿视频在线观看网站 | 午夜日韩久久影院 | 亚洲欧美人成人综合在线50p | 免费99精品国产自在现线观看 | 久久国产亚洲欧美日韩精品 | h成人在线 | 香蕉视频啊啊啊 | 亚洲欧美日本国产综合在线 | 91香蕉视频苹果 | 色妇网| 欧美激情综合 | 日本天堂在线播放 | 日韩视频一区二区三区 | 日老逼视频 | 中国一级毛片aaa片 中国一级毛片 | 国产精品视频全国免费观看 | 欧美激情视频一区二区 | 日本高清不卡一区 |