ajax+mysql+jsp仿google搜索匹配

package book.suggest; 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; public class SearchSuggest extends HttpServlet { public void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, java.io.IOException { String search = request.getParameter("search");//获得请求中cate的值 //定义查询数据库的SQL语句 String sql = "select title from suggest where title like '"+search+"%' order by title"; Connection conn = null;//声明Connection对象 Statement stmt = null;//声明Statement对象 ResultSet rs = null;//声明ResultSet对象 Vector vData = new Vector(); //response.setContentType("text/xml");//设置返回数据类型为xml格式 java.io.PrintWriter out = response.getWriter(); try { // 加载数据库驱动类 Class.forName("com.mysql.jdbc.Driver"); // 访问数据库的地址 String url = "jdbc:mysql://localhost:3306/test"; //创建Connection对象 conn = DriverManager.getConnection(url, "root", "821208"); // 创建Statement对象 stmt = conn.createStatement(); // 执行SQL语句，返回记录集 rs = stmt.executeQuery(sql); //定义AblumEO实体对象 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()); // out.print(parasToXML(vData));//调用parasToXML()方法 } catch (Exception e) { e.printStackTrace(); } finally {//最后关必记录集，Connection对象 try { // this will close any associated ResultSets if (stmt != null) stmt.close(); if (conn != null) conn.close(); } catch (SQLException sqle) { } } } public void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, java.io.IOException { doPost(request, response); } /* public String parasToXML(Vector v) {// 该方法将数据转化成XML格式输出 StringBuffer buf = new StringBuffer(); buf.append("<?xml version=\"1.0\" encoding=\"utf-8\"?>"); buf.append("<pictures>"); for (int i = 0; i < v.size(); i++) { AlbumEO album = (AlbumEO) v.get(i); buf.append("<item>"); buf.append("<name>" + album.getAlbumName() + "</name>"); buf.append("<url>" + album.getAlbumURL() + "</url>"); buf.append("<description>" + album.getAlbumDescription() + "</description>"); buf.append("</item>"); } buf.append("</pictures>"); return buf.toString(); } */ }