package?com.guotu.biz;

/*?數據訪問組件?*/

import?java.sql.*;

public?class?DBPool?{
	private?static?String[]?props?=?{?“com.mysql.jdbc.Driver“
			“jdbc:mysql://127.0.0.1:3306/guotu“?“root“?“198684“?};
	//?1、加載驅動?
	static?{
		try?{
			Class.forName（props[0]）;
		}?catch?（Exception?e）?{
			e.printStackTrace（）;
		}
	}

	//?2、獲取連接
	public?static?Connection?getConnection（）?{
		Connection?con?=?null;
		try?{
			con?=?DriverManager.getConnection（props[1]?props[2]?props[3]）;
		}?catch?（Exception?e）?{
			e.printStackTrace（）;
		}
		return?con;
	}

	//?3、釋放資源
	public?static?void?release（object?o）?{
		try?{
			if?（o?instanceof?ResultSet）?{
				（（ResultSet）?o）.close（）;
			}?else?if?（o?instanceof?Statement）?{
				（（Statement）?o）.close（）;
			}?else?if?（o?instanceof?Connection）?{
				（（Connection）?o）.close（）;
			}
		}?catch?（Exception?e）?{
			e.printStackTrace（）;
		}
	}

	public?static?void?release（ResultSet?rs?Statement?stmt?Connection?con）?{
		if?（rs?!=?null）?{
			try?{
				rs.close（）;
			}?catch?（Exception?e）?{
				e.printStackTrace（）;
			}
		}

		if?（stmt?!=?null）?{
			try?{
				stmt.close（）;
			}?catch?（Exception?e）?{
				e.printStackTrace（）;
			}
		}

		if?（con?!=?null）?{
			try?{
				con.close（）;
			}?catch?（Exception?e）?{
				e.printStackTrace（）;
			}
		}

	}

	public?static?void?printRs（ResultSet?rs）?{
		if?（rs?==?null）
			return;
		try?{
			ResultSetmetaData?md?=?rs.getmetaData（）;
			int?num?=?md.getColumnCount（）;
			StringBuffer?sb?=?new?StringBuffer（）;
			for?（int?i?=?1;?i?<=?num;?i++）?{
				int?size?=?md.getColumnDisplaySize（i）;
				if?（size?!=?0）?{
					String?cname?=?md.getColumnName（i）;
					int?blank?=?（size?-?cname.length（））?/?2;
					for?（int?j?=?0;?j?						sb.append（“?“）;
					sb.append（cname）;
					if?（（size?-?cname.length（））?%?2?!=?0）
						blank++;
					for?（int?j?=?0;?j?						sb.append（“?“）;
				}
			}
			sb.append（“\n“）;
			while?（rs.next（））?{
				for?（int?i?=?1;?i?<=?num;?i++）?{
					int?size?=?md.getColumnDisplaySize（i）;
					if?（size?!=?0）?{
						String?value?=?rs.getString（i）;
						int?blank?=?（size?-?value.length（））?/?2;
						for?（int?j?=?0;?j?							sb.append（“?“）;
						sb.append（value）;
						if?（（size?-?value.length（））?%?2?!=?0）
							blank++;
						for?（int?j?=?0;?j?							sb.append（“?“）;
					}
				}
				sb.append（“\n“）;
			}
			System.out.println（sb.toString（））;
		}?catch?（Exception?e）?{
			e.printStackTrace（）;
		}
	}
}

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2014-01-08?13:52??（國土資源局網站）\
?????目錄???????????0??2014-01-05?15:11??（國土資源局網站）\guotu\
?????文件????????2301??2009-01-02?00:19??（國土資源局網站）\guotu\.classpath
?????文件?????????381??2008-11-13?16:01??（國土資源局網站）\guotu\.project
?????目錄???????????0??2013-12-30?21:19??（國土資源局網站）\guotu\DT_inc\
?????目錄???????????0??2013-12-30?21:19??（國土資源局網站）\guotu\DT_inc\Editor\
?????目錄???????????0??2013-12-30?21:19??（國土資源局網站）\guotu\DT_inc\Editor\buttonimage\
?????目錄???????????0??2013-12-30?21:19??（國土資源局網站）\guotu\DT_inc\Editor\buttonimage\standard\
?????文件??????????92??2011-11-15?02:21??（國土資源局網站）\guotu\DT_inc\Editor\buttonimage\standard\about.gif
?????文件??????????98??2011-11-15?02:21??（國土資源局網站）\guotu\DT_inc\Editor\buttonimage\standard\abspos.gif
?????文件?????????273??2011-11-15?02:21??（國土資源局網站）\guotu\DT_inc\Editor\buttonimage\standard\anchor.gif
?????文件?????????175??2011-11-15?02:21??（國土資源局網站）\guotu\DT_inc\Editor\buttonimage\standard\backcolor.gif
?????文件?????????108??2011-11-15?02:21??（國土資源局網站）\guotu\DT_inc\Editor\buttonimage\standard\backward.gif
?????文件?????????177??2011-11-15?02:21??（國土資源局網站）\guotu\DT_inc\Editor\buttonimage\standard\bgcolor.gif
?????文件?????????127??2011-11-15?02:21??（國土資源局網站）\guotu\DT_inc\Editor\buttonimage\standard\bgpic.gif
?????文件??????????89??2011-11-15?02:21??（國土資源局網站）\guotu\DT_inc\Editor\buttonimage\standard\blink.gif
?????文件??????????77??2011-11-15?02:21??（國土資源局網站）\guotu\DT_inc\Editor\buttonimage\standard\bold.gif
?????文件?????????226??2011-11-15?02:21??（國土資源局網站）\guotu\DT_inc\Editor\buttonimage\standard\br.gif
?????文件??????????72??2011-11-15?02:21??（國土資源局網站）\guotu\DT_inc\Editor\buttonimage\standard\checked.gif
?????文件?????????211??2011-11-15?02:21??（國土資源局網站）\guotu\DT_inc\Editor\buttonimage\standard\code.gif
?????文件?????????113??2011-11-15?02:21??（國土資源局網站）\guotu\DT_inc\Editor\buttonimage\standard\copy.gif
?????文件?????????136??2011-11-15?02:21??（國土資源局網站）\guotu\DT_inc\Editor\buttonimage\standard\createlink.gif
?????文件??????????94??2011-11-15?02:21??（國土資源局網站）\guotu\DT_inc\Editor\buttonimage\standard\cut.gif
?????文件?????????586??2011-11-15?02:21??（國土資源局網站）\guotu\DT_inc\Editor\buttonimage\standard\date.gif
?????文件??????????96??2011-11-15?02:21??（國土資源局網站）\guotu\DT_inc\Editor\buttonimage\standard\delete.gif
?????文件?????????114??2011-11-15?02:21??（國土資源局網站）\guotu\DT_inc\Editor\buttonimage\standard\emot.gif
?????文件?????????145??2011-11-15?02:21??（國土資源局網站）\guotu\DT_inc\Editor\buttonimage\standard\excel.gif
?????文件??????????92??2011-11-15?02:21??（國土資源局網站）\guotu\DT_inc\Editor\buttonimage\standard\fieldset.gif
?????文件????????1058??2011-11-15?02:21??（國土資源局網站）\guotu\DT_inc\Editor\buttonimage\standard\file.gif
?????文件?????????107??2011-11-15?02:21??（國土資源局網站）\guotu\DT_inc\Editor\buttonimage\standard\findreplace.gif
?????文件?????????405??2011-11-15?02:21??（國土資源局網站）\guotu\DT_inc\Editor\buttonimage\standard\flash.gif
............此處省略1245個文件信息