<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 <= #{endIndex,jdbcType=NUMERIC}
)
WHERE RN > #{startIndex,jdbcType=NUMERIC}
</select>
<!-- 公用标签 -->
<sql id="bookWhere">
<where>
</where>
</sql>
</textarea>