java/sql-dk/src/info/globalcode/sql/dk/SQLCommandNumbered.java
author František Kučera <franta-hg@frantovo.cz>
Fri, 27 Dec 2013 21:26:30 +0100
branchv_0
changeset 87 03bf24449c7a
parent 68 574cd7fbb5b2
child 143 1336bb9a4499
permissions -rw-r--r--
TabularFormatter: support for value trim (if longer than cell size)
franta-hg@16
     1
/**
franta-hg@16
     2
 * SQL-DK
franta-hg@16
     3
 * Copyright © 2013 František Kučera (frantovo.cz)
franta-hg@16
     4
 *
franta-hg@16
     5
 * This program is free software: you can redistribute it and/or modify
franta-hg@16
     6
 * it under the terms of the GNU General Public License as published by
franta-hg@16
     7
 * the Free Software Foundation, either version 3 of the License, or
franta-hg@16
     8
 * (at your option) any later version.
franta-hg@16
     9
 *
franta-hg@16
    10
 * This program is distributed in the hope that it will be useful,
franta-hg@16
    11
 * but WITHOUT ANY WARRANTY; without even the implied warranty of
franta-hg@16
    12
 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
franta-hg@16
    13
 * GNU General Public License for more details.
franta-hg@16
    14
 *
franta-hg@16
    15
 * You should have received a copy of the GNU General Public License
franta-hg@16
    16
 * along with this program. If not, see <http://www.gnu.org/licenses/>.
franta-hg@16
    17
 */
franta-hg@1
    18
package info.globalcode.sql.dk;
franta-hg@1
    19
franta-hg@34
    20
import static info.globalcode.sql.dk.Functions.notNull;
franta-hg@1
    21
import java.sql.PreparedStatement;
franta-hg@34
    22
import java.sql.SQLException;
franta-hg@34
    23
import java.util.List;
franta-hg@1
    24
franta-hg@1
    25
/**
franta-hg@1
    26
 *
franta-hg@1
    27
 * @author Ing. František Kučera (frantovo.cz)
franta-hg@1
    28
 */
franta-hg@1
    29
public class SQLCommandNumbered extends SQLCommand {
franta-hg@1
    30
franta-hg@34
    31
	private List<Parameter> parameters;
franta-hg@34
    32
franta-hg@37
    33
	public SQLCommandNumbered(String query, List<Parameter> parameters) {
franta-hg@37
    34
		super(query);
franta-hg@34
    35
		this.parameters = parameters;
franta-hg@1
    36
	}
franta-hg@1
    37
franta-hg@1
    38
	@Override
franta-hg@34
    39
	public void parametrize(PreparedStatement ps) throws SQLException {
franta-hg@34
    40
		int i = 1;
franta-hg@34
    41
		for (Parameter p : notNull(parameters)) {
franta-hg@68
    42
			ps.setObject(i++, p.getValue(), p.getType().getCode());
franta-hg@34
    43
		}
franta-hg@34
    44
	}
franta-hg@34
    45
franta-hg@34
    46
	@Override
franta-hg@34
    47
	public List<Parameter> getParameters() {
franta-hg@34
    48
		return parameters;
franta-hg@1
    49
	}
franta-hg@1
    50
}