java/sql-dk/src/main/java/info/globalcode/sql/dk/SQLCommandNumbered.java
author František Kučera <franta-hg@frantovo.cz>
Thu, 24 Oct 2019 21:43:08 +0200
branchv_0
changeset 250 aae5009bd0af
parent 238 4a1864c3e867
permissions -rw-r--r--
fix license version: GNU GPLv3
Ignore whitespace changes - Everywhere: Within whitespace: At end of lines:
16
5b8fcd35d4d6 license: GNU GPLv3+
František Kučera <franta-hg@frantovo.cz>
parents: 1
diff changeset
     1
/**
5b8fcd35d4d6 license: GNU GPLv3+
František Kučera <franta-hg@frantovo.cz>
parents: 1
diff changeset
     2
 * SQL-DK
5b8fcd35d4d6 license: GNU GPLv3+
František Kučera <franta-hg@frantovo.cz>
parents: 1
diff changeset
     3
 * Copyright © 2013 František Kučera (frantovo.cz)
5b8fcd35d4d6 license: GNU GPLv3+
František Kučera <franta-hg@frantovo.cz>
parents: 1
diff changeset
     4
 *
5b8fcd35d4d6 license: GNU GPLv3+
František Kučera <franta-hg@frantovo.cz>
parents: 1
diff changeset
     5
 * This program is free software: you can redistribute it and/or modify
5b8fcd35d4d6 license: GNU GPLv3+
František Kučera <franta-hg@frantovo.cz>
parents: 1
diff changeset
     6
 * it under the terms of the GNU General Public License as published by
250
aae5009bd0af fix license version: GNU GPLv3
František Kučera <franta-hg@frantovo.cz>
parents: 238
diff changeset
     7
 * the Free Software Foundation, version 3 of the License.
16
5b8fcd35d4d6 license: GNU GPLv3+
František Kučera <franta-hg@frantovo.cz>
parents: 1
diff changeset
     8
 *
5b8fcd35d4d6 license: GNU GPLv3+
František Kučera <franta-hg@frantovo.cz>
parents: 1
diff changeset
     9
 * This program is distributed in the hope that it will be useful,
5b8fcd35d4d6 license: GNU GPLv3+
František Kučera <franta-hg@frantovo.cz>
parents: 1
diff changeset
    10
 * but WITHOUT ANY WARRANTY; without even the implied warranty of
5b8fcd35d4d6 license: GNU GPLv3+
František Kučera <franta-hg@frantovo.cz>
parents: 1
diff changeset
    11
 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
5b8fcd35d4d6 license: GNU GPLv3+
František Kučera <franta-hg@frantovo.cz>
parents: 1
diff changeset
    12
 * GNU General Public License for more details.
5b8fcd35d4d6 license: GNU GPLv3+
František Kučera <franta-hg@frantovo.cz>
parents: 1
diff changeset
    13
 *
5b8fcd35d4d6 license: GNU GPLv3+
František Kučera <franta-hg@frantovo.cz>
parents: 1
diff changeset
    14
 * You should have received a copy of the GNU General Public License
5b8fcd35d4d6 license: GNU GPLv3+
František Kučera <franta-hg@frantovo.cz>
parents: 1
diff changeset
    15
 * along with this program. If not, see <http://www.gnu.org/licenses/>.
5b8fcd35d4d6 license: GNU GPLv3+
František Kučera <franta-hg@frantovo.cz>
parents: 1
diff changeset
    16
 */
1
f32dac78d13a WOW some classes LOL; TODO: refactor
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
    17
package info.globalcode.sql.dk;
f32dac78d13a WOW some classes LOL; TODO: refactor
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
    18
34
9335cf31c0f2 first working version
František Kučera <franta-hg@frantovo.cz>
parents: 16
diff changeset
    19
import static info.globalcode.sql.dk.Functions.notNull;
1
f32dac78d13a WOW some classes LOL; TODO: refactor
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
    20
import java.sql.PreparedStatement;
34
9335cf31c0f2 first working version
František Kučera <franta-hg@frantovo.cz>
parents: 16
diff changeset
    21
import java.sql.SQLException;
9335cf31c0f2 first working version
František Kučera <franta-hg@frantovo.cz>
parents: 16
diff changeset
    22
import java.util.List;
1
f32dac78d13a WOW some classes LOL; TODO: refactor
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
    23
f32dac78d13a WOW some classes LOL; TODO: refactor
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
    24
/**
155
eb3676c6929b more JavaDoc
František Kučera <franta-hg@frantovo.cz>
parents: 143
diff changeset
    25
 * Has ordinal/numbered parameters.
1
f32dac78d13a WOW some classes LOL; TODO: refactor
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
    26
 *
f32dac78d13a WOW some classes LOL; TODO: refactor
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
    27
 * @author Ing. František Kučera (frantovo.cz)
f32dac78d13a WOW some classes LOL; TODO: refactor
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
    28
 */
f32dac78d13a WOW some classes LOL; TODO: refactor
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
    29
public class SQLCommandNumbered extends SQLCommand {
f32dac78d13a WOW some classes LOL; TODO: refactor
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
    30
143
1336bb9a4499 convert named parameters to numbered
František Kučera <franta-hg@frantovo.cz>
parents: 68
diff changeset
    31
	private List<? extends Parameter> parameters;
34
9335cf31c0f2 first working version
František Kučera <franta-hg@frantovo.cz>
parents: 16
diff changeset
    32
143
1336bb9a4499 convert named parameters to numbered
František Kučera <franta-hg@frantovo.cz>
parents: 68
diff changeset
    33
	public SQLCommandNumbered(String query, List<? extends Parameter> parameters) {
37
9e6f8e5d5f98 support SQL commands returning more ResultSets + remove COMMAND_TYPE (type is now derived from result returned from SQL – it is not needed to specify the type on CLI)
František Kučera <franta-hg@frantovo.cz>
parents: 35
diff changeset
    34
		super(query);
34
9335cf31c0f2 first working version
František Kučera <franta-hg@frantovo.cz>
parents: 16
diff changeset
    35
		this.parameters = parameters;
9335cf31c0f2 first working version
František Kučera <franta-hg@frantovo.cz>
parents: 16
diff changeset
    36
	}
9335cf31c0f2 first working version
František Kučera <franta-hg@frantovo.cz>
parents: 16
diff changeset
    37
1
f32dac78d13a WOW some classes LOL; TODO: refactor
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
    38
	@Override
34
9335cf31c0f2 first working version
František Kučera <franta-hg@frantovo.cz>
parents: 16
diff changeset
    39
	public void parametrize(PreparedStatement ps) throws SQLException {
9335cf31c0f2 first working version
František Kučera <franta-hg@frantovo.cz>
parents: 16
diff changeset
    40
		int i = 1;
9335cf31c0f2 first working version
František Kučera <franta-hg@frantovo.cz>
parents: 16
diff changeset
    41
		for (Parameter p : notNull(parameters)) {
68
574cd7fbb5b2 SQLType enum wrapper for java.sql.Types
František Kučera <franta-hg@frantovo.cz>
parents: 37
diff changeset
    42
			ps.setObject(i++, p.getValue(), p.getType().getCode());
34
9335cf31c0f2 first working version
František Kučera <franta-hg@frantovo.cz>
parents: 16
diff changeset
    43
		}
9335cf31c0f2 first working version
František Kučera <franta-hg@frantovo.cz>
parents: 16
diff changeset
    44
	}
9335cf31c0f2 first working version
František Kučera <franta-hg@frantovo.cz>
parents: 16
diff changeset
    45
9335cf31c0f2 first working version
František Kučera <franta-hg@frantovo.cz>
parents: 16
diff changeset
    46
	@Override
143
1336bb9a4499 convert named parameters to numbered
František Kučera <franta-hg@frantovo.cz>
parents: 68
diff changeset
    47
	public List<? extends Parameter> getParameters() {
34
9335cf31c0f2 first working version
František Kučera <franta-hg@frantovo.cz>
parents: 16
diff changeset
    48
		return parameters;
1
f32dac78d13a WOW some classes LOL; TODO: refactor
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
    49
	}
f32dac78d13a WOW some classes LOL; TODO: refactor
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
    50
}