MySQL数据库中正确实现分页显示的代码示例

public List getProducts(int pageNo, int pageSize) 
{ 
Connection conn=null; 
ResultSet rs=null; 
List list=new ArrayList(); 
conn=DB.getConn(); 
String sql="select * from product limit "+(pageNo-1)*pageSize+","+pageSize; 
 
rs=DB.executeQuery(conn, sql); 
try 
{ 
while(rs.next()) 
{ 
Product p=new Product(); 
p.setId(rs.getInt("id")); 
p.setName(rs.getString("name")); 
p.setDescr(rs.getString("descr")); 
p.setNormalPrice(rs.getDouble("normalprice")); 
p.setMemberPrice(rs.getDouble("memberprice")); 
p.setCategoryId(rs.getInt("categoryid")); 
p.setPdate(rs.getTimestamp("pdate")); 
list.add(p); 
} 
} catch (SQLException e) 
{ 
e.printStackTrace(); 
} 
finally 
{ 
DB.closeRs(rs); 
DB.closeConn(conn); 
} 
return list; 
}