jquery 下拉列表

jquery 下拉列表

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")