| Classes in this File | Line Coverage | Branch Coverage | Complexity | ||||
| Connect |
|
| 1.0;1 | ||||
| Connect$Plain |
|
| 1.0;1 | ||||
| Connect$WithKeys |
|
| 1.0;1 |
| 1 | 2 | /** |
| 2 | * Copyright (c) 2012-2015, jcabi.com | |
| 3 | * All rights reserved. | |
| 4 | * | |
| 5 | * Redistribution and use in source and binary forms, with or without | |
| 6 | * modification, are permitted provided that the following conditions | |
| 7 | * are met: 1) Redistributions of source code must retain the above | |
| 8 | * copyright notice, this list of conditions and the following | |
| 9 | * disclaimer. 2) Redistributions in binary form must reproduce the above | |
| 10 | * copyright notice, this list of conditions and the following | |
| 11 | * disclaimer in the documentation and/or other materials provided | |
| 12 | * with the distribution. 3) Neither the name of the jcabi.com nor | |
| 13 | * the names of its contributors may be used to endorse or promote | |
| 14 | * products derived from this software without specific prior written | |
| 15 | * permission. | |
| 16 | * | |
| 17 | * THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS | |
| 18 | * "AS IS" AND ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT | |
| 19 | * NOT LIMITED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY AND | |
| 20 | * FITNESS FOR A PARTICULAR PURPOSE ARE DISCLAIMED. IN NO EVENT SHALL | |
| 21 | * THE COPYRIGHT HOLDER OR CONTRIBUTORS BE LIABLE FOR ANY DIRECT, | |
| 22 | * INDIRECT, INCIDENTAL, SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES | |
| 23 | * (INCLUDING, BUT NOT LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR | |
| 24 | * SERVICES; LOSS OF USE, DATA, OR PROFITS; OR BUSINESS INTERRUPTION) | |
| 25 | * HOWEVER CAUSED AND ON ANY THEORY OF LIABILITY, WHETHER IN CONTRACT, | |
| 26 | * STRICT LIABILITY, OR TORT (INCLUDING NEGLIGENCE OR OTHERWISE) | |
| 27 | * ARISING IN ANY WAY OUT OF THE USE OF THIS SOFTWARE, EVEN IF ADVISED | |
| 28 | * OF THE POSSIBILITY OF SUCH DAMAGE. | |
| 29 | */ | |
| 30 | package com.jcabi.jdbc; | |
| 31 | ||
| 32 | import com.jcabi.aspects.Immutable; | |
| 33 | import java.sql.Connection; | |
| 34 | import java.sql.PreparedStatement; | |
| 35 | import java.sql.SQLException; | |
| 36 | import java.sql.Statement; | |
| 37 | ||
| 38 | /** | |
| 39 | * Connect. | |
| 40 | * | |
| 41 | * @author Yegor Bugayenko (yegor@teamed.io) | |
| 42 | * @version $Id: d3130a8099b4b0b63c5b91b644fd6dd692d20516 $ | |
| 43 | * @since 0.13 | |
| 44 | */ | |
| 45 | @Immutable | |
| 46 | interface Connect { | |
| 47 | ||
| 48 | /** | |
| 49 | * Create prepare statement. | |
| 50 | * @param conn Open connection | |
| 51 | * @return The statement | |
| 52 | * @throws SQLException If some problem | |
| 53 | */ | |
| 54 | PreparedStatement open(Connection conn) throws SQLException; | |
| 55 | ||
| 56 | /** | |
| 57 | * Plain, without keys. | |
| 58 | */ | |
| 59 | @Immutable | |
| 60 | final class Plain implements Connect { | |
| 61 | /** | |
| 62 | * SQL query. | |
| 63 | */ | |
| 64 | private final transient String sql; | |
| 65 | /** | |
| 66 | * Ctor. | |
| 67 | * @param query Query | |
| 68 | */ | |
| 69 | 37 | public Plain(final String query) { |
| 70 | 37 | this.sql = query; |
| 71 | 37 | } |
| 72 | @Override | |
| 73 | public PreparedStatement open(final Connection conn) | |
| 74 | throws SQLException { | |
| 75 | 37 | return conn.prepareStatement(this.sql); |
| 76 | } | |
| 77 | } | |
| 78 | ||
| 79 | /** | |
| 80 | * With returned keys. | |
| 81 | */ | |
| 82 | @Immutable | |
| 83 | final class WithKeys implements Connect { | |
| 84 | /** | |
| 85 | * SQL query. | |
| 86 | */ | |
| 87 | private final transient String sql; | |
| 88 | /** | |
| 89 | * Ctor. | |
| 90 | * @param query Query | |
| 91 | */ | |
| 92 | 2 | public WithKeys(final String query) { |
| 93 | 2 | this.sql = query; |
| 94 | 2 | } |
| 95 | @Override | |
| 96 | public PreparedStatement open(final Connection conn) | |
| 97 | throws SQLException { | |
| 98 | 2 | return conn.prepareStatement( |
| 99 | this.sql, | |
| 100 | Statement.RETURN_GENERATED_KEYS | |
| 101 | ); | |
| 102 | } | |
| 103 | } | |
| 104 | ||
| 105 | } |