该楼层疑似违规已被系统折叠 隐藏此楼查看此楼
index.asp
------------------------------------------
无标题文档body {font-size:12px;}
.box {width:600px; height:300px; border:1px solid #666;}
.formbox { margin:30px;}
.keybox {position:relative; height:25px; }
.keybox .data {position:absolute; border:1px solid #ccc; top:23px; display:none; width:200px; height:100px; overflow:auto;line-height:25px;}
.keybox div { height:24px; line-height:24px; border-bottom:1px solid #ddd; cursor:hand; background:#E8E8E8;}
function set(str)
{
$("#keyword").val(str);
$('.data').hide();
$('.data').html('');
}
function get()
{
var num = $("#keyword").val();
if(num == '') return false;
$.get("ajax.asp",{num:num},function(data){
if(data != '')
{
$('.data').show();
$('.data').html(data);
}
else
{
$('.data').hide();
$('.data').html('');
}
});
}
ajax.asp
----------------------------------------
Dim Num
Num = Request("num")
Dim Str
Set Rs = Db.Execute("Select * From Sheet1 Where dh Like '"&Num&"%' ")
If Not Rs.Eof And Not Rs.Bof Then
Do While Not Rs.Eof
Str = Str & "
Rs.MoveNext
Loop
Else
Str = ""
End If
Rs.Close
Response.Clear
Response.CharSet="GB2312"
Response.ContentType="text"
Response.Write(Str)
Response.End()
CloseAllObj
%>