package?com.web.dao;

import?java.sql.Connection;
import?java.sql.PreparedStatement;
import?java.sql.ResultSet;
import?java.sql.SQLException;

import?com.web.util.DBUtil;

public?class?CityDAO?{

	
	public?String[]?getCity（String?city）{
		String[]?res?=?null;
		String?sql?=?“select?cityson?from?t_city?where?city?=??“;
		Connection?conn?=?DBUtil.getCon（）;
		PreparedStatement?pst?=?null;
		ResultSet?rs?=?null;
		try?{
			pst?=?conn.prepareStatement（sql）;
			pst.setString（1?city）;
			rs?=?pst.executeQuery（）;
			if（rs.next（））{
				res?=?rs.getString（“cityson“）.split（““）;
			}
		}?catch?（SQLException?e）?{
			//?TODO?Auto-generated?catch?block
			e.printStackTrace（）;
		}
		return?res;
	}
	
	
}

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

?????文件????????399??2013-04-27?21:36??用Java代碼實現二級聯動\city.sql

?????文件????????529??2013-04-27?20:56??用Java代碼實現二級聯動\webcity\.classpath

?????文件????????294??2013-04-27?20:56??用Java代碼實現二級聯動\webcity\.mymetadata

?????文件???????1750??2013-04-27?21:26??用Java代碼實現二級聯動\webcity\.project

?????文件????????493??2013-04-27?20:56??用Java代碼實現二級聯動\webcity\.settings\.jsdtscope

?????文件????????395??2013-04-27?20:56??用Java代碼實現二級聯動\webcity\.settings\org.eclipse.jdt.core.prefs

?????文件????????459??2013-04-27?20:56??用Java代碼實現二級聯動\webcity\.settings\org.eclipse.wst.common.component

?????文件????????252??2013-04-27?20:56??用Java代碼實現二級聯動\webcity\.settings\org.eclipse.wst.common.project.facet.core.xml

?????文件?????????49??2013-04-27?20:56??用Java代碼實現二級聯動\webcity\.settings\org.eclipse.wst.jsdt.ui.superType.container

?????文件??????????6??2013-04-27?20:56??用Java代碼實現二級聯動\webcity\.settings\org.eclipse.wst.jsdt.ui.superType.name

?????文件????????733??2013-04-27?21:35??用Java代碼實現二級聯動\webcity\src\com\web\dao\CityDAO.java

?????文件????????376??2013-04-27?21:35??用Java代碼實現二級聯動\webcity\src\com\web\dwr\City.java

?????文件????????655??2013-04-27?20:58??用Java代碼實現二級聯動\webcity\src\com\web\util\DBUtil.java

?????文件???????1662??2013-04-27?21:32??用Java代碼實現二級聯動\webcity\WebRoot\city.jsp

?????文件????????834??2013-04-27?20:56??用Java代碼實現二級聯動\webcity\WebRoot\index.jsp

?????文件???????1412??2013-04-27?21:35??用Java代碼實現二級聯動\webcity\WebRoot\WEB-INF\classes\com\web\dao\CityDAO.class

?????文件????????664??2013-04-27?21:35??用Java代碼實現二級聯動\webcity\WebRoot\WEB-INF\classes\com\web\dwr\City.class

?????文件???????1170??2013-04-27?20:58??用Java代碼實現二級聯動\webcity\WebRoot\WEB-INF\classes\com\web\util\DBUtil.class

?????文件????????341??2013-04-27?21:28??用Java代碼實現二級聯動\webcity\WebRoot\WEB-INF\dwr.xml

?????文件????1590041??2013-04-27?20:57??用Java代碼實現二級聯動\webcity\WebRoot\WEB-INF\lib\classes12.jar

?????文件??????38015??2013-04-27?20:57??用Java代碼實現二級聯動\webcity\WebRoot\WEB-INF\lib\commons-logging.jar

?????文件????1188586??2013-04-27?20:57??用Java代碼實現二級聯動\webcity\WebRoot\WEB-INF\lib\dwr.jar

?????文件?????????36??2013-04-27?20:56??用Java代碼實現二級聯動\webcity\WebRoot\WEB-INF\meta-INF\MANIFEST.MF

?????文件????????803??2013-04-27?21:20??用Java代碼實現二級聯動\webcity\WebRoot\WEB-INF\web.xml

?????目錄??????????0??2013-04-27?21:36??用Java代碼實現二級聯動\webcity\WebRoot\WEB-INF\classes\com\web\dao

?????目錄??????????0??2013-04-27?21:36??用Java代碼實現二級聯動\webcity\WebRoot\WEB-INF\classes\com\web\dwr

?????目錄??????????0??2013-04-27?21:36??用Java代碼實現二級聯動\webcity\WebRoot\WEB-INF\classes\com\web\util

?????目錄??????????0??2013-04-27?21:36??用Java代碼實現二級聯動\webcity\WebRoot\WEB-INF\classes\com\web

?????目錄??????????0??2013-04-27?21:36??用Java代碼實現二級聯動\webcity\src\com\web\dao

?????目錄??????????0??2013-04-27?21:36??用Java代碼實現二級聯動\webcity\src\com\web\dwr

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