franta-hg@171: /**
franta-hg@171:  * SQL-DK
franta-hg@171:  * Copyright © 2014 František Kučera (frantovo.cz)
franta-hg@171:  *
franta-hg@171:  * This program is free software: you can redistribute it and/or modify
franta-hg@171:  * it under the terms of the GNU General Public License as published by
franta-hg@171:  * the Free Software Foundation, either version 3 of the License, or
franta-hg@171:  * (at your option) any later version.
franta-hg@171:  *
franta-hg@171:  * This program is distributed in the hope that it will be useful,
franta-hg@171:  * but WITHOUT ANY WARRANTY; without even the implied warranty of
franta-hg@171:  * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
franta-hg@171:  * GNU General Public License for more details.
franta-hg@171:  *
franta-hg@171:  * You should have received a copy of the GNU General Public License
franta-hg@171:  * along with this program. If not, see <http://www.gnu.org/licenses/>.
franta-hg@171:  */
franta-hg@171: package info.globalcode.jdbc.loopback;
franta-hg@171: 
franta-hg@171: import java.sql.SQLException;
franta-hg@171: import java.sql.SQLWarning;
franta-hg@171: import java.sql.Types;
franta-hg@171: import java.util.ArrayList;
franta-hg@171: import java.util.HashMap;
franta-hg@171: import java.util.List;
franta-hg@171: import java.util.Map;
franta-hg@171: 
franta-hg@171: /**
franta-hg@171:  *
franta-hg@171:  * @author Ing. František Kučera (frantovo.cz)
franta-hg@171:  */
franta-hg@171: public class PreparedStatement extends AbstractPreparedStatement {
franta-hg@171: 
franta-hg@172: 	private final Map<Integer, ObjectParameter> parameters = new HashMap<>();
franta-hg@171: 	private List<Object[]> table;
franta-hg@172: 	private final ResultSetMetaData metadata = new ResultSetMetaData();
franta-hg@171: 
franta-hg@171: 	@Override
franta-hg@176: 	public void setObject(int parameterNumber, Object data, int targetSqlType) throws SQLException {
franta-hg@176: 		parameters.put(parameterNumber, new ObjectParameter(data, targetSqlType));
franta-hg@171: 	}
franta-hg@171: 
franta-hg@171: 	@Override
franta-hg@171: 	public boolean execute() throws SQLException {
franta-hg@171: 
franta-hg@171: 		if (parameters.size() < 1) {
franta-hg@171: 			throw new SQLException("Missing first parameter (column count)");
franta-hg@171: 		} else {
franta-hg@172: 			int columnCount = Integer.valueOf(String.valueOf(parameters.get(1).getData()));
franta-hg@171: 
franta-hg@171: 			for (int i = 0; i < columnCount; i++) {
franta-hg@171: 				String label = parameters.get(1 + i + 1).getData().toString();
franta-hg@171: 				metadata.addColumn(new ResultSetMetaData.ColumnDescriptor(Types.VARCHAR, "VARCHAR", label, label));
franta-hg@171: 			}
franta-hg@171: 
franta-hg@171: 			int cellIndex = 0;
franta-hg@171: 
franta-hg@171: 			table = new ArrayList<>();
franta-hg@171: 			Object[] currentRow = null;
franta-hg@171: 
franta-hg@171: 			for (int parameterNumber = (1 + columnCount + 1); true; parameterNumber++) {
franta-hg@171: 				ObjectParameter data = parameters.get(parameterNumber);
franta-hg@171: 				if (data == null) {
franta-hg@171: 					break;
franta-hg@171: 				} else {
franta-hg@171: 					int columnIndex = cellIndex % columnCount;
franta-hg@171: 					cellIndex++;
franta-hg@171: 					if (columnIndex == 0) {
franta-hg@171: 						currentRow = new Object[columnCount];
franta-hg@171: 						table.add(currentRow);
franta-hg@171: 					}
franta-hg@171: 					currentRow[columnIndex] = data.getData();
franta-hg@171: 				}
franta-hg@171: 			}
franta-hg@171: 
franta-hg@171: 			return true;
franta-hg@171: 		}
franta-hg@171: 	}
franta-hg@171: 
franta-hg@171: 	@Override
franta-hg@171: 	public java.sql.ResultSet getResultSet() throws SQLException {
franta-hg@171: 		return new ResultSet(metadata, table);
franta-hg@171: 	}
franta-hg@171: 
franta-hg@171: 	@Override
franta-hg@171: 	public int getUpdateCount() throws SQLException {
franta-hg@171: 		return -1;
franta-hg@171: 	}
franta-hg@171: 
franta-hg@171: 	@Override
franta-hg@171: 	public boolean getMoreResults() throws SQLException {
franta-hg@171: 		return false;
franta-hg@171: 	}
franta-hg@171: 
franta-hg@171: 	@Override
franta-hg@171: 	public void close() throws SQLException {
franta-hg@171: 	}
franta-hg@171: 
franta-hg@171: 	@Override
franta-hg@171: 	public SQLWarning getWarnings() throws SQLException {
franta-hg@171: 		return null;
franta-hg@171: 	}
franta-hg@171: 
franta-hg@171: 	@Override
franta-hg@171: 	public void clearWarnings() throws SQLException {
franta-hg@171: 	}
franta-hg@171: }