searchsuggest.java

《精通AJAX》光盘 要求： JDK1.4.2 以上版本 数据库采用MySQL 4.1.4 以上版本 服务器采用Tomcat 5 以上版本 开发工具采用Eclipse 3.0

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/search";
			//创建Connection对象
			conn = DriverManager.getConnection(url, "root", "");
			// 创建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();
	}
*/
}