EasyClass!Query类

public class Query extends LinkedHashMap<String , Object> {

private static final long serialVersionUID = 1L ;

//当前页码

private int page ;

//每页条数

private int limit ;

 

public Query (Map<String , Object> params){

this .putAll(params) ;

 

//分页参数

if (params.get( "page" ) != null ) {

this . page = Integer. parseInt (params.get( "page" ).toString()) ;

} else {

this . page = 1 ;

}

 

if (params.get( "limit" ) != null ) {

this . limit = Integer. parseInt (params.get( "limit" ).toString()) ;

} else {

this . limit = 20 ;

}

 

this .put( "offset" , ( page - 1 ) * limit ) ;

this .put( "page" , page ) ;

this .put( "limit" , limit ) ;

 

// 启动系统分页效果

if ( this . page > 0 && this . limit > 0 ) {

PageHelper. startPage ( page , limit , true ) ;

}

 

//防止SQL注入（因为sidx、order是通过拼接SQL实现排序的，会有SQL注入风险）

if (params.get( "sidx" ) != null ) {

String sidx = params.get( "sidx" ).toString() ;

this .put( "sidx" , SQLFilter. sqlInject (sidx)) ;

}

if (params.get( "order" ) != null ) {

String order = params.get( "order" ).toString() ;

this .put( "order" , SQLFilter. sqlInject (order)) ;

}

}

 

 

public int getPage () {

return page ;

}

 

public void setPage ( int page) {

this . page = page ;

}

 

public int getLimit () {

return limit ;

 

public void setLimit ( int limit) {

this . limit = limit ;

}

}

 

 

 

Github: https://github.com/pagehelper/Mybatis-PageHelper  配合PageUtils