這段代碼也許對你有用
源碼來自：
http://www.aygfsteel.com/supercrsky/archive/2008/09/23/230723.html
/**
* 查詢用戶(帶分頁)
*
* @param startNo
* 開始條數
* @param maxCount
* 最大記錄數
* @return
*/
public List<User> getAll(int startNo, int maxCount)
{
Connection conn = DBConnection.getConn();
String sql = "select * from person";
List<User> users = new ArrayList<User>();
try
{
if (this.getAllSize() <= 0)
return null;
PreparedStatement pstmt = conn.prepareStatement(sql,
ResultSet.TYPE_SCROLL_INSENSITIVE,
ResultSet.CONCUR_READ_ONLY);
// 最大查詢到第幾條記錄
pstmt.setMaxRows(startNo + maxCount - 1);
ResultSet rs = pstmt.executeQuery();
// 將游標移動到第一條記錄
rs.first();
// 游標移動到要輸出的第一條記錄
rs.relative(startNo - 2);
while (rs.next())
{
User user = new User();
user.setId(rs.getInt("id"));
user.setUsername(rs.getString("username"));
user.setAge(rs.getInt("age"));
user.setRemark(rs.getString("remark"));
users.add(user);
}
} catch (SQLException e)
{
e.printStackTrace();
} finally
{
try
{
conn.close();
} catch (SQLException e)
{
e.printStackTrace();
}
}
return users;
}