autocomplete.java

Ajax实现页面自动搜索

package pack;

import java.io.IOException;
import java.io.PrintWriter;
import javax.servlet.ServletConfig;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import java.sql.ResultSet;


public class AutoComplete extends HttpServlet {
    
	public void init(ServletConfig config) throws ServletException {
    }
    
    
    public void doGet(HttpServletRequest request, HttpServletResponse response)
    throws ServletException, IOException {
    	//设置接收信息的字符集
    	request.setCharacterEncoding("UTF-8");
    	
    	//请求参数
    	String action = request.getParameter("action");
    	String name = request.getParameter("names");
    	if(name!=null) {
    		name = new String(name.getBytes("ISO-8859-1"),"GB2312");
    	}
        response.setContentType("text/xml; charset=UTF-8");
        response.setHeader("Cache-Control", "no-cache");
        //创建输出流对象
        PrintWriter out = response.getWriter();
        out.println("<response>");
        
        DataAccess db = new DataAccess();
    	ResultSet rs = null;
    	String strSql = null;
    	//匹配
    	if("match".equals(action)) {
    		strSql = "select * from Computer where name like '" + name + "%'";
    		rs = db.query(strSql);
    		try {
	    		while(rs.next()) {
	    			out.println("<res>" + rs.getString("name") + "</res>");
	    		}
		    }
		    catch (Exception ex) {
		    	ex.printStackTrace();
		    }
    	} else if("search".equals(action)) {
    		strSql = "select * from Computer where name='" + name + "'";
    		rs = db.query(strSql);
    		try {
	    		if(rs.next()) {
	    			out.println("<res>" + rs.getString("description") + "</res>");
	    		}
		    }
		    catch (Exception ex) {
		    	ex.printStackTrace();
		    }
    	}
        out.println("</response>");
		out.close();
    }
    /*
     *  处理<POST> 请求方法.
     */
    public void doPost(HttpServletRequest request, HttpServletResponse response)
    throws ServletException, IOException {
       doGet(request, response);
    }
}