springboot从零开始[3] 内容扩充

前面两篇已经构建最基本的一个框架，但是一个项目能够真正成立，还需要更多的内容进行扩充。所以我打算在之后的学习中，陆续把用到的技术记录下来。

PageHelp

PageHelp没有人不熟悉吧，实际的开发中用到的频率也很多。
在前面的基础上，只需要添加依赖和配置，就可以像之前一样便捷的使用了。

1. 配置文件MyBatisConfiguration.java

package top.aircastle.springboot.springboot_xml.commom.configuration;

import com.github.pagehelper.PageHelper;
import org.springframework.boot.context.properties.ConfigurationProperties;
import org.springframework.context.annotation.Bean;
import org.springframework.context.annotation.Configuration;
import org.springframework.jdbc.datasource.DriverManagerDataSource;

import java.util.Properties;

/**
 * Created by Castle on 2017/7/31.
 */
@Configuration
@ConfigurationProperties(prefix = "spring.datasource")
public class MyBatisConfiguration {
    private String url;
    private String driverClassName;
    private String username;
    private String password;

    public String getUrl() {
        return url;
    }

    public void setUrl(String url) {
        this.url = url;
    }

    public String getDriverClassName() {
        return driverClassName;
    }

    public void setDriverClassName(String driverClassName) {
        this.driverClassName = driverClassName;
    }

    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;
    }

    @Bean
    public PageHelper pageHelper() {
        System.out.println("MyBatisConfiguration.pageHelper()");
        PageHelper pageHelper = new PageHelper();
        Properties p = new Properties();
        p.setProperty("offsetAsPageNum", "true");
        p.setProperty("rowBoundsWithCount", "true");
        p.setProperty("reasonable", "true");
        pageHelper.setProperties(p);
        return pageHelper;
    }

    @Bean(name = "dataSource")
    public DriverManagerDataSource dataSource(){
        DriverManagerDataSource driverManagerDataSource = new DriverManagerDataSource();
        driverManagerDataSource.setDriverClassName(driverClassName);
        driverManagerDataSource.setUrl(url);
        driverManagerDataSource.setUsername(username);
        driverManagerDataSource.setPassword(password);
        return driverManagerDataSource;
    }
}

2.UserController.java方法改造

@RequestMapping(value = "/selectUserPage", method = RequestMethod.POST)
public Map selectUserPage(@RequestParam(name = "userName", required = false) String userName) {
    Map<String, Object> map = new HashMap();
    map.put("status", "SUCCESS");

    Map<String, String> parm = new HashMap<>();
    if (StringUtils.isNotBlank(userName)) {
        parm.put("userName", userName);
    }
    //分页
    PageHelper.startPage(2, 2);

    List<User> data = userDao.selectUser(parm);
    map.put("data", data);
    return map;
}