Main.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>PreparedStatement<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>logging<span class='operator'>.</span>ConsoleHandler<span class='operator'>;</span> <SPAN id='line_20' class='line_number'>20</SPAN><span class='package'>import</span> java<span class='operator'>.</span>util<span class='operator'>.</span>logging<span class='operator'>.</span>Level<span class='operator'>;</span> <SPAN id='line_21' class='line_number'>21</SPAN><span class='package'>import</span> java<span class='operator'>.</span>util<span class='operator'>.</span>logging<span class='operator'>.</span>Logger<span class='operator'>;</span> <SPAN id='line_22' class='line_number'>22</SPAN> <SPAN id='line_23' class='line_number'>23</SPAN><span class='access'>public</span> <span class='typedef'>class</span> Main <SPAN id='line_24' class='line_number'>24</SPAN>{ <SPAN id='line_25' class='line_number'>25</SPAN> <span class='access'>public</span> <span class='storage'>static</span> <span class='type'>void</span> main(<span class='type'>String</span><span class='operator'>[</span><span class='operator'>]</span> args) <span class='throw'>throws</span> <span class='type'>Exception</span> <SPAN id='line_26' class='line_number'>26</SPAN> { <SPAN id='line_27' class='line_number'>27</SPAN> configureLogging()<span class='operator'>;</span> <SPAN id='line_28' class='line_number'>28</SPAN> Connection connection <span class='operator'>=</span> createConnection()<span class='operator'>;</span> <SPAN id='line_29' class='line_number'>29</SPAN> setupTable(connection)<span class='operator'>;</span> <SPAN id='line_30' class='line_number'>30</SPAN> queryTable(connection)<span class='operator'>;</span> <SPAN id='line_31' class='line_number'>31</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'>void</span> configureLogging() <SPAN id='line_34' class='line_number'>34</SPAN> { <SPAN id='line_35' class='line_number'>35</SPAN> ConsoleHandler handler <span class='operator'>=</span> <span class='operator'>new</span> ConsoleHandler()<span class='operator'>;</span> <SPAN id='line_36' class='line_number'>36</SPAN> Logger logger <span class='operator'>=</span> Logger<span class='operator'>.</span>getLogger(<span class='string'>"jdbc.trace"</span>)<span class='operator'>;</span> <SPAN id='line_37' class='line_number'>37</SPAN> <SPAN id='line_38' class='line_number'>38</SPAN> handler<span class='operator'>.</span>setLevel(Level<span class='operator'>.</span>FINER)<span class='operator'>;</span> <SPAN id='line_39' class='line_number'>39</SPAN> logger<span class='operator'>.</span>setLevel(Level<span class='operator'>.</span>FINER)<span class='operator'>;</span> <SPAN id='line_40' class='line_number'>40</SPAN> logger<span class='operator'>.</span>addHandler(handler)<span class='operator'>;</span> <SPAN id='line_41' class='line_number'>41</SPAN> } <SPAN id='line_42' class='line_number'>42</SPAN> <SPAN id='line_43' class='line_number'>43</SPAN> <span class='access'>private</span> <span class='storage'>static</span> Connection createConnection() <span class='throw'>throws</span> <span class='type'>ClassNotFoundException</span><span class='operator'>,</span> <span class='type'>SQLException</span> <SPAN id='line_44' class='line_number'>44</SPAN> { <SPAN id='line_45' class='line_number'>45</SPAN> <span class='comment'>// This sample is configured to use the H2 database (http://www.h2database.com), but other databases can be used in its place</span> <SPAN id='line_46' class='line_number'>46</SPAN> <span class='type'>Class</span><span class='operator'>.</span>forName(<span class='string'>"org.h2.Driver"</span>)<span class='operator'>;</span> <SPAN id='line_47' class='line_number'>47</SPAN> Connection connection <span class='operator'>=</span> ConnectionManager<span class='operator'>.</span>getConnection(<span class='string'>"jdbc:h2:mem:test"</span><span class='operator'>,</span> <span class='string'>"sa"</span><span class='operator'>,</span> <span class='string'>""</span>)<span class='operator'>;</span> <SPAN id='line_48' class='line_number'>48</SPAN> <span class='flow'>return</span> connection<span class='operator'>;</span> <SPAN id='line_49' class='line_number'>49</SPAN> } <SPAN id='line_50' class='line_number'>50</SPAN> <SPAN id='line_51' class='line_number'>51</SPAN> <span class='access'>private</span> <span class='storage'>static</span> <span class='type'>void</span> queryTable(Connection connection) <span class='throw'>throws</span> <span class='type'>SQLException</span> <SPAN id='line_52' class='line_number'>52</SPAN> { <SPAN id='line_53' class='line_number'>53</SPAN> PreparedStatement statement <span class='operator'>=</span> connection<span class='operator'>.</span>prepareStatement(<span class='string'>"SELECT * FROM test"</span>)<span class='operator'>;</span> <SPAN id='line_54' class='line_number'>54</SPAN> ResultSet results <span class='operator'>=</span> statement<span class='operator'>.</span>executeQuery()<span class='operator'>;</span> <SPAN id='line_55' class='line_number'>55</SPAN> <span class='loop'>while</span> (results<span class='operator'>.</span>next()) <SPAN id='line_56' class='line_number'>56</SPAN> { <SPAN id='line_57' class='line_number'>57</SPAN> <span class='type'>int</span> columnValue <span class='operator'>=</span> results<span class='operator'>.</span>getInt(<span class='number'>1</span>)<span class='operator'>;</span> <SPAN id='line_58' class='line_number'>58</SPAN> System<span class='operator'>.</span>out<span class='operator'>.</span>println(<span class='string'>"Column value: "</span> <span class='operator'>+</span> columnValue)<span class='operator'>;</span> <SPAN id='line_59' class='line_number'>59</SPAN> } <SPAN id='line_60' class='line_number'>60</SPAN> } <SPAN id='line_61' class='line_number'>61</SPAN> <SPAN id='line_62' class='line_number'>62</SPAN> <span class='access'>private</span> <span class='storage'>static</span> <span class='type'>void</span> setupTable(Connection connection) <span class='throw'>throws</span> <span class='type'>SQLException</span> <SPAN id='line_63' class='line_number'>63</SPAN> { <SPAN id='line_64' class='line_number'>64</SPAN> Statement statement <span class='operator'>=</span> connection<span class='operator'>.</span>createStatement()<span class='operator'>;</span> <SPAN id='line_65' class='line_number'>65</SPAN> statement<span class='operator'>.</span>execute(<span class='string'>"CREATE TABLE test ( value INTEGER NOT NULL )"</span>)<span class='operator'>;</span> <SPAN id='line_66' class='line_number'>66</SPAN> statement<span class='operator'>.</span>execute(<span class='string'>"INSERT INTO test VALUES ( 1 )"</span>)<span class='operator'>;</span> <SPAN id='line_67' class='line_number'>67</SPAN> statement<span class='operator'>.</span>execute(<span class='string'>"INSERT INTO test VALUES ( 2 )"</span>)<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 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.PreparedStatement; import java.sql.ResultSet; import java.sql.SQLException; import java.sql.Statement; import java.util.logging.ConsoleHandler; import java.util.logging.Level; import java.util.logging.Logger; public class Main { public static void main(String[] args) throws Exception { configureLogging(); Connection connection = createConnection(); setupTable(connection); queryTable(connection); } private static void configureLogging() { ConsoleHandler handler = new ConsoleHandler(); Logger logger = Logger.getLogger("jdbc.trace"); handler.setLevel(Level.FINER); logger.setLevel(Level.FINER); logger.addHandler(handler); } private static Connection createConnection() throws ClassNotFoundException, SQLException { // This sample is configured to use the H2 database (http://www.h2database.com), but other databases can be used in its place Class.forName("org.h2.Driver"); Connection connection = ConnectionManager.getConnection("jdbc:h2:mem:test", "sa", ""); return connection; } private static void queryTable(Connection connection) throws SQLException { PreparedStatement statement = connection.prepareStatement("SELECT * FROM test"); ResultSet results = statement.executeQuery(); while (results.next()) { int columnValue = results.getInt(1); System.out.println("Column value: " + columnValue); } } private static void setupTable(Connection connection) throws SQLException { Statement statement = connection.createStatement(); statement.execute("CREATE TABLE test ( value INTEGER NOT NULL )"); statement.execute("INSERT INTO test VALUES ( 1 )"); statement.execute("INSERT INTO test VALUES ( 2 )"); } }</PRE></DIV> </BODY></HTML>