package?testajax.area;

import?java.sql.Connection;
import?java.sql.DriverManager;
import?java.sql.ResultSet;
import?java.sql.SQLException;
import?java.sql.Statement;

public?class?DbConn?{
	Connection?conn=null;
	ResultSet??rs=null;
	Statement??stmt=null;
	private?final	String?classdriver=“com.mysql.jdbc.Driver“;
	private?final	String?dbname=“area“;
	private?final	String?user=“root“;
	private?final	String?password=“zhang0817“;
	private?final	String?url=“jdbc:mysql://localhost:3306/“+dbname+“?useSSL=false&serverTimezone=Asia/Shanghai&characterEncoding=utf-8&autoReconnect=true“;
	public?Connection?getconn（）?{
	
		
		try?{
			Class.forName（classdriver）;
			conn=DriverManager.getConnection（url?user?password）;
			//DriverManager.registerDriver（new?com.mysql.cj.jdbc.Driver（））;
			//DriverManager.registerDriver（new?com.mysql.jdbc.Driver（））;
		}?catch?（ClassNotFoundException?e）?{
			//?TODO?Auto-generated?catch?block
			e.printStackTrace（）;
		}?catch?（SQLException?e）?{
			//?TODO?Auto-generated?catch?block
			e.printStackTrace（）;
		}
		return?conn;
	}
	public?ResultSet?quarycity（String?idString?selectid?String?tablename）?{
		String?sql=“select?*?from?“+tablename+“?where?“+selectid+“?=?“+id+“?order?by?id“;
		System.out.println（sql）;
		try?{
			rs=getconn（）.createStatement（）.executeQuery（sql）;
		}?catch?（SQLException?e）?{
			//?TODO?Auto-generated?catch?block
			e.printStackTrace（）;
		}
		return?rs;
	}
	public?ResultSet?quaryProvincial（）?{
		String?sql=“select?*?from?provinces“;
		System.out.println（sql）;
		try?{
			rs=getconn（）.createStatement（）.executeQuery（sql）;
		}?catch?（SQLException?e）?{
			//?TODO?Auto-generated?catch?block
			e.printStackTrace（）;
		}
		return?rs;
	}
	public?String?quaryPCA（String?sql）{
		StringBuffer?sb=new?StringBuffer（）;
		try?{
			rs=getconn（）.createStatement（）.executeQuery（sql）;
			while（rs.next（））?{
				sb.append（rs.getString（“province“））;
				sb.append（rs.getString（“city“））;
				sb.append（rs.getString（“area“））;
			}
		}?catch?（SQLException?e）?{
			//?TODO?Auto-generated?catch?block
			e.printStackTrace（）;
		}
		System.out.println（sb.toString（））;
		close（）;
		return?sb.toString（）;
		
	}
	
	
	public?void?close（）?{
		try?{
			if?（rs!=null）?{
				rs.close（）;;
			}
			if?（conn!=null）?{
				conn.close（）;
			}
			
		}?catch?（Exception?e）?{
			//?TODO:?handle?exception
		}
	}
	public?static?void?main（String[]?args）?{
		DbConn?dbConn=new?DbConn（）;
		ResultSet?rSet=dbConn.quaryProvincial（）;
		try?{
			while?（rSet.next（））?{
				try?{
					System.out.println（rSet.getInt（“pid“）+“:“+rSet.getString（“Provincial“））;
				}?catch?（SQLException?e）?{
					//?TODO?Auto-generated?catch?block
					e.printStackTrace（）;
				}
				
			}
		}?catch?（SQLException?e）?{
			//?TODO?Auto-generated?catch?block
			e.printStackTrace（）;
		}
	}

}