java/sql-dk/src/info/globalcode/sql/dk/SQLCommandNumbered.java
author František Kučera <franta-hg@frantovo.cz>
Sun, 19 Jan 2014 18:30:21 +0100
branchv_0
changeset 167 84aaa91642bf
parent 155 eb3676c6929b
permissions -rw-r--r--
fix Tabular: table was broken if value ended with \n
     1 /**
     2  * SQL-DK
     3  * Copyright © 2013 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.sql.dk;
    19 
    20 import static info.globalcode.sql.dk.Functions.notNull;
    21 import java.sql.PreparedStatement;
    22 import java.sql.SQLException;
    23 import java.util.List;
    24 
    25 /**
    26  * Has ordinal/numbered parameters.
    27  *
    28  * @author Ing. František Kučera (frantovo.cz)
    29  */
    30 public class SQLCommandNumbered extends SQLCommand {
    31 
    32 	private List<? extends Parameter> parameters;
    33 
    34 	public SQLCommandNumbered(String query, List<? extends Parameter> parameters) {
    35 		super(query);
    36 		this.parameters = parameters;
    37 	}
    38 
    39 	@Override
    40 	public void parametrize(PreparedStatement ps) throws SQLException {
    41 		int i = 1;
    42 		for (Parameter p : notNull(parameters)) {
    43 			ps.setObject(i++, p.getValue(), p.getType().getCode());
    44 		}
    45 	}
    46 
    47 	@Override
    48 	public List<? extends Parameter> getParameters() {
    49 		return parameters;
    50 	}
    51 }