easyui(datagrid数据查询)

1、界面代码：

	
	
		
			书籍名称
			书籍类型
		
		
		查询
	
	
	
	
	
	
	
		 
		
		
	

 2、script块：

界面展示：

3、servlet块：

package com.zking.servlet;

import java.io.IOException;
import java.io.PrintWriter;
import java.util.HashMap;
import java.util.List;
import java.util.Map;

import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import com.alibaba.fastjson.JSON;
import com.zking.biz.BookBiz;
import com.zking.biz.IBookBiz;
import com.zking.entity.Book;

@WebServlet("/BookListServlet")
public class BookListServlet extends HttpServlet {
	protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
		doPost(request, response);
	}

	protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
		//三个编码方式
		request.setCharacterEncoding("utf-8");
		response.setCharacterEncoding("utf-8");
		response.setContentType("text/html; charset=UTF-8");
		//获取out对象
		PrintWriter out = response.getWriter();
		int pageIndex=1;
		int pageSize=10;
		
		//接收前台传递过来的参数 page rows bname
		String pid=request.getParameter("page");//当前页码
		if(pid!=null) {
			pageIndex=Integer.parseInt(pid);
		}
		String size=request.getParameter("rows");//每页多少条
		if(size!=null) {
			pageSize=Integer.parseInt(size);
		}
		String bname=request.getParameter("bname");//关键字
		if(bname==null) {
			bname="";//相当于查询全部
		}
		String btype=request.getParameter("btype");//列名
		if(btype==null) {
			btype="bname";
		}
		//servlet调用biz
		IBookBiz ibb=new BookBiz();
		//获取总行数
		int zhs=ibb.getRows("tb_book where "+btype+" like '%"+bname+"%'");
		//拿到分页的集合
		List ls = ibb.getAllByPage(pageIndex, pageSize, btype,bname);
		//前台的json数据需要的两个参数：total：总行数 rows:书籍集合
		Map mym=new HashMap<>();
		//放两对值
		mym.put("total", zhs);
		mym.put("rows", ls);
		//把map集合-->json格式的对象字符串
		String str=JSON.toJSONString(mym);
		//输送到页面
		out.write(str);
		out.flush();
		out.close();
	}

}