springjdbcTemplate源碼剖析

1、springjdbcTemplate源碼 剖析本文淺析spring jdbcTemplate源碼，主展是字習(xí)其沒計用«。模板犋式、巧妙的回調(diào).jdbcTemplate 類結(jié)拘JdbcOpertions execute(Strirg sql)IdbcTenplateexecute(5tring sql)、JdbcOperations:接口定義了方法，如<T>T execute(S!atementCallback<T> action) throws DataAccessException;void execute(Stnng sql) throws DataAcc

2、essExceplion;<T> T query(String sql, ResultSetExtradorcT> rse) throws DataAccessException:、JdbcAccessor:定義了數(shù)據(jù)源。I實現(xiàn)JdbcOperations接口定義的方法二 jdbcTemplatG 橫板攢式1、我們番下execute(StatementCallback<T> action)實現(xiàn)(核心) public <T> T exec ute< St atom entCallback<T> action) throws DataAc

3、cessException ( Assert.naNulHactwnobject must not be null: Cormeclion ccr = DataSourceUtils.getConneclion(getDataScurce()> Slatement stmt = nu>tryCormecton ccxiToUse 番 con;If (this.natrveJdbcExtractor ?= null &&this.nabveJdbcExtractor.isNativeConnectionNecessaryForNativeSlalementsOH co

4、nToUse = ths natrveJdbcExtractor.getNativeConnection(con); stmt = conToUse createStatementO；applyStatementSettrgslstmt);Statement stmtToUse stmtIf (tNs.natrvJdbcExtractornuli> stmtToUse «Ite.nativeJdbcExtractor.getNatrveStatementlstnitl；T resuk aclion.doinSlatement(slmtToUse); f/ 回ithandleWa

5、rn4ngs(stim)：rrtum result; catch (SOLException w) JdDclXiis.ck»eState<nent(stmt);stmt nul;DalaSourceUiils.re4easeConnection(con getDataSource);con - null;throw gotExceptionTranslatarO.translatofStatofnontCallback*, gatSql(action). ex|;finally (JdbcUtils ck»eSutetnentistmt)：DataSouceUlil

6、s.re4eMeConnection(con. getDataSourceO);2s 內(nèi)看下 execute(String sql> 源碼public vod exBCUtefinai Stnng sq|) throws DataAccessException (rf (logger isDe<xigEnab*od()| logger debugCExeculing SQL statement sql 丁)； class ExaculeSlatementCallback implomenls Sta1ementCallback<Ot|ect>. SqIPrwider |

7、 O/em(Jepubic Object dolnStalefnent(Stalement stmt) throws SQLException stmt execute<sql): /I JAVA jdbc return nUI;O0mdepublic Smog getSql()(return 城executelnew ExecuteSta：ementCallback(); / ift!用上ifT execute(StaiefnentCailback<T> acticxM由此.可以知遍，我們平時常用的xGeut(final String sql)方法，茌SS我們做了很多事情.

8、如創(chuàng)建默認(rèn)的ExecutoSiatementCallback.采 用回調(diào)的方式.由模板去執(zhí)行sql,關(guān)閉鏈接3、T query (final Stnng sql, final ResultSetExtractor<T> rse)源碼實現(xiàn)EOvemdopublic <T> T query (final String sql. final Res uit Set E x trac tor<T > rsej throws DataAccessException Assert notNulHsqi. 'SOL must not be nur)： Assert

9、.notNuIHrse. -ResunSetExtractor must not De null");if (loggerjsDetxjgEnabled() logger deOugExecuting SOL query sql 門；class QuefySlatementCallback implements StatefnentCallback<T>. ScProvder |Oemc»public T dolnStatemernfStatement stmt) throws SOLExcepnon ( ResultSet rs « nuK;t<

10、;yrs « slmt.executeOuefy(sql); ResultSet rsToUse rs;tt (nativeJdbcExtractor， nul) |nToUse ruitrvcfcx:Extractor.o«NativeResuitSGt(rsj： Ireturn rse extractData(rsToUse);fnaly( JdbcUiils.claseResuhSet(rs);Oemctepublic Stnng getSql()(return 的： > return executftnew Query Statement Cal lback(

11、);View Code4、update(final String sql)源碼public mt update(final String sql) throws DataAccessException Assert notNullfsqi *SOL must not be nulO:"ower. * s DeOugE nawed() UloggefSQL update sql class UpdateStaiomentCaitoack implements StmementCaiiMckcimegeo. SqiProvKMf (Xemdepublic Integer dolnStafement(S!atement stmt) throws SQLException ( imt rows stmi.execjteUpdatMsqO：i