1 /*
2 * Copyright (c) 2012-2023, 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 java.sql.PreparedStatement;
33 import java.sql.ResultSet;
34 import java.sql.SQLException;
35
36 /**
37 * Request.
38 *
39 * @since 0.13
40 */
41 interface Request {
42
43 /**
44 * Execute.
45 */
46 Request EXECUTE = new Request() {
47 @Override
48 public ResultSet fetch(final PreparedStatement stmt)
49 throws SQLException {
50 stmt.execute();
51 return stmt.getGeneratedKeys();
52 }
53 };
54
55 /**
56 * Execute update.
57 */
58 Request EXECUTE_UPDATE = new Request() {
59 @Override
60 public ResultSet fetch(final PreparedStatement stmt)
61 throws SQLException {
62 stmt.executeUpdate();
63 return stmt.getGeneratedKeys();
64 }
65 };
66
67 /**
68 * Execute query.
69 */
70 Request EXECUTE_QUERY = new Request() {
71 @Override
72 public ResultSet fetch(final PreparedStatement stmt)
73 throws SQLException {
74 return stmt.executeQuery();
75 }
76 };
77
78 /**
79 * Fetch result set from statement.
80 * @param stmt The statement
81 * @return The result set
82 * @throws SQLException If some problem
83 */
84 ResultSet fetch(PreparedStatement stmt) throws SQLException;
85
86 }