DatabaseManager.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 id='line_18' class='line_number'>18</SPAN><span class='access'>public</span> <span class='typedef'>class</span> DatabaseManager <SPAN id='line_19' class='line_number'>19</SPAN>{ <SPAN id='line_20' class='line_number'>20</SPAN> <span class='access'>public</span> <span class='storage'>static</span> Connection getActiveConnection() <SPAN id='line_21' class='line_number'>21</SPAN> { <SPAN id='line_22' class='line_number'>22</SPAN> <span class='comment'>// Not implemented (sample code only)</span> <SPAN id='line_23' class='line_number'>23</SPAN> <span class='flow'>return</span> <span class='operator'>null</span><span class='operator'>;</span> <SPAN id='line_24' class='line_number'>24</SPAN> } <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='storage'>static</span> <span class='type'>int</span> getIntegerResult(ResultSet results) <span class='throw'>throws</span> <span class='type'>SQLException</span> <SPAN id='line_27' class='line_number'>27</SPAN> { <SPAN id='line_28' class='line_number'>28</SPAN> <span class='comment'>// This is not particularly good JDBC code. Please don't do this in your own applications.</span> <SPAN id='line_29' class='line_number'>29</SPAN> results<span class='operator'>.</span>next()<span class='operator'>;</span> <SPAN id='line_30' class='line_number'>30</SPAN> <span class='type'>int</span> count <span class='operator'>=</span> results<span class='operator'>.</span>getInt(<span class='number'>1</span>)<span class='operator'>;</span> <SPAN id='line_31' class='line_number'>31</SPAN> results<span class='operator'>.</span>close()<span class='operator'>;</span> <SPAN id='line_32' class='line_number'>32</SPAN> <span class='flow'>return</span> count<span class='operator'>;</span> <SPAN id='line_33' class='line_number'>33</SPAN> } <SPAN id='line_34' class='line_number'>34</SPAN> <SPAN id='line_35' class='line_number'>35</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; public class DatabaseManager { public static Connection getActiveConnection() { // Not implemented (sample code only) return null; } public static int getIntegerResult(ResultSet results) throws SQLException { // This is not particularly good JDBC code. Please don't do this in your own applications. results.next(); int count = results.getInt(1); results.close(); return count; } }</PRE></DIV> </BODY></HTML>