java/jdbc-loopback-driver/src/info/globalcode/jdbc/loopback/PreparedStatement.java
branchv_0
changeset 237 7e08730da258
parent 236 a3ec71fa8e17
child 238 4a1864c3e867
     1.1 --- a/java/jdbc-loopback-driver/src/info/globalcode/jdbc/loopback/PreparedStatement.java	Tue Feb 26 18:19:49 2019 +0100
     1.2 +++ /dev/null	Thu Jan 01 00:00:00 1970 +0000
     1.3 @@ -1,107 +0,0 @@
     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 -}