You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@commons.apache.org by br...@apache.org on 2014/07/20 10:52:25 UTC
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/...
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 <code>PreparedStatement</code>.</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 <code>Connection</code></em>
-<a class="jxr_linenumber" name="L187" href="#L187">187</a> <em class="jxr_javadoccomment"> * object. <code>QueryRunner</code> 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 <code>Connection</code> configuration if</em>
-<a class="jxr_linenumber" name="L190" href="#L190">190</a> <em class="jxr_javadoccomment"> * needed. This implementation simply calls <code>ds.getConnection()</code>.</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 <code>Connection</code>.</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 <code>PreparedStatement</code> 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; <code>null</code> 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 < 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 <code>PreparedStatement</code> 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 < 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 <code>PreparedStatement</code> 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 < 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 < 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; <code>null</code> 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 <code>ResultSet</code> 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 <code>ResultSet</code> 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"> * <p></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"> * </p></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"> * <pre></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"> * </pre></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 <code>ResultSet</code> to decorate; never</em>
-<a class="jxr_linenumber" name="L418" href="#L418">418</a> <em class="jxr_javadoccomment"> * <code>null</code>.</em>
-<a class="jxr_linenumber" name="L419" href="#L419">419</a> <em class="jxr_javadoccomment"> * @return The <code>ResultSet</code> 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 <code>Connection</code>. This implementation avoids closing if</em>
-<a class="jxr_linenumber" name="L427" href="#L427">427</a> <em class="jxr_javadoccomment"> * null and does <strong>not</strong> 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 <code>Statement</code>. This implementation avoids closing if</em>
-<a class="jxr_linenumber" name="L442" href="#L442">442</a> <em class="jxr_javadoccomment"> * null and does <strong>not</strong> 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 <code>ResultSet</code>. This implementation avoids closing if</em>
-<a class="jxr_linenumber" name="L457" href="#L457">457</a> <em class="jxr_javadoccomment"> * null and does <strong>not</strong> 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 <code>Connection</code></em>
+<a class="jxr_linenumber" name="L188" href="#L188">188</a> <em class="jxr_javadoccomment"> * object. <code>QueryRunner</code> 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 <code>Connection</code> configuration if</em>
+<a class="jxr_linenumber" name="L191" href="#L191">191</a> <em class="jxr_javadoccomment"> * needed. This implementation simply calls <code>ds.getConnection()</code>.</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 <code>Connection</code>.</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 <code>PreparedStatement</code> 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; <code>null</code> 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 < 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 <code>PreparedStatement</code> 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 < 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 <code>PreparedStatement</code> 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 < 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 < 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; <code>null</code> 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 <code>ResultSet</code> 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 <code>ResultSet</code> 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"> * <p></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"> * </p></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"> * <pre></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"> * </pre></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 <code>ResultSet</code> to decorate; never</em>
+<a class="jxr_linenumber" name="L419" href="#L419">419</a> <em class="jxr_javadoccomment"> * <code>null</code>.</em>
+<a class="jxr_linenumber" name="L420" href="#L420">420</a> <em class="jxr_javadoccomment"> * @return The <code>ResultSet</code> 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 <code>Connection</code>. This implementation avoids closing if</em>
+<a class="jxr_linenumber" name="L428" href="#L428">428</a> <em class="jxr_javadoccomment"> * null and does <strong>not</strong> 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 <code>Statement</code>. This implementation avoids closing if</em>
+<a class="jxr_linenumber" name="L443" href="#L443">443</a> <em class="jxr_javadoccomment"> * null and does <strong>not</strong> 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 <code>ResultSet</code>. This implementation avoids closing if</em>
+<a class="jxr_linenumber" name="L458" href="#L458">458</a> <em class="jxr_javadoccomment"> * null and does <strong>not</strong> 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 © 2002–2014 <a href="http://www.apache.org/">The Apache Software Foundation</a>. All rights reserved.</div>