Easyui分页查询

 <textarea readonly="readonly" name="code" class="c++"> 
1.要引入的jsp文件:
<link rel="stylesheet" href="../js/uploadify/uploadify.css">
<link rel="stylesheet" href="../js/easyui1.5/themes/icon.css">
<link rel="stylesheet" href="../js/easyui1.5/themes/default/easyui.css">
<link rel="stylesheet" href="../js/kindeditor-4.1.10/themes/simple/simple.css">
<script src="../js/easyui1.5/jquery.min.js"></script>
<script src="../js/easyui1.5/jquery.easyui.min.js"></script>
<script src="../js/easyui1.5/locale/easyui-lang-zh_CN.js"></script>
<script src="../js/uploadify/jquery.uploadify.js"></script>
<script src="../js/kindeditor-4.1.10/kindeditor-all.js"></script>

2.进入查询页面的jsp页面
声明一个Table当载体:
<table id="bookTable"></table>

3.scrpt脚本代码
$("#bookTable").datagrid({  //#bookTable是table的id值
	url:"../book/findBookList.do", //进入controller后台查询
	//浏览器打开时加载 条查页面
	toolbar:'#toolbar',
	//屏幕自适应
	fit:true,
	//pagination开启分页,如果开启了easyui分页,默认会传2个参数。分别是page(第几页)和rows(每页多少条)，默认是第一页，每页10条数据
	pagination:true,
	//自定义每页显示的条数
	pageSize:2,
	//自定义列表下拉框
	pageList:[2,4,10,15,20,40],
	//加这个复选框单选只能选一个
	//singleSelect:true,
	columns:[[
		//全选
		{field:'id111',checkbox:true},
	
		{field:'id',title:'ID'},
		{field:'bookName',title:'图书名称'},   //value表示当前img的值   row表示当前这一行的值  index表示下标
		{field:'bookDate',title:'发布时间'},
		{field:'price',title:'价格'},
		{field:'provinceName',title:'出版地区',formatter:function(value,row,index){
			return value+"-"+row.cityName
		}},
		{field:'img',title:'图片',formatter:function(value,row,index){
			return '<img width="80" height="50" src="'+value+'">'
		}},
		{field:'typeName',title:'类型'},
		{field:'163',title:'操作',formatter:function(value,row,index){       //修改
			return '<a href="javascript:del('+row.id+')">删除</a> | <a href="javascript:edit('+row.id+')">修改</a>';
		}},
	]]
})



3.Controller层
@RequestMapping("findBookList")
	@ResponseBody
	public EasyuiPage findBookList(Integer page,Integer rows,BookBean BookBean){
		return bookService.findArticleListPage(page, rows, BookBean);
	}




4.serviceImpl层
	 @Override
	public EasyuiPage findBookList(Integer page, Integer rows, BookBean bookBean) {
		 	//构建总返回题
		 	EasyuiPage result = new EasyuiPage();
			HashMap<String, Object> params = new HashMap<>();
			//查询总条数
			params.put("bookBean", bookBean);
			int count = bookMapper.findBookCount(params);
			//将查询出来的总条数放入总返回体中
			result.setTotal(count);
			//查询分页列表list
			PageUtil<BookBean> pageUtil = new PageUtil<>(count,page,rows);
			params.put("startIndex", pageUtil.getStartIndex());
			params.put("endIndex", pageUtil.getEndIndex());
			List<BookBean> articles = bookMapper.findBookLists(params);
			//将分页查询出来的列表放入总返回体中
			result.setRows(articles);
			return result;
		}

5.XML层sql
	<select id="findBookCount" parameterType="map" resultType="int">
		select count(1)
		from jk_book b 
		left join jk_type y on b.typeid = y.id 
		left join jk_area ta1 on b.province = ta1.id 
		left join jk_area ta2 on b.city = ta2.id 
		<include refid="bookWhere"></include>  
	</select>
	
	<select id="findBookLists" parameterType="map" resultType="com.jk.cyb.model.book.BookBean">
		SELECT * FROM
		(
		SELECT A.*, ROWNUM RN 
		FROM(
		select b.id,b.bookName,to_char(b.bookDate,'yyyy-MM-dd') as bookDate,b.price,b.province,b.city,b.img,b.typeId,ta1.name as provinceName,ta2.name as cityName,y.name as typeName		
from jk_book b 
		left join jk_type y on b.typeid = y.id 
		left join jk_area ta1 on b.province = ta1.id 
		left join jk_area ta2 on b.city = ta2.id 
			<include refid="bookWhere"></include>  
		)A
		WHERE ROWNUM &lt;= #{endIndex,jdbcType=NUMERIC}
		)
		WHERE RN > #{startIndex,jdbcType=NUMERIC} 
	</select>
	
	<!-- 公用标签 -->
	<sql id="bookWhere">
		<where>			
		</where>
	</sql>

 </textarea>