package?bookshop;
import?java.sql.*;
public?class?DBHandle?{
	Connection?conn?=?null;
	Statement?stmt?=?null;
	ResultSet?rs?=?null;
	String?urlString?=?“jdbc:mysql://localhost:3306/book“;
	String?user?=?“root“;
	String?pwd?=?“1234“;
	public?DBHandle（）?throws?Exception?{
		Class.forName（“com.mysql.jdbc.Driver“）;
	}
	public?Connection?getConnection（）?throws?Exception?{
		conn?=?DriverManager.getConnection（urlString?user?pwd）;
		return?conn;
	}
	public?void?closeResource（）?{
		try?{
			if?（rs?!=?null）?{
				rs.close（）;
				rs?=?null;
			}
		}?catch?（Exception?ex）?{
			ex.printStackTrace（）;
		}
		try?{
			if?（stmt?!=?null）?{
				stmt.close（）;
				stmt?=?null;
			}
		}?catch?（Exception?ex）?{
			ex.printStackTrace（）;
		}
		try?{
			if?（conn?!=?null）?{
				conn.close（）;
				conn?=?null;
			}
		}?catch?（Exception?ex）?{
			ex.printStackTrace（）;
		}
	}
	public?ResultSet?executeQuery（String?sql）?throws?Exception?{
		conn?=?DriverManager.getConnection（urlString?user?pwd）;
		stmt?=?conn.createStatement（ResultSet.TYPE_SCROLL_INSENSITIVE
				ResultSet.CONCUR_READ_ONLY）;
		rs?=?stmt.executeQuery（sql）;
		return?rs;
	}
	public?int?executeUpdate（String?sql）?throws?Exception?{
		int?result?=?0;
		try?{
			conn?=?DriverManager.getConnection（urlString?user?pwd）;
			stmt?=?conn.createStatement（）;
			result?=?stmt.executeUpdate（sql）;
			return?result;
		}?finally?{
			closeResource（）;
		}
	}
	public?static?void?main（String?args[]）?throws?Exception?{
		DBHandle?h?=?new?DBHandle（）;
		ResultSet?rs?=?h.executeQuery（“select?*?from?book“）;
		rs.next（）;
		System.out.print（rs.getString（8））;
	}
}

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????文件???????24528??2015-05-18?19:26??book.sql
?????目錄???????????0??2015-05-18?19:21??bookshop\
?????文件?????????529??2015-05-18?19:21??bookshop\.classpath
?????目錄???????????0??2016-02-22?11:24??bookshop\.myeclipse\
?????文件?????????297??2015-05-18?19:21??bookshop\.mymetadata
?????文件????????1751??2015-05-18?19:21??bookshop\.project
?????目錄???????????0??2015-05-18?19:21??bookshop\.settings\
?????文件?????????500??2015-05-18?19:21??bookshop\.settings\.jsdtscope
?????文件?????????105??2015-05-18?19:21??bookshop\.settings\com.genuitec.eclipse.core.prefs
?????文件?????????125??2015-05-18?19:21??bookshop\.settings\org.eclipse.core.resources.prefs
?????文件?????????395??2015-05-18?19:21??bookshop\.settings\org.eclipse.jdt.core.prefs
?????文件?????????462??2015-05-18?19:21??bookshop\.settings\org.eclipse.wst.common.component
?????文件?????????252??2015-05-18?19:21??bookshop\.settings\org.eclipse.wst.common.project.facet.core.xml
?????文件??????????49??2015-05-18?19:21??bookshop\.settings\org.eclipse.wst.jsdt.ui.superType.container
?????文件???????????6??2015-05-18?19:21??bookshop\.settings\org.eclipse.wst.jsdt.ui.superType.name
?????目錄???????????0??2015-05-18?19:21??bookshop\WebRoot\
?????目錄???????????0??2015-05-18?19:21??bookshop\WebRoot\meta-INF\
?????文件??????????36??2015-05-18?19:21??bookshop\WebRoot\meta-INF\MANIFEST.MF
?????目錄???????????0??2015-05-18?19:21??bookshop\WebRoot\scripts\
?????目錄???????????0??2015-05-18?19:21??bookshop\WebRoot\scripts\_notes\
?????文件?????????289??2015-05-18?19:21??bookshop\WebRoot\scripts\_notes\dwsync.xml
?????文件?????????773??2015-05-18?19:21??bookshop\WebRoot\scripts\expressInstall.swf
?????文件???????22349??2015-05-18?19:21??bookshop\WebRoot\scripts\swfobject_modified.js
?????目錄???????????0??2015-05-18?19:21??bookshop\WebRoot\WEB-INF\
?????目錄???????????0??2015-05-18?19:21??bookshop\WebRoot\WEB-INF\classes\
?????目錄???????????0??2015-05-18?19:21??bookshop\WebRoot\WEB-INF\classes\bookshop\
?????文件????????2613??2015-05-18?19:21??bookshop\WebRoot\WEB-INF\classes\bookshop\DBHandle.class
?????文件????????5556??2015-05-18?19:21??bookshop\WebRoot\WEB-INF\classes\bookshop\ShoppingCart.class
?????文件?????????642??2015-05-18?19:21??bookshop\WebRoot\WEB-INF\classes\bookshop\ShoppingCartItem.class
?????文件????????3714??2015-05-18?19:21??bookshop\WebRoot\WEB-INF\classes\bookshop\WPage.class
?????目錄???????????0??2015-05-18?19:21??bookshop\WebRoot\WEB-INF\lib\
............此處省略251個文件信息