commons-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From brit...@apache.org
Subject svn commit: r916835 [36/41] - in /websites/production/commons/content/proper/commons-dbutils: ./ apidocs/ apidocs/org/apache/commons/dbutils/ apidocs/org/apache/commons/dbutils/class-use/ apidocs/org/apache/commons/dbutils/handlers/ apidocs/org/apache/...
Date Sun, 20 Jul 2014 08:52:25 GMT
Modified: websites/production/commons/content/proper/commons-dbutils/xref/org/apache/commons/dbutils/AbstractQueryRunner.html
==============================================================================
--- websites/production/commons/content/proper/commons-dbutils/xref/org/apache/commons/dbutils/AbstractQueryRunner.html (original)
+++ websites/production/commons/content/proper/commons-dbutils/xref/org/apache/commons/dbutils/AbstractQueryRunner.html Sun Jul 20 08:52:20 2014
@@ -183,299 +183,300 @@
 <a class="jxr_linenumber" name="L175" href="#L175">175</a> <em class="jxr_javadoccomment">     * @return An initialized &lt;code&gt;PreparedStatement&lt;/code&gt;.</em>
 <a class="jxr_linenumber" name="L176" href="#L176">176</a> <em class="jxr_javadoccomment">     * @throws SQLException</em>
 <a class="jxr_linenumber" name="L177" href="#L177">177</a> <em class="jxr_javadoccomment">     *             if a database access error occurs</em>
-<a class="jxr_linenumber" name="L178" href="#L178">178</a> <em class="jxr_javadoccomment">     */</em>
-<a class="jxr_linenumber" name="L179" href="#L179">179</a>     <strong class="jxr_keyword">protected</strong> PreparedStatement prepareStatement(Connection conn, String sql, <strong class="jxr_keyword">int</strong> returnedKeys)
-<a class="jxr_linenumber" name="L180" href="#L180">180</a>             <strong class="jxr_keyword">throws</strong> SQLException {
-<a class="jxr_linenumber" name="L181" href="#L181">181</a> 
-<a class="jxr_linenumber" name="L182" href="#L182">182</a>         <strong class="jxr_keyword">return</strong> conn.prepareStatement(sql, returnedKeys);
-<a class="jxr_linenumber" name="L183" href="#L183">183</a>     }
-<a class="jxr_linenumber" name="L184" href="#L184">184</a> 
-<a class="jxr_linenumber" name="L185" href="#L185">185</a>     <em class="jxr_javadoccomment">/**</em>
-<a class="jxr_linenumber" name="L186" href="#L186">186</a> <em class="jxr_javadoccomment">     * Factory method that creates and initializes a &lt;code&gt;Connection&lt;/code&gt;</em>
-<a class="jxr_linenumber" name="L187" href="#L187">187</a> <em class="jxr_javadoccomment">     * object. &lt;code&gt;QueryRunner&lt;/code&gt; methods always call this method to</em>
-<a class="jxr_linenumber" name="L188" href="#L188">188</a> <em class="jxr_javadoccomment">     * retrieve connections from its DataSource. Subclasses can override this</em>
-<a class="jxr_linenumber" name="L189" href="#L189">189</a> <em class="jxr_javadoccomment">     * method to provide special &lt;code&gt;Connection&lt;/code&gt; configuration if</em>
-<a class="jxr_linenumber" name="L190" href="#L190">190</a> <em class="jxr_javadoccomment">     * needed. This implementation simply calls &lt;code&gt;ds.getConnection()&lt;/code&gt;.</em>
-<a class="jxr_linenumber" name="L191" href="#L191">191</a> <em class="jxr_javadoccomment">     *</em>
-<a class="jxr_linenumber" name="L192" href="#L192">192</a> <em class="jxr_javadoccomment">     * @return An initialized &lt;code&gt;Connection&lt;/code&gt;.</em>
-<a class="jxr_linenumber" name="L193" href="#L193">193</a> <em class="jxr_javadoccomment">     * @throws SQLException</em>
-<a class="jxr_linenumber" name="L194" href="#L194">194</a> <em class="jxr_javadoccomment">     *             if a database access error occurs</em>
-<a class="jxr_linenumber" name="L195" href="#L195">195</a> <em class="jxr_javadoccomment">     * @since DbUtils 1.1</em>
-<a class="jxr_linenumber" name="L196" href="#L196">196</a> <em class="jxr_javadoccomment">     */</em>
-<a class="jxr_linenumber" name="L197" href="#L197">197</a>     <strong class="jxr_keyword">protected</strong> Connection prepareConnection() <strong class="jxr_keyword">throws</strong> SQLException {
-<a class="jxr_linenumber" name="L198" href="#L198">198</a>         <strong class="jxr_keyword">if</strong> (<strong class="jxr_keyword">this</strong>.getDataSource() == <strong class="jxr_keyword">null</strong>) {
-<a class="jxr_linenumber" name="L199" href="#L199">199</a>             <strong class="jxr_keyword">throw</strong> <strong class="jxr_keyword">new</strong> SQLException(
-<a class="jxr_linenumber" name="L200" href="#L200">200</a>                     <span class="jxr_string">"QueryRunner requires a DataSource to be "</span>
-<a class="jxr_linenumber" name="L201" href="#L201">201</a>                             + <span class="jxr_string">"invoked in this way, or a Connection should be passed in"</span>);
-<a class="jxr_linenumber" name="L202" href="#L202">202</a>         }
-<a class="jxr_linenumber" name="L203" href="#L203">203</a>         <strong class="jxr_keyword">return</strong> <strong class="jxr_keyword">this</strong>.getDataSource().getConnection();
-<a class="jxr_linenumber" name="L204" href="#L204">204</a>     }
-<a class="jxr_linenumber" name="L205" href="#L205">205</a> 
-<a class="jxr_linenumber" name="L206" href="#L206">206</a>     <em class="jxr_javadoccomment">/**</em>
-<a class="jxr_linenumber" name="L207" href="#L207">207</a> <em class="jxr_javadoccomment">     * Fill the &lt;code&gt;PreparedStatement&lt;/code&gt; replacement parameters with the</em>
-<a class="jxr_linenumber" name="L208" href="#L208">208</a> <em class="jxr_javadoccomment">     * given objects.</em>
-<a class="jxr_linenumber" name="L209" href="#L209">209</a> <em class="jxr_javadoccomment">     *</em>
-<a class="jxr_linenumber" name="L210" href="#L210">210</a> <em class="jxr_javadoccomment">     * @param stmt</em>
-<a class="jxr_linenumber" name="L211" href="#L211">211</a> <em class="jxr_javadoccomment">     *            PreparedStatement to fill</em>
-<a class="jxr_linenumber" name="L212" href="#L212">212</a> <em class="jxr_javadoccomment">     * @param params</em>
-<a class="jxr_linenumber" name="L213" href="#L213">213</a> <em class="jxr_javadoccomment">     *            Query replacement parameters; &lt;code&gt;null&lt;/code&gt; is a valid</em>
-<a class="jxr_linenumber" name="L214" href="#L214">214</a> <em class="jxr_javadoccomment">     *            value to pass in.</em>
-<a class="jxr_linenumber" name="L215" href="#L215">215</a> <em class="jxr_javadoccomment">     * @throws SQLException</em>
-<a class="jxr_linenumber" name="L216" href="#L216">216</a> <em class="jxr_javadoccomment">     *             if a database access error occurs</em>
-<a class="jxr_linenumber" name="L217" href="#L217">217</a> <em class="jxr_javadoccomment">     */</em>
-<a class="jxr_linenumber" name="L218" href="#L218">218</a>     <strong class="jxr_keyword">public</strong> <strong class="jxr_keyword">void</strong> fillStatement(PreparedStatement stmt, Object... params)
-<a class="jxr_linenumber" name="L219" href="#L219">219</a>             <strong class="jxr_keyword">throws</strong> SQLException {
-<a class="jxr_linenumber" name="L220" href="#L220">220</a> 
-<a class="jxr_linenumber" name="L221" href="#L221">221</a>         <em class="jxr_comment">// check the parameter count, if we can</em>
-<a class="jxr_linenumber" name="L222" href="#L222">222</a>         ParameterMetaData pmd = <strong class="jxr_keyword">null</strong>;
-<a class="jxr_linenumber" name="L223" href="#L223">223</a>         <strong class="jxr_keyword">if</strong> (!pmdKnownBroken) {
-<a class="jxr_linenumber" name="L224" href="#L224">224</a>             pmd = stmt.getParameterMetaData();
-<a class="jxr_linenumber" name="L225" href="#L225">225</a>             <strong class="jxr_keyword">int</strong> stmtCount = pmd.getParameterCount();
-<a class="jxr_linenumber" name="L226" href="#L226">226</a>             <strong class="jxr_keyword">int</strong> paramsCount = params == <strong class="jxr_keyword">null</strong> ? 0 : params.length;
-<a class="jxr_linenumber" name="L227" href="#L227">227</a> 
-<a class="jxr_linenumber" name="L228" href="#L228">228</a>             <strong class="jxr_keyword">if</strong> (stmtCount != paramsCount) {
-<a class="jxr_linenumber" name="L229" href="#L229">229</a>                 <strong class="jxr_keyword">throw</strong> <strong class="jxr_keyword">new</strong> SQLException(<span class="jxr_string">"Wrong number of parameters: expected "</span>
-<a class="jxr_linenumber" name="L230" href="#L230">230</a>                         + stmtCount + <span class="jxr_string">", was given "</span> + paramsCount);
-<a class="jxr_linenumber" name="L231" href="#L231">231</a>             }
-<a class="jxr_linenumber" name="L232" href="#L232">232</a>         }
-<a class="jxr_linenumber" name="L233" href="#L233">233</a> 
-<a class="jxr_linenumber" name="L234" href="#L234">234</a>         <em class="jxr_comment">// nothing to do here</em>
-<a class="jxr_linenumber" name="L235" href="#L235">235</a>         <strong class="jxr_keyword">if</strong> (params == <strong class="jxr_keyword">null</strong>) {
-<a class="jxr_linenumber" name="L236" href="#L236">236</a>             <strong class="jxr_keyword">return</strong>;
-<a class="jxr_linenumber" name="L237" href="#L237">237</a>         }
-<a class="jxr_linenumber" name="L238" href="#L238">238</a> 
-<a class="jxr_linenumber" name="L239" href="#L239">239</a>         <strong class="jxr_keyword">for</strong> (<strong class="jxr_keyword">int</strong> i = 0; i &lt; params.length; i++) {
-<a class="jxr_linenumber" name="L240" href="#L240">240</a>             <strong class="jxr_keyword">if</strong> (params[i] != <strong class="jxr_keyword">null</strong>) {
-<a class="jxr_linenumber" name="L241" href="#L241">241</a>                 stmt.setObject(i + 1, params[i]);
-<a class="jxr_linenumber" name="L242" href="#L242">242</a>             } <strong class="jxr_keyword">else</strong> {
-<a class="jxr_linenumber" name="L243" href="#L243">243</a>                 <em class="jxr_comment">// VARCHAR works with many drivers regardless</em>
-<a class="jxr_linenumber" name="L244" href="#L244">244</a>                 <em class="jxr_comment">// of the actual column type. Oddly, NULL and</em>
-<a class="jxr_linenumber" name="L245" href="#L245">245</a>                 <em class="jxr_comment">// OTHER don't work with Oracle's drivers.</em>
-<a class="jxr_linenumber" name="L246" href="#L246">246</a>                 <strong class="jxr_keyword">int</strong> sqlType = Types.VARCHAR;
-<a class="jxr_linenumber" name="L247" href="#L247">247</a>                 <strong class="jxr_keyword">if</strong> (!pmdKnownBroken) {
-<a class="jxr_linenumber" name="L248" href="#L248">248</a>                     <strong class="jxr_keyword">try</strong> {
-<a class="jxr_linenumber" name="L249" href="#L249">249</a>                         <em class="jxr_comment">/*</em>
-<a class="jxr_linenumber" name="L250" href="#L250">250</a> <em class="jxr_comment">                         * It's not possible for pmdKnownBroken to change from</em>
-<a class="jxr_linenumber" name="L251" href="#L251">251</a> <em class="jxr_comment">                         * true to false, (once true, always true) so pmd cannot</em>
-<a class="jxr_linenumber" name="L252" href="#L252">252</a> <em class="jxr_comment">                         * be null here.</em>
-<a class="jxr_linenumber" name="L253" href="#L253">253</a> <em class="jxr_comment">                         */</em>
-<a class="jxr_linenumber" name="L254" href="#L254">254</a>                         sqlType = pmd.getParameterType(i + 1);
-<a class="jxr_linenumber" name="L255" href="#L255">255</a>                     } <strong class="jxr_keyword">catch</strong> (SQLException e) {
-<a class="jxr_linenumber" name="L256" href="#L256">256</a>                         pmdKnownBroken = <strong class="jxr_keyword">true</strong>;
-<a class="jxr_linenumber" name="L257" href="#L257">257</a>                     }
-<a class="jxr_linenumber" name="L258" href="#L258">258</a>                 }
-<a class="jxr_linenumber" name="L259" href="#L259">259</a>                 stmt.setNull(i + 1, sqlType);
-<a class="jxr_linenumber" name="L260" href="#L260">260</a>             }
-<a class="jxr_linenumber" name="L261" href="#L261">261</a>         }
-<a class="jxr_linenumber" name="L262" href="#L262">262</a>     }
-<a class="jxr_linenumber" name="L263" href="#L263">263</a> 
-<a class="jxr_linenumber" name="L264" href="#L264">264</a>     <em class="jxr_javadoccomment">/**</em>
-<a class="jxr_linenumber" name="L265" href="#L265">265</a> <em class="jxr_javadoccomment">     * Fill the &lt;code&gt;PreparedStatement&lt;/code&gt; replacement parameters with the</em>
-<a class="jxr_linenumber" name="L266" href="#L266">266</a> <em class="jxr_javadoccomment">     * given object's bean property values.</em>
-<a class="jxr_linenumber" name="L267" href="#L267">267</a> <em class="jxr_javadoccomment">     *</em>
-<a class="jxr_linenumber" name="L268" href="#L268">268</a> <em class="jxr_javadoccomment">     * @param stmt</em>
-<a class="jxr_linenumber" name="L269" href="#L269">269</a> <em class="jxr_javadoccomment">     *            PreparedStatement to fill</em>
-<a class="jxr_linenumber" name="L270" href="#L270">270</a> <em class="jxr_javadoccomment">     * @param bean</em>
-<a class="jxr_linenumber" name="L271" href="#L271">271</a> <em class="jxr_javadoccomment">     *            a JavaBean object</em>
-<a class="jxr_linenumber" name="L272" href="#L272">272</a> <em class="jxr_javadoccomment">     * @param properties</em>
-<a class="jxr_linenumber" name="L273" href="#L273">273</a> <em class="jxr_javadoccomment">     *            an ordered array of properties; this gives the order to insert</em>
-<a class="jxr_linenumber" name="L274" href="#L274">274</a> <em class="jxr_javadoccomment">     *            values in the statement</em>
-<a class="jxr_linenumber" name="L275" href="#L275">275</a> <em class="jxr_javadoccomment">     * @throws SQLException</em>
-<a class="jxr_linenumber" name="L276" href="#L276">276</a> <em class="jxr_javadoccomment">     *             if a database access error occurs</em>
-<a class="jxr_linenumber" name="L277" href="#L277">277</a> <em class="jxr_javadoccomment">     */</em>
-<a class="jxr_linenumber" name="L278" href="#L278">278</a>     <strong class="jxr_keyword">public</strong> <strong class="jxr_keyword">void</strong> fillStatementWithBean(PreparedStatement stmt, Object bean,
-<a class="jxr_linenumber" name="L279" href="#L279">279</a>             PropertyDescriptor[] properties) <strong class="jxr_keyword">throws</strong> SQLException {
-<a class="jxr_linenumber" name="L280" href="#L280">280</a>         Object[] params = <strong class="jxr_keyword">new</strong> Object[properties.length];
-<a class="jxr_linenumber" name="L281" href="#L281">281</a>         <strong class="jxr_keyword">for</strong> (<strong class="jxr_keyword">int</strong> i = 0; i &lt; properties.length; i++) {
-<a class="jxr_linenumber" name="L282" href="#L282">282</a>             PropertyDescriptor property = properties[i];
-<a class="jxr_linenumber" name="L283" href="#L283">283</a>             Object value = <strong class="jxr_keyword">null</strong>;
-<a class="jxr_linenumber" name="L284" href="#L284">284</a>             Method method = property.getReadMethod();
-<a class="jxr_linenumber" name="L285" href="#L285">285</a>             <strong class="jxr_keyword">if</strong> (method == <strong class="jxr_keyword">null</strong>) {
-<a class="jxr_linenumber" name="L286" href="#L286">286</a>                 <strong class="jxr_keyword">throw</strong> <strong class="jxr_keyword">new</strong> RuntimeException(<span class="jxr_string">"No read method for bean property "</span>
-<a class="jxr_linenumber" name="L287" href="#L287">287</a>                         + bean.getClass() + <span class="jxr_string">" "</span> + property.getName());
-<a class="jxr_linenumber" name="L288" href="#L288">288</a>             }
-<a class="jxr_linenumber" name="L289" href="#L289">289</a>             <strong class="jxr_keyword">try</strong> {
-<a class="jxr_linenumber" name="L290" href="#L290">290</a>                 value = method.invoke(bean, <strong class="jxr_keyword">new</strong> Object[0]);
-<a class="jxr_linenumber" name="L291" href="#L291">291</a>             } <strong class="jxr_keyword">catch</strong> (InvocationTargetException e) {
-<a class="jxr_linenumber" name="L292" href="#L292">292</a>                 <strong class="jxr_keyword">throw</strong> <strong class="jxr_keyword">new</strong> RuntimeException(<span class="jxr_string">"Couldn't invoke method: "</span> + method,
-<a class="jxr_linenumber" name="L293" href="#L293">293</a>                         e);
-<a class="jxr_linenumber" name="L294" href="#L294">294</a>             } <strong class="jxr_keyword">catch</strong> (IllegalArgumentException e) {
-<a class="jxr_linenumber" name="L295" href="#L295">295</a>                 <strong class="jxr_keyword">throw</strong> <strong class="jxr_keyword">new</strong> RuntimeException(
-<a class="jxr_linenumber" name="L296" href="#L296">296</a>                         <span class="jxr_string">"Couldn't invoke method with 0 arguments: "</span> + method, e);
-<a class="jxr_linenumber" name="L297" href="#L297">297</a>             } <strong class="jxr_keyword">catch</strong> (IllegalAccessException e) {
-<a class="jxr_linenumber" name="L298" href="#L298">298</a>                 <strong class="jxr_keyword">throw</strong> <strong class="jxr_keyword">new</strong> RuntimeException(<span class="jxr_string">"Couldn't invoke method: "</span> + method,
-<a class="jxr_linenumber" name="L299" href="#L299">299</a>                         e);
-<a class="jxr_linenumber" name="L300" href="#L300">300</a>             }
-<a class="jxr_linenumber" name="L301" href="#L301">301</a>             params[i] = value;
-<a class="jxr_linenumber" name="L302" href="#L302">302</a>         }
-<a class="jxr_linenumber" name="L303" href="#L303">303</a>         fillStatement(stmt, params);
-<a class="jxr_linenumber" name="L304" href="#L304">304</a>     }
-<a class="jxr_linenumber" name="L305" href="#L305">305</a> 
-<a class="jxr_linenumber" name="L306" href="#L306">306</a>     <em class="jxr_javadoccomment">/**</em>
-<a class="jxr_linenumber" name="L307" href="#L307">307</a> <em class="jxr_javadoccomment">     * Fill the &lt;code&gt;PreparedStatement&lt;/code&gt; replacement parameters with the</em>
-<a class="jxr_linenumber" name="L308" href="#L308">308</a> <em class="jxr_javadoccomment">     * given object's bean property values.</em>
-<a class="jxr_linenumber" name="L309" href="#L309">309</a> <em class="jxr_javadoccomment">     *</em>
-<a class="jxr_linenumber" name="L310" href="#L310">310</a> <em class="jxr_javadoccomment">     * @param stmt</em>
-<a class="jxr_linenumber" name="L311" href="#L311">311</a> <em class="jxr_javadoccomment">     *            PreparedStatement to fill</em>
-<a class="jxr_linenumber" name="L312" href="#L312">312</a> <em class="jxr_javadoccomment">     * @param bean</em>
-<a class="jxr_linenumber" name="L313" href="#L313">313</a> <em class="jxr_javadoccomment">     *            A JavaBean object</em>
-<a class="jxr_linenumber" name="L314" href="#L314">314</a> <em class="jxr_javadoccomment">     * @param propertyNames</em>
-<a class="jxr_linenumber" name="L315" href="#L315">315</a> <em class="jxr_javadoccomment">     *            An ordered array of property names (these should match the</em>
-<a class="jxr_linenumber" name="L316" href="#L316">316</a> <em class="jxr_javadoccomment">     *            getters/setters); this gives the order to insert values in the</em>
-<a class="jxr_linenumber" name="L317" href="#L317">317</a> <em class="jxr_javadoccomment">     *            statement</em>
-<a class="jxr_linenumber" name="L318" href="#L318">318</a> <em class="jxr_javadoccomment">     * @throws SQLException</em>
-<a class="jxr_linenumber" name="L319" href="#L319">319</a> <em class="jxr_javadoccomment">     *             If a database access error occurs</em>
-<a class="jxr_linenumber" name="L320" href="#L320">320</a> <em class="jxr_javadoccomment">     */</em>
-<a class="jxr_linenumber" name="L321" href="#L321">321</a>     <strong class="jxr_keyword">public</strong> <strong class="jxr_keyword">void</strong> fillStatementWithBean(PreparedStatement stmt, Object bean,
-<a class="jxr_linenumber" name="L322" href="#L322">322</a>             String... propertyNames) <strong class="jxr_keyword">throws</strong> SQLException {
-<a class="jxr_linenumber" name="L323" href="#L323">323</a>         PropertyDescriptor[] descriptors;
-<a class="jxr_linenumber" name="L324" href="#L324">324</a>         <strong class="jxr_keyword">try</strong> {
-<a class="jxr_linenumber" name="L325" href="#L325">325</a>             descriptors = Introspector.getBeanInfo(bean.getClass())
-<a class="jxr_linenumber" name="L326" href="#L326">326</a>                     .getPropertyDescriptors();
-<a class="jxr_linenumber" name="L327" href="#L327">327</a>         } <strong class="jxr_keyword">catch</strong> (IntrospectionException e) {
-<a class="jxr_linenumber" name="L328" href="#L328">328</a>             <strong class="jxr_keyword">throw</strong> <strong class="jxr_keyword">new</strong> RuntimeException(<span class="jxr_string">"Couldn't introspect bean "</span>
-<a class="jxr_linenumber" name="L329" href="#L329">329</a>                     + bean.getClass().toString(), e);
-<a class="jxr_linenumber" name="L330" href="#L330">330</a>         }
-<a class="jxr_linenumber" name="L331" href="#L331">331</a>         PropertyDescriptor[] sorted = <strong class="jxr_keyword">new</strong> PropertyDescriptor[propertyNames.length];
-<a class="jxr_linenumber" name="L332" href="#L332">332</a>         <strong class="jxr_keyword">for</strong> (<strong class="jxr_keyword">int</strong> i = 0; i &lt; propertyNames.length; i++) {
-<a class="jxr_linenumber" name="L333" href="#L333">333</a>             String propertyName = propertyNames[i];
-<a class="jxr_linenumber" name="L334" href="#L334">334</a>             <strong class="jxr_keyword">if</strong> (propertyName == <strong class="jxr_keyword">null</strong>) {
-<a class="jxr_linenumber" name="L335" href="#L335">335</a>                 <strong class="jxr_keyword">throw</strong> <strong class="jxr_keyword">new</strong> NullPointerException(<span class="jxr_string">"propertyName can't be null: "</span>
-<a class="jxr_linenumber" name="L336" href="#L336">336</a>                         + i);
-<a class="jxr_linenumber" name="L337" href="#L337">337</a>             }
-<a class="jxr_linenumber" name="L338" href="#L338">338</a>             <strong class="jxr_keyword">boolean</strong> found = false;
-<a class="jxr_linenumber" name="L339" href="#L339">339</a>             <strong class="jxr_keyword">for</strong> (<strong class="jxr_keyword">int</strong> j = 0; j &lt; descriptors.length; j++) {
-<a class="jxr_linenumber" name="L340" href="#L340">340</a>                 PropertyDescriptor descriptor = descriptors[j];
-<a class="jxr_linenumber" name="L341" href="#L341">341</a>                 <strong class="jxr_keyword">if</strong> (propertyName.equals(descriptor.getName())) {
-<a class="jxr_linenumber" name="L342" href="#L342">342</a>                     sorted[i] = descriptor;
-<a class="jxr_linenumber" name="L343" href="#L343">343</a>                     found = <strong class="jxr_keyword">true</strong>;
-<a class="jxr_linenumber" name="L344" href="#L344">344</a>                     <strong class="jxr_keyword">break</strong>;
-<a class="jxr_linenumber" name="L345" href="#L345">345</a>                 }
-<a class="jxr_linenumber" name="L346" href="#L346">346</a>             }
-<a class="jxr_linenumber" name="L347" href="#L347">347</a>             <strong class="jxr_keyword">if</strong> (!found) {
-<a class="jxr_linenumber" name="L348" href="#L348">348</a>                 <strong class="jxr_keyword">throw</strong> <strong class="jxr_keyword">new</strong> RuntimeException(<span class="jxr_string">"Couldn't find bean property: "</span>
-<a class="jxr_linenumber" name="L349" href="#L349">349</a>                         + bean.getClass() + <span class="jxr_string">" "</span> + propertyName);
-<a class="jxr_linenumber" name="L350" href="#L350">350</a>             }
-<a class="jxr_linenumber" name="L351" href="#L351">351</a>         }
-<a class="jxr_linenumber" name="L352" href="#L352">352</a>         fillStatementWithBean(stmt, bean, sorted);
-<a class="jxr_linenumber" name="L353" href="#L353">353</a>     }
-<a class="jxr_linenumber" name="L354" href="#L354">354</a> 
-<a class="jxr_linenumber" name="L355" href="#L355">355</a>     <em class="jxr_javadoccomment">/**</em>
-<a class="jxr_linenumber" name="L356" href="#L356">356</a> <em class="jxr_javadoccomment">     * Throws a new exception with a more informative error message.</em>
-<a class="jxr_linenumber" name="L357" href="#L357">357</a> <em class="jxr_javadoccomment">     *</em>
-<a class="jxr_linenumber" name="L358" href="#L358">358</a> <em class="jxr_javadoccomment">     * @param cause</em>
-<a class="jxr_linenumber" name="L359" href="#L359">359</a> <em class="jxr_javadoccomment">     *            The original exception that will be chained to the new</em>
-<a class="jxr_linenumber" name="L360" href="#L360">360</a> <em class="jxr_javadoccomment">     *            exception when it's rethrown.</em>
-<a class="jxr_linenumber" name="L361" href="#L361">361</a> <em class="jxr_javadoccomment">     *</em>
-<a class="jxr_linenumber" name="L362" href="#L362">362</a> <em class="jxr_javadoccomment">     * @param sql</em>
-<a class="jxr_linenumber" name="L363" href="#L363">363</a> <em class="jxr_javadoccomment">     *            The query that was executing when the exception happened.</em>
-<a class="jxr_linenumber" name="L364" href="#L364">364</a> <em class="jxr_javadoccomment">     *</em>
-<a class="jxr_linenumber" name="L365" href="#L365">365</a> <em class="jxr_javadoccomment">     * @param params</em>
-<a class="jxr_linenumber" name="L366" href="#L366">366</a> <em class="jxr_javadoccomment">     *            The query replacement parameters; &lt;code&gt;null&lt;/code&gt; is a valid</em>
-<a class="jxr_linenumber" name="L367" href="#L367">367</a> <em class="jxr_javadoccomment">     *            value to pass in.</em>
-<a class="jxr_linenumber" name="L368" href="#L368">368</a> <em class="jxr_javadoccomment">     *</em>
-<a class="jxr_linenumber" name="L369" href="#L369">369</a> <em class="jxr_javadoccomment">     * @throws SQLException</em>
-<a class="jxr_linenumber" name="L370" href="#L370">370</a> <em class="jxr_javadoccomment">     *             if a database access error occurs</em>
-<a class="jxr_linenumber" name="L371" href="#L371">371</a> <em class="jxr_javadoccomment">     */</em>
-<a class="jxr_linenumber" name="L372" href="#L372">372</a>     <strong class="jxr_keyword">protected</strong> <strong class="jxr_keyword">void</strong> rethrow(SQLException cause, String sql, Object... params)
-<a class="jxr_linenumber" name="L373" href="#L373">373</a>             <strong class="jxr_keyword">throws</strong> SQLException {
-<a class="jxr_linenumber" name="L374" href="#L374">374</a> 
-<a class="jxr_linenumber" name="L375" href="#L375">375</a>         String causeMessage = cause.getMessage();
-<a class="jxr_linenumber" name="L376" href="#L376">376</a>         <strong class="jxr_keyword">if</strong> (causeMessage == <strong class="jxr_keyword">null</strong>) {
-<a class="jxr_linenumber" name="L377" href="#L377">377</a>             causeMessage = <span class="jxr_string">""</span>;
-<a class="jxr_linenumber" name="L378" href="#L378">378</a>         }
-<a class="jxr_linenumber" name="L379" href="#L379">379</a>         StringBuffer msg = <strong class="jxr_keyword">new</strong> StringBuffer(causeMessage);
-<a class="jxr_linenumber" name="L380" href="#L380">380</a> 
-<a class="jxr_linenumber" name="L381" href="#L381">381</a>         msg.append(<span class="jxr_string">" Query: "</span>);
-<a class="jxr_linenumber" name="L382" href="#L382">382</a>         msg.append(sql);
-<a class="jxr_linenumber" name="L383" href="#L383">383</a>         msg.append(<span class="jxr_string">" Parameters: "</span>);
-<a class="jxr_linenumber" name="L384" href="#L384">384</a> 
-<a class="jxr_linenumber" name="L385" href="#L385">385</a>         <strong class="jxr_keyword">if</strong> (params == <strong class="jxr_keyword">null</strong>) {
-<a class="jxr_linenumber" name="L386" href="#L386">386</a>             msg.append(<span class="jxr_string">"[]"</span>);
-<a class="jxr_linenumber" name="L387" href="#L387">387</a>         } <strong class="jxr_keyword">else</strong> {
-<a class="jxr_linenumber" name="L388" href="#L388">388</a>             msg.append(Arrays.deepToString(params));
-<a class="jxr_linenumber" name="L389" href="#L389">389</a>         }
-<a class="jxr_linenumber" name="L390" href="#L390">390</a> 
-<a class="jxr_linenumber" name="L391" href="#L391">391</a>         SQLException e = <strong class="jxr_keyword">new</strong> SQLException(msg.toString(), cause.getSQLState(),
-<a class="jxr_linenumber" name="L392" href="#L392">392</a>                 cause.getErrorCode());
-<a class="jxr_linenumber" name="L393" href="#L393">393</a>         e.setNextException(cause);
-<a class="jxr_linenumber" name="L394" href="#L394">394</a> 
-<a class="jxr_linenumber" name="L395" href="#L395">395</a>         <strong class="jxr_keyword">throw</strong> e;
-<a class="jxr_linenumber" name="L396" href="#L396">396</a>     }
-<a class="jxr_linenumber" name="L397" href="#L397">397</a> 
-<a class="jxr_linenumber" name="L398" href="#L398">398</a>     <em class="jxr_javadoccomment">/**</em>
-<a class="jxr_linenumber" name="L399" href="#L399">399</a> <em class="jxr_javadoccomment">     * Wrap the &lt;code&gt;ResultSet&lt;/code&gt; in a decorator before processing it. This</em>
-<a class="jxr_linenumber" name="L400" href="#L400">400</a> <em class="jxr_javadoccomment">     * implementation returns the &lt;code&gt;ResultSet&lt;/code&gt; it is given without any</em>
-<a class="jxr_linenumber" name="L401" href="#L401">401</a> <em class="jxr_javadoccomment">     * decoration.</em>
-<a class="jxr_linenumber" name="L402" href="#L402">402</a> <em class="jxr_javadoccomment">     *</em>
-<a class="jxr_linenumber" name="L403" href="#L403">403</a> <em class="jxr_javadoccomment">     * &lt;p&gt;</em>
-<a class="jxr_linenumber" name="L404" href="#L404">404</a> <em class="jxr_javadoccomment">     * Often, the implementation of this method can be done in an anonymous</em>
-<a class="jxr_linenumber" name="L405" href="#L405">405</a> <em class="jxr_javadoccomment">     * inner class like this:</em>
-<a class="jxr_linenumber" name="L406" href="#L406">406</a> <em class="jxr_javadoccomment">     * &lt;/p&gt;</em>
-<a class="jxr_linenumber" name="L407" href="#L407">407</a> <em class="jxr_javadoccomment">     *</em>
-<a class="jxr_linenumber" name="L408" href="#L408">408</a> <em class="jxr_javadoccomment">     * &lt;pre&gt;</em>
-<a class="jxr_linenumber" name="L409" href="#L409">409</a> <em class="jxr_javadoccomment">     * QueryRunner run = new QueryRunner() {</em>
-<a class="jxr_linenumber" name="L410" href="#L410">410</a> <em class="jxr_javadoccomment">     *     protected ResultSet wrap(ResultSet rs) {</em>
-<a class="jxr_linenumber" name="L411" href="#L411">411</a> <em class="jxr_javadoccomment">     *         return StringTrimmedResultSet.wrap(rs);</em>
-<a class="jxr_linenumber" name="L412" href="#L412">412</a> <em class="jxr_javadoccomment">     *     }</em>
-<a class="jxr_linenumber" name="L413" href="#L413">413</a> <em class="jxr_javadoccomment">     * };</em>
-<a class="jxr_linenumber" name="L414" href="#L414">414</a> <em class="jxr_javadoccomment">     * &lt;/pre&gt;</em>
-<a class="jxr_linenumber" name="L415" href="#L415">415</a> <em class="jxr_javadoccomment">     *</em>
-<a class="jxr_linenumber" name="L416" href="#L416">416</a> <em class="jxr_javadoccomment">     * @param rs</em>
-<a class="jxr_linenumber" name="L417" href="#L417">417</a> <em class="jxr_javadoccomment">     *            The &lt;code&gt;ResultSet&lt;/code&gt; to decorate; never</em>
-<a class="jxr_linenumber" name="L418" href="#L418">418</a> <em class="jxr_javadoccomment">     *            &lt;code&gt;null&lt;/code&gt;.</em>
-<a class="jxr_linenumber" name="L419" href="#L419">419</a> <em class="jxr_javadoccomment">     * @return The &lt;code&gt;ResultSet&lt;/code&gt; wrapped in some decorator.</em>
-<a class="jxr_linenumber" name="L420" href="#L420">420</a> <em class="jxr_javadoccomment">     */</em>
-<a class="jxr_linenumber" name="L421" href="#L421">421</a>     <strong class="jxr_keyword">protected</strong> ResultSet wrap(ResultSet rs) {
-<a class="jxr_linenumber" name="L422" href="#L422">422</a>         <strong class="jxr_keyword">return</strong> rs;
-<a class="jxr_linenumber" name="L423" href="#L423">423</a>     }
-<a class="jxr_linenumber" name="L424" href="#L424">424</a> 
-<a class="jxr_linenumber" name="L425" href="#L425">425</a>     <em class="jxr_javadoccomment">/**</em>
-<a class="jxr_linenumber" name="L426" href="#L426">426</a> <em class="jxr_javadoccomment">     * Close a &lt;code&gt;Connection&lt;/code&gt;. This implementation avoids closing if</em>
-<a class="jxr_linenumber" name="L427" href="#L427">427</a> <em class="jxr_javadoccomment">     * null and does &lt;strong&gt;not&lt;/strong&gt; suppress any exceptions. Subclasses</em>
-<a class="jxr_linenumber" name="L428" href="#L428">428</a> <em class="jxr_javadoccomment">     * can override to provide special handling like logging.</em>
-<a class="jxr_linenumber" name="L429" href="#L429">429</a> <em class="jxr_javadoccomment">     *</em>
-<a class="jxr_linenumber" name="L430" href="#L430">430</a> <em class="jxr_javadoccomment">     * @param conn</em>
-<a class="jxr_linenumber" name="L431" href="#L431">431</a> <em class="jxr_javadoccomment">     *            Connection to close</em>
-<a class="jxr_linenumber" name="L432" href="#L432">432</a> <em class="jxr_javadoccomment">     * @throws SQLException</em>
-<a class="jxr_linenumber" name="L433" href="#L433">433</a> <em class="jxr_javadoccomment">     *             if a database access error occurs</em>
-<a class="jxr_linenumber" name="L434" href="#L434">434</a> <em class="jxr_javadoccomment">     * @since DbUtils 1.1</em>
-<a class="jxr_linenumber" name="L435" href="#L435">435</a> <em class="jxr_javadoccomment">     */</em>
-<a class="jxr_linenumber" name="L436" href="#L436">436</a>     <strong class="jxr_keyword">protected</strong> <strong class="jxr_keyword">void</strong> close(Connection conn) <strong class="jxr_keyword">throws</strong> SQLException {
-<a class="jxr_linenumber" name="L437" href="#L437">437</a>         DbUtils.close(conn);
-<a class="jxr_linenumber" name="L438" href="#L438">438</a>     }
-<a class="jxr_linenumber" name="L439" href="#L439">439</a> 
-<a class="jxr_linenumber" name="L440" href="#L440">440</a>     <em class="jxr_javadoccomment">/**</em>
-<a class="jxr_linenumber" name="L441" href="#L441">441</a> <em class="jxr_javadoccomment">     * Close a &lt;code&gt;Statement&lt;/code&gt;. This implementation avoids closing if</em>
-<a class="jxr_linenumber" name="L442" href="#L442">442</a> <em class="jxr_javadoccomment">     * null and does &lt;strong&gt;not&lt;/strong&gt; suppress any exceptions. Subclasses</em>
-<a class="jxr_linenumber" name="L443" href="#L443">443</a> <em class="jxr_javadoccomment">     * can override to provide special handling like logging.</em>
-<a class="jxr_linenumber" name="L444" href="#L444">444</a> <em class="jxr_javadoccomment">     *</em>
-<a class="jxr_linenumber" name="L445" href="#L445">445</a> <em class="jxr_javadoccomment">     * @param stmt</em>
-<a class="jxr_linenumber" name="L446" href="#L446">446</a> <em class="jxr_javadoccomment">     *            Statement to close</em>
-<a class="jxr_linenumber" name="L447" href="#L447">447</a> <em class="jxr_javadoccomment">     * @throws SQLException</em>
-<a class="jxr_linenumber" name="L448" href="#L448">448</a> <em class="jxr_javadoccomment">     *             if a database access error occurs</em>
-<a class="jxr_linenumber" name="L449" href="#L449">449</a> <em class="jxr_javadoccomment">     * @since DbUtils 1.1</em>
-<a class="jxr_linenumber" name="L450" href="#L450">450</a> <em class="jxr_javadoccomment">     */</em>
-<a class="jxr_linenumber" name="L451" href="#L451">451</a>     <strong class="jxr_keyword">protected</strong> <strong class="jxr_keyword">void</strong> close(Statement stmt) <strong class="jxr_keyword">throws</strong> SQLException {
-<a class="jxr_linenumber" name="L452" href="#L452">452</a>         DbUtils.close(stmt);
-<a class="jxr_linenumber" name="L453" href="#L453">453</a>     }
-<a class="jxr_linenumber" name="L454" href="#L454">454</a> 
-<a class="jxr_linenumber" name="L455" href="#L455">455</a>     <em class="jxr_javadoccomment">/**</em>
-<a class="jxr_linenumber" name="L456" href="#L456">456</a> <em class="jxr_javadoccomment">     * Close a &lt;code&gt;ResultSet&lt;/code&gt;. This implementation avoids closing if</em>
-<a class="jxr_linenumber" name="L457" href="#L457">457</a> <em class="jxr_javadoccomment">     * null and does &lt;strong&gt;not&lt;/strong&gt; suppress any exceptions. Subclasses</em>
-<a class="jxr_linenumber" name="L458" href="#L458">458</a> <em class="jxr_javadoccomment">     * can override to provide special handling like logging.</em>
-<a class="jxr_linenumber" name="L459" href="#L459">459</a> <em class="jxr_javadoccomment">     *</em>
-<a class="jxr_linenumber" name="L460" href="#L460">460</a> <em class="jxr_javadoccomment">     * @param rs</em>
-<a class="jxr_linenumber" name="L461" href="#L461">461</a> <em class="jxr_javadoccomment">     *            ResultSet to close</em>
-<a class="jxr_linenumber" name="L462" href="#L462">462</a> <em class="jxr_javadoccomment">     * @throws SQLException</em>
-<a class="jxr_linenumber" name="L463" href="#L463">463</a> <em class="jxr_javadoccomment">     *             if a database access error occurs</em>
-<a class="jxr_linenumber" name="L464" href="#L464">464</a> <em class="jxr_javadoccomment">     * @since DbUtils 1.1</em>
-<a class="jxr_linenumber" name="L465" href="#L465">465</a> <em class="jxr_javadoccomment">     */</em>
-<a class="jxr_linenumber" name="L466" href="#L466">466</a>     <strong class="jxr_keyword">protected</strong> <strong class="jxr_keyword">void</strong> close(ResultSet rs) <strong class="jxr_keyword">throws</strong> SQLException {
-<a class="jxr_linenumber" name="L467" href="#L467">467</a>         DbUtils.close(rs);
-<a class="jxr_linenumber" name="L468" href="#L468">468</a>     }
-<a class="jxr_linenumber" name="L469" href="#L469">469</a> 
-<a class="jxr_linenumber" name="L470" href="#L470">470</a> }
+<a class="jxr_linenumber" name="L178" href="#L178">178</a> <em class="jxr_javadoccomment">     * @since 1.6</em>
+<a class="jxr_linenumber" name="L179" href="#L179">179</a> <em class="jxr_javadoccomment">     */</em>
+<a class="jxr_linenumber" name="L180" href="#L180">180</a>     <strong class="jxr_keyword">protected</strong> PreparedStatement prepareStatement(Connection conn, String sql, <strong class="jxr_keyword">int</strong> returnedKeys)
+<a class="jxr_linenumber" name="L181" href="#L181">181</a>             <strong class="jxr_keyword">throws</strong> SQLException {
+<a class="jxr_linenumber" name="L182" href="#L182">182</a> 
+<a class="jxr_linenumber" name="L183" href="#L183">183</a>         <strong class="jxr_keyword">return</strong> conn.prepareStatement(sql, returnedKeys);
+<a class="jxr_linenumber" name="L184" href="#L184">184</a>     }
+<a class="jxr_linenumber" name="L185" href="#L185">185</a> 
+<a class="jxr_linenumber" name="L186" href="#L186">186</a>     <em class="jxr_javadoccomment">/**</em>
+<a class="jxr_linenumber" name="L187" href="#L187">187</a> <em class="jxr_javadoccomment">     * Factory method that creates and initializes a &lt;code&gt;Connection&lt;/code&gt;</em>
+<a class="jxr_linenumber" name="L188" href="#L188">188</a> <em class="jxr_javadoccomment">     * object. &lt;code&gt;QueryRunner&lt;/code&gt; methods always call this method to</em>
+<a class="jxr_linenumber" name="L189" href="#L189">189</a> <em class="jxr_javadoccomment">     * retrieve connections from its DataSource. Subclasses can override this</em>
+<a class="jxr_linenumber" name="L190" href="#L190">190</a> <em class="jxr_javadoccomment">     * method to provide special &lt;code&gt;Connection&lt;/code&gt; configuration if</em>
+<a class="jxr_linenumber" name="L191" href="#L191">191</a> <em class="jxr_javadoccomment">     * needed. This implementation simply calls &lt;code&gt;ds.getConnection()&lt;/code&gt;.</em>
+<a class="jxr_linenumber" name="L192" href="#L192">192</a> <em class="jxr_javadoccomment">     *</em>
+<a class="jxr_linenumber" name="L193" href="#L193">193</a> <em class="jxr_javadoccomment">     * @return An initialized &lt;code&gt;Connection&lt;/code&gt;.</em>
+<a class="jxr_linenumber" name="L194" href="#L194">194</a> <em class="jxr_javadoccomment">     * @throws SQLException</em>
+<a class="jxr_linenumber" name="L195" href="#L195">195</a> <em class="jxr_javadoccomment">     *             if a database access error occurs</em>
+<a class="jxr_linenumber" name="L196" href="#L196">196</a> <em class="jxr_javadoccomment">     * @since DbUtils 1.1</em>
+<a class="jxr_linenumber" name="L197" href="#L197">197</a> <em class="jxr_javadoccomment">     */</em>
+<a class="jxr_linenumber" name="L198" href="#L198">198</a>     <strong class="jxr_keyword">protected</strong> Connection prepareConnection() <strong class="jxr_keyword">throws</strong> SQLException {
+<a class="jxr_linenumber" name="L199" href="#L199">199</a>         <strong class="jxr_keyword">if</strong> (<strong class="jxr_keyword">this</strong>.getDataSource() == <strong class="jxr_keyword">null</strong>) {
+<a class="jxr_linenumber" name="L200" href="#L200">200</a>             <strong class="jxr_keyword">throw</strong> <strong class="jxr_keyword">new</strong> SQLException(
+<a class="jxr_linenumber" name="L201" href="#L201">201</a>                     <span class="jxr_string">"QueryRunner requires a DataSource to be "</span>
+<a class="jxr_linenumber" name="L202" href="#L202">202</a>                             + <span class="jxr_string">"invoked in this way, or a Connection should be passed in"</span>);
+<a class="jxr_linenumber" name="L203" href="#L203">203</a>         }
+<a class="jxr_linenumber" name="L204" href="#L204">204</a>         <strong class="jxr_keyword">return</strong> <strong class="jxr_keyword">this</strong>.getDataSource().getConnection();
+<a class="jxr_linenumber" name="L205" href="#L205">205</a>     }
+<a class="jxr_linenumber" name="L206" href="#L206">206</a> 
+<a class="jxr_linenumber" name="L207" href="#L207">207</a>     <em class="jxr_javadoccomment">/**</em>
+<a class="jxr_linenumber" name="L208" href="#L208">208</a> <em class="jxr_javadoccomment">     * Fill the &lt;code&gt;PreparedStatement&lt;/code&gt; replacement parameters with the</em>
+<a class="jxr_linenumber" name="L209" href="#L209">209</a> <em class="jxr_javadoccomment">     * given objects.</em>
+<a class="jxr_linenumber" name="L210" href="#L210">210</a> <em class="jxr_javadoccomment">     *</em>
+<a class="jxr_linenumber" name="L211" href="#L211">211</a> <em class="jxr_javadoccomment">     * @param stmt</em>
+<a class="jxr_linenumber" name="L212" href="#L212">212</a> <em class="jxr_javadoccomment">     *            PreparedStatement to fill</em>
+<a class="jxr_linenumber" name="L213" href="#L213">213</a> <em class="jxr_javadoccomment">     * @param params</em>
+<a class="jxr_linenumber" name="L214" href="#L214">214</a> <em class="jxr_javadoccomment">     *            Query replacement parameters; &lt;code&gt;null&lt;/code&gt; is a valid</em>
+<a class="jxr_linenumber" name="L215" href="#L215">215</a> <em class="jxr_javadoccomment">     *            value to pass in.</em>
+<a class="jxr_linenumber" name="L216" href="#L216">216</a> <em class="jxr_javadoccomment">     * @throws SQLException</em>
+<a class="jxr_linenumber" name="L217" href="#L217">217</a> <em class="jxr_javadoccomment">     *             if a database access error occurs</em>
+<a class="jxr_linenumber" name="L218" href="#L218">218</a> <em class="jxr_javadoccomment">     */</em>
+<a class="jxr_linenumber" name="L219" href="#L219">219</a>     <strong class="jxr_keyword">public</strong> <strong class="jxr_keyword">void</strong> fillStatement(PreparedStatement stmt, Object... params)
+<a class="jxr_linenumber" name="L220" href="#L220">220</a>             <strong class="jxr_keyword">throws</strong> SQLException {
+<a class="jxr_linenumber" name="L221" href="#L221">221</a> 
+<a class="jxr_linenumber" name="L222" href="#L222">222</a>         <em class="jxr_comment">// check the parameter count, if we can</em>
+<a class="jxr_linenumber" name="L223" href="#L223">223</a>         ParameterMetaData pmd = <strong class="jxr_keyword">null</strong>;
+<a class="jxr_linenumber" name="L224" href="#L224">224</a>         <strong class="jxr_keyword">if</strong> (!pmdKnownBroken) {
+<a class="jxr_linenumber" name="L225" href="#L225">225</a>             pmd = stmt.getParameterMetaData();
+<a class="jxr_linenumber" name="L226" href="#L226">226</a>             <strong class="jxr_keyword">int</strong> stmtCount = pmd.getParameterCount();
+<a class="jxr_linenumber" name="L227" href="#L227">227</a>             <strong class="jxr_keyword">int</strong> paramsCount = params == <strong class="jxr_keyword">null</strong> ? 0 : params.length;
+<a class="jxr_linenumber" name="L228" href="#L228">228</a> 
+<a class="jxr_linenumber" name="L229" href="#L229">229</a>             <strong class="jxr_keyword">if</strong> (stmtCount != paramsCount) {
+<a class="jxr_linenumber" name="L230" href="#L230">230</a>                 <strong class="jxr_keyword">throw</strong> <strong class="jxr_keyword">new</strong> SQLException(<span class="jxr_string">"Wrong number of parameters: expected "</span>
+<a class="jxr_linenumber" name="L231" href="#L231">231</a>                         + stmtCount + <span class="jxr_string">", was given "</span> + paramsCount);
+<a class="jxr_linenumber" name="L232" href="#L232">232</a>             }
+<a class="jxr_linenumber" name="L233" href="#L233">233</a>         }
+<a class="jxr_linenumber" name="L234" href="#L234">234</a> 
+<a class="jxr_linenumber" name="L235" href="#L235">235</a>         <em class="jxr_comment">// nothing to do here</em>
+<a class="jxr_linenumber" name="L236" href="#L236">236</a>         <strong class="jxr_keyword">if</strong> (params == <strong class="jxr_keyword">null</strong>) {
+<a class="jxr_linenumber" name="L237" href="#L237">237</a>             <strong class="jxr_keyword">return</strong>;
+<a class="jxr_linenumber" name="L238" href="#L238">238</a>         }
+<a class="jxr_linenumber" name="L239" href="#L239">239</a> 
+<a class="jxr_linenumber" name="L240" href="#L240">240</a>         <strong class="jxr_keyword">for</strong> (<strong class="jxr_keyword">int</strong> i = 0; i &lt; params.length; i++) {
+<a class="jxr_linenumber" name="L241" href="#L241">241</a>             <strong class="jxr_keyword">if</strong> (params[i] != <strong class="jxr_keyword">null</strong>) {
+<a class="jxr_linenumber" name="L242" href="#L242">242</a>                 stmt.setObject(i + 1, params[i]);
+<a class="jxr_linenumber" name="L243" href="#L243">243</a>             } <strong class="jxr_keyword">else</strong> {
+<a class="jxr_linenumber" name="L244" href="#L244">244</a>                 <em class="jxr_comment">// VARCHAR works with many drivers regardless</em>
+<a class="jxr_linenumber" name="L245" href="#L245">245</a>                 <em class="jxr_comment">// of the actual column type. Oddly, NULL and</em>
+<a class="jxr_linenumber" name="L246" href="#L246">246</a>                 <em class="jxr_comment">// OTHER don't work with Oracle's drivers.</em>
+<a class="jxr_linenumber" name="L247" href="#L247">247</a>                 <strong class="jxr_keyword">int</strong> sqlType = Types.VARCHAR;
+<a class="jxr_linenumber" name="L248" href="#L248">248</a>                 <strong class="jxr_keyword">if</strong> (!pmdKnownBroken) {
+<a class="jxr_linenumber" name="L249" href="#L249">249</a>                     <strong class="jxr_keyword">try</strong> {
+<a class="jxr_linenumber" name="L250" href="#L250">250</a>                         <em class="jxr_comment">/*</em>
+<a class="jxr_linenumber" name="L251" href="#L251">251</a> <em class="jxr_comment">                         * It's not possible for pmdKnownBroken to change from</em>
+<a class="jxr_linenumber" name="L252" href="#L252">252</a> <em class="jxr_comment">                         * true to false, (once true, always true) so pmd cannot</em>
+<a class="jxr_linenumber" name="L253" href="#L253">253</a> <em class="jxr_comment">                         * be null here.</em>
+<a class="jxr_linenumber" name="L254" href="#L254">254</a> <em class="jxr_comment">                         */</em>
+<a class="jxr_linenumber" name="L255" href="#L255">255</a>                         sqlType = pmd.getParameterType(i + 1);
+<a class="jxr_linenumber" name="L256" href="#L256">256</a>                     } <strong class="jxr_keyword">catch</strong> (SQLException e) {
+<a class="jxr_linenumber" name="L257" href="#L257">257</a>                         pmdKnownBroken = <strong class="jxr_keyword">true</strong>;
+<a class="jxr_linenumber" name="L258" href="#L258">258</a>                     }
+<a class="jxr_linenumber" name="L259" href="#L259">259</a>                 }
+<a class="jxr_linenumber" name="L260" href="#L260">260</a>                 stmt.setNull(i + 1, sqlType);
+<a class="jxr_linenumber" name="L261" href="#L261">261</a>             }
+<a class="jxr_linenumber" name="L262" href="#L262">262</a>         }
+<a class="jxr_linenumber" name="L263" href="#L263">263</a>     }
+<a class="jxr_linenumber" name="L264" href="#L264">264</a> 
+<a class="jxr_linenumber" name="L265" href="#L265">265</a>     <em class="jxr_javadoccomment">/**</em>
+<a class="jxr_linenumber" name="L266" href="#L266">266</a> <em class="jxr_javadoccomment">     * Fill the &lt;code&gt;PreparedStatement&lt;/code&gt; replacement parameters with the</em>
+<a class="jxr_linenumber" name="L267" href="#L267">267</a> <em class="jxr_javadoccomment">     * given object's bean property values.</em>
+<a class="jxr_linenumber" name="L268" href="#L268">268</a> <em class="jxr_javadoccomment">     *</em>
+<a class="jxr_linenumber" name="L269" href="#L269">269</a> <em class="jxr_javadoccomment">     * @param stmt</em>
+<a class="jxr_linenumber" name="L270" href="#L270">270</a> <em class="jxr_javadoccomment">     *            PreparedStatement to fill</em>
+<a class="jxr_linenumber" name="L271" href="#L271">271</a> <em class="jxr_javadoccomment">     * @param bean</em>
+<a class="jxr_linenumber" name="L272" href="#L272">272</a> <em class="jxr_javadoccomment">     *            a JavaBean object</em>
+<a class="jxr_linenumber" name="L273" href="#L273">273</a> <em class="jxr_javadoccomment">     * @param properties</em>
+<a class="jxr_linenumber" name="L274" href="#L274">274</a> <em class="jxr_javadoccomment">     *            an ordered array of properties; this gives the order to insert</em>
+<a class="jxr_linenumber" name="L275" href="#L275">275</a> <em class="jxr_javadoccomment">     *            values in the statement</em>
+<a class="jxr_linenumber" name="L276" href="#L276">276</a> <em class="jxr_javadoccomment">     * @throws SQLException</em>
+<a class="jxr_linenumber" name="L277" href="#L277">277</a> <em class="jxr_javadoccomment">     *             if a database access error occurs</em>
+<a class="jxr_linenumber" name="L278" href="#L278">278</a> <em class="jxr_javadoccomment">     */</em>
+<a class="jxr_linenumber" name="L279" href="#L279">279</a>     <strong class="jxr_keyword">public</strong> <strong class="jxr_keyword">void</strong> fillStatementWithBean(PreparedStatement stmt, Object bean,
+<a class="jxr_linenumber" name="L280" href="#L280">280</a>             PropertyDescriptor[] properties) <strong class="jxr_keyword">throws</strong> SQLException {
+<a class="jxr_linenumber" name="L281" href="#L281">281</a>         Object[] params = <strong class="jxr_keyword">new</strong> Object[properties.length];
+<a class="jxr_linenumber" name="L282" href="#L282">282</a>         <strong class="jxr_keyword">for</strong> (<strong class="jxr_keyword">int</strong> i = 0; i &lt; properties.length; i++) {
+<a class="jxr_linenumber" name="L283" href="#L283">283</a>             PropertyDescriptor property = properties[i];
+<a class="jxr_linenumber" name="L284" href="#L284">284</a>             Object value = <strong class="jxr_keyword">null</strong>;
+<a class="jxr_linenumber" name="L285" href="#L285">285</a>             Method method = property.getReadMethod();
+<a class="jxr_linenumber" name="L286" href="#L286">286</a>             <strong class="jxr_keyword">if</strong> (method == <strong class="jxr_keyword">null</strong>) {
+<a class="jxr_linenumber" name="L287" href="#L287">287</a>                 <strong class="jxr_keyword">throw</strong> <strong class="jxr_keyword">new</strong> RuntimeException(<span class="jxr_string">"No read method for bean property "</span>
+<a class="jxr_linenumber" name="L288" href="#L288">288</a>                         + bean.getClass() + <span class="jxr_string">" "</span> + property.getName());
+<a class="jxr_linenumber" name="L289" href="#L289">289</a>             }
+<a class="jxr_linenumber" name="L290" href="#L290">290</a>             <strong class="jxr_keyword">try</strong> {
+<a class="jxr_linenumber" name="L291" href="#L291">291</a>                 value = method.invoke(bean, <strong class="jxr_keyword">new</strong> Object[0]);
+<a class="jxr_linenumber" name="L292" href="#L292">292</a>             } <strong class="jxr_keyword">catch</strong> (InvocationTargetException e) {
+<a class="jxr_linenumber" name="L293" href="#L293">293</a>                 <strong class="jxr_keyword">throw</strong> <strong class="jxr_keyword">new</strong> RuntimeException(<span class="jxr_string">"Couldn't invoke method: "</span> + method,
+<a class="jxr_linenumber" name="L294" href="#L294">294</a>                         e);
+<a class="jxr_linenumber" name="L295" href="#L295">295</a>             } <strong class="jxr_keyword">catch</strong> (IllegalArgumentException e) {
+<a class="jxr_linenumber" name="L296" href="#L296">296</a>                 <strong class="jxr_keyword">throw</strong> <strong class="jxr_keyword">new</strong> RuntimeException(
+<a class="jxr_linenumber" name="L297" href="#L297">297</a>                         <span class="jxr_string">"Couldn't invoke method with 0 arguments: "</span> + method, e);
+<a class="jxr_linenumber" name="L298" href="#L298">298</a>             } <strong class="jxr_keyword">catch</strong> (IllegalAccessException e) {
+<a class="jxr_linenumber" name="L299" href="#L299">299</a>                 <strong class="jxr_keyword">throw</strong> <strong class="jxr_keyword">new</strong> RuntimeException(<span class="jxr_string">"Couldn't invoke method: "</span> + method,
+<a class="jxr_linenumber" name="L300" href="#L300">300</a>                         e);
+<a class="jxr_linenumber" name="L301" href="#L301">301</a>             }
+<a class="jxr_linenumber" name="L302" href="#L302">302</a>             params[i] = value;
+<a class="jxr_linenumber" name="L303" href="#L303">303</a>         }
+<a class="jxr_linenumber" name="L304" href="#L304">304</a>         fillStatement(stmt, params);
+<a class="jxr_linenumber" name="L305" href="#L305">305</a>     }
+<a class="jxr_linenumber" name="L306" href="#L306">306</a> 
+<a class="jxr_linenumber" name="L307" href="#L307">307</a>     <em class="jxr_javadoccomment">/**</em>
+<a class="jxr_linenumber" name="L308" href="#L308">308</a> <em class="jxr_javadoccomment">     * Fill the &lt;code&gt;PreparedStatement&lt;/code&gt; replacement parameters with the</em>
+<a class="jxr_linenumber" name="L309" href="#L309">309</a> <em class="jxr_javadoccomment">     * given object's bean property values.</em>
+<a class="jxr_linenumber" name="L310" href="#L310">310</a> <em class="jxr_javadoccomment">     *</em>
+<a class="jxr_linenumber" name="L311" href="#L311">311</a> <em class="jxr_javadoccomment">     * @param stmt</em>
+<a class="jxr_linenumber" name="L312" href="#L312">312</a> <em class="jxr_javadoccomment">     *            PreparedStatement to fill</em>
+<a class="jxr_linenumber" name="L313" href="#L313">313</a> <em class="jxr_javadoccomment">     * @param bean</em>
+<a class="jxr_linenumber" name="L314" href="#L314">314</a> <em class="jxr_javadoccomment">     *            A JavaBean object</em>
+<a class="jxr_linenumber" name="L315" href="#L315">315</a> <em class="jxr_javadoccomment">     * @param propertyNames</em>
+<a class="jxr_linenumber" name="L316" href="#L316">316</a> <em class="jxr_javadoccomment">     *            An ordered array of property names (these should match the</em>
+<a class="jxr_linenumber" name="L317" href="#L317">317</a> <em class="jxr_javadoccomment">     *            getters/setters); this gives the order to insert values in the</em>
+<a class="jxr_linenumber" name="L318" href="#L318">318</a> <em class="jxr_javadoccomment">     *            statement</em>
+<a class="jxr_linenumber" name="L319" href="#L319">319</a> <em class="jxr_javadoccomment">     * @throws SQLException</em>
+<a class="jxr_linenumber" name="L320" href="#L320">320</a> <em class="jxr_javadoccomment">     *             If a database access error occurs</em>
+<a class="jxr_linenumber" name="L321" href="#L321">321</a> <em class="jxr_javadoccomment">     */</em>
+<a class="jxr_linenumber" name="L322" href="#L322">322</a>     <strong class="jxr_keyword">public</strong> <strong class="jxr_keyword">void</strong> fillStatementWithBean(PreparedStatement stmt, Object bean,
+<a class="jxr_linenumber" name="L323" href="#L323">323</a>             String... propertyNames) <strong class="jxr_keyword">throws</strong> SQLException {
+<a class="jxr_linenumber" name="L324" href="#L324">324</a>         PropertyDescriptor[] descriptors;
+<a class="jxr_linenumber" name="L325" href="#L325">325</a>         <strong class="jxr_keyword">try</strong> {
+<a class="jxr_linenumber" name="L326" href="#L326">326</a>             descriptors = Introspector.getBeanInfo(bean.getClass())
+<a class="jxr_linenumber" name="L327" href="#L327">327</a>                     .getPropertyDescriptors();
+<a class="jxr_linenumber" name="L328" href="#L328">328</a>         } <strong class="jxr_keyword">catch</strong> (IntrospectionException e) {
+<a class="jxr_linenumber" name="L329" href="#L329">329</a>             <strong class="jxr_keyword">throw</strong> <strong class="jxr_keyword">new</strong> RuntimeException(<span class="jxr_string">"Couldn't introspect bean "</span>
+<a class="jxr_linenumber" name="L330" href="#L330">330</a>                     + bean.getClass().toString(), e);
+<a class="jxr_linenumber" name="L331" href="#L331">331</a>         }
+<a class="jxr_linenumber" name="L332" href="#L332">332</a>         PropertyDescriptor[] sorted = <strong class="jxr_keyword">new</strong> PropertyDescriptor[propertyNames.length];
+<a class="jxr_linenumber" name="L333" href="#L333">333</a>         <strong class="jxr_keyword">for</strong> (<strong class="jxr_keyword">int</strong> i = 0; i &lt; propertyNames.length; i++) {
+<a class="jxr_linenumber" name="L334" href="#L334">334</a>             String propertyName = propertyNames[i];
+<a class="jxr_linenumber" name="L335" href="#L335">335</a>             <strong class="jxr_keyword">if</strong> (propertyName == <strong class="jxr_keyword">null</strong>) {
+<a class="jxr_linenumber" name="L336" href="#L336">336</a>                 <strong class="jxr_keyword">throw</strong> <strong class="jxr_keyword">new</strong> NullPointerException(<span class="jxr_string">"propertyName can't be null: "</span>
+<a class="jxr_linenumber" name="L337" href="#L337">337</a>                         + i);
+<a class="jxr_linenumber" name="L338" href="#L338">338</a>             }
+<a class="jxr_linenumber" name="L339" href="#L339">339</a>             <strong class="jxr_keyword">boolean</strong> found = false;
+<a class="jxr_linenumber" name="L340" href="#L340">340</a>             <strong class="jxr_keyword">for</strong> (<strong class="jxr_keyword">int</strong> j = 0; j &lt; descriptors.length; j++) {
+<a class="jxr_linenumber" name="L341" href="#L341">341</a>                 PropertyDescriptor descriptor = descriptors[j];
+<a class="jxr_linenumber" name="L342" href="#L342">342</a>                 <strong class="jxr_keyword">if</strong> (propertyName.equals(descriptor.getName())) {
+<a class="jxr_linenumber" name="L343" href="#L343">343</a>                     sorted[i] = descriptor;
+<a class="jxr_linenumber" name="L344" href="#L344">344</a>                     found = <strong class="jxr_keyword">true</strong>;
+<a class="jxr_linenumber" name="L345" href="#L345">345</a>                     <strong class="jxr_keyword">break</strong>;
+<a class="jxr_linenumber" name="L346" href="#L346">346</a>                 }
+<a class="jxr_linenumber" name="L347" href="#L347">347</a>             }
+<a class="jxr_linenumber" name="L348" href="#L348">348</a>             <strong class="jxr_keyword">if</strong> (!found) {
+<a class="jxr_linenumber" name="L349" href="#L349">349</a>                 <strong class="jxr_keyword">throw</strong> <strong class="jxr_keyword">new</strong> RuntimeException(<span class="jxr_string">"Couldn't find bean property: "</span>
+<a class="jxr_linenumber" name="L350" href="#L350">350</a>                         + bean.getClass() + <span class="jxr_string">" "</span> + propertyName);
+<a class="jxr_linenumber" name="L351" href="#L351">351</a>             }
+<a class="jxr_linenumber" name="L352" href="#L352">352</a>         }
+<a class="jxr_linenumber" name="L353" href="#L353">353</a>         fillStatementWithBean(stmt, bean, sorted);
+<a class="jxr_linenumber" name="L354" href="#L354">354</a>     }
+<a class="jxr_linenumber" name="L355" href="#L355">355</a> 
+<a class="jxr_linenumber" name="L356" href="#L356">356</a>     <em class="jxr_javadoccomment">/**</em>
+<a class="jxr_linenumber" name="L357" href="#L357">357</a> <em class="jxr_javadoccomment">     * Throws a new exception with a more informative error message.</em>
+<a class="jxr_linenumber" name="L358" href="#L358">358</a> <em class="jxr_javadoccomment">     *</em>
+<a class="jxr_linenumber" name="L359" href="#L359">359</a> <em class="jxr_javadoccomment">     * @param cause</em>
+<a class="jxr_linenumber" name="L360" href="#L360">360</a> <em class="jxr_javadoccomment">     *            The original exception that will be chained to the new</em>
+<a class="jxr_linenumber" name="L361" href="#L361">361</a> <em class="jxr_javadoccomment">     *            exception when it's rethrown.</em>
+<a class="jxr_linenumber" name="L362" href="#L362">362</a> <em class="jxr_javadoccomment">     *</em>
+<a class="jxr_linenumber" name="L363" href="#L363">363</a> <em class="jxr_javadoccomment">     * @param sql</em>
+<a class="jxr_linenumber" name="L364" href="#L364">364</a> <em class="jxr_javadoccomment">     *            The query that was executing when the exception happened.</em>
+<a class="jxr_linenumber" name="L365" href="#L365">365</a> <em class="jxr_javadoccomment">     *</em>
+<a class="jxr_linenumber" name="L366" href="#L366">366</a> <em class="jxr_javadoccomment">     * @param params</em>
+<a class="jxr_linenumber" name="L367" href="#L367">367</a> <em class="jxr_javadoccomment">     *            The query replacement parameters; &lt;code&gt;null&lt;/code&gt; is a valid</em>
+<a class="jxr_linenumber" name="L368" href="#L368">368</a> <em class="jxr_javadoccomment">     *            value to pass in.</em>
+<a class="jxr_linenumber" name="L369" href="#L369">369</a> <em class="jxr_javadoccomment">     *</em>
+<a class="jxr_linenumber" name="L370" href="#L370">370</a> <em class="jxr_javadoccomment">     * @throws SQLException</em>
+<a class="jxr_linenumber" name="L371" href="#L371">371</a> <em class="jxr_javadoccomment">     *             if a database access error occurs</em>
+<a class="jxr_linenumber" name="L372" href="#L372">372</a> <em class="jxr_javadoccomment">     */</em>
+<a class="jxr_linenumber" name="L373" href="#L373">373</a>     <strong class="jxr_keyword">protected</strong> <strong class="jxr_keyword">void</strong> rethrow(SQLException cause, String sql, Object... params)
+<a class="jxr_linenumber" name="L374" href="#L374">374</a>             <strong class="jxr_keyword">throws</strong> SQLException {
+<a class="jxr_linenumber" name="L375" href="#L375">375</a> 
+<a class="jxr_linenumber" name="L376" href="#L376">376</a>         String causeMessage = cause.getMessage();
+<a class="jxr_linenumber" name="L377" href="#L377">377</a>         <strong class="jxr_keyword">if</strong> (causeMessage == <strong class="jxr_keyword">null</strong>) {
+<a class="jxr_linenumber" name="L378" href="#L378">378</a>             causeMessage = <span class="jxr_string">""</span>;
+<a class="jxr_linenumber" name="L379" href="#L379">379</a>         }
+<a class="jxr_linenumber" name="L380" href="#L380">380</a>         StringBuffer msg = <strong class="jxr_keyword">new</strong> StringBuffer(causeMessage);
+<a class="jxr_linenumber" name="L381" href="#L381">381</a> 
+<a class="jxr_linenumber" name="L382" href="#L382">382</a>         msg.append(<span class="jxr_string">" Query: "</span>);
+<a class="jxr_linenumber" name="L383" href="#L383">383</a>         msg.append(sql);
+<a class="jxr_linenumber" name="L384" href="#L384">384</a>         msg.append(<span class="jxr_string">" Parameters: "</span>);
+<a class="jxr_linenumber" name="L385" href="#L385">385</a> 
+<a class="jxr_linenumber" name="L386" href="#L386">386</a>         <strong class="jxr_keyword">if</strong> (params == <strong class="jxr_keyword">null</strong>) {
+<a class="jxr_linenumber" name="L387" href="#L387">387</a>             msg.append(<span class="jxr_string">"[]"</span>);
+<a class="jxr_linenumber" name="L388" href="#L388">388</a>         } <strong class="jxr_keyword">else</strong> {
+<a class="jxr_linenumber" name="L389" href="#L389">389</a>             msg.append(Arrays.deepToString(params));
+<a class="jxr_linenumber" name="L390" href="#L390">390</a>         }
+<a class="jxr_linenumber" name="L391" href="#L391">391</a> 
+<a class="jxr_linenumber" name="L392" href="#L392">392</a>         SQLException e = <strong class="jxr_keyword">new</strong> SQLException(msg.toString(), cause.getSQLState(),
+<a class="jxr_linenumber" name="L393" href="#L393">393</a>                 cause.getErrorCode());
+<a class="jxr_linenumber" name="L394" href="#L394">394</a>         e.setNextException(cause);
+<a class="jxr_linenumber" name="L395" href="#L395">395</a> 
+<a class="jxr_linenumber" name="L396" href="#L396">396</a>         <strong class="jxr_keyword">throw</strong> e;
+<a class="jxr_linenumber" name="L397" href="#L397">397</a>     }
+<a class="jxr_linenumber" name="L398" href="#L398">398</a> 
+<a class="jxr_linenumber" name="L399" href="#L399">399</a>     <em class="jxr_javadoccomment">/**</em>
+<a class="jxr_linenumber" name="L400" href="#L400">400</a> <em class="jxr_javadoccomment">     * Wrap the &lt;code&gt;ResultSet&lt;/code&gt; in a decorator before processing it. This</em>
+<a class="jxr_linenumber" name="L401" href="#L401">401</a> <em class="jxr_javadoccomment">     * implementation returns the &lt;code&gt;ResultSet&lt;/code&gt; it is given without any</em>
+<a class="jxr_linenumber" name="L402" href="#L402">402</a> <em class="jxr_javadoccomment">     * decoration.</em>
+<a class="jxr_linenumber" name="L403" href="#L403">403</a> <em class="jxr_javadoccomment">     *</em>
+<a class="jxr_linenumber" name="L404" href="#L404">404</a> <em class="jxr_javadoccomment">     * &lt;p&gt;</em>
+<a class="jxr_linenumber" name="L405" href="#L405">405</a> <em class="jxr_javadoccomment">     * Often, the implementation of this method can be done in an anonymous</em>
+<a class="jxr_linenumber" name="L406" href="#L406">406</a> <em class="jxr_javadoccomment">     * inner class like this:</em>
+<a class="jxr_linenumber" name="L407" href="#L407">407</a> <em class="jxr_javadoccomment">     * &lt;/p&gt;</em>
+<a class="jxr_linenumber" name="L408" href="#L408">408</a> <em class="jxr_javadoccomment">     *</em>
+<a class="jxr_linenumber" name="L409" href="#L409">409</a> <em class="jxr_javadoccomment">     * &lt;pre&gt;</em>
+<a class="jxr_linenumber" name="L410" href="#L410">410</a> <em class="jxr_javadoccomment">     * QueryRunner run = new QueryRunner() {</em>
+<a class="jxr_linenumber" name="L411" href="#L411">411</a> <em class="jxr_javadoccomment">     *     protected ResultSet wrap(ResultSet rs) {</em>
+<a class="jxr_linenumber" name="L412" href="#L412">412</a> <em class="jxr_javadoccomment">     *         return StringTrimmedResultSet.wrap(rs);</em>
+<a class="jxr_linenumber" name="L413" href="#L413">413</a> <em class="jxr_javadoccomment">     *     }</em>
+<a class="jxr_linenumber" name="L414" href="#L414">414</a> <em class="jxr_javadoccomment">     * };</em>
+<a class="jxr_linenumber" name="L415" href="#L415">415</a> <em class="jxr_javadoccomment">     * &lt;/pre&gt;</em>
+<a class="jxr_linenumber" name="L416" href="#L416">416</a> <em class="jxr_javadoccomment">     *</em>
+<a class="jxr_linenumber" name="L417" href="#L417">417</a> <em class="jxr_javadoccomment">     * @param rs</em>
+<a class="jxr_linenumber" name="L418" href="#L418">418</a> <em class="jxr_javadoccomment">     *            The &lt;code&gt;ResultSet&lt;/code&gt; to decorate; never</em>
+<a class="jxr_linenumber" name="L419" href="#L419">419</a> <em class="jxr_javadoccomment">     *            &lt;code&gt;null&lt;/code&gt;.</em>
+<a class="jxr_linenumber" name="L420" href="#L420">420</a> <em class="jxr_javadoccomment">     * @return The &lt;code&gt;ResultSet&lt;/code&gt; wrapped in some decorator.</em>
+<a class="jxr_linenumber" name="L421" href="#L421">421</a> <em class="jxr_javadoccomment">     */</em>
+<a class="jxr_linenumber" name="L422" href="#L422">422</a>     <strong class="jxr_keyword">protected</strong> ResultSet wrap(ResultSet rs) {
+<a class="jxr_linenumber" name="L423" href="#L423">423</a>         <strong class="jxr_keyword">return</strong> rs;
+<a class="jxr_linenumber" name="L424" href="#L424">424</a>     }
+<a class="jxr_linenumber" name="L425" href="#L425">425</a> 
+<a class="jxr_linenumber" name="L426" href="#L426">426</a>     <em class="jxr_javadoccomment">/**</em>
+<a class="jxr_linenumber" name="L427" href="#L427">427</a> <em class="jxr_javadoccomment">     * Close a &lt;code&gt;Connection&lt;/code&gt;. This implementation avoids closing if</em>
+<a class="jxr_linenumber" name="L428" href="#L428">428</a> <em class="jxr_javadoccomment">     * null and does &lt;strong&gt;not&lt;/strong&gt; suppress any exceptions. Subclasses</em>
+<a class="jxr_linenumber" name="L429" href="#L429">429</a> <em class="jxr_javadoccomment">     * can override to provide special handling like logging.</em>
+<a class="jxr_linenumber" name="L430" href="#L430">430</a> <em class="jxr_javadoccomment">     *</em>
+<a class="jxr_linenumber" name="L431" href="#L431">431</a> <em class="jxr_javadoccomment">     * @param conn</em>
+<a class="jxr_linenumber" name="L432" href="#L432">432</a> <em class="jxr_javadoccomment">     *            Connection to close</em>
+<a class="jxr_linenumber" name="L433" href="#L433">433</a> <em class="jxr_javadoccomment">     * @throws SQLException</em>
+<a class="jxr_linenumber" name="L434" href="#L434">434</a> <em class="jxr_javadoccomment">     *             if a database access error occurs</em>
+<a class="jxr_linenumber" name="L435" href="#L435">435</a> <em class="jxr_javadoccomment">     * @since DbUtils 1.1</em>
+<a class="jxr_linenumber" name="L436" href="#L436">436</a> <em class="jxr_javadoccomment">     */</em>
+<a class="jxr_linenumber" name="L437" href="#L437">437</a>     <strong class="jxr_keyword">protected</strong> <strong class="jxr_keyword">void</strong> close(Connection conn) <strong class="jxr_keyword">throws</strong> SQLException {
+<a class="jxr_linenumber" name="L438" href="#L438">438</a>         DbUtils.close(conn);
+<a class="jxr_linenumber" name="L439" href="#L439">439</a>     }
+<a class="jxr_linenumber" name="L440" href="#L440">440</a> 
+<a class="jxr_linenumber" name="L441" href="#L441">441</a>     <em class="jxr_javadoccomment">/**</em>
+<a class="jxr_linenumber" name="L442" href="#L442">442</a> <em class="jxr_javadoccomment">     * Close a &lt;code&gt;Statement&lt;/code&gt;. This implementation avoids closing if</em>
+<a class="jxr_linenumber" name="L443" href="#L443">443</a> <em class="jxr_javadoccomment">     * null and does &lt;strong&gt;not&lt;/strong&gt; suppress any exceptions. Subclasses</em>
+<a class="jxr_linenumber" name="L444" href="#L444">444</a> <em class="jxr_javadoccomment">     * can override to provide special handling like logging.</em>
+<a class="jxr_linenumber" name="L445" href="#L445">445</a> <em class="jxr_javadoccomment">     *</em>
+<a class="jxr_linenumber" name="L446" href="#L446">446</a> <em class="jxr_javadoccomment">     * @param stmt</em>
+<a class="jxr_linenumber" name="L447" href="#L447">447</a> <em class="jxr_javadoccomment">     *            Statement to close</em>
+<a class="jxr_linenumber" name="L448" href="#L448">448</a> <em class="jxr_javadoccomment">     * @throws SQLException</em>
+<a class="jxr_linenumber" name="L449" href="#L449">449</a> <em class="jxr_javadoccomment">     *             if a database access error occurs</em>
+<a class="jxr_linenumber" name="L450" href="#L450">450</a> <em class="jxr_javadoccomment">     * @since DbUtils 1.1</em>
+<a class="jxr_linenumber" name="L451" href="#L451">451</a> <em class="jxr_javadoccomment">     */</em>
+<a class="jxr_linenumber" name="L452" href="#L452">452</a>     <strong class="jxr_keyword">protected</strong> <strong class="jxr_keyword">void</strong> close(Statement stmt) <strong class="jxr_keyword">throws</strong> SQLException {
+<a class="jxr_linenumber" name="L453" href="#L453">453</a>         DbUtils.close(stmt);
+<a class="jxr_linenumber" name="L454" href="#L454">454</a>     }
+<a class="jxr_linenumber" name="L455" href="#L455">455</a> 
+<a class="jxr_linenumber" name="L456" href="#L456">456</a>     <em class="jxr_javadoccomment">/**</em>
+<a class="jxr_linenumber" name="L457" href="#L457">457</a> <em class="jxr_javadoccomment">     * Close a &lt;code&gt;ResultSet&lt;/code&gt;. This implementation avoids closing if</em>
+<a class="jxr_linenumber" name="L458" href="#L458">458</a> <em class="jxr_javadoccomment">     * null and does &lt;strong&gt;not&lt;/strong&gt; suppress any exceptions. Subclasses</em>
+<a class="jxr_linenumber" name="L459" href="#L459">459</a> <em class="jxr_javadoccomment">     * can override to provide special handling like logging.</em>
+<a class="jxr_linenumber" name="L460" href="#L460">460</a> <em class="jxr_javadoccomment">     *</em>
+<a class="jxr_linenumber" name="L461" href="#L461">461</a> <em class="jxr_javadoccomment">     * @param rs</em>
+<a class="jxr_linenumber" name="L462" href="#L462">462</a> <em class="jxr_javadoccomment">     *            ResultSet to close</em>
+<a class="jxr_linenumber" name="L463" href="#L463">463</a> <em class="jxr_javadoccomment">     * @throws SQLException</em>
+<a class="jxr_linenumber" name="L464" href="#L464">464</a> <em class="jxr_javadoccomment">     *             if a database access error occurs</em>
+<a class="jxr_linenumber" name="L465" href="#L465">465</a> <em class="jxr_javadoccomment">     * @since DbUtils 1.1</em>
+<a class="jxr_linenumber" name="L466" href="#L466">466</a> <em class="jxr_javadoccomment">     */</em>
+<a class="jxr_linenumber" name="L467" href="#L467">467</a>     <strong class="jxr_keyword">protected</strong> <strong class="jxr_keyword">void</strong> close(ResultSet rs) <strong class="jxr_keyword">throws</strong> SQLException {
+<a class="jxr_linenumber" name="L468" href="#L468">468</a>         DbUtils.close(rs);
+<a class="jxr_linenumber" name="L469" href="#L469">469</a>     }
+<a class="jxr_linenumber" name="L470" href="#L470">470</a> 
+<a class="jxr_linenumber" name="L471" href="#L471">471</a> }
 </pre>
 <hr/>
 <div id="footer">Copyright &#169; 2002&#x2013;2014 <a href="http://www.apache.org/">The Apache Software Foundation</a>. All rights reserved.</div>



Mime
View raw message