/
JdbcPreparedStatement.java
118 lines (104 loc) · 3.9 KB
/
JdbcPreparedStatement.java
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
/*
* Copyright 2019 Google LLC
*
* Licensed under the Apache License, Version 2.0 (the "License");
* you may not use this file except in compliance with the License.
* You may obtain a copy of the License at
*
* http://www.apache.org/licenses/LICENSE-2.0
*
* Unless required by applicable law or agreed to in writing, software
* distributed under the License is distributed on an "AS IS" BASIS,
* WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
* See the License for the specific language governing permissions and
* limitations under the License.
*/
package com.google.cloud.spanner.jdbc;
import com.google.cloud.spanner.Options.QueryOption;
import com.google.cloud.spanner.ReadContext.QueryAnalyzeMode;
import com.google.cloud.spanner.ResultSets;
import com.google.cloud.spanner.Statement;
import com.google.cloud.spanner.Struct;
import com.google.cloud.spanner.Type;
import com.google.cloud.spanner.connection.StatementParser;
import com.google.cloud.spanner.jdbc.JdbcParameterStore.ParametersInfo;
import com.google.common.annotations.VisibleForTesting;
import com.google.common.collect.ImmutableList;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.ResultSetMetaData;
import java.sql.SQLException;
/** Implementation of {@link PreparedStatement} for Cloud Spanner. */
class JdbcPreparedStatement extends AbstractJdbcPreparedStatement {
private final String sql;
private final String sqlWithoutComments;
private final ParametersInfo parameters;
JdbcPreparedStatement(JdbcConnection connection, String sql) throws SQLException {
super(connection);
this.sql = sql;
this.sqlWithoutComments = StatementParser.removeCommentsAndTrim(this.sql);
this.parameters =
JdbcParameterStore.convertPositionalParametersToNamedParameters(sqlWithoutComments);
}
ParametersInfo getParametersInfo() throws SQLException {
return parameters;
}
@VisibleForTesting
Statement createStatement() throws SQLException {
ParametersInfo paramInfo = getParametersInfo();
Statement.Builder builder = Statement.newBuilder(paramInfo.sqlWithNamedParameters);
for (int index = 1; index <= getParameters().getHighestIndex(); index++) {
getParameters().bindParameterValue(builder.bind("p" + index), index);
}
return builder.build();
}
@Override
public ResultSet executeQuery() throws SQLException {
checkClosed();
return executeQuery(createStatement());
}
ResultSet executeQueryWithOptions(QueryOption... options) throws SQLException {
checkClosed();
return executeQuery(createStatement(), options);
}
@Override
public int executeUpdate() throws SQLException {
checkClosed();
return executeUpdate(createStatement());
}
public long executeLargeUpdate() throws SQLException {
checkClosed();
return executeLargeUpdate(createStatement());
}
@Override
public boolean execute() throws SQLException {
checkClosed();
return executeStatement(createStatement());
}
@Override
public void addBatch() throws SQLException {
checkClosed();
checkAndSetBatchType(sql);
batchedStatements.add(createStatement());
}
@Override
public JdbcParameterMetaData getParameterMetaData() throws SQLException {
checkClosed();
return new JdbcParameterMetaData(this);
}
@Override
public ResultSetMetaData getMetaData() throws SQLException {
checkClosed();
if (StatementParser.INSTANCE.isUpdateStatement(sql)) {
// Return metadata for an empty result set as DML statements do not return any results (as a
// result set).
com.google.cloud.spanner.ResultSet resultSet =
ResultSets.forRows(Type.struct(), ImmutableList.<Struct>of());
resultSet.next();
return new JdbcResultSetMetaData(JdbcResultSet.of(resultSet), this);
}
try (ResultSet rs = analyzeQuery(createStatement(), QueryAnalyzeMode.PLAN)) {
return rs.getMetaData();
}
}
}