1.
<head>
<title>运维平台</title>
<link rel="stylesheet" type="text/css" href="/static/Css/Deploy/deploy.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">
<label class="condition">应用系统</label>
<select name="application" class="monitor">
</select>
<label class="condition">发布用户</label>
<select name="deployuser" class="monitor">
</select>
<label class="condition">发布机器</label>
<select name="deploymachine" class="monitor">
</select>
<label class="condition">发布版本包</label>
<select name="deploypkg" class="monitor">
</select>
<input type="submit" value="发布应用" class="publish">
<input type="submit" value="查看应用发布情况" class="check">
</div>
<table class="gridtable fr">
<tr><th>消息</th></tr>
</table>
</div>
</body>
<script type="text/javascript" src="/static/Js/jquery-2.2.2.min.js"></script>
<script type="text/javascript" src="/static/Js/Deploy/deploy.js"></script>
<!script type="text/javascript" src="/static/Js/Public/menu.js"><!/script>
<script type="text/javascript" src="/static/Js/Public/ajax.js"></script>
</html>
<html>
2.
$(function(){
var _env_select = $("select[name='application']");
var _app_select = $("select[name='deployuser']");
var _qmgr_select = $("select[name='deploymachine']");
var _queue_select = $("select[name='deploypkg']");
var _sub_btn = $(".publish");
var _qmgr_btn = $(".check");
getapp("pro");
getqmgr("pro");
getqueue("pro");
function getapp(env){
var data = {};
var successfn = function(jdata){
var _HTML = "";
_env_select.html("");
$.each(jdata,function(i,val){
_HTML = _HTML + "<option value="+jdata[i][0]+">"+jdata[i][0]+"</option>";
});
_env_select.html(_HTML);
};
var errorfn = function(jdata){
alert("数据返回出错");
};
$.ajax({
type: "get",
data: data,
url: "/api/getdeployapp",
dataType: "json",
success: function(d){
successfn(d);
},
error: function(e){
errorfn(e);
}
});
}
_env_select.on("change",function(){
env = _env_select.val();
getapp(env);
});
});
3.接口数据:
[08/Apr/2018 09:27:35] "GET /favicon.ico HTTP/1.1" 404 10741
/api/getdeployapp/
((u'ESBu7cfbu7edf',), (u'TEST',))
<type 'tuple'>
def getdeployapp(req):
print req.get_full_path()
conn= MySQLdb.connect(
host='127.0.0.1',
port = 3306,
user='root',
passwd='1234567',
db ='DEVOPS',
charset="UTF8"
)
cur = conn.cursor()
a = cur.execute("select distinct appname from publish")
info = cur.fetchall()
print info
print type(info)
return HttpResponse(json.dumps(info), content_type="application/json")