81,092
社区成员
发帖
与我相关
我的任务
分享
package org.jbit.book.entity;
import java.util.List;
public class Page {
private int totalPageCount=0; //总页数
private int pageSize=5;//每页显示记录数
private int totalCount;//记录总数
private int currPageNo=1;//当前页码
private List<Book> bookList;//每页图书集合
public int getTotalPageCount() {
return totalPageCount;
}
public void setTotalPageCount(int totalPageCount) {
this.totalPageCount = totalPageCount;
}
public int getPageSize() {
return pageSize;
}
public void setPageSize(int pageSize) {
if (pageSize>0) {
this.pageSize = pageSize;
}
}
public int getTotalCount() {
return totalCount;
}
public void setTotalCount(int totalCount) {
if (totalCount>0) {
this.totalCount = totalCount;
//计算总页数
totalPageCount=this.totalCount%pageSize==0?
(this.totalCount/pageSize):(this.totalCount/pageSize+1);
}
// System.out.println(totalCount);
// System.out.println(this.pageSize);
// System.out.println("page"+this.getTotalPageCount());
}
public int getCurrPageNo() {
if (totalPageCount==0) {
return 0;
}
return currPageNo;
}
public void setCurrPageNo(int currPageNo) {
if (currPageNo>0) {
this.currPageNo = currPageNo;
}
}
public List<Book> getBookList() {
return bookList;
}
public void setBookList(List<Book> bookList) {
this.bookList = bookList;
}
}
@Override
public List<Book> getBookByPage(int pageIndex,int pageSize) {
List<Book> booklist=new ArrayList<Book>();
String sql = "select * from book_info order by creationTime DESC limit ?,?";
rs = this.executeQuery(sql,(pageIndex-1)*pageSize,pageSize);
System.out.println(rs);
Book book=null;
try {
while (rs.next()) {
book=new Book();
book.setBookId(rs.getString("bookId"));
book.setBookCde(rs.getString("bookCde"));
book.setBookName(rs.getString("bookName"));
book.setBookType(rs.getString("bookType"));
book.setBookAuthor(rs.getString("bookAuthor"));
book.setPublishPress(rs.getString("publishPress"));
SimpleDateFormat simpleDateFormat=new SimpleDateFormat();
book.setPublishDate(simpleDateFormat.format(rs.getTimestamp("publishDate")));
book.setBorrowed(rs.getString("borrowed"));
book.setCreatedBy(rs.getString("createdBy"));
book.setCreationTime(simpleDateFormat.format(rs.getTimestamp("creationTime")));
book.setLastUpdatetime(simpleDateFormat.format(rs.getTimestamp("lastUpdatetime")));
booklist.add(book);
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return booklist;
}
public static void main(String[] args) {
BookDao bookDao=new BookDaoImpl();
//List<Book> list=bookDao.getAllBook();
List<Book> booklist=bookDao.getBookByPage(5,4);
for (Book book:booklist) {
//System.out.println(book.getBookName()+">>>"+book.getBookAuthor()+">>>"+book.getCreationTime());
System.out.println(bookDao.getBookByPage(5,4));
}
}
public static int temp(int spanCount,int span){
int temp = 0;
if(spanCount%span==0){
temp=spanCount/span;
}else{
temp=spanCount/span+1;
}
return temp;
}
这段代码求出有多少页 第一个参数是数据总数 第二个是你要每页的数据数