jQuery+ Asp实现的动态组合框
getData.js:
function doStart(){
var publisherID = $("#toUser").val();
$.ajax({
url : "logic.asp",
type : "GET",
data : { "PublisherID" : publisherID },
success : function(ResponseData){
$("#toServer").html(ResponseData);
}
});
};
var publisherID = $("#toUser").val();
$.ajax({
url : "logic.asp",
type : "GET",
data : { "PublisherID" : publisherID },
success : function(ResponseData){
$("#toServer").html(ResponseData);
}
});
};
导入jQuery.js 与 getData.js
<script type="text/javascript" src="../../Scripts/jQuery.js" ></script>
<script type="text/javascript" src="Scripts/getData.js" ></script>
<script type="text/javascript" src="Scripts/getData.js" ></script>
组合框初始状态
<select id="toUser" onchange="doStart()">
<option value="0">-Choose a Publisher-</option>
<option value="1">-APress-</option>
<option value="5">-Manning-</option>
<option value="3">-SAMS-</option>
</select>
<select id="toServer"></select>
<option value="0">-Choose a Publisher-</option>
<option value="1">-APress-</option>
<option value="5">-Manning-</option>
<option value="3">-SAMS-</option>
</select>
<select id="toServer"></select>
服务器端处理 -> logic.asp
<%@ CODEPAGE=65001%>
<%
Response.CodePage = 65001;
Response.Charset = "UTF-8";
Response.CacheControl = "no-Cache";
var conn = Server.CreateObject("ADODB.CONNECTION");
conn.ConnectionString = "Provider=SQLOLEDB.1;(接下行)
Server =(local);Initial Catalog=books;User ID =sa;Password =;";
try{
conn.Open();
}catch(error){
Response.Write("数据库连接出错!");
Response.End();
}
var rs = Server.CreateObject("ADODB.RECORDSET");
var PublisherID = Request.QueryString("PublisherID");
rs.Source = "select book.BookTitle from book inner join Publisher ";
rs.Source += "on Publisher.PublisherID = (接下行)
book.bookPublisherID where Publisher.PublisherID = ";
rs.Source += PublisherID;
//Response.Write(rs.Source);
//Response.End();
rs.Open(rs.Source,conn,1,1);
while(!rs.EOF){
Response.Write("<option>" + rs("BookTitle") + "</option>");
rs.MoveNext;
}
%>
<%
Response.CodePage = 65001;
Response.Charset = "UTF-8";
Response.CacheControl = "no-Cache";
var conn = Server.CreateObject("ADODB.CONNECTION");
conn.ConnectionString = "Provider=SQLOLEDB.1;(接下行)
Server =(local);Initial Catalog=books;User ID =sa;Password =;";
try{
conn.Open();
}catch(error){
Response.Write("数据库连接出错!");
Response.End();
}
var rs = Server.CreateObject("ADODB.RECORDSET");
var PublisherID = Request.QueryString("PublisherID");
rs.Source = "select book.BookTitle from book inner join Publisher ";
rs.Source += "on Publisher.PublisherID = (接下行)
book.bookPublisherID where Publisher.PublisherID = ";
rs.Source += PublisherID;
//Response.Write(rs.Source);
//Response.End();
rs.Open(rs.Source,conn,1,1);
while(!rs.EOF){
Response.Write("<option>" + rs("BookTitle") + "</option>");
rs.MoveNext;
}
%>
http://www.xvdesign.com/ajax/jquery_asp.html
Previous: XHTML CSS网页布局中ID与class的理解应用
Next: 如何编写代码才能更有效率(编程同样适用)
