Javaweb项目三，分页部分

package com.ls.dao; import com.ls.bean.Bill; import com.ls.bean.Provider; import com.ls.bean.Page; import com.ls.utils.BaseDao; import java.sql.Connection; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.util.ArrayList; import java.util.List; public class BillDao{ public List<Bill> selectAll(){ List<Bill> list=new ArrayList<>(); String sql="select b.*,p.proName from tb_bill b,tb_provider p where b.providerId=p.id"; try { Connection conn=BaseDao.getConnection(); PreparedStatement ps=conn.prepareStatement(sql); ResultSet rs=ps.executeQuery(); while (rs.next()){ Provider provider=new Provider(); provider.setProName(rs.getString("proName")); Bill bill=new Bill(); bill.setId(rs.getLong("id")); bill.setBillCode(rs.getString("billCode")); bill.setProductName(rs.getString("productName")); bill.setProductDesc(rs.getString("productDesc")); bill.setProductUnit(rs.getString("productUnit")); bill.setProductCount(rs.getBigDecimal("productCount")); bill.setTotalPrice(rs.getBigDecimal("totalPrice")); bill.setIsPayment(rs.getInt("isPayment")); bill.setCreationDate(rs.getDate("creationDate")); bill.setProviderId(rs.getInt("providerId")); bill.setProvider(provider); list.add(bill); } } catch (Exception e) { e.printStackTrace(); } return list; } //分页查询 public List<Bill> seleByAny(String name, Page page){ List<Bill>list=new ArrayList<Bill>(); String sql="select b.*,p.proName from tb_bill b,tb_provider p where b.providerId=p.id AND b.productName like concat('%',?,'%') limit ?,?"; try { Connection conn=BaseDao.getConnection(); PreparedStatement ps=conn.prepareStatement(sql); ps.setString(1,name); ps.setInt(2,(page.getPageNum()-1)*page.getPageSize()); ps.setInt(3,page.getPageSize()); ResultSet rs=ps.executeQuery(); while (rs.next()){ Provider provider=new Provider(); provider.setProName(rs.getString("proName")); Bill bill=new Bill(); bill.setId(rs.getLong("id")); bill.setBillCode(rs.getString("billCode")); bill.setProductName(rs.getString("productName")); bill.setProductDesc(rs.getString("productDesc")); bill.setProductUnit(rs.getString("productUnit")); bill.setProductCount(rs.getBigDecimal("productCount")); bill.setTotalPrice(rs.getBigDecimal("totalPrice")); bill.setIsPayment(rs.getInt("isPayment")); bill.setCreationDate(rs.getDate("creationDate")); bill.setProviderId(rs.getInt("providerId")); bill.setProvider(provider); list.add(bill); } } catch (Exception e) { e.printStackTrace(); } return list; } //获取总条数 public int selectCount(String name){ int count=0; String sql; sql="select count(*) as count from tb_bill where productName like concat('%',?,'%')"; try { Connection conn=BaseDao.getConnection(); PreparedStatement ps=conn.prepareStatement(sql); ps.setString(1,name); ResultSet rs=ps.executeQuery(); while (rs.next()){ count=rs.getInt("count"); } } catch (Exception e) { e.printStackTrace(); } return count; } public static void main(String[] args) throws Exception { BillDao dao=new BillDao(); Page p1=new Page(); p1.setPageNum(1); p1.setPageSize(6); System.out.println(dao.seleByAny("",p1)); } }