2020-08-05

配置插件

<!--    创建sqlSessionFactory对象-->
    <bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
        <!--      dataSource属性是一个对象，用ref-->
        <property name="dataSource" ref="myDataSource"/>
        <!--      mybatis主配置文件路径-->
        <property name="configLocation" value="classpath:spring-mybatis.xml"/>
        <!-- 指定Mapper.xml配置文件位置 -->
        <property name="mapperLocations" value="classpath:mybatis/mapper/*.xml"/>
        <!-- 配置插件-->
        <property name="plugins">
            <array>
<!--                配置PageHelp插件-->
                <bean class="com.github.pagehelper.PageInterceptor">
                    <property name="properties">
                        <props>
<!--                            配置数据库方言，告诉PageHelp当前使用的数据库-->
                            <prop key="helperDialect">mysql</prop>
<!--                            配置页码的合理化修正，在1~总页数之间修正页码-->
                            <prop key="reasonable">true</prop>
                        </props>
                    </property>
                </bean>
            </array>
        </property>
    </bean>

**Service层

  @Override
    public PageInfo<TAdmin> getPageInfo(String keyword, Integer pageNum, Integer pageSize) {

        //1.调用PageHelper的静态方法开启分页功能
        PageHelper.startPage(pageNum,pageSize);

        //2.执行查询
        List<TAdmin> list = tAdminMapper.selectAdminByKeyword(keyword);

        //3.封装到PageInfo对象中
        return new PageInfo<>(list);
    }

Controller层

 @RequestMapping("/admin/get/page.html")
    public String getPageInfo(
            @RequestParam(value = "keyword" ,defaultValue = "") String keyword,
            @RequestParam(value = "pageNum" ,defaultValue = "1") Integer pageNum,
            @RequestParam(value = "pageSize",defaultValue = "5") Integer pageSize,
            Model model
            ){
        PageInfo<TAdmin> pageInfo = adminService.getPageInfo(keyword, pageNum, pageSize);
        model.addAttribute("pageInfo",pageInfo);
        return "admin-page";
    }