java/jdbc-loopback-driver/src/main/java/info/globalcode/jdbc/loopback/PreparedStatement.java
1.1 --- /dev/null Thu Jan 01 00:00:00 1970 +0000
1.2 +++ b/java/jdbc-loopback-driver/src/main/java/info/globalcode/jdbc/loopback/PreparedStatement.java Mon Mar 04 17:06:42 2019 +0100
1.3 @@ -0,0 +1,107 @@
1.4 +/**
1.5 + * SQL-DK
1.6 + * Copyright © 2014 František Kučera (frantovo.cz)
1.7 + *
1.8 + * This program is free software: you can redistribute it and/or modify
1.9 + * it under the terms of the GNU General Public License as published by
1.10 + * the Free Software Foundation, either version 3 of the License, or
1.11 + * (at your option) any later version.
1.12 + *
1.13 + * This program is distributed in the hope that it will be useful,
1.14 + * but WITHOUT ANY WARRANTY; without even the implied warranty of
1.15 + * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
1.16 + * GNU General Public License for more details.
1.17 + *
1.18 + * You should have received a copy of the GNU General Public License
1.19 + * along with this program. If not, see <http://www.gnu.org/licenses/>.
1.20 + */
1.21 +package info.globalcode.jdbc.loopback;
1.22 +
1.23 +import java.sql.SQLException;
1.24 +import java.sql.SQLWarning;
1.25 +import java.sql.Types;
1.26 +import java.util.ArrayList;
1.27 +import java.util.HashMap;
1.28 +import java.util.List;
1.29 +import java.util.Map;
1.30 +
1.31 +/**
1.32 + *
1.33 + * @author Ing. František Kučera (frantovo.cz)
1.34 + */
1.35 +public class PreparedStatement extends AbstractPreparedStatement {
1.36 +
1.37 + private final Map<Integer, ObjectParameter> parameters = new HashMap<>();
1.38 + private List<Object[]> table;
1.39 + private final ResultSetMetaData metadata = new ResultSetMetaData();
1.40 +
1.41 + @Override
1.42 + public void setObject(int parameterNumber, Object data, int targetSqlType) throws SQLException {
1.43 + parameters.put(parameterNumber, new ObjectParameter(data, targetSqlType));
1.44 + }
1.45 +
1.46 + @Override
1.47 + public boolean execute() throws SQLException {
1.48 +
1.49 + if (parameters.size() < 1) {
1.50 + throw new SQLException("Missing first parameter (column count)");
1.51 + } else {
1.52 + int columnCount = Integer.valueOf(String.valueOf(parameters.get(1).getData()));
1.53 +
1.54 + for (int i = 0; i < columnCount; i++) {
1.55 + String label = parameters.get(1 + i + 1).getData().toString();
1.56 + metadata.addColumn(new ResultSetMetaData.ColumnDescriptor(Types.VARCHAR, "VARCHAR", label, label));
1.57 + }
1.58 +
1.59 + int cellIndex = 0;
1.60 +
1.61 + table = new ArrayList<>();
1.62 + Object[] currentRow = null;
1.63 +
1.64 + for (int parameterNumber = (1 + columnCount + 1); true; parameterNumber++) {
1.65 + ObjectParameter data = parameters.get(parameterNumber);
1.66 + if (data == null) {
1.67 + break;
1.68 + } else {
1.69 + int columnIndex = cellIndex % columnCount;
1.70 + cellIndex++;
1.71 + if (columnIndex == 0) {
1.72 + currentRow = new Object[columnCount];
1.73 + table.add(currentRow);
1.74 + }
1.75 + currentRow[columnIndex] = data.getData();
1.76 + }
1.77 + }
1.78 +
1.79 + return true;
1.80 + }
1.81 + }
1.82 +
1.83 + @Override
1.84 + public java.sql.ResultSet getResultSet() throws SQLException {
1.85 + return new ResultSet(metadata, table);
1.86 + }
1.87 +
1.88 + @Override
1.89 + public int getUpdateCount() throws SQLException {
1.90 + return -1;
1.91 + }
1.92 +
1.93 + @Override
1.94 + public boolean getMoreResults() throws SQLException {
1.95 + return false;
1.96 + }
1.97 +
1.98 + @Override
1.99 + public void close() throws SQLException {
1.100 + }
1.101 +
1.102 + @Override
1.103 + public SQLWarning getWarnings() throws SQLException {
1.104 + return null;
1.105 + }
1.106 +
1.107 + @Override
1.108 + public void clearWarnings() throws SQLException {
1.109 + }
1.110 +}