package?cn.itcast.chapter10.example;
import?java.sql.Connection;?????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????
import?java.sql.PreparedStatement;
import?java.sql.ResultSet;
import?java.sql.SQLException;
import?org.apache.commons.dbutils.ResultSetHandler;
?public?class?baseDao?{
?	//?優(yōu)化查詢
?	public?static?object?query（String?sql?ResultSetHandler?rsh?
??????????????object...?params）?throws?SQLException?{
?		????Connection?conn?=?null;
?		????PreparedStatement?pstmt?=?null;
?		????ResultSet?rs?=?null;
?		????try?{
?				//?獲得連接
?				conn?=?JDBCUtils.getConnection（）;
?				//?預(yù)編譯sql
?				pstmt?=?conn.prepareStatement（sql）;
?				//?將參數(shù)設(shè)置進(jìn)去
?				for?（int?i?=?0;?params?!=?null?&&?i???????????????????{
?					pstmt.setobject（i?+?1?params[i]）;
?				}
?				//?發(fā)送sql
?				rs?=?pstmt.executeQuery（）;
?				//?讓調(diào)用者去實(shí)現(xiàn)對(duì)結(jié)果集的處理
?				object?obj?=?rsh.handle（rs）;
?				return?obj;
?			}?catch?（Exception?e）?{
?				e.printStackTrace（）;
?			}finally?{
?				//?釋放資源
?				JDBCUtils.release（rs?pstmt?conn）;
?		?	}
?			return?rs;
?		}
?}

?屬性????????????大小?????日期????時(shí)間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2017-04-20?16:22??鏁欐潗婧愮爜\
?????文件???????????0??2017-04-20?16:22??鏁欐潗婧愮爜\絎?0绔?
?????目錄???????????0??2017-04-20?16:22??鏁欐潗婧愮爜\絎?0绔?chapter10\
?????文件????????1257??2016-02-23?15:07??鏁欐潗婧愮爜\絎?0绔?chapter10\.classpath
?????文件????????1042??2016-02-23?10:10??鏁欐潗婧愮爜\絎?0绔?chapter10\.project
?????目錄???????????0??2017-04-20?16:22??鏁欐潗婧愮爜\絎?0绔?chapter10\.settings\
?????文件?????????503??2016-02-23?10:10??鏁欐潗婧愮爜\絎?0绔?chapter10\.settings\.jsdtscope
?????文件?????????395??2016-02-23?10:10??鏁欐潗婧愮爜\絎?0绔?chapter10\.settings\org.eclipse.jdt.core.prefs
?????文件?????????455??2016-02-23?10:10??鏁欐潗婧愮爜\絎?0绔?chapter10\.settings\org.eclipse.wst.common.component
?????文件?????????345??2016-02-23?10:10??鏁欐潗婧愮爜\絎?0绔?chapter10\.settings\org.eclipse.wst.common.project.facet.core.xml
?????文件??????????49??2016-02-23?10:10??鏁欐潗婧愮爜\絎?0绔?chapter10\.settings\org.eclipse.wst.jsdt.ui.superType.container
?????文件???????????6??2016-02-23?10:10??鏁欐潗婧愮爜\絎?0绔?chapter10\.settings\org.eclipse.wst.jsdt.ui.superType.name
?????目錄???????????0??2017-04-20?16:22??鏁欐潗婧愮爜\絎?0绔?chapter10\build\
?????目錄???????????0??2017-04-20?16:22??鏁欐潗婧愮爜\絎?0绔?chapter10\build\classes\
?????文件????????1037??2016-02-23?14:12??鏁欐潗婧愮爜\絎?0绔?chapter10\build\classes\c3p0-config.xml
?????目錄???????????0??2017-04-20?16:22??鏁欐潗婧愮爜\絎?0绔?chapter10\build\classes\cn\
?????目錄???????????0??2017-04-20?16:22??鏁欐潗婧愮爜\絎?0绔?chapter10\build\classes\cn\itcast\
?????目錄???????????0??2017-04-20?16:22??鏁欐潗婧愮爜\絎?0绔?chapter10\build\classes\cn\itcast\chapter10\
?????目錄???????????0??2017-04-20?16:22??鏁欐潗婧愮爜\絎?0绔?chapter10\build\classes\cn\itcast\chapter10\example\
?????文件????????2037??2016-02-23?15:10??鏁欐潗婧愮爜\絎?0绔?chapter10\build\classes\cn\itcast\chapter10\example\baseDao.class
?????文件????????1853??2016-02-23?15:07??鏁欐潗婧愮爜\絎?0绔?chapter10\build\classes\cn\itcast\chapter10\example\Example01.class
?????文件????????2234??2016-02-23?15:07??鏁欐潗婧愮爜\絎?0绔?chapter10\build\classes\cn\itcast\chapter10\example\Example02.class
?????文件????????1491??2016-02-23?15:07??鏁欐潗婧愮爜\絎?0绔?chapter10\build\classes\cn\itcast\chapter10\example\Example03.class
?????文件?????????995??2016-02-23?15:07??鏁欐潗婧愮爜\絎?0绔?chapter10\build\classes\cn\itcast\chapter10\example\Example04.class
?????文件????????1672??2016-02-23?15:07??鏁欐潗婧愮爜\絎?0绔?chapter10\build\classes\cn\itcast\chapter10\example\JDBCUtils.class
?????文件????????1550??2016-02-23?15:13??鏁欐潗婧愮爜\絎?0绔?chapter10\build\classes\cn\itcast\chapter10\example\ResultSetTest1.class
?????文件????????1835??2016-02-23?15:17??鏁欐潗婧愮爜\絎?0绔?chapter10\build\classes\cn\itcast\chapter10\example\ResultSetTest2.class
?????文件????????1288??2016-02-23?15:24??鏁欐潗婧愮爜\絎?0绔?chapter10\build\classes\cn\itcast\chapter10\example\ResultSetTest3.class
?????文件?????????930??2016-02-23?15:10??鏁欐潗婧愮爜\絎?0绔?chapter10\build\classes\cn\itcast\chapter10\example\User.class
?????目錄???????????0??2017-04-20?16:22??鏁欐潗婧愮爜\絎?0绔?chapter10\build\classes\cn\itcast\jdbc\
?????目錄???????????0??2017-04-20?16:22??鏁欐潗婧愮爜\絎?0绔?chapter10\build\classes\cn\itcast\jdbc\demo\
............此處省略1456個(gè)文件信息