package?commonDao;

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

/**
?*?抽象的Dao基類
?*?
?*?@author?Administrator
?*?
?*/
public?abstract?class?AbstractDao?{
	/**
	?*?查詢
	?*?
	?*?@param?sql
	?*????????????要執行的查詢語句
	?*?@param?values
	?*????????????要綁定的參數，若無參數，傳遞null
	?*?@return?結果集合，若無結果，則size=0
	?*/
	protected?Listject[]>?query（String?sql?object[]?values）?{
		Connection?conn?=?null;
		PreparedStatement?pstmt?=?null;
		ResultSet?rs?=?null;
		Listject[]>?list?=?new?ArrayListject[]>（）;

		//?向連接池要一個連接
		try?{
			//?conn是連接池中Connection接口的實現類
			conn?=?C3p0DBUtil.getConnection（）;

			pstmt?=?conn.prepareStatement（sql）;

			if?（values?!=?null）?{
				for?（int?i?=?0;?i?					pstmt.setobject（i?+?1?values[i]）;
				}
			}
			rs?=?pstmt.executeQuery（）;
			ResultSetmetaData?metaData?=?rs.getmetaData（）;
			int?columnCount?=?metaData.getColumnCount（）;
			object[]?row?=?null;
			while?（rs.next（））?{
				row?=?new?object[columnCount];
				for?（int?i?=?0;?i?					row[i]?=?rs.getobject（i?+?1）;
				}
				list.add（row）;
			}
		}?catch?（SQLException?e）?{
			e.printStackTrace（）;
		}?finally?{
			if?（rs?!=?null）?{
				try?{
					rs.close（）;
				}?catch?（SQLException?e）?{
					e.printStackTrace（）;
				}
			}
			if?（pstmt?!=?null）?{
				try?{
					pstmt.close（）;
				}?catch?（SQLException?e）?{
					e.printStackTrace（）;
				}
			}
			if?（conn?!=?null）?{
				try?{
					//?使用了連接池后，close（）被覆蓋，實際上將連接還給連接池
					conn.close（）;
				}?catch?（SQLException?e）?{
					e.printStackTrace（）;
				}
			}
		}
		return?list;
	}

	/**
	?*?dml操作
	?*?
	?*?@param?sql
	?*????????????要執行的dml語句
	?*?@param?values
	?*????????????要綁定的參數，若無參數，傳遞null
	?*?@return?dml語句影響的行數
	?*/
	protected?int?dml（String?sql?object[]?values）?{
		Connection?conn?=?null;
		PreparedStatement?pstmt?=?null;
		int?count?=?0;
		//?向連接池要一個連接
		try?{
			//?conn是連接池中Connection接口的實現類
			conn?=?C3p0DBUtil.getConnection（）;

			pstmt?=?conn.prepareStatement（sql）;

			if?（values?!=?null）?{
				for?（int?i?=?0;?i?					pstmt.setobject（i?+?1?values[i]）;
				}
			}

			count?=?pstmt.executeUpdate（）;
		}?catch?（SQLException?e）?{
			e.printStackTrace（）;
		}?finally?{
			if?（pstmt?!=?null）?{
				try?{
					pstmt.close（）;
				}?catch?（SQLException?e）?{
					e.printStackTrace（）;
				}
			}
			if?（conn?!=?null）?{
				try?{
					//?使用了連接池后，close（）被覆蓋，實際上將連接還給連接池
					conn.close（）;
				}?catch?（SQLException?e）?{
					e.printStackTrace（）;
				}
			}
		}
		return?count;
	}
}

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

?????文件????????409??2010-09-20?17:29??源代碼\tallybook\.classpath

?????文件????????385??2010-09-20?15:16??源代碼\tallybook\.project

?????文件?????608376??2010-09-20?17:28??源代碼\tallybook\bin\c3p0-0.9.1.jar

?????文件???????3179??2010-09-29?14:11??源代碼\tallybook\bin\commonDao\AbstractDao.class

?????文件???????3555??2010-09-29?14:11??源代碼\tallybook\bin\commonDao\C3p0DBUtil.class

?????文件???????2809??2010-09-29?14:11??源代碼\tallybook\bin\commonDao\searchDao.class

?????文件???????3994??2010-09-29?14:11??源代碼\tallybook\bin\commonDao\TypeDao.class

?????文件???????5656??2010-09-29?14:11??源代碼\tallybook\bin\commonDao\UserDao.class

?????文件???????3413??2010-09-29?16:54??源代碼\tallybook\bin\dialog_manager\newUser$1.class

?????文件????????770??2010-09-29?16:54??源代碼\tallybook\bin\dialog_manager\newUser$2.class

?????文件???????3997??2010-09-29?16:54??源代碼\tallybook\bin\dialog_manager\newUser.class

?????文件???????3021??2010-09-29?14:57??源代碼\tallybook\bin\dialog_manager\searchUser$1.class

?????文件????????787??2010-09-29?14:57??源代碼\tallybook\bin\dialog_manager\searchUser$2.class

?????文件???????2956??2010-09-29?14:57??源代碼\tallybook\bin\dialog_manager\searchUser.class

?????文件????????809??2010-09-29?14:58??源代碼\tallybook\bin\dialog_manager\updateManager$1.class

?????文件???????1913??2010-09-29?14:58??源代碼\tallybook\bin\dialog_manager\updateManager$2.class

?????文件???????3942??2010-09-29?14:58??源代碼\tallybook\bin\dialog_manager\updateManager.class

?????文件????????791??2010-09-29?14:58??源代碼\tallybook\bin\dialog_manager\updateUser$1.class

?????文件???????1889??2010-09-29?14:58??源代碼\tallybook\bin\dialog_manager\updateUser$2.class

?????文件???????3918??2010-09-29?14:58??源代碼\tallybook\bin\dialog_manager\updateUser.class

?????文件???????2118??2010-09-29?14:58??源代碼\tallybook\bin\dialog_user\addIn$1.class

?????文件????????741??2010-09-29?14:58??源代碼\tallybook\bin\dialog_user\addIn$2.class

?????文件????????931??2010-09-29?14:58??源代碼\tallybook\bin\dialog_user\addIn$3.class

?????文件???????4488??2010-09-29?14:58??源代碼\tallybook\bin\dialog_user\addIn.class

?????文件???????1866??2010-09-29?14:59??源代碼\tallybook\bin\dialog_user\addInType$1.class

?????文件???????2013??2010-09-29?14:59??源代碼\tallybook\bin\dialog_user\addInType.class

?????文件???????2126??2010-09-29?14:59??源代碼\tallybook\bin\dialog_user\addOut$1.class

?????文件????????748??2010-09-29?14:59??源代碼\tallybook\bin\dialog_user\addOut$2.class

?????文件????????937??2010-09-29?14:59??源代碼\tallybook\bin\dialog_user\addOut$3.class

?????文件???????4400??2010-09-29?14:59??源代碼\tallybook\bin\dialog_user\addOut.class

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