| <!DOCTYPE HTML> |
| <html lang="en"> |
| <head> |
| <title>Source code</title> |
| <link rel="stylesheet" type="text/css" href="../../../../../stylesheet.css" title="Style"> |
| </head> |
| <body> |
| <main role="main"> |
| <div class="sourceContainer"> |
| <pre><span class="sourceLineNo">001</span><a id="line.1">/*</a> |
| <span class="sourceLineNo">002</span><a id="line.2"> * Licensed to the Apache Software Foundation (ASF) under one</a> |
| <span class="sourceLineNo">003</span><a id="line.3"> * or more contributor license agreements. See the NOTICE file</a> |
| <span class="sourceLineNo">004</span><a id="line.4"> * distributed with this work for additional information</a> |
| <span class="sourceLineNo">005</span><a id="line.5"> * regarding copyright ownership. The ASF licenses this file</a> |
| <span class="sourceLineNo">006</span><a id="line.6"> * to you under the Apache License, Version 2.0 (the</a> |
| <span class="sourceLineNo">007</span><a id="line.7"> * "License"); you may not use this file except in compliance</a> |
| <span class="sourceLineNo">008</span><a id="line.8"> * with the License. You may obtain a copy of the License at</a> |
| <span class="sourceLineNo">009</span><a id="line.9"> *</a> |
| <span class="sourceLineNo">010</span><a id="line.10"> * http://www.apache.org/licenses/LICENSE-2.0</a> |
| <span class="sourceLineNo">011</span><a id="line.11"> *</a> |
| <span class="sourceLineNo">012</span><a id="line.12"> * Unless required by applicable law or agreed to in writing,</a> |
| <span class="sourceLineNo">013</span><a id="line.13"> * software distributed under the License is distributed on an</a> |
| <span class="sourceLineNo">014</span><a id="line.14"> * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY</a> |
| <span class="sourceLineNo">015</span><a id="line.15"> * KIND, either express or implied. See the License for the</a> |
| <span class="sourceLineNo">016</span><a id="line.16"> * specific language governing permissions and limitations</a> |
| <span class="sourceLineNo">017</span><a id="line.17"> * under the License.</a> |
| <span class="sourceLineNo">018</span><a id="line.18"> */</a> |
| <span class="sourceLineNo">019</span><a id="line.19">package org.apache.shiro.util;</a> |
| <span class="sourceLineNo">020</span><a id="line.20"></a> |
| <span class="sourceLineNo">021</span><a id="line.21">import java.sql.Connection;</a> |
| <span class="sourceLineNo">022</span><a id="line.22">import java.sql.ResultSet;</a> |
| <span class="sourceLineNo">023</span><a id="line.23">import java.sql.SQLException;</a> |
| <span class="sourceLineNo">024</span><a id="line.24">import java.sql.Statement;</a> |
| <span class="sourceLineNo">025</span><a id="line.25"></a> |
| <span class="sourceLineNo">026</span><a id="line.26">import org.slf4j.Logger;</a> |
| <span class="sourceLineNo">027</span><a id="line.27">import org.slf4j.LoggerFactory;</a> |
| <span class="sourceLineNo">028</span><a id="line.28"></a> |
| <span class="sourceLineNo">029</span><a id="line.29">/**</a> |
| <span class="sourceLineNo">030</span><a id="line.30"> * A set of static helper methods for managing JDBC API objects.</a> |
| <span class="sourceLineNo">031</span><a id="line.31"> * <p/></a> |
| <span class="sourceLineNo">032</span><a id="line.32"> * <em>Note:</em> Some parts of this class were copied from the Spring Framework and then modified.</a> |
| <span class="sourceLineNo">033</span><a id="line.33"> * They were copied here to prevent Spring dependencies in the Shiro core API. The original license conditions</a> |
| <span class="sourceLineNo">034</span><a id="line.34"> * (Apache 2.0) have been maintained.</a> |
| <span class="sourceLineNo">035</span><a id="line.35"> *</a> |
| <span class="sourceLineNo">036</span><a id="line.36"> * @since 0.2</a> |
| <span class="sourceLineNo">037</span><a id="line.37"> */</a> |
| <span class="sourceLineNo">038</span><a id="line.38">public class JdbcUtils {</a> |
| <span class="sourceLineNo">039</span><a id="line.39"></a> |
| <span class="sourceLineNo">040</span><a id="line.40"> /** Private internal log instance. */</a> |
| <span class="sourceLineNo">041</span><a id="line.41"> private static final Logger log = LoggerFactory.getLogger(JdbcUtils.class);</a> |
| <span class="sourceLineNo">042</span><a id="line.42"></a> |
| <span class="sourceLineNo">043</span><a id="line.43"> /**</a> |
| <span class="sourceLineNo">044</span><a id="line.44"> * Private constructor to prevent instantiation.</a> |
| <span class="sourceLineNo">045</span><a id="line.45"> */</a> |
| <span class="sourceLineNo">046</span><a id="line.46"> private JdbcUtils() {</a> |
| <span class="sourceLineNo">047</span><a id="line.47"> }</a> |
| <span class="sourceLineNo">048</span><a id="line.48"></a> |
| <span class="sourceLineNo">049</span><a id="line.49"> /**</a> |
| <span class="sourceLineNo">050</span><a id="line.50"> * Close the given JDBC Connection and ignore any thrown exception.</a> |
| <span class="sourceLineNo">051</span><a id="line.51"> * This is useful for typical finally blocks in manual JDBC code.</a> |
| <span class="sourceLineNo">052</span><a id="line.52"> *</a> |
| <span class="sourceLineNo">053</span><a id="line.53"> * @param connection the JDBC Connection to close (may be <tt>null</tt>)</a> |
| <span class="sourceLineNo">054</span><a id="line.54"> */</a> |
| <span class="sourceLineNo">055</span><a id="line.55"> public static void closeConnection(Connection connection) {</a> |
| <span class="sourceLineNo">056</span><a id="line.56"> if (connection != null) {</a> |
| <span class="sourceLineNo">057</span><a id="line.57"> try {</a> |
| <span class="sourceLineNo">058</span><a id="line.58"> connection.close();</a> |
| <span class="sourceLineNo">059</span><a id="line.59"> } catch (SQLException ex) {</a> |
| <span class="sourceLineNo">060</span><a id="line.60"> if (log.isDebugEnabled()) {</a> |
| <span class="sourceLineNo">061</span><a id="line.61"> log.debug("Could not close JDBC Connection", ex);</a> |
| <span class="sourceLineNo">062</span><a id="line.62"> }</a> |
| <span class="sourceLineNo">063</span><a id="line.63"> } catch (Throwable ex) {</a> |
| <span class="sourceLineNo">064</span><a id="line.64"> if (log.isDebugEnabled()) {</a> |
| <span class="sourceLineNo">065</span><a id="line.65"> log.debug("Unexpected exception on closing JDBC Connection", ex);</a> |
| <span class="sourceLineNo">066</span><a id="line.66"> }</a> |
| <span class="sourceLineNo">067</span><a id="line.67"> }</a> |
| <span class="sourceLineNo">068</span><a id="line.68"> }</a> |
| <span class="sourceLineNo">069</span><a id="line.69"> }</a> |
| <span class="sourceLineNo">070</span><a id="line.70"></a> |
| <span class="sourceLineNo">071</span><a id="line.71"> /**</a> |
| <span class="sourceLineNo">072</span><a id="line.72"> * Close the given JDBC Statement and ignore any thrown exception.</a> |
| <span class="sourceLineNo">073</span><a id="line.73"> * This is useful for typical finally blocks in manual JDBC code.</a> |
| <span class="sourceLineNo">074</span><a id="line.74"> *</a> |
| <span class="sourceLineNo">075</span><a id="line.75"> * @param statement the JDBC Statement to close (may be <tt>null</tt>)</a> |
| <span class="sourceLineNo">076</span><a id="line.76"> */</a> |
| <span class="sourceLineNo">077</span><a id="line.77"> public static void closeStatement(Statement statement) {</a> |
| <span class="sourceLineNo">078</span><a id="line.78"> if (statement != null) {</a> |
| <span class="sourceLineNo">079</span><a id="line.79"> try {</a> |
| <span class="sourceLineNo">080</span><a id="line.80"> statement.close();</a> |
| <span class="sourceLineNo">081</span><a id="line.81"> } catch (SQLException ex) {</a> |
| <span class="sourceLineNo">082</span><a id="line.82"> if (log.isDebugEnabled()) {</a> |
| <span class="sourceLineNo">083</span><a id="line.83"> log.debug("Could not close JDBC Statement", ex);</a> |
| <span class="sourceLineNo">084</span><a id="line.84"> }</a> |
| <span class="sourceLineNo">085</span><a id="line.85"> } catch (Throwable ex) {</a> |
| <span class="sourceLineNo">086</span><a id="line.86"> if (log.isDebugEnabled()) {</a> |
| <span class="sourceLineNo">087</span><a id="line.87"> log.debug("Unexpected exception on closing JDBC Statement", ex);</a> |
| <span class="sourceLineNo">088</span><a id="line.88"> }</a> |
| <span class="sourceLineNo">089</span><a id="line.89"> }</a> |
| <span class="sourceLineNo">090</span><a id="line.90"> }</a> |
| <span class="sourceLineNo">091</span><a id="line.91"> }</a> |
| <span class="sourceLineNo">092</span><a id="line.92"></a> |
| <span class="sourceLineNo">093</span><a id="line.93"> /**</a> |
| <span class="sourceLineNo">094</span><a id="line.94"> * Close the given JDBC ResultSet and ignore any thrown exception.</a> |
| <span class="sourceLineNo">095</span><a id="line.95"> * This is useful for typical finally blocks in manual JDBC code.</a> |
| <span class="sourceLineNo">096</span><a id="line.96"> *</a> |
| <span class="sourceLineNo">097</span><a id="line.97"> * @param rs the JDBC ResultSet to close (may be <tt>null</tt>)</a> |
| <span class="sourceLineNo">098</span><a id="line.98"> */</a> |
| <span class="sourceLineNo">099</span><a id="line.99"> public static void closeResultSet(ResultSet rs) {</a> |
| <span class="sourceLineNo">100</span><a id="line.100"> if (rs != null) {</a> |
| <span class="sourceLineNo">101</span><a id="line.101"> try {</a> |
| <span class="sourceLineNo">102</span><a id="line.102"> rs.close();</a> |
| <span class="sourceLineNo">103</span><a id="line.103"> } catch (SQLException ex) {</a> |
| <span class="sourceLineNo">104</span><a id="line.104"> if (log.isDebugEnabled()) {</a> |
| <span class="sourceLineNo">105</span><a id="line.105"> log.debug("Could not close JDBC ResultSet", ex);</a> |
| <span class="sourceLineNo">106</span><a id="line.106"> }</a> |
| <span class="sourceLineNo">107</span><a id="line.107"> } catch (Throwable ex) {</a> |
| <span class="sourceLineNo">108</span><a id="line.108"> if (log.isDebugEnabled()) {</a> |
| <span class="sourceLineNo">109</span><a id="line.109"> log.debug("Unexpected exception on closing JDBC ResultSet", ex);</a> |
| <span class="sourceLineNo">110</span><a id="line.110"> }</a> |
| <span class="sourceLineNo">111</span><a id="line.111"> }</a> |
| <span class="sourceLineNo">112</span><a id="line.112"> }</a> |
| <span class="sourceLineNo">113</span><a id="line.113"> }</a> |
| <span class="sourceLineNo">114</span><a id="line.114"></a> |
| <span class="sourceLineNo">115</span><a id="line.115">}</a> |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| </pre> |
| </div> |
| </main> |
| </body> |
| </html> |
