package?com.ajax.connection;

import?java.sql.Connection;
import?java.sql.DriverManager;
import?java.sql.PreparedStatement;
import?java.sql.ResultSet;
import?java.sql.SQLException;
import?java.sql.Statement;
import?java.util.ArrayList;
import?java.util.HashMap;
import?java.util.List;

/**
?*?數據庫鏈接，查詢類
?*?對jdbc操作數據庫不懂的可以參考：http://blog.csdn.net/qq_19558705/article/details/49947317
?*?以下內容就不做過多的注釋了
?*?實際業務會采用連接池的方式，這只做學習使用
?*?@author?Administrator
?*
?*/
public?class?ConnectionUtil?{

	private?static?String?url?=?“jdbc:mysql:///test“;
	private?static?String?username?=?“root“;
	private?static?String?password?=?“root“;
	
	public?static?Connection?getConnection（）{
		Connection?connection?=?null;
		try{
			Class.forName（“com.mysql.jdbc.Driver“）;
			connection?=?DriverManager.getConnection（urlusernamepassword）;
			return?connection;
		}catch（Exception?ex）{
			return?null;
		}
	}
	
	public?static?Listject>>?findProvinces（）{
		Connection?connection?=?null;
		Statement?statement?=?null;
		ResultSet?rs?=?null;
		Listject>>?maps?=?null;
		try{
			String?sql?=?“SELECT?idname?FROM?tm_province?order?by?sort?asc“;
			connection?=?getConnection（）;
			statement?=?connection.createStatement（）;
			rs?=?statement.executeQuery（sql）;
			maps?=?new?ArrayListject>>（）;
			HashMapject>?map?=?null;
			while（rs.next（））{
				map?=?new?HashMapject>（）;
				map.put（“id“?rs.getInt（“id“））;
				map.put（“name“?rs.getString（“name“））;
				maps.add（map）;
			}
			return?maps;
		}catch（SQLException?sql）{
			sql.printStackTrace（）;
			return?null;
		}finally{
			try{
				if（rs!=null）rs.close（）;
				if（statement!=null）statement.close（）;
				if（connection!=null）connection.close（）;
			}catch（SQLException?sql）{
				sql.printStackTrace（）;
			}
		}
	}
	
	public?static?Listject>>?findCitys（int?provinceId）{
		Connection?connection?=?null;
		PreparedStatement?statement?=?null;
		ResultSet?rs?=?null;
		Listject>>?maps?=?null;
		try{
			String?sql?=?“SELECT?idname?FROM?tm_city?WHERE?province_id?=??“;
			connection?=?getConnection（）;
			statement?=?connection.prepareStatement（sql）;
			statement.setInt（1?provinceId）;
			rs?=?statement.executeQuery（）;
			maps?=?new?ArrayListject>>（）;
			HashMapject>?map?=?null;
			while（rs.next（））{
				map?=?new?HashMapject>（）;
				map.put（“id“?rs.getInt（“id“））;
				map.put（“name“?rs.getString（“name“））;
				maps.add（map）;
			}
			return?maps;
		}catch（SQLException?sql）{
			sql.printStackTrace（）;
			return?null;
		}finally{
			try{
				if（rs!=null）rs.close（）;
				if（statement!=null）statement.close（）;
				if（connection!=null）connection.close（）;
			}catch（SQLException?sql）{
				sql.printStackTrace（）;
			}
		}
	}
	
	public?static?Listject>>?findAreas（int?cityId）{
		Connection?connection?=?nu

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

?????文件????????841??2015-12-16?16:49??ajaxDemo\.classpath

?????文件???????1041??2015-12-16?16:49??ajaxDemo\.project

?????文件????????503??2015-12-16?16:49??ajaxDemo\.settings\.jsdtscope

?????文件????????364??2015-12-16?16:49??ajaxDemo\.settings\org.eclipse.jdt.core.prefs

?????文件????????476??2015-12-16?16:49??ajaxDemo\.settings\org.eclipse.wst.common.component

?????文件????????345??2015-12-16?16:49??ajaxDemo\.settings\org.eclipse.wst.common.project.facet.core.xml

?????文件?????????49??2015-12-16?16:49??ajaxDemo\.settings\org.eclipse.wst.jsdt.ui.superType.container

?????文件??????????6??2015-12-16?16:49??ajaxDemo\.settings\org.eclipse.wst.jsdt.ui.superType.name

?????文件???????5153??2015-12-16?21:12??ajaxDemo\build\classes\com\ajax\connection\ConnectionUtil.class

?????文件???????2126??2015-12-16?21:30??ajaxDemo\build\classes\com\ajax\dao\AreaServlet.class

?????文件???????2130??2015-12-16?21:29??ajaxDemo\build\classes\com\ajax\dao\CityServlet.class

?????文件???????1882??2015-12-16?21:34??ajaxDemo\build\classes\com\ajax\filter\CharacterFilter.class

?????文件???????3968??2015-12-16?21:12??ajaxDemo\src\com\ajax\connection\ConnectionUtil.java

?????文件???????1299??2015-12-16?21:30??ajaxDemo\src\com\ajax\dao\AreaServlet.java

?????文件???????1490??2015-12-16?21:29??ajaxDemo\src\com\ajax\dao\CityServlet.java

?????文件???????1532??2015-12-16?21:34??ajaxDemo\src\com\ajax\filter\CharacterFilter.java

?????文件????????594??2014-11-01?00:32??ajaxDemo\WebContent\js\.svn\all-wcprops

?????文件????????607??2014-11-01?00:32??ajaxDemo\WebContent\js\.svn\entries

?????文件??????95786??2014-11-01?00:32??ajaxDemo\WebContent\js\.svn\text-base\jquery-1.11.1.min.js.svn-base

?????文件??????95786??2014-11-01?00:32??ajaxDemo\WebContent\js\jquery-1.11.1.min.js

?????文件?????????39??2015-12-16?16:49??ajaxDemo\WebContent\meta-INF\MANIFEST.MF

?????文件???????3422??2015-12-16?21:31??ajaxDemo\WebContent\pages\province.jsp

?????文件???????1192??2015-12-16?21:37??ajaxDemo\WebContent\sql\.svn\all-wcprops

?????文件????????903??2015-12-16?21:37??ajaxDemo\WebContent\sql\.svn\entries

?????文件?????207926??2015-12-16?21:37??ajaxDemo\WebContent\sql\.svn\text-base\tm_area.sql.svn-base

?????文件??????24053??2015-12-16?21:37??ajaxDemo\WebContent\sql\.svn\text-base\tm_city.sql.svn-base

?????文件???????3092??2015-12-16?21:37??ajaxDemo\WebContent\sql\.svn\text-base\tm_province.sql.svn-base

?????文件?????207926??2015-12-16?21:37??ajaxDemo\WebContent\sql\tm_area.sql

?????文件??????24053??2015-12-16?21:37??ajaxDemo\WebContent\sql\tm_city.sql

?????文件???????3092??2015-12-16?21:37??ajaxDemo\WebContent\sql\tm_province.sql

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