io.github.ldhai99.easyOrm.page.PostgrePageData Maven / Gradle / Ivy
The newest version!
package io.github.ldhai99.easyOrm.page;
import io.github.ldhai99.easyOrm.SQL;
import java.io.Serializable;
import java.sql.SQLException;
import java.util.List;
import java.util.Map;
public class PostgrePageData implements PageData, Serializable{
SQL sql=null;
PageModel page=null;
public SQL getSql() {
return sql;
}
public PageData setSql(SQL sql) {
this.sql = sql;
return this;
}
public PageModel getPage() {
return page;
}
public PageData setPage(PageModel page) {
this.page = page;
return this;
}
public static void main(String[] args) {
}
public int getRowCount() {
return getRowCount(sql).intValue();
}
public List > getPageData() {
//具体哪一种可以翻页可以更换
return getPageData(sql,page.getPageStartRow(),page.getPageRecorders());
}
//获取总记录数量
public Number getRowCount(SQL sql) {
return sql.getCount();
}
//通用获取页数据
public List > getPageData(SQL sql,int pageStartRow,int pageRecorders) {
return sql.clone().last("limit :records offset :start ")
.setValue$("start",pageStartRow)
.setValue$("records",pageRecorders) .getMaps();
}
//有id的获取页数据
public List > getPageData(SQL sql,int pageStartRow,int pageRecorders,String id) {
return sql.clone().setWhere("").in(id,
SQL.SELECT(sql.clone().setColumn(id)
.last("limit :records offset :start")
.setValue$("start",pageStartRow)
.setValue$("records",pageRecorders)
,"a")
.column("id")).getMaps();
}
//有起始id的获取页数据
public List > getPageData1(SQL sql,int pageStartId,int pageRecorders,String id) throws SQLException {
return sql.clone().gt("id",pageStartId)
.last(" limit :records")
.setValue$("records",pageRecorders)
.getMaps();
}
}