package?com.db;

import?java.sql.SQLException;
import?java.util.ArrayList;
import?java.util.Iterator;
import?java.util.List;

import?org.apache.commons.dbutils.QueryRunner;
import?org.apache.commons.dbutils.handlers.BeanListHandler;
import?com.mchange.v2.c3p0.ComboPooledDataSource;
import?com.tables.Admin;
import?com.util.JDBCUtil;

public?class?Db?{

	//?用于增加，刪除，修改的共用方法只要外部傳進不同的sql語句
	public?boolean?Dql（String?sql）?{

		boolean?pe?=?false;
		try?{
			QueryRunner?runner?=?new?QueryRunner（JDBCUtil.getDataSource（））;//?提供一個數據源
			//?
			int?a?=?runner.update（sql）;
			if?（a?>?0）?{
				pe?=?true;
			}?else?{

				pe?=?false;
			}

		}?catch?（SQLException?e）?{

			throw?new?RuntimeException（e）;

		}
		return?pe;
	}

	//?用于返回數據源的方法，只要外部傳進不同的sql語句和封裝類。

	public?List?getTableList（String?sql?Class?myclass）?{
		List?list?=?new?ArrayList（）;
		QueryRunner?queryRunner?=?new?QueryRunner（JDBCUtil.getDataSource（））;//?需要一個數據源
		try?{
			list?=?（List）?queryRunner.query（sql?new?BeanListHandler（myclass））;
		}?catch?（SQLException?e）?{
			//?TODO?Auto-generated?catch?block
			e.printStackTrace（）;
		}
		return?list;
	}

}

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2013-04-03?22:57??jsp美食網站\
?????目錄???????????0??2013-04-03?22:57??jsp美食網站\BookMeals\
?????文件????????1169??2012-12-27?14:27??jsp美食網站\BookMeals\.classpath
?????目錄???????????0??2013-04-03?22:57??jsp美食網站\BookMeals\.myeclipse\
?????文件?????????300??2012-12-28?12:52??jsp美食網站\BookMeals\.mymetadata
?????文件????????1282??2012-12-27?20:35??jsp美食網站\BookMeals\.project
?????目錄???????????0??2013-04-03?22:57??jsp美食網站\BookMeals\.settings\
?????文件?????????629??2012-12-29?21:59??jsp美食網站\BookMeals\.settings\org.eclipse.jdt.core.prefs
?????目錄???????????0??2013-04-03?22:57??jsp美食網站\BookMeals\WebRoot\
?????目錄???????????0??2013-04-03?22:57??jsp美食網站\BookMeals\WebRoot\meta-INF\
?????文件??????????39??2012-12-27?14:26??jsp美食網站\BookMeals\WebRoot\meta-INF\MANIFEST.MF
?????目錄???????????0??2013-04-03?22:57??jsp美食網站\BookMeals\WebRoot\WEB-INF\
?????目錄???????????0??2013-04-03?22:57??jsp美食網站\BookMeals\WebRoot\WEB-INF\classes\
?????文件?????????534??2012-12-28?20:04??jsp美食網站\BookMeals\WebRoot\WEB-INF\classes\c3p0-config.xml
?????目錄???????????0??2013-04-03?22:57??jsp美食網站\BookMeals\WebRoot\WEB-INF\classes\com\
?????目錄???????????0??2013-04-03?22:57??jsp美食網站\BookMeals\WebRoot\WEB-INF\classes\com\db\
?????文件????????1509??2012-12-29?21:59??jsp美食網站\BookMeals\WebRoot\WEB-INF\classes\com\db\Db.class
?????文件????????2230??2012-12-29?21:59??jsp美食網站\BookMeals\WebRoot\WEB-INF\classes\com\db\DbTest.class
?????目錄???????????0??2013-04-03?22:57??jsp美食網站\BookMeals\WebRoot\WEB-INF\classes\com\hou\
?????目錄???????????0??2013-04-03?22:57??jsp美食網站\BookMeals\WebRoot\WEB-INF\classes\com\hou\servlet\
?????文件????????2057??2012-12-29?21:59??jsp美食網站\BookMeals\WebRoot\WEB-INF\classes\com\hou\servlet\AdminLogin.class
?????文件????????2638??2012-12-30?13:22??jsp美食網站\BookMeals\WebRoot\WEB-INF\classes\com\hou\servlet\CategoriesServlet.class
?????文件????????6578??2012-12-30?13:45??jsp美食網站\BookMeals\WebRoot\WEB-INF\classes\com\hou\servlet\ProductServlet.class
?????文件????????3070??2012-12-30?13:27??jsp美食網站\BookMeals\WebRoot\WEB-INF\classes\com\hou\servlet\TableServlet.class
?????目錄???????????0??2013-04-03?22:57??jsp美食網站\BookMeals\WebRoot\WEB-INF\classes\com\qian\
?????目錄???????????0??2013-04-03?22:57??jsp美食網站\BookMeals\WebRoot\WEB-INF\classes\com\qian\servlet\
?????文件????????2183??2012-12-29?21:59??jsp美食網站\BookMeals\WebRoot\WEB-INF\classes\com\qian\servlet\FindProductServlet.class
?????文件????????1863??2012-12-29?21:59??jsp美食網站\BookMeals\WebRoot\WEB-INF\classes\com\qian\servlet\OrderListServlet.class
?????文件????????1869??2012-12-29?21:59??jsp美食網站\BookMeals\WebRoot\WEB-INF\classes\com\qian\servlet\ProductInfoServlet.class
?????文件?????????310??2012-12-29?21:59??jsp美食網站\BookMeals\WebRoot\WEB-INF\classes\com\qian\servlet\SelectCateServlet.class
?????文件????????1869??2012-12-29?21:59??jsp美食網站\BookMeals\WebRoot\WEB-INF\classes\com\qian\servlet\ShoppingCarServlet.class
............此處省略304個文件信息