<%@ page language="java" import="java.util.*" pageEncoding="utf-8"%>
|
<%
|
String path = request.getContextPath();
|
String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";
|
%>
|
<%@ taglib uri="/struts-tags" prefix="s"%>
|
<!DOCTYPE HTML>
|
<html>
|
<head>
|
<!-- 默认使用最高内核 -->
|
<meta http-equiv="X-UA-Compatible" content="IE=Edge,chrome=1" >
|
<base href="<%=basePath%>">
|
<title>数据库备份</title>
|
<link rel="stylesheet" href="css/basic.css">
|
<link rel="stylesheet" type="text/css" href="css/nocontent.css">
|
<link rel="stylesheet" type="text/css" href="css/loading.css">
|
<link rel="stylesheet" type="text/css" href="css/ul-list.css">
|
<link rel="stylesheet" type="text/css" href="css/basic-layout.css"/>
|
<link rel="stylesheet" href="css/confirm.css" />
|
<style type="text/css">
|
.hdw-btn.hdw-icon-backup {
|
float: right;
|
margin-right: 3em;
|
}
|
</style>
|
</head>
|
|
<body>
|
<!--头部内容开始-->
|
<jsp:include page="Top.jsp" flush="true"/>
|
<!--头部内容结束-->
|
<!--导航开始-->
|
<jsp:include page="nav.jsp" flush="true"/>
|
<div class="page-content">
|
<div class="content-item side-bar-container">
|
<div class="ul-list">
|
<!-- 数据库列表 -->
|
</div>
|
</div>
|
<div class="content-item data-show">
|
<div class="data-container">
|
<div class="data-container-header"></div>
|
<div class="data-container-body">
|
<!-- 数据库表列表 -->
|
</div>
|
<div class="data-container-footer">
|
<div class="btn-container">
|
<a href="javascript:;" class="hdw-btn hdw-icon hdw-icon-backup backup-all">备份全部数据库</a>
|
<a href="javascript:;" class="hdw-btn hdw-icon hdw-icon-backup btn-disabled backup-all">下载备份数据</a>
|
</div>
|
</div>
|
</div>
|
</div>
|
</div>
|
<script type="text/javascript" src="jqueryui/jquery-ui.min.js"></script>
|
<script type="text/javascript" src="js/basic-layout.js"></script>
|
<script type="text/javascript" src="js/ui-list.js"></script>
|
<script type="text/javascript" src="js/myConfirm.js"></script>
|
<script type="text/javascript">
|
$(function() {
|
searchAllDataBase(); // 查询并生成数据库列表
|
|
// 点击数据库列表显示右侧的对应的表
|
$('.ul-list').on('click', 'li a:not(.active)', function() {
|
var databaseName = $(this).attr('value');
|
searchTableByDBName(databaseName);
|
});
|
|
// 点击备份数据库显示确认告警框
|
$('.backup-all').on('click', function() {
|
if(!$(this).hasClass('btn-disabled')) {
|
myConfirm.show({
|
'content': '是否确认备份数据库',
|
'class':'y-backup'
|
});
|
}
|
});
|
|
// 点击confirm的确定按钮触发备份数据请求
|
myConfirm.confirm.on('click', '.y-backup', function() {
|
myConfirm.hide();
|
backupAllDB(); // 向后台发送备份数据库指令
|
});
|
});
|
|
// 生成数据库表
|
function createDatabaseTblList(dataList) {
|
var container = $('.data-container-body');
|
|
var items = "";
|
|
for(var i=0; i<dataList.length; i++) {
|
items += '<div class="list-items">'+dataList[i]+'</div>';
|
}
|
container.html(items);
|
}
|
|
//查询所有的数据库
|
function searchAllDataBase(){
|
loading.showLoading();
|
var opts = {
|
txt: new Array(),
|
};
|
$.ajax({
|
type: "post",
|
url: "Database_backupAction!searchAllDatabase",
|
async:true,
|
dataType:'json',
|
data:null,
|
success: function(data){
|
loading.hideLoading();
|
var model = eval("("+data.result+")");
|
if(model.code == 1){
|
var opts = {
|
txt:model.data,
|
};
|
createLiList($('.ul-list'), opts);
|
$('.ul-list').find('li').eq(0).find('a').addClass('active');
|
searchTableByDBName(model.data[0]);
|
}else{
|
noContent.showNoContent("暂无数据库");
|
}
|
},
|
error:function(a){
|
loading.hideLoading();
|
noContent.showNoContent("查询失败");
|
}
|
});
|
}
|
|
//查询指定数据库中的所有表
|
function searchTableByDBName(dbname){
|
loading.showLoading($('.data-container'));
|
$.ajax({
|
type: "post",
|
url: "Database_backupAction!searchAllTable",
|
async:true,
|
dataType:'json',
|
data:"json="+JSON.stringify({
|
database_name:dbname,
|
}),
|
success: function(data){
|
loading.hideLoading($('.data-container'));
|
var model = eval("("+data.result+")");
|
if(model.code == 1) {
|
createDatabaseTblList(model.data);
|
}
|
},
|
error:function(a){
|
loading.hideLoading($('.data-container'));
|
}
|
});
|
}
|
|
//备份所有的数据库
|
function backupAllDB(){
|
loading.showLoading($('.data-container'));
|
$.ajax({
|
type: "post",
|
url: "Database_backupAction!updateProAll",
|
async:true,
|
dataType:'json',
|
success: function(data){
|
loading.hideLoading($('.data-container'));
|
var model = eval("("+data.result+")");
|
if(model.code == 1) {
|
noContent.showNoContent("启动备份完成");
|
}else{
|
noContent.showNoContent("启动备份失败");
|
}
|
},
|
error:function(a){
|
noContent.showNoContent("修改失败");
|
}
|
});
|
}
|
</script>
|
</body>
|
</html>
|
