仿google,百度搜索提示功能

package com; import java.io.IOException; import java.io.PrintWriter; import java.sql.Connection; import java.sql.DriverManager; import java.sql.ResultSet; import java.sql.SQLException; import java.sql.Statement; import java.util.Vector; import javax.servlet.ServletException; import javax.servlet.http.HttpServlet; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; @SuppressWarnings("serial") public class SearchSuggest extends HttpServlet { public void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { this.doPost(request, response); } @SuppressWarnings("unchecked") public void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { request.setCharacterEncoding("GBK"); String sql = ""; String search = request.getParameter("search"); if(search == " "){ sql = "select title from suggest order by title"; } else { //String str = search.trim(); String str = search.replaceAll("^\\s*", ""); sql = "select title from suggest where title like '" + str + "%' order by title"; } Connection conn = null; Statement stmt = null; ResultSet rs = null; Vector vData = new Vector(); response.setContentType("text/xml"); PrintWriter out = response.getWriter(); try { Class.forName("org.gjt.mm.mysql.Driver"); String url = "jdbc:mysql://localhost:3306/acegi"; conn = DriverManager.getConnection(url, "root", "123"); stmt = conn.createStatement(); rs = stmt.executeQuery(sql); while (rs.next()) { vData.add(rs.getString("TITLE")); } StringBuffer buf = new StringBuffer(); for (int i = 0; i < vData.size(); i++) { String keyword = (String) vData.get(i); buf.append(keyword + "\n"); } out.print(buf.toString()); } catch (Exception e) { e.printStackTrace(); System.out.println(e.getMessage()); } finally {// 最后关必记录集，Connection对象 try { if (stmt != null) stmt.close(); if (conn != null) conn.close(); } catch (SQLException sqle) { sqle.printStackTrace(); System.out.println(sqle.getMessage()); } } } }