Jdbc实现页面分页查询功能

男娘i 2022-07-26 06:08 230阅读 0赞

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

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

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;
    }