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（“txtSearch“）;//獲得請求中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“?“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			{
				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（“l?version=\“1.0\“?encoding=\“utf-8\“?>“）;
		buf.append（““）;
		for?（int?i?=?0;?i?			AlbumEO?album?=?（AlbumEO）?v.get（i）;
			buf.append（““）;
			buf.append（““?+?album.getAlbumName（）?+?““）;
			buf.append（““?+?album.getAlbumURL（）?+?““）;
			buf.append（“ription>“?+?album.getAlbumDescription（）
					+?“ription>“）;
			buf.append（““）;
		}
		buf.append（““）;
		return?buf.toString（）;
	}
*/
}

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----

?????文件????????408??2009-12-18?17:36??Suggest\.classpath

?????文件????????294??2011-05-30?17:18??Suggest\.mymetadata

?????文件???????1535??2011-05-31?08:29??Suggest\.project

?????文件???????2684??2011-05-31?16:40??Suggest\WebRoot\ajax_search.js

?????文件???????2157??2011-05-31?16:53??Suggest\WebRoot\db.sql

?????文件???????1117??2011-05-31?16:33??Suggest\WebRoot\suggest.html

?????文件????????650??2011-05-30?17:24??Suggest\WebRoot\WEB-INF\web.xml

?????文件?????236956??2006-05-19?15:20??Suggest\WebRoot\WEB-INF\lib\mysql.jar

?????文件???????3388??2011-05-31?15:26??Suggest\WebRoot\WEB-INF\classes\book\suggest\SearchSuggest.class

?????文件?????????39??2006-05-19?15:20??Suggest\WebRoot\meta-INF\MANIFEST.MF

?????文件???????2844??2011-05-31?15:26??Suggest\src\book\suggest\SearchSuggest.java

?????文件????????500??2011-05-31?08:29??Suggest\.settings\.jsdtscope

?????文件?????????49??2011-05-31?08:29??Suggest\.settings\org.eclipse.wst.jsdt.ui.superType.container

?????文件??????????6??2011-05-31?08:29??Suggest\.settings\org.eclipse.wst.jsdt.ui.superType.name

?????目錄??????????0??2011-05-31?16:53??Suggest\WebRoot\WEB-INF\classes\book\suggest

?????目錄??????????0??2011-05-31?16:53??Suggest\WebRoot\WEB-INF\classes\book

?????目錄??????????0??2011-05-31?16:53??Suggest\WebRoot\WEB-INF\lib

?????目錄??????????0??2011-05-31?16:53??Suggest\WebRoot\WEB-INF\classes

?????目錄??????????0??2011-05-31?16:53??Suggest\src\book\suggest

?????目錄??????????0??2011-05-31?16:53??Suggest\WebRoot\WEB-INF

?????目錄??????????0??2011-05-31?16:53??Suggest\WebRoot\meta-INF

?????目錄??????????0??2011-05-31?16:53??Suggest\src\book

?????目錄??????????0??2011-05-31?16:53??Suggest\WebRoot

?????目錄??????????0??2011-05-31?16:53??Suggest\src

?????目錄??????????0??2011-05-31?16:53??Suggest\.settings

?????目錄??????????0??2011-05-31?16:53??Suggest\.myeclipse

?????目錄??????????0??2011-05-31?16:53??Suggest

-----------?---------??----------?-----??----

???????????????252627????????????????????27



............此處省略0個文件信息