<!-- pagehelp -->
		<dependency>
			<groupId>com.github.pagehelper</groupId>
			<artifactId>pagehelper-spring-boot-starter</artifactId>
			<version>1.2.3</version>
		</dependency>
		<!-- 通用mapper -->
		<dependency>
			<groupId>tk.mybatis</groupId>
			<artifactId>mapper-spring-boot-starter</artifactId>
			<version>1.0.0</version>
		</dependency>

public interface MyMapper<T> extends Mapper<T>, MySqlMapper<T>,ConditionMapper<T> {
  //FIXME 特別注意，該接口不能被掃描到，否則會出錯
}

#jdbc
spring.datasource.url=jdbc:mysql://127.0.0.1:3306/news
spring.datasource.username=數據庫用戶名
spring.datasource.password=數據庫密碼
spring.datasource.driver-class-name=com.mysql.jdbc.Driver
spring.freemarker.request-context-attribute=request

#mapper  
mapper.mappers=com.imooc.springboot.mapper.util.MyMapper
mapper.not-empty=false
mapper.identity=MYSQL

#pagehelper
pagehelper.helper-dialect = mysql
pagehelper.reasonable = true
pagehelper.support-methods-arguments = true
pagehelper.params= count= countSql

public interface BaseService<T> {
	/**
	 * 查詢所有
	 * 
	 * @return 返回所有數據
	 */
	List<T> findAll();

	/**
	 * 添加
	 * 
	 * @param t   實體
	 *          
	 * @return
	 */
	int save(T t);

	/**
	 * 修改
	 * 
	 * @param t
	 *            實體
	 * @return
	 */
	int updateByPrimaryKey(T t);

	/**
	 * 根據主鍵刪除
	 * 
	 * @param t   主鍵
	 *            
	 * @return
	 */
	int deleteByPrimaryKey(int t);
	
	/**
	 * 查詢表格列表
	 * @param t 分頁參數
	 * @return
	 */
	TableData<T> getTableData(PageBean pageBean);
}

public abstract class BaseServiceImpl<T> implements BaseService<T> {
	@Autowired
	protected MyMapper<T> mapper;

	@Override
	public List<T> findAll() {
		return mapper.selectAll();
	}

	@Override
	public int save(T t) {
		return mapper.insert(t);
	}

	@Override
	public int updateByPrimaryKey(T t) {
		return mapper.updateByPrimaryKey(t);
	}

	@Override
	public int deleteByPrimaryKey(int t) {
		return mapper.deleteByPrimaryKey(t);
	}

	@Override
	public TableData<T> getTableData(PageBean bean) {
		int count = mapper.selectAll().size();
		if (count > 0) {
			PageHelper.startPage((bean.getOffset()/bean.getLimit()) + 1, bean.getLimit());
			List<T> list = this.findAll();
			return TableData.bulid(count, list);
		}

		return TableData.empty();
	}
}

public interface NewsService extends BaseService<SysUser> {

}

@Service
public class NewsServiceImpl extends BaseServiceImpl<SysUser> implements NewsService{

}

  $('#mytable').bootstrapTable({
                 //請求方法
                method: 'get',
                 //是否顯示行間隔色
                striped: true,
                //是否使用緩存，默認為true，所以一般情況下需要設置一下這個屬性（*）     
                cache: false,    
                //是否顯示分頁（*）  
                pagination: true,   
                 //是否啟用排序  
                sortable: false,    
                 //排序方式 
                sortOrder: "desc",    
                //初始化加載第一頁，默認第一頁
                //我設置了這一項，但是貌似沒起作用，而且我這默認是0,- -
                //pageNumber:1,   
                //每頁的記錄行數（*）   
                pageSize: 10,  
                //可供選擇的每頁的行數（*）    
                pageList: [10, 25, 50, 100],
                //這個接口需要處理bootstrap table傳遞的固定參數,并返回特定格式的json數據  
                url: "${contextPath}/mapper/getTableData",
                //默認值為 'limit',傳給服務端的參數為：limit, offset, search, sort, order Else
                //queryParamsType:'',   
                ////查詢參數,每次調用是會帶上這個參數，可自定義                         
                queryParams: queryParams : function(params) {
                    var subcompany = $('#subcompany option:selected').val();
                    var name = $('#name').val();
                    return {
                          pageNumber: params.offset+1,
                          pageSize: params.limit,
                          companyId:subcompany,
                          name:name
                        };
                },
                //分頁方式：client客戶端分頁，server服務端分頁（*）
                sidePagination: "server",
                //是否顯示搜索
                search: false,  
                //Enable the strict search.    
                strictSearch: true,
                //Indicate which field is an identity field.
                idField : "id",
                columns: [],
                pagination:true
            });

contentType: 'application/json',//post請求頭 application/x-www-form-urlencoded; charset=UTF-8'
 dataType: 'json',
 sidePagination: 'server', // 改成server    

 function queryParams(params) {
			var query={};
			query["limit"] = params.limit;//第幾條數據開始
			query["offset"] = params.offset;//數據大小
			return query;
		}

public TableData<T> getTableData(PageBean bean) {
        int count = mapper.selectAll().size();
        if (count > 0) {
            PageHelper.startPage((bean.getOffset()/bean.getLimit()) + 1, bean.getLimit());
            List<T> list = this.findAll();
            return TableData.bulid(count, list);
        }

        return TableData.empty();
    }