JAVA分页案例(基础思想)

河南大学软件学院
pagetotal=listall.size()/mun+1; //System.out.println(pagetotal+"\t"+listall.size()%10); if(pagetotal==nowpage) {
mun=listall.size()%mun; } // System.out.println(mun); for(int i=0;i<mun;i++) {
System.out.println(nowPage); /*for(int i=0;i<(list.size()/10+1);i++) {
List<User> lu=up.getPage((i+1),list); Userpage userpage=new Userpage(); userpage.setMun(i+1); userpage.setList(lu); listu.add(userpage); } pagetotal=listu.size(); listPage=listu; */ if(nowPage==0) nowPage=1; listuser=up.getPage(nowPage, list); return "success"; }
User u=list.get(i); //up.insertUser(u); System.out.println(u.getPassword()+"\t"+u.getUsename()); }*/ List<Userpage> upage=up.getUserPage(listall); for(int i=0;i<upage.size();i++) {
import java.sql.Connection;
河南大学软件学院
import java.sql.PreparedStatement; import java.sql.ResultSet; import java.sql.SQLException; import java.sql.Statement; import java.util.ArrayList; import java.util.List;
UserPage userpage=new UserPage(); for(int i=0;i<listall.size()/10+1;i++) {
Userpage up=new Userpage(); List<User> list=userpage.getPage(i+1, listall); up.setMun(i+1); up.setList(list); upage.add(up); } return upage; } public void insertUser(User user) { Connection conn=cdb.conn();//连接数据库 try { PreparedStatement pstm=conn.prepareStatement("insert into login (usename,password) values(?,?)"); pstm.setString(1,user.getUsename()); pstm.setString(2,user.getPassword()); pstm.execute(); } catch (SQLException e) { e.printStackTrace(); } finally{ try {
return "success"; } public String getlistback() {
//显示上一页数据集 HttpServletRequest request=ServletActionContext.getRequest(); nowPage=Integer.parseInt(request.getParameter("nowPage"))-1;
//执行显示得到的数据集的首页 listuser=up.getPage(nowPage, list);
return "success"; } public String getlistnext() {
//显示下一页数据集
河南大学软件学院
HttpServletRequest request=ServletActionContext.getRequest(); nowPage=Integer.parseInt(request.getParameter("nowPage"))+1; System.out.println(nowPage); if(nowPage>pagetotal) nowPage=1; listuser=up.getPage(nowPage, list);
super(); this.usename=usename; this.password=password; this.id=id; } public Integer getId() { return id; } public void setId(Integer id) { this.id = id; } public String getUsename() { return usename; } public void setUsename(String usename) { this.usename = usename; } public String getPassword() { return password; } public void setPassword(String password) { this.password = password; } public User() { super(); } } 二、得到数据集 package com.neusoft.common;
河南大学软件学院
关于分页的简单案例
关于分页的问题，此案例只是个人思想实现的分页。在编程中，没有实现不了的功能， 只有想出来的执行过程，简单的实现学习分页的基础思想。 一、User 类
public class User { private String usename; private String password; private Integer id; public User(String usename,String password,Integer id) {
Userpage userpage=upage.get(i); System.out.println("第"+userpage.getMun()+"页"); for(int j=0;j<userpage.getList().size();j++) {
User use=userpage.getList().get(j); System.out.println(use.getPassword()+"\t"+use.getUsename()); } }
conn.close(); } catch (SQLException e) {
e.printStackTrace();
河南大学软件学院
} } } public static void main(String[] args) { UserPage up=new UserPage(); User user=new User(); List<User> listall=up.getUser(user); List<User> list=up.getPage(1, listall); /*for(int i=0;i<list.size();i++) {
} }
三、执行 action package com.neusoft.action;
import java.util.ArrayList; import java.util.List;
import javax.servlet.http.HttpServletRequest;
import org.apache.struts2.ServletActionContext;
User use=listall.get((nowpage-1)*10+i); list.add(use); } return list; } public List<Userpage> getUserPage(List<User> listall)Fra Baidu bibliotek List<Userpage> upage=new ArrayList<Userpage>();
import com.neusoft.common.UserPage; import com.neusoft.dao.User; import com.neusoft.dao.Userpage;
河南大学软件学院
public class PageoneAction { public User getUser() { return user; } public void setUser(User user) { this.user = user; } public Integer getNowPage() { return nowPage; } public void setNowPage(Integer nowPage) { this.nowPage = nowPage; } public Integer getPagetotal() { return pagetotal; } public void setPagetotal(Integer pagetotal) { this.pagetotal = pagetotal; } public List<User> getListuser() { return listuser; } public void setListuser(List<User> listuser) { this.listuser = listuser; }
import com.neusoft.dao.User; import com.neusoft.dao.Userpage;
public class UserPage { ConnectionDB cdb=new ConnectionDB(); public List<User> getUser(User user) { List<User> list=new ArrayList<User>(); Connection conn=cdb.conn();//连接数据库 try { Statement stmt=conn.createStatement(); ResultSet rs=stmt.executeQuery("select * from login"); while(rs.next()) { User u=new User(); u.setPassword(rs.getString("password")); u.setUsename(rs.getString("usename")); u.setId(rs.getInt("id")); list.add(u); } } catch (SQLException e) { e.printStackTrace(); } finally{ try { conn.close(); } catch (SQLException e) { e.printStackTrace(); } } return list; } public List<User> getPage(int nowpage,List<User> listall) { List<User> list=new ArrayList<User>(); int mun=10;//每页的条数 int pagetotal=0;//总页数
private Integer nowPage=1;//当前页数 private List<User> listuser; private User user; UserPage up=new UserPage(); List<User> list=up.getUser(user);//得到数据集 private Integer pagetotal=list.size()/10+1;//总页数 List<Userpage> listu=new ArrayList<Userpage>(); public String getAlllist() {