SSM Demo - 6

<!-- Pagehelper -->
<dependency>
	<groupId>com.github.pagehelper</groupId>
	<artifactId>pagehelper</artifactId>
	<version>4.1.6</version>
</dependency>

<!-- spring和MyBatis完美整合，不需要mybatis的配置映射文件 -->
<bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
    <property name="dataSource" ref="dataSource" />
    <!-- 自动扫描mapping.xml文件 -->
    <property name="mapperLocations" value="classpath:org/totoro/ssm/mapping/*.xml"></property>
    <property name="typeAliasesPackage" value="org.totoro.ssm.model"/>
	<property name="plugins">
		<array>
			<bean class="com.github.pagehelper.PageHelper">
				<property name="properties">
					<value>
						reasonable=true
					</value>
				</property>
			</bean>
		</array>
	</property>
</bean>

public ArrayList<Country> pageList() {
	PageHelper.startPage(2, 4);
	return countryDao.list();  
}

  <select id="searchAndSort" resultMap="BaseResultMap" >
    select 'true' as QUERYID,
    <include refid="Base_Column_List" />
    from country
    <if test="search != null  and search !=''">
    where country_id like CONCAT('%','${search}','%' ) or country like CONCAT('%','${search}','%' )
    </if>
    order by ${colIndex} ${sortDirection}
  </select>

ArrayList<Country> searchAndSort(@Param("search")String search, @Param("colIndex")String colIndex, @Param("sortDirection")String sortDirection);

	/**
	 * 
	 * @Title: pageList
	 * @Description: 查找单位并排序
	 * @param: @param pageStart       页面序号
	 * @param: @param pageLength      页面大小
	 * @param: @param search          搜索词
	 * @param: @param colIndex        排序字段
	 * @param: @param sortDirection   排序方式
	 * @param: @return    参数                      结果分页
	 */
	public PageInfo<Country> pageList(Integer pageStart, Integer pageLength, String search, String colIndex, String sortDirection);

	@Override
	public PageInfo<Country> pageList(Integer pageStart, Integer pageLength, String search, String colIndex, String sortDirection) {
		int column = 0;
		if (colIndex != null) {
			column = Integer.parseInt(colIndex);
			if (column < 0 || column > 5)
				column = 0;
		}
		String colName = columnNames[column];
		PageHelper.startPage(pageStart, pageLength);
		ArrayList<Country> countryList = countryDao.searchAndSort(search,colName,sortDirection);
		PageInfo<Country> page = new PageInfo<Country>(countryList);
		return page; 
	}

	@GET
	@RequestMapping("/datatable")
	@ResponseBody
	public JSONObject counttryDatatables(HttpServletRequest request,Model model){
		String displayStart = request.getParameter("iDisplayStart");
		String displayLength = request.getParameter("iDisplayLength");
		String search = request.getParameter("sSearch");
		String colIndex = request.getParameter("iSortCol_0");
		String sortDirection = request.getParameter("sSortDir_0");
		Integer pageLength = Integer.parseInt(displayLength);
		Integer pageStart = Integer.parseInt(displayStart)/pageLength + 1;
		PageInfo<Country> countryPageInfo = countryService.pageList(pageStart,pageLength,search,colIndex,sortDirection);
		
		JSONObject result = new JSONObject();
		result.put("iTotalRecords", countryPageInfo.getTotal());
		result.put("aaData", countryPageInfo.getList());
		result.put("iTotalDisplayRecords", countryPageInfo.getTotal());
		return result;
	}

$(function () {
	$("#example1").DataTable({
		//汉化

	    language: {
	        "sProcessing": "处理中...",
	        "sLengthMenu": "显示 _MENU_ 项结果",
	        "sZeroRecords": "没有匹配结果",
	        "sInfo": "显示第 _START_ 至 _END_ 项结果，共 _TOTAL_ 项",
	        "sInfoEmpty": "显示第 0 至 0 项结果，共 0 项",
	        "sInfoFiltered": "(由 _MAX_ 项结果过滤)",
	        "sInfoPostFix": "",
	        "sSearch": "搜索:",
	        "sUrl": "",
	        "sEmptyTable": "暂无信息",
	        "sLoadingRecords": "载入中...",
	        "sInfoThousands": ",",
	        "oPaginate": {
	            "sFirst": "首页",
	            "sPrevious": "上页",
	            "sNext": "下页",
	            "sLast": "末页"
	        },
	        "oAria": {
	            "sSortAscending": ": 以升序排列此列",
	            "sSortDescending": ": 以降序排列此列"
	        }
	    },
		//详细分页组，可以支持直接跳转到某页

	    "pagingType": "full_numbers",
	    //每页显示多少条选择

	    "lengthMenu": [ [ 5, 10, 25, 50, 75, 100, -1 ], [ 5, 10, 25, 50, 75, 100, "所有" ] ],
	    //默认显示条数

	    "displayLength": 10,
	    //默认排序行与排序方式

	    "order": [[ 1, "asc" ]],
	    //不排序的列的class

	    "columnDefs": [ {
	        "targets": 'nosort',
	        "orderable": false
	      } ],
	    //开启服务端处理

	    "processing": true,
	    "bServerSide": true,
	    "sAjaxSource" : "${ctx}/country/datatable.do",
        "columns": [
                    { "data": "countryId" },
                    { "data": "country" },
                    //展示时间

                    {
						"data": "lastUpdate",
						"render": function (data) {
					        var date = new Date(data);
					        var month = date.getMonth() + 1;
					        return (month.length > 1 ? month : "0" + month) + "/" + date.getDate() + "/" + date.getFullYear();
					    }
					},
					//展示传参按钮

                    { 
						"data": "countryId",
						"render": function (data) {
					        return "<a class='blue' href='javascript:void(0);' onclick='alert(" + data + ")' title='查看'>"
							+ "<i class='fa fa-fw fa-chrome '></i>"
							+ "</a>";
					    }
                    },
					//展示固定信息

                    { 
						"data": null,
						"defaultContent": "<a class='blue' href='javascript:void(0);' title='查看'>"
										+ "<i class='fa fa-fw fa-chrome '></i>"
										+ "</a>"
                    }
                ]
	});
});