jQuery+ Asp实现的动态组合框

Published by Sean_Loo at 2008-3-18 with 0 review(s), ? hits. [AJAX]

getData.js:

function doStart(){
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>

组合框初始状态

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

服务器端处理 -> 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;
}
%>
http://www.xvdesign.com/ajax/jquery_asp.html



News and coming

Directories

抓虾 Rojo
google reader bloglines
my yahoo 哪吒

Resources

Status

  • []Writings
  • []Reviews
  • lx-super[A]163.comSean_Loo
鄂ICP备07004579号 Powered by Sean_Loo. All right reserved. W3CSitemap