test.htmlCode
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<meta http-equiv="Content-Type"content="text/html; charset=utf-8" />
<head>
<link rel="stylesheet" href="jquery.autocomplete.css" type="text/css" />
<script src="jquery-latest.js"></script>
<script type="text/javascript" src="jquery.autocomplete.js"></script>
<script>
function findValue(li) {
if( li == null )
return alert("No match!");
if( !!li.extra )
var sValue = li.extra[0];
else
var sValue = li.selectValue;
}
function selectItem(li) {
findValue(li);
}
function formatItem(row) {
return row[0] ;
}
$(document).ready(function(){
$("#example").autocomplete("test.asp",{
delay:10,
minChars:0,
matchSubset:0,
matchContains:1,
cacheLength:10,
onItemSelect:selectItem,
onFindValue:findValue,
formatItem:formatItem,
autoFill:true
});
});
</script>
</head>
<body>
<input id="example" size="50"/>
</body>
</html>
test.aspCode
<%
Response.ContentType = "text/html"
Response.Charset = "UTF-8"
set conn = Server.CreateObject("Adodb.Connection")
conn.ConnectionString="Provider=SQLOLEDB; Data Source=192.168.1.20;UID=sa; PWD=123456; Initial Catalog=turbocms_6008;"
conn.Open
Sql_str="SELECT id,keyword FROM cms_content where keyword like '%"& request.QueryString("q") &"%'"
set rs=server.createobject("adodb.recordset")
rs.open Sql_str,conn,1,3
do while not rs.eof
datas = datas & rs("keyword") &vbCrLf
rs.MoveNext
loop
response.Write (datas)
%>
源碼下載Asp+jQuery.autocomplete.js