jsp简单分页实现

墨蓝 2022-08-07 13:34 257阅读 0赞

## 1.所需jar包 ##

![Center][]

## 2.实现步骤 ##

\#\#1.jsp页面中使用jQuery load函数加载数据。在点击页数按钮调用js函数加载数据。

\#\#2.2jsp页面中异步获取需要分页数

\#\#2.3分页方法

public List<DataRecord> getAllNotice(int start) {
    		String startStr=String.valueOf(start);
    		String sql = "SELECT * FROM " + TABLE_NAME+" LIMIT "+startStr+",10";
    		List<DataRecord> list = new ArrayList<DataRecord>();
    		try {
    			st = con.createStatement();
    			rs = st.executeQuery(sql);
    			while (rs.next()) {
    				list.add(new DataRecord(rs.getInt("nt_id"), rs
    						.getString("nt_title"), rs.getString("nt_date")));
    			}
    			return list;
    		} catch (SQLException e) {
    			e.printStackTrace();
    		}
    		return null;
    	}

用MySQL的LIMIT关键字实现分页

\#\#2.4获取总记录数

//返回总记录数
    	public int numberOfRecords(){
    		String sql="SELECT COUNT(*) FROM "+TABLE_NAME;
    		try{
    			pst=con.prepareStatement(sql);
    			rs=pst.executeQuery();
    			if(rs.next())
    				return rs.getInt(1);
    		}catch(SQLException e){
    			e.printStackTrace();
    		}
    		return 0;
    	}

在JavaScript中根据记录数计算所需分页数

var page_num=0;
    page_num=(((record_num%10)==0)?(record_num/10):(record_num/10+1));

完整代码：http://download.csdn.net/detail/lantiancaiyun/8586217

[Center]: /images/20220805/41b5025624ca49babeba855a2bc874de.png