在MYSQL中实现分页显示的代码－－SHOPPING

1.     public List<Product> getProducts(int pageNo, int pageSize)
2.     {
3.         Connection conn=null;
4.         ResultSet rs=null;
5.         List<Product> list=new ArrayList<Product>();
6.         conn=DB.getConn();
7.         String sql="select * from product limit "+(pageNo-1)*pageSize+","+pageSize;
9.         rs=DB.executeQuery(conn, sql);
10.         try
11.         {
12.             while(rs.next())
13.             {
14.                 Product p=new Product();
15.                 p.setId(rs.getInt("id"));
16.                 p.setName(rs.getString("name"));
17.                 p.setDescr(rs.getString("descr"));
18.                 p.setNormalPrice(rs.getDouble("normalprice"));
19.                 p.setMemberPrice(rs.getDouble("memberprice"));
20.                 p.setCategoryId(rs.getInt("categoryid"));
21.                 p.setPdate(rs.getTimestamp("pdate"));
22.                 list.add(p);
23.             }
24.         } catch (SQLException e)
25.         {
26.             e.printStackTrace();
27.         }
28.         finally
29.         {
30.             DB.closeRs(rs);
31.             DB.closeConn(conn);
32.         }
33.         return list;
34.     }