后台生成如下格式:ResultSet rs = BaseDB.getConnection().createStatement()
.executeQuery(sql);
countrys += "[";
while (rs.next()) {
country+="{id:\""+rs.getInt("id")+"\",called:\""+rs.getString("CALLED")+"\"},";
}
countrys+="{id: 'a',called:'a'}";
countrys += "]";
将String放到request:
request.setAttribute("country", "country="+country);
前台:
var country="";
eval(<%=request.getAttribute("country").toString() %>);
绑定文本框事件:
keyword是文本控件ID
$(function() {
$('#keyword').autocomplete(country, {
max: 12, //列表里的条目数
minChars: 0, //自动完成激活之前填入的最小字符
width: 400, //提示的宽度,溢出隐藏
scrollHeight: 300, //提示的高度,溢出显示滚动条
matchContains: false, //包含匹配,就是data参数里的数据,是否只要包含文本框里的数据就显示
autoFill: false, //自动填充
formatItem: function(row, i, max) {
return row.called;
},
formatMatch: function(row, i, max) {
return row.called;
},
formatResult: function(row) {
return row.called;
}
}).result(function(event, row, formatted) {
$("#gj").val(row.id);
});
});