1. 网上百度了好多,都那么麻烦,要么就是非要传到后台解决的,要么就是前段获取再解析,要么就是有代码不让你看的,要么就是代码一堆让你看但是是图片不让你粘贴的,要么就是让你花积分下载。
2. 导出Excel过程
引入js<script type="text/javascript" src="jquery-easyui-1.4.1/datagrid-export.js"></script>
3. easyui datagrid标题栏添加一个按钮
<a class="easyui-linkbutton" plain="true" onclick="exportExcel()"
id="serach" data-options="iconCls:'icon-large_chart'">导出excel</a>
4. js里面写exportExcel()函数
//导出excel
function exportExcel(){
$('#tt').datagrid('toExcel','dg.xls'); // export to excel
}
5.效果,
6. 附完整代码,前端增删改查都有了
<!DOCTYPE html>
<html>
<head>
<meta charset="utf-8">
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<meta name="viewport" content="width=device-width, initial-scale=1">
<title>所有有用户评论</title>
<!-- easyUI-->
<link rel="stylesheet" href="jquery-easyui-1.4.1/themes/gray/easyui.css">
<link rel="stylesheet" href="jquery-easyui-1.4.1/themes/icon.css">
<script type="text/javascript"
src="jquery-easyui-1.4.1/locale/easyui-lang-zh_CN.js"></script>
<script type="text/javascript" src="jquery-easyui-1.4.1/jquery.min.js"></script>
<script type="text/javascript"
src="http://code.jquery.com/jquery-latest.js"></script>
<script type="text/javascript"
src="jquery-easyui-1.4.1/jquery.easyui.min.js"></script>
<script type="text/javascript" src="jquery-easyui-1.4.1/datagrid-export.js"></script>
</head>
<body>
<div class="container">
<div class="row">
<div class="col-sm-8 col-sm-offset-2 text">
<h1 style="margin-left: 45%">所有值班表</h1>
<div class="description"></div>
</div>
</div>
<div class="row">
<div class="col-sm-6 col-sm-offset-3 form-box">
<div class="form-top" style="height: 70%">
<div class="form-top-right">
<i class="fa fa-key"></i>
</div>
</div>
<div id="tb" style="padding: 3px">
<span>ID</span> <input id="asin"
style="line-height: 26px; border: 1px solid #ccc"> <span>值班人姓名:</span>
<input id="reviewerName"
style="line-height: 26px; border: 1px solid #ccc"> <span>值班地点:</span>
<input id="keyWord"
style="line-height: 26px; border: 1px solid #ccc"> <a
class="easyui-linkbutton" plain="true" onclick="doSearch()"
id="serach" data-options="iconCls:'icon-search'">查找</a> <a
class="easyui-linkbutton" plain="true"
onclick="$('#w').window('open')" id="serach"
data-options="iconCls:'icon-add'">添加</a>
<a
class="easyui-linkbutton" plain="true" onclick="exportExcel()"
id="serach" data-options="iconCls:'icon-large_chart'">导出excel</a>
</div>
<div class="form-bottom" style="height: 70%">
<table id="tt" class="easyui-datagrid"
style="width: 100%; height: auto" url="/getAllDuty" toolbar="#tb"
title="建议列表" iconCls="icon-save" rownumbers="true"
pagination="true">
<!-- 工具栏-->
<thead>
<tr>
<th field="id" width="20%">教室ID</th>
<th field="name" width="10%">值班人员</th>
<th field="dutyDate" width="20%" formatter="formatShow">值班日期</th>
<th field="dutyClass" width="20%">值班地点</th>
<th field="opt" width="20%"
align:"center" formatter=operate_formatter>操作</th>
<!-- <th field="reviewtext" width="47%">评论</th> -->
</tr>
</thead>
</table>
<div class="table-responsive"></div>
</div>
</div>
</div>
<!-- 添加操作 -->
<div id="w" class="easyui-window" title="Modal Window"
data-options="modal:true,closed:true,iconCls:'icon-save'"
style="width: 300px; height: 300px; padding: 10px;">
<form id="ff" method="post" action="addDuty">
<table cellpadding="5">
<tr>
<td>值班人员:</td>
<td><input class="easyui-textbox" type="text" name="name"
data-options="required:true"></input></td>
</tr>
<tr>
<td>值班地点</td>
<td><input class="easyui-textbox" type="text" name="place"
data-options="required:true"></input></td>
</tr>
<tr>
<td>值班日期</td>
<td><input class="easyui-datebox" type="text" name="date"
data-options="required:true,validType:'date'"></input></td>
</tr>
</table>
</form>
<div style="text-align: center; padding: 5px">
<a href="javascript:void(0)" class="easyui-linkbutton"
onclick="submitForm()">提交</a> <a href="javascript:void(0)"
class="easyui-linkbutton" onclick="clearForm()">重置</a>
</div>
</div>
<!-- 添加操作 end-->
</div>
</body>
<script>
//用户搜索时触发
function doSearch() {
$('#tt').datagrid('load', {
//当所有代码执行完之后,当前表格会自动提交一份带参数的去后台
id : $('#asin').val(),
name : $('#reviewerName').val(),
place : $('#keyWord').val(),
});
}
//日期格式化
function formatShow(value, row, index) {
if (value != null) {
var date = new Date(value);
var y = date.getFullYear();
var m = date.getMonth() + 1;
var d = date.getDate();
return y + '-' + m + '-' + d;
}
}
//操作
function operate_formatter(value, row, index) {
return "<button onClick='deleteRow(" + row.id
+ ")' class='easyui-linkbutton'>删除</button>";
}
//删除
function deleteRow(value) {
$.messager.confirm("操作提示", "您确定要删除该值班记录吗?", function(data) {
if (data) {
$.ajax({
type : "POST",
url : "deleteDutyById",
data : {
id : value
},
//返回数据的格式
datatype : "text",//"xml", "html", "script", "json", "jsonp", "text".
//在请求之前调用的函数
beforeSend : function() {
//$("#msg").html("logining");
},
success : function(data) {
$("#tt").datagrid("reload");
alert("删除成功");
},
//调用执行后调用的函数
complete : function(XMLHttpRequest, textStatus) {
},
//调用出错执行的函数
error : function() {
alert("删除失败");
}
});
}
});
}
//添加
function submitForm() {
$('#ff').form('submit');
alert("添加成功");
$('#ff').form('clear');
$("#tt").datagrid("reload");
}
//重置
function clearForm() {
$('#ff').form('clear');
}
//导出excel
function exportExcel(){
$('#tt').datagrid('toExcel','dg.xls'); // export to excel
}
</script>
</html>