1.

[root@yyjk templates]# cat displayOracleExport.html 


<html>
<head>
<title>运维平台</title>
<link rel="stylesheet" type="text/css" href="/static/Css/Monitor/displayOracleExport.css">
<link rel="stylesheet" type="text/css" href="/static/Css/Public/header.css">
<link rel="stylesheet" type="text/css" href="/static/Css/Public/menu.css">
</head>
<body>
<include file="Public:header"/>
<div class="content">
<include file="Public:menu"/>
<div class="con fl">
<div id="condition">
<label class="condition">数据库服务名</label><input type="text" name="dbservice" class="equipment_sz1">
<label class="condition">数据库IP</label><input type="text" name="dbip" class="equipment_sz2">
<label class="condition">数据库用户名</label><input type="text" name="dbuser" class="equipment_sz3">
<label class="condition">数据库密码</label><input type="text" name="dbpass" class="equipment_sz4">
<br />
<br />
<label class="condition">导出的表</label><input type="text" name="exportTable" class="equipment_sz5">
<label class="condition">where条件</label><input type="text" name="condition" class="equipment_sz6">
<br />
<br />
<input type="submit" value="导出" class="equipment_search_btn es_1">
<!--<input type="submit" value="组查找" class="equipment_search_btn es_2">-->
</div>
<table class="gridtable">
<tr>
<th>"导出成功后,请通过下面的url下载文件"</th>
</tr>
</table>
</div>
</div>
</body>
<script type="text/javascript" src="/static/Js/jquery-2.2.2.min.js"></script>
<script type="text/javascript" src="/static/Js/Monitor/displayOracleExport.js"></script>
<script type="text/javascript" src="/static/Js/Public/ajax.js"></script>
</html>


2.
[root@yyjk Monitor]# cat displayOracleExport.js 
$(function(){
        var _dbservice= $("input[name='dbservice']");
        var _dbip= $("input[name='dbip']");
  var _dbuser= $("input[name='dbuser']");
  var _dbpass= $("input[name='dbpass']");
  var _exportTable= $("input[name='exportTable']");
  var _tiaojian= $("input[name='tiaojian']");
        var _ip_bt = $(".content .con #condition .es_1");
        _ip_bt.on('click',function(){
                var data={};
                data.dbservice=_dbservice.val();
                data.dbip=_dbip.val();
                data.dbuser=_dbuser.val();
                data.dbpass=_dbpass.val();
                data.exporttable=_exportTable.val();
                data.tiaojian=_tiaojian.val();
                var successfn = function(jdata){
    alert(jdata);
                };
                var errorfn = function(){
                alert("数据获取出错");
                };
                $.ajax({
        type: "get",
        data: data,
        url: "/api/exportoraceldata",
        dataType: "json",
        success: function(d){
          successfn(d);
        },
        error: function(e){
          errorfn(e);
        }
      });
        });
  }
)

3.
/api/exportoraceldata/?dbservice=tlyy&dbip=12.23.23.23&dbuser=oracle&dbpass=21212&exporttable=uses
tlyy
12.23.23.23
oracle
21212
uses