java静态分页_Javaweb分页

在这里先说说分页的主要思路，分页limit语句和count(*)这两个你要知道之后的就是你的逻辑问题了。在这里简单的展示一下

这里展示的是连接数据库的情况，分页一页5条数据如下代码

1.HTML

分页

搜索：

$("#btn").click(function(){

var tableHtml = "

编号名字价格";

$.ajax({

url:"hui.hui",

type:"post",

dataType:"json",

data:{"search":$("#search").val(),"page":"0"},

success:function(data){

$.each(data.arr , function(i,item){

tableHtml = tableHtml + "

"+item.bookNumber+""+item.bookName+""+item.bookPressTime+"";

});

let count = parseInt(data.count)%5;

if(count>0){

count = parseInt(parseInt(data.count)/5)+1;

}

var div1="";

for(var i=0;i

div1 = div1 + ""+(i+1)+" ";

}

$("#div1").html(div1+"总页数："+count);

$("#tables").html(tableHtml);

}

});

});

function page(pageNo){

var tableHtml = "

编号书名时间";

$.ajax({

url:"hui.hui",

type:"post",

dataType:"json",

data:{"search":$("#search").val(),"page":pageNo},

success:function(data){

$.each(data.arr , function(i,item){

tableHtml = tableHtml + "

"+item.bookNumber+""+item.bookName+""+item.bookPressTime+"";

});

let count = parseInt(data.count)%5;

if(count>0){

count = parseInt(parseInt(data.count)/5)+1;

}

var div1="";

for(var i=0;i

div1 = div1 + ""+(i+1)+" ";

}

$("#div1").html(div1+"总页数："+count);

$("#tables").html(tableHtml);

}

});

}

分页是一个静态分页，如果想动态的就把蓝色部分循环改一下就好了

2.servlet

package com.hp2.servlet;

import java.io.IOException;

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.ResultSet;

import java.sql.Statement;

import java.util.HashMap;

import java.util.LinkedList;

import java.util.List;

import java.util.Map;

import javax.servlet.ServletException;

import javax.servlet.http.HttpServlet;

import javax.servlet.http.HttpServletRequest;

import javax.servlet.http.HttpServletResponse;

import net.sf.json.JSONArray;

import net.sf.json.JSONObject;

public class HServlet extends HttpServlet {

final static String url = "jdbc:mysql://127.0.0.1:3306/project01?useUnicode=true&characterEncoding=UTF-8";

final static String username = "root";

final static String password = "root";

final static String driver = "com.mysql.jdbc.Driver";

@Override

protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {

}

@Override

protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {

this.loginHTML(request, response);

}

public void loginHTML(HttpServletRequest request, HttpServletResponse response) throws IOException {

List list = new LinkedList();

Map resultMap = new HashMap();

Connection conn = null;

Statement state = null;

ResultSet rs = null;

ResultSet rs1 = null;

String search = request.getParameter("search") ==null ? "" : request.getParameter("search").toString();

String page = request.getParameter("page") ==null ? "0" : request.getParameter("page").toString();

String sql = "select * from book where 1=1 and (bookNumber like '%"+search+"%' or bookName like '%"+search+"%') limit "+page+" ,5";

String sql1 = "select count(*) count from book where 1=1 and (bookNumber like '%"+search+"%' or bookName like '%"+search+"%')";

try {

Class.forName(driver);

conn = DriverManager.getConnection(url,username,password);

state = conn.createStatement();

rs1 = state.executeQuery(sql1);

rs1.next();

resultMap.put("count", rs1.getObject("count"));

rs = state.executeQuery(sql);

while(rs.next()) {

Map map = new HashMap();

map.put("bookNumber",rs.getObject("bookNumber")+"");

map.put("bookName",rs.getObject("bookName")+"");

map.put("bookPressTime",rs.getObject("bookPressTime")+"");

list.add(map);

}

} catch (Exception e) {

e.printStackTrace();

}finally{

try {

if(rs == null) {

rs.close();

}

if(state ==null) {

state.close();

}

if(conn==null) {

conn.close();

}

}catch (Exception e) {

e.printStackTrace();

}

}

resultMap.put("arr", list);

JSONObject jsonObject = JSONObject.fromObject(resultMap);

response.getWriter().print(jsonObject.toString());

response.getWriter().close();

}

}

上面的内容有什么不对的地方，请大家多多指教！