Jdbc实现页面分页查询功能

1.限制input只能输入0-59的数字

<span style="font-size:14px;"><input style="width:40px" maxlength="2" type="text" id="minute" name="minute" value="${minute}" οnkeyup="if(event.keyCode !=37 && event.keyCode != 39){if (! /^[0-5]{0,1}[0-9]{1}$/ig.test(this.value)){this.value='';}}"/></span>

2.限制input只能输入最大三位数字

<span style="font-size:14px;"><input type="text" maxlength="3" οnkeyup='this.value=this.value.replace(/\D/gi,"")' name="para.timerNum" value="${para.timerNum}"/></td></span>

3.setMaxRows：设定取的最后一个数的下标

   absolute：设定取的第一个数的下标

<span style="font-size:18px;color:#ff0000;">  ResultSet.TYPE_SCROLL_SENSITIVE：设定为一个可滚动的结果集</span>

public List<Object[]> findDataByPage(String sql,int iPageSize,int iPageNum)
{
	PreparedStatement pst = null;
	ResultSet rs = null;
	List<Object[]> dataList = new ArrayList<Object[]>();

	try
	{
		pst =connManager.getConn("ykt").prepareStatement(sql,
                    ResultSet.TYPE_SCROLL_SENSITIVE,
                    ResultSet.CONCUR_READ_ONLY);

		pst.setMaxRows(iPageSize * iPageNum);
		rs = pst.executeQuery();
		rs.absolute(iPageSize * (iPageNum - 1));

		while(rs.next())
		{	
     			obj = new Object[7];
     			obj[0] = rs.getInt("rec_no");
     			obj[1] = rs.getString("buyer_id");
     			dataList.add(obj);
		}
	}
	catch(Exception e)
	{
		return null;
	}
 	finally
        {
            try
            {
                if (rs != null)
                    rs.close();
                if (pst != null)
                    pst.close();
                
            }
            catch (Exception e2)
            {
                // TODO: handle exception
            }
        }
        return dataList;
}