WiringItUp.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> logging_interceptor<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>ResultSet<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><span class='type'>SQLException</span><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>Statement<span class='operator'>;</span> <SPAN id='line_18' class='line_number'>18</SPAN> <SPAN id='line_19' class='line_number'>19</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_20' class='line_number'>20</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/InterceptorStack.html'>InterceptorStack</a></span><span class='operator'>;</span> <SPAN id='line_21' class='line_number'>21</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/MethodInterceptorStack.html'>MethodInterceptorStack</a></span><span class='operator'>;</span> <SPAN id='line_22' class='line_number'>22</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_23' class='line_number'>23</SPAN> <SPAN id='line_24' class='line_number'>24</SPAN><span class='access'>public</span> <span class='typedef'>class</span> WiringItUp <SPAN id='line_25' class='line_number'>25</SPAN>{ <SPAN id='line_26' class='line_number'>26</SPAN> <span class='access'>public</span> <span class='type'><a title='View javadoc' href='../../api/net/sf/tie/MethodInterceptorStack.html'>MethodInterceptorStack</a></span> createStack() <SPAN id='line_27' class='line_number'>27</SPAN> { <SPAN id='line_28' class='line_number'>28</SPAN> <span class='flow'>return</span> <span class='type'><a title='View javadoc' href='../../api/net/sf/tie/InterceptorStack.html'>InterceptorStack</a></span><span class='operator'>.</span>singleton(<span class='operator'>new</span> LoggingInterceptor())<span class='operator'>;</span> <SPAN id='line_29' class='line_number'>29</SPAN> } <SPAN id='line_30' class='line_number'>30</SPAN> <SPAN id='line_31' class='line_number'>31</SPAN> <span class='access'>public</span> <span class='type'><a title='View javadoc' href='../../api/net/sf/tie/InterceptionInjector.html'>InterceptionInjector</a></span> createInjector() <SPAN id='line_32' class='line_number'>32</SPAN> { <SPAN id='line_33' class='line_number'>33</SPAN> <span class='type'><a title='View javadoc' href='../../api/net/sf/tie/MethodInterceptorStack.html'>MethodInterceptorStack</a></span> stack <span class='operator'>=</span> createStack()<span class='operator'>;</span> <SPAN id='line_34' class='line_number'>34</SPAN> <span class='flow'>return</span> <span class='operator'>new</span> <span class='type'><a title='View javadoc' href='../../api/net/sf/tie/ProxyInjector.html'>ProxyInjector</a></span>(stack)<span class='operator'>;</span> <SPAN id='line_35' class='line_number'>35</SPAN> } <SPAN id='line_36' class='line_number'>36</SPAN> <SPAN id='line_37' class='line_number'>37</SPAN> <span class='access'>public</span> Statement getStatement(Connection connection) <span class='throw'>throws</span> <span class='type'>SQLException</span> <SPAN id='line_38' class='line_number'>38</SPAN> { <SPAN id='line_39' class='line_number'>39</SPAN> <span class='type'><a title='View javadoc' href='../../api/net/sf/tie/InterceptionInjector.html'>InterceptionInjector</a></span> injector <span class='operator'>=</span> createInjector()<span class='operator'>;</span> <SPAN id='line_40' class='line_number'>40</SPAN> Statement statement <span class='operator'>=</span> connection<span class='operator'>.</span>createStatement()<span class='operator'>;</span> <SPAN id='line_41' class='line_number'>41</SPAN> <span class='flow'>return</span> injector<span class='operator'>.</span>wrapObject(Statement<span class='operator'>.</span><span class='typedef'>class</span><span class='operator'>,</span> statement)<span class='operator'>;</span> <SPAN id='line_42' class='line_number'>42</SPAN> } <SPAN id='line_43' class='line_number'>43</SPAN> <SPAN id='line_44' class='line_number'>44</SPAN> <span class='access'>public</span> <span class='type'>int</span> getNumberOfOrders() <span class='throw'>throws</span> <span class='type'>SQLException</span> <SPAN id='line_45' class='line_number'>45</SPAN> { <SPAN id='line_46' class='line_number'>46</SPAN> Connection connection <span class='operator'>=</span> DatabaseManager<span class='operator'>.</span>getActiveConnection()<span class='operator'>;</span> <SPAN id='line_47' class='line_number'>47</SPAN> Statement statement <span class='operator'>=</span> getStatement(connection)<span class='operator'>;</span> <SPAN id='line_48' class='line_number'>48</SPAN> <span class='throw'>try</span> <SPAN id='line_49' class='line_number'>49</SPAN> { <SPAN id='line_50' class='line_number'>50</SPAN> ResultSet results <span class='operator'>=</span> statement<span class='operator'>.</span>executeQuery(<span class='string'>"SELECT COUNT(*) FROM orders"</span>)<span class='operator'>;</span> <SPAN id='line_51' class='line_number'>51</SPAN> <span class='flow'>return</span> DatabaseManager<span class='operator'>.</span>getIntegerResult(results)<span class='operator'>;</span> <SPAN id='line_52' class='line_number'>52</SPAN> } <SPAN id='line_53' class='line_number'>53</SPAN> finally <SPAN id='line_54' class='line_number'>54</SPAN> { <SPAN id='line_55' class='line_number'>55</SPAN> statement<span class='operator'>.</span>close()<span class='operator'>;</span> <SPAN id='line_56' class='line_number'>56</SPAN> } <SPAN id='line_57' class='line_number'>57</SPAN> } <SPAN id='line_58' class='line_number'>58</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 logging_interceptor; import java.sql.Connection; import java.sql.ResultSet; import java.sql.SQLException; import java.sql.Statement; import net.sf.tie.InterceptionInjector; import net.sf.tie.InterceptorStack; import net.sf.tie.MethodInterceptorStack; import net.sf.tie.ProxyInjector; public class WiringItUp { public MethodInterceptorStack createStack() { return InterceptorStack.singleton(new LoggingInterceptor()); } public InterceptionInjector createInjector() { MethodInterceptorStack stack = createStack(); return new ProxyInjector(stack); } public Statement getStatement(Connection connection) throws SQLException { InterceptionInjector injector = createInjector(); Statement statement = connection.createStatement(); return injector.wrapObject(Statement.class, statement); } public int getNumberOfOrders() throws SQLException { Connection connection = DatabaseManager.getActiveConnection(); Statement statement = getStatement(connection); try { ResultSet results = statement.executeQuery("SELECT COUNT(*) FROM orders"); return DatabaseManager.getIntegerResult(results); } finally { statement.close(); } } }</PRE></DIV> </BODY></HTML>