package?dao;

import?java.sql.Connection;
import?java.sql.PreparedStatement;
import?java.sql.ResultSet;
import?java.util.ArrayList;
import?java.util.List;

import?po.Worker;

import?util.DBUtil;

public?class?SearchFromMySql?{
	@SuppressWarnings（“unchecked“）
	public?static?List?findInfo（String?kwd）{
		List?list?=?new?ArrayList（）;
		Connection?conn?=?null;
		PreparedStatement?ps?=?null;
		ResultSet?rs?=?null;
		try?{
			conn?=?DBUtil.getConn（）;
			String?sql?=?“select?distinct?name?from?worker?where?name?like??“;
			ps?=?conn.prepareStatement（sql）;
			ps.setString（1（kwd+“%“））;
			rs?=?ps.executeQuery（）;
			while（rs.next（））{
				Worker?w?=?new?Worker（）;
				w.setName（rs.getString（“name“））;
				list.add（w）;
			}
			
		}?catch?（Exception?e）?{
			e.printStackTrace（）;
		}?finally{
			DBUtil.close（conn?ps?rs）;
		}
		return?list;
	}
	/*
	@SuppressWarnings（“unchecked“）
	public?static?void?main（String[]?args）?{
		List?list?=?findInfo（“李“）;
		for?（int?i?=?0;?i?			Worker?w?=?（Worker）list.get（i）;
			System.out.println（w.getName（））;
		}
	}
	*/
}

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

?????文件????????525??2012-12-07?17:06??baidudemo\.classpath

?????文件????????301??2012-12-07?21:44??baidudemo\.mymetadata

?????文件???????1415??2012-12-07?21:05??baidudemo\.project

?????文件????????500??2012-12-07?17:05??baidudemo\.settings\.jsdtscope

?????文件???????1040??2012-12-07?21:44??baidudemo\.settings\com.genuitec.eclipse.j2eedt.core.prefs

?????文件?????????49??2012-12-07?17:05??baidudemo\.settings\org.eclipse.wst.jsdt.ui.superType.container

?????文件??????????6??2012-12-07?17:05??baidudemo\.settings\org.eclipse.wst.jsdt.ui.superType.name

?????文件???????1125??2012-12-08?00:02??baidudemo\src\dao\SearchFromMySql.java

?????文件????????960??2012-12-07?22:49??baidudemo\src\dao\SearchTheOne.java

?????文件????????590??2012-12-06?22:54??baidudemo\src\po\Worker.java

?????文件???????1215??2012-12-07?23:29??baidudemo\src\searchinfos\ShowResult.java

?????文件???????1286??2012-12-07?21:28??baidudemo\src\suggestionlist\SuggestionServlet.java

?????文件???????1107??2012-12-06?15:36??baidudemo\src\util\DBUtil.java

?????文件???????3681??2012-12-07?23:23??baidudemo\WebRoot\baidu.jsp

?????文件???????1032??2012-12-06?21:35??baidudemo\WebRoot\js\ajaxutils.js

?????文件?????????36??2012-12-07?17:05??baidudemo\WebRoot\meta-INF\MANIFEST.MF

?????文件????????893??2012-12-07?23:05??baidudemo\WebRoot\notexist.jsp

?????文件???????1401??2012-12-07?23:53??baidudemo\WebRoot\show.jsp

?????文件???????2017??2012-12-08?00:02??baidudemo\WebRoot\WEB-INF\classes\dao\SearchFromMySql.class

?????文件???????1950??2012-12-07?22:49??baidudemo\WebRoot\WEB-INF\classes\dao\SearchTheOne.class

?????文件???????1132??2012-12-07?21:25??baidudemo\WebRoot\WEB-INF\classes\po\Worker.class

?????文件???????1917??2012-12-07?23:29??baidudemo\WebRoot\WEB-INF\classes\searchinfos\ShowResult.class

?????文件???????1998??2012-12-07?21:28??baidudemo\WebRoot\WEB-INF\classes\suggestionlist\SuggestionServlet.class

?????文件???????1634??2012-12-07?21:20??baidudemo\WebRoot\WEB-INF\classes\util\DBUtil.class

?????文件?????189285??2012-12-06?16:14??baidudemo\WebRoot\WEB-INF\lib\gson-2.2.2.jar

?????文件?????767492??2012-12-06?17:46??baidudemo\WebRoot\WEB-INF\lib\mysql-connector-java-5.1.13.jar

?????文件????????948??2012-12-07?22:29??baidudemo\WebRoot\WEB-INF\web.xml

?????目錄??????????0??2012-12-07?22:48??baidudemo\WebRoot\WEB-INF\classes\dao

?????目錄??????????0??2012-12-07?21:25??baidudemo\WebRoot\WEB-INF\classes\po

?????目錄??????????0??2012-12-07?22:29??baidudemo\WebRoot\WEB-INF\classes\searchinfos

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