java/jdbc-loopback-driver/src/info/globalcode/jdbc/loopback/PreparedStatement.java
author František Kučera <franta-hg@frantovo.cz>
Fri, 04 Apr 2014 23:40:28 +0200
branchv_0
changeset 171 701ec4db43fb
child 172 dec1ba8af6c5
permissions -rw-r--r--
JDBC loopback driver: first version
experimental JDBC driver which does not need any real SQL database,
just passes values of statement parameters as a result set.
The first parameter is column count, then follows column names and then data.

Example:

2 a b c d e f

will result into table:

a | b
-----
c | d
e | f
     1 /**
     2  * SQL-DK
     3  * Copyright © 2014 František Kučera (frantovo.cz)
     4  *
     5  * This program is free software: you can redistribute it and/or modify
     6  * it under the terms of the GNU General Public License as published by
     7  * the Free Software Foundation, either version 3 of the License, or
     8  * (at your option) any later version.
     9  *
    10  * This program is distributed in the hope that it will be useful,
    11  * but WITHOUT ANY WARRANTY; without even the implied warranty of
    12  * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
    13  * GNU General Public License for more details.
    14  *
    15  * You should have received a copy of the GNU General Public License
    16  * along with this program. If not, see <http://www.gnu.org/licenses/>.
    17  */
    18 package info.globalcode.jdbc.loopback;
    19 
    20 import java.sql.SQLException;
    21 import java.sql.SQLWarning;
    22 import java.sql.Types;
    23 import java.util.ArrayList;
    24 import java.util.HashMap;
    25 import java.util.List;
    26 import java.util.Map;
    27 
    28 /**
    29  *
    30  * @author Ing. František Kučera (frantovo.cz)
    31  */
    32 public class PreparedStatement extends AbstractPreparedStatement {
    33 
    34 	private Map<Integer, ObjectParameter> parameters = new HashMap<>();
    35 	private List<Object[]> table;
    36 	private ResultSetMetaData metadata = new ResultSetMetaData();
    37 
    38 	@Override
    39 	public void setObject(int parameterIndex, Object data, int targetSqlType) throws SQLException {
    40 		parameters.put(parameterIndex, new ObjectParameter(data, targetSqlType));
    41 	}
    42 
    43 	@Override
    44 	public boolean execute() throws SQLException {
    45 
    46 		if (parameters.size() < 1) {
    47 			throw new SQLException("Missing first parameter (column count)");
    48 		} else {
    49 			int columnCount = Integer.valueOf((String) parameters.get(1).getData());
    50 
    51 			for (int i = 0; i < columnCount; i++) {
    52 				String label = parameters.get(1 + i + 1).getData().toString();
    53 				metadata.addColumn(new ResultSetMetaData.ColumnDescriptor(Types.VARCHAR, "VARCHAR", label, label));
    54 			}
    55 
    56 			int cellIndex = 0;
    57 
    58 			table = new ArrayList<>();
    59 			Object[] currentRow = null;
    60 
    61 			for (int parameterNumber = (1 + columnCount + 1); true; parameterNumber++) {
    62 				ObjectParameter data = parameters.get(parameterNumber);
    63 				if (data == null) {
    64 					break;
    65 				} else {
    66 					int columnIndex = cellIndex % columnCount;
    67 					cellIndex++;
    68 					if (columnIndex == 0) {
    69 						currentRow = new Object[columnCount];
    70 						table.add(currentRow);
    71 					}
    72 					currentRow[columnIndex] = data.getData();
    73 				}
    74 			}
    75 
    76 			return true;
    77 		}
    78 	}
    79 
    80 	@Override
    81 	public java.sql.ResultSet getResultSet() throws SQLException {
    82 		return new ResultSet(metadata, table);
    83 	}
    84 
    85 	@Override
    86 	public int getUpdateCount() throws SQLException {
    87 		return -1;
    88 	}
    89 
    90 	@Override
    91 	public boolean getMoreResults() throws SQLException {
    92 		return false;
    93 	}
    94 
    95 	@Override
    96 	public void close() throws SQLException {
    97 	}
    98 
    99 	@Override
   100 	public SQLWarning getWarnings() throws SQLException {
   101 		return null;
   102 	}
   103 
   104 	@Override
   105 	public void clearWarnings() throws SQLException {
   106 	}
   107 }