1 jsp:
<html>
<head>
<style type="text/css" media="screen">
//设置body的样式表
body{
font: 11px arial;
}
//提示连接的样式表
.suggest_link{
background-color: #FFFFFF;
}
//鼠标移动到提示上的样式表
.suggest_link_over{
background-color: #E8F2FE;
padding: 2px 6px 2px 6px;
}
//设置显示搜索提示div的样式表
#search_suggest{
position: absolute;
background-color: #E8F2FE;
text-align:left;
border: 10px solid #000000;
}
</style>
</head>
<script language="javascript">
function openXml(url) {
createXMLHttpRequest();
xmlgiftHttp.onreadystatechange = statexmlChange;
xmlgiftHttp.open("GET", url, true);
xmlgiftHttp.send("false");
}
var statexmlChange = function(){
if (xmlgiftHttp.readyState == 4) {
if (xmlgiftHttp.status == 200) {
handle();
} else {
alert("礼品名称重复!");
}
}
}
var xmlgiftHttp;
function createXMLHttpRequest() {
if(window.ActiveXObject) {
xmlgiftHttp = new ActiveXObject("Microsoft.XMLHTTP");
}else{
if(window.XMLHttpRequest) {
xmlgiftHttp = new XMLHttpRequest();
}
}
}
function handle(){
var ss=document.getElementById('search_suggest');
ss.innerHTML='';
var str=xmlgiftHttp.responseText.split(",");
for(i=0;i<str.length-1;i++){
//var suggest='<div>'+str[i]+'</div>';
var suggest='<div οnmοuseοver="javascript:suggestOver(this);"';
suggest +='οnmοuseοut="javascript:suggestOut(this)"';
suggest +='οnclick="javascript:setSearch(this.innerHTML)"';
suggest +='class="suggest_link">' +str[i]+'</div>';
ss.innerHTML +=suggest;
}
}
function chgoogle(){
var el=document.getElementById("google");
var url="/platform/crmfile/addyiftAction.do?";
url+="actionType=getgoogle";
url+="&name="+el.value;
openXml(url);
}
function suggestOver(div_value){
div_value.className='suggest_link_over';
}
function suggestOut(div_value){
div_value.className='suggest_link';
}
function setSearch(div_value){
document.fm.google.value=div_value;
}
</script>
<body>
<div style="width: 500px">
<form name="fm" action="" method="post">
<input type="text" style="width:80%" name="google" id="google" οnkeyup="chgoogle();" value="" maxlength="16">
<input name="endService" type="button" class="button" value="提 交" οnclick="chkInsertBase();" /><br />
<div id="search_suggest">
</div>
</form>
</div>
</body>
</html>
2 java:
public void getgoogle(HttpServletRequest request, HttpServletResponse response)
throws Exception {
PrintWriter out = response.getWriter();
String name = request.getParameter("name");
String returnXml = "";
boolean REPSTYCOD;
String sql1 = "select t.name from category t where 1=1 and t.name like'"+name+"%'";
ResultSet rs1 = new DataBase().executeQuery(sql1);
List list=new ArrayList();
while(rs1.next()){
String a=rs1.getString(1);
returnXml+=a+",";
}
System.out.println(sql1);
System.out.println(rs1);
System.out.println(returnXml);
out.write(returnXml); //返回给xmlgiftHttp.responseText
out.flush();
out.close();
}