ConnectionManager.java<TITLE> <LINK rel="stylesheet" href="..//java.css" type="text/css" media="all" /> </HEAD> <BODY id="java">  <SCRIPT type="text/javascript" src="..//java.js" /> <TABLE class="tabs"><TR> <TD id="tab_colour" class="active"><A HREF='javascript:set_style("colour")'>Coloured</A></TD> <TD id="tab_raw" class="inactive"><A HREF='javascript:set_style("raw")'>Raw</A></TD> </TR></TABLE> <DIV id="colour" class="display"> <PRE class="colour" id="code"> <SPAN id='line_0' class='line_number'> </SPAN> <SPAN id='line_1' class='line_number'> 1</SPAN><span class='comment'>// Copyright 2007, Tim Vernum</span> <SPAN id='line_2' class='line_number'> 2</SPAN><span class='comment'>// Permission is hereby granted, free of charge, to any person obtaining a copy of this software and associated documentation </span> <SPAN id='line_3' class='line_number'> 3</SPAN><span class='comment'>// files (the "Software"), to deal in the Software without restriction, including without limitation the rights to use, copy,</span> <SPAN id='line_4' class='line_number'> 4</SPAN><span class='comment'>// modify, merge, publish, distribute, sublicense, and/or sell copies of the Software, and to permit persons to whom the</span> <SPAN id='line_5' class='line_number'> 5</SPAN><span class='comment'>// Software is furnished to do so, subject to the following conditions:</span> <SPAN id='line_6' class='line_number'> 6</SPAN><span class='comment'>// The above copyright notice and this permission notice shall be included in all copies or substantial portions of the Software.</span> <SPAN id='line_7' class='line_number'> 7</SPAN><span class='comment'>// THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE </span> <SPAN id='line_8' class='line_number'> 8</SPAN><span class='comment'>// WARRANTIES OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE AUTHORS OR </span> <SPAN id='line_9' class='line_number'> 9</SPAN><span class='comment'>// COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE,</span> <SPAN id='line_10' class='line_number'>10</SPAN><span class='comment'>// ARISING FROM, OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE SOFTWARE.</span> <SPAN id='line_11' class='line_number'>11</SPAN> <SPAN id='line_12' class='line_number'>12</SPAN><span class='package'>package</span> jdbc_wrapper<span class='operator'>;</span> <SPAN id='line_13' class='line_number'>13</SPAN> <SPAN id='line_14' class='line_number'>14</SPAN><span class='package'>import</span> java<span class='operator'>.</span>sql<span class='operator'>.</span>Connection<span class='operator'>;</span> <SPAN id='line_15' class='line_number'>15</SPAN><span class='package'>import</span> java<span class='operator'>.</span>sql<span class='operator'>.</span>DriverManager<span class='operator'>;</span> <SPAN id='line_16' class='line_number'>16</SPAN><span class='package'>import</span> java<span class='operator'>.</span>sql<span class='operator'>.</span>ResultSet<span class='operator'>;</span> <SPAN id='line_17' class='line_number'>17</SPAN><span class='package'>import</span> java<span class='operator'>.</span>sql<span class='operator'>.</span><span class='type'>SQLException</span><span class='operator'>;</span> <SPAN id='line_18' class='line_number'>18</SPAN><span class='package'>import</span> java<span class='operator'>.</span>sql<span class='operator'>.</span>Statement<span class='operator'>;</span> <SPAN id='line_19' class='line_number'>19</SPAN><span class='package'>import</span> java<span class='operator'>.</span>util<span class='operator'>.</span>Properties<span class='operator'>;</span> <SPAN id='line_20' class='line_number'>20</SPAN> <SPAN id='line_21' class='line_number'>21</SPAN><span class='package'>import</span> javax<span class='operator'>.</span>sql<span class='operator'>.</span>DataSource<span class='operator'>;</span> <SPAN id='line_22' class='line_number'>22</SPAN> <SPAN id='line_23' class='line_number'>23</SPAN><span class='package'>import</span> net<span class='operator'>.</span>sf<span class='operator'>.</span>tie<span class='operator'>.</span><span class='type'><a title='View javadoc' href='../../api/net/sf/tie/InterceptionInjector.html'>InterceptionInjector</a></span><span class='operator'>;</span> <SPAN id='line_24' class='line_number'>24</SPAN><span class='package'>import</span> net<span class='operator'>.</span>sf<span class='operator'>.</span>tie<span class='operator'>.</span><span class='type'><a title='View javadoc' href='../../api/net/sf/tie/ProxyInjector.html'>ProxyInjector</a></span><span class='operator'>;</span> <SPAN id='line_25' class='line_number'>25</SPAN><span class='package'>import</span> net<span class='operator'>.</span>sf<span class='operator'>.</span>tie<span class='operator'>.</span>ext<span class='operator'>.</span><span class='type'><a title='View javadoc' href='../../api/net/sf/tie/ext/InterceptionBuilder.html'>InterceptionBuilder</a></span><span class='operator'>;</span> <SPAN id='line_26' class='line_number'>26</SPAN><span class='package'>import</span> net<span class='operator'>.</span>sf<span class='operator'>.</span>tie<span class='operator'>.</span>ext<span class='operator'>.</span>interceptor<span class='operator'>.</span><span class='type'><a title='View javadoc' href='../../api/net/sf/tie/ext/interceptor/WrapReturnValueInterceptor.html'>WrapReturnValueInterceptor</a></span><span class='operator'>;</span> <SPAN id='line_27' class='line_number'>27</SPAN><span class='package'>import</span> net<span class='operator'>.</span>sf<span class='operator'>.</span>tie<span class='operator'>.</span>ext<span class='operator'>.</span>type<span class='operator'>.</span><span class='type'><a title='View javadoc' href='../../api/net/sf/tie/ext/type/ReturnTypeRule.html'>ReturnTypeRule</a></span><span class='operator'>;</span> <SPAN id='line_28' class='line_number'>28</SPAN> <SPAN id='line_29' class='line_number'>29</SPAN><span class='access'>public</span> <span class='typedef'>class</span> ConnectionManager <SPAN id='line_30' class='line_number'>30</SPAN>{ <SPAN id='line_31' class='line_number'>31</SPAN> <span class='access'>private</span> <span class='storage'>static</span> <span class='storage'>final</span> <span class='type'><a title='View javadoc' href='../../api/net/sf/tie/InterceptionInjector.html'>InterceptionInjector</a></span> INJECTOR <span class='operator'>=</span> buildInjector()<span class='operator'>;</span> <SPAN id='line_32' class='line_number'>32</SPAN> <SPAN id='line_33' class='line_number'>33</SPAN> <span class='access'>private</span> <span class='storage'>static</span> <span class='type'><a title='View javadoc' href='../../api/net/sf/tie/InterceptionInjector.html'>InterceptionInjector</a></span> buildInjector() <SPAN id='line_34' class='line_number'>34</SPAN> { <SPAN id='line_35' class='line_number'>35</SPAN> <span class='type'><a title='View javadoc' href='../../api/net/sf/tie/ext/InterceptionBuilder.html'>InterceptionBuilder</a></span> builder <span class='operator'>=</span> <span class='operator'>new</span> <span class='type'><a title='View javadoc' href='../../api/net/sf/tie/ext/InterceptionBuilder.html'>InterceptionBuilder</a></span>()<span class='operator'>;</span> <SPAN id='line_36' class='line_number'>36</SPAN> builder<span class='operator'>.</span>always(<span class='operator'>new</span> JDBCLoggingInterceptor())<span class='operator'>;</span> <SPAN id='line_37' class='line_number'>37</SPAN> <span class='type'><a title='View javadoc' href='../../api/net/sf/tie/ext/interceptor/WrapReturnValueInterceptor.html'>WrapReturnValueInterceptor</a></span> wrapReturnValueInterceptor <span class='operator'>=</span> <span class='operator'>new</span> <span class='type'><a title='View javadoc' href='../../api/net/sf/tie/ext/interceptor/WrapReturnValueInterceptor.html'>WrapReturnValueInterceptor</a></span>()<span class='operator'>;</span> <SPAN id='line_38' class='line_number'>38</SPAN> builder<span class='operator'>.</span>whenRuleMatches(getReturnTypeRule()<span class='operator'>,</span> wrapReturnValueInterceptor)<span class='operator'>;</span> <SPAN id='line_39' class='line_number'>39</SPAN> <SPAN id='line_40' class='line_number'>40</SPAN> <span class='type'><a title='View javadoc' href='../../api/net/sf/tie/ProxyInjector.html'>ProxyInjector</a></span> injector <span class='operator'>=</span> <span class='operator'>new</span> <span class='type'><a title='View javadoc' href='../../api/net/sf/tie/ProxyInjector.html'>ProxyInjector</a></span>(builder<span class='operator'>.</span>done())<span class='operator'>;</span> <SPAN id='line_41' class='line_number'>41</SPAN> wrapReturnValueInterceptor<span class='operator'>.</span>setInjector(injector)<span class='operator'>;</span> <SPAN id='line_42' class='line_number'>42</SPAN> <span class='flow'>return</span> injector<span class='operator'>;</span> <SPAN id='line_43' class='line_number'>43</SPAN> } <SPAN id='line_44' class='line_number'>44</SPAN> <SPAN id='line_45' class='line_number'>45</SPAN> <span class='access'>private</span> <span class='storage'>static</span> <span class='type'><a title='View javadoc' href='../../api/net/sf/tie/ext/type/ReturnTypeRule.html'>ReturnTypeRule</a></span> getReturnTypeRule() <SPAN id='line_46' class='line_number'>46</SPAN> { <SPAN id='line_47' class='line_number'>47</SPAN> <span class='type'><a title='View javadoc' href='../../api/net/sf/tie/ext/type/ReturnTypeRule.html'>ReturnTypeRule</a></span> returnTypeRule <span class='operator'>=</span> <span class='operator'>new</span> <span class='type'><a title='View javadoc' href='../../api/net/sf/tie/ext/type/ReturnTypeRule.html'>ReturnTypeRule</a></span>()<span class='operator'>;</span> <SPAN id='line_48' class='line_number'>48</SPAN> returnTypeRule<span class='operator'>.</span>addInheritedType(Statement<span class='operator'>.</span><span class='typedef'>class</span>)<span class='operator'>;</span> <SPAN id='line_49' class='line_number'>49</SPAN> returnTypeRule<span class='operator'>.</span>addDirectType(Connection<span class='operator'>.</span><span class='typedef'>class</span>)<span class='operator'>;</span> <SPAN id='line_50' class='line_number'>50</SPAN> returnTypeRule<span class='operator'>.</span>addDirectType(DataSource<span class='operator'>.</span><span class='typedef'>class</span>)<span class='operator'>;</span> <SPAN id='line_51' class='line_number'>51</SPAN> returnTypeRule<span class='operator'>.</span>addDirectType(ResultSet<span class='operator'>.</span><span class='typedef'>class</span>)<span class='operator'>;</span> <SPAN id='line_52' class='line_number'>52</SPAN> <span class='flow'>return</span> returnTypeRule<span class='operator'>;</span> <SPAN id='line_53' class='line_number'>53</SPAN> } <SPAN id='line_54' class='line_number'>54</SPAN> <SPAN id='line_55' class='line_number'>55</SPAN> <span class='access'>public</span> <span class='storage'>static</span> Connection getConnection(<span class='type'>String</span> url) <span class='throw'>throws</span> <span class='type'>SQLException</span> <SPAN id='line_56' class='line_number'>56</SPAN> { <SPAN id='line_57' class='line_number'>57</SPAN> <span class='flow'>return</span> intercept(DriverManager<span class='operator'>.</span>getConnection(url))<span class='operator'>;</span> <SPAN id='line_58' class='line_number'>58</SPAN> } <SPAN id='line_59' class='line_number'>59</SPAN> <SPAN id='line_60' class='line_number'>60</SPAN> <span class='access'>public</span> <span class='storage'>static</span> Connection getConnection(<span class='type'>String</span> url<span class='operator'>,</span> <span class='type'>String</span> user<span class='operator'>,</span> <span class='type'>String</span> password) <span class='throw'>throws</span> <span class='type'>SQLException</span> <SPAN id='line_61' class='line_number'>61</SPAN> { <SPAN id='line_62' class='line_number'>62</SPAN> <span class='flow'>return</span> intercept(DriverManager<span class='operator'>.</span>getConnection(url<span class='operator'>,</span> user<span class='operator'>,</span> password))<span class='operator'>;</span> <SPAN id='line_63' class='line_number'>63</SPAN> } <SPAN id='line_64' class='line_number'>64</SPAN> <SPAN id='line_65' class='line_number'>65</SPAN> <span class='access'>public</span> <span class='storage'>static</span> Connection getConnection(<span class='type'>String</span> url<span class='operator'>,</span> Properties properties) <span class='throw'>throws</span> <span class='type'>SQLException</span> <SPAN id='line_66' class='line_number'>66</SPAN> { <SPAN id='line_67' class='line_number'>67</SPAN> <span class='flow'>return</span> intercept(DriverManager<span class='operator'>.</span>getConnection(url<span class='operator'>,</span> properties))<span class='operator'>;</span> <SPAN id='line_68' class='line_number'>68</SPAN> } <SPAN id='line_69' class='line_number'>69</SPAN> <SPAN id='line_70' class='line_number'>70</SPAN> <span class='access'>public</span> <span class='storage'>static</span> DataSource intercept(DataSource dataSource) <SPAN id='line_71' class='line_number'>71</SPAN> { <SPAN id='line_72' class='line_number'>72</SPAN> <span class='flow'>return</span> INJECTOR<span class='operator'>.</span>wrapObject(DataSource<span class='operator'>.</span><span class='typedef'>class</span><span class='operator'>,</span> dataSource)<span class='operator'>;</span> <SPAN id='line_73' class='line_number'>73</SPAN> } <SPAN id='line_74' class='line_number'>74</SPAN> <SPAN id='line_75' class='line_number'>75</SPAN> <span class='access'>private</span> <span class='storage'>static</span> Connection intercept(Connection connection) <SPAN id='line_76' class='line_number'>76</SPAN> { <SPAN id='line_77' class='line_number'>77</SPAN> <span class='flow'>return</span> INJECTOR<span class='operator'>.</span>wrapObject(Connection<span class='operator'>.</span><span class='typedef'>class</span><span class='operator'>,</span> connection)<span class='operator'>;</span> <SPAN id='line_78' class='line_number'>78</SPAN> } <SPAN id='line_79' class='line_number'>79</SPAN>} <SPAN id='line_last' class='line_number'> </SPAN> </PRE></DIV> <DIV id='raw' class='hidden'><PRE class='raw'>// Copyright 2007, Tim Vernum // Permission is hereby granted, free of charge, to any person obtaining a copy of this software and associated documentation // files (the "Software"), to deal in the Software without restriction, including without limitation the rights to use, copy, // modify, merge, publish, distribute, sublicense, and/or sell copies of the Software, and to permit persons to whom the // Software is furnished to do so, subject to the following conditions: // The above copyright notice and this permission notice shall be included in all copies or substantial portions of the Software. // THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE // WARRANTIES OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE AUTHORS OR // COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, // ARISING FROM, OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE SOFTWARE. package jdbc_wrapper; import java.sql.Connection; import java.sql.DriverManager; import java.sql.ResultSet; import java.sql.SQLException; import java.sql.Statement; import java.util.Properties; import javax.sql.DataSource; import net.sf.tie.InterceptionInjector; import net.sf.tie.ProxyInjector; import net.sf.tie.ext.InterceptionBuilder; import net.sf.tie.ext.interceptor.WrapReturnValueInterceptor; import net.sf.tie.ext.type.ReturnTypeRule; public class ConnectionManager { private static final InterceptionInjector INJECTOR = buildInjector(); private static InterceptionInjector buildInjector() { InterceptionBuilder builder = new InterceptionBuilder(); builder.always(new JDBCLoggingInterceptor()); WrapReturnValueInterceptor wrapReturnValueInterceptor = new WrapReturnValueInterceptor(); builder.whenRuleMatches(getReturnTypeRule(), wrapReturnValueInterceptor); ProxyInjector injector = new ProxyInjector(builder.done()); wrapReturnValueInterceptor.setInjector(injector); return injector; } private static ReturnTypeRule getReturnTypeRule() { ReturnTypeRule returnTypeRule = new ReturnTypeRule(); returnTypeRule.addInheritedType(Statement.class); returnTypeRule.addDirectType(Connection.class); returnTypeRule.addDirectType(DataSource.class); returnTypeRule.addDirectType(ResultSet.class); return returnTypeRule; } public static Connection getConnection(String url) throws SQLException { return intercept(DriverManager.getConnection(url)); } public static Connection getConnection(String url, String user, String password) throws SQLException { return intercept(DriverManager.getConnection(url, user, password)); } public static Connection getConnection(String url, Properties properties) throws SQLException { return intercept(DriverManager.getConnection(url, properties)); } public static DataSource intercept(DataSource dataSource) { return INJECTOR.wrapObject(DataSource.class, dataSource); } private static Connection intercept(Connection connection) { return INJECTOR.wrapObject(Connection.class, connection); } }</PRE></DIV> </BODY></HTML>