|
- 帖子
- 1
- 主題
- 1
- 精華
- 0
- 積分
- 4
- 威望
- 1
- 金錢
- 1
|
請教JQuery autocomplete問題
各位，請幫忙檢視autocomplete問題，輸入後沒有反應呀，請當忙解惑，謝謝，下列為我的code，感恩
//******
<html>
<head>
<title>AutoComplete</title>
<link href="css/mm/jquery.autocomplete.css" rel="stylesheet" type="text/css" />
<script src="js/mm/jquery-1.9.1.js"></script>
<script src="js/mm/jquery.autocomplete.js"></script>
<script>
$(function()
{
$("#cpn_name").autocomplete({
source:function(request,response)
{
$.ajax({
url:"ajax_get_PkgTitle.jsp",
type:"POST",
dataType:"text",
data:{id:"cpn_name",name:"cpn_name"},
success:function(data){
//Do something with the data here
alert(data);
//response(data);
},
error:function (response){
alert(response.responseText);
},
failure:function (response){
alert(response.responseText)
}
});
},
minLength:1
});
});
</script>
</head>
<body>
<form name="form" method="post">
<input type="text" name="cpn_name" id="cpn_name" >
</form>
</body>
</html>
//******ajax觸發ajax_get_PkgTitle.jsp
ResultSet ms_rs = null;
String name = request.getParameter("cpn_name");
String query_ms_qty = "select * from cpn_data(nolock) Where PkgTitle Like '%"+name+"%' Order By 1";
ms_rs = stmt_ms.executeQuery(query_ms_qty);
ms_rs.last();
int count_ms = ms_rs.getRow();
String pkg_title_list = "";
ms_rs.beforeFirst();
while(ms_rs.next())
{
String x_pkg_title = ms_rs.getString("PkgTitle");
pkg_title_list+=x_pkg_title+"<br>";
}
out.print(pkg_title_list);
ms_rs.close();
con_ms.close(); |
|
發表於 2015-5-22 08:50
|