java/sql-dk/src/info/globalcode/sql/dk/SQLCommandNumbered.java
author František Kučera <franta-hg@frantovo.cz>
Sun, 22 Dec 2013 23:31:55 +0100
branchv_0
changeset 34 9335cf31c0f2
parent 16 5b8fcd35d4d6
child 35 b2ff3b2d58b2
permissions -rw-r--r--
first working version
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
5b8fcd35d4d6 license: GNU GPLv3+
František Kučera <franta-hg@frantovo.cz>
parents: 1
diff changeset
     7
 * the Free Software Foundation, either version 3 of the License, or
5b8fcd35d4d6 license: GNU GPLv3+
František Kučera <franta-hg@frantovo.cz>
parents: 1
diff changeset
     8
 * (at your option) any later version.
5b8fcd35d4d6 license: GNU GPLv3+
František Kučera <franta-hg@frantovo.cz>
parents: 1
diff changeset
     9
 *
5b8fcd35d4d6 license: GNU GPLv3+
František Kučera <franta-hg@frantovo.cz>
parents: 1
diff changeset
    10
 * 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
    11
 * 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
    12
 * 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
    13
 * GNU General Public License for more details.
5b8fcd35d4d6 license: GNU GPLv3+
František Kučera <franta-hg@frantovo.cz>
parents: 1
diff changeset
    14
 *
5b8fcd35d4d6 license: GNU GPLv3+
František Kučera <franta-hg@frantovo.cz>
parents: 1
diff changeset
    15
 * 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
    16
 * 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
    17
 */
1
f32dac78d13a WOW some classes LOL; TODO: refactor
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
    18
package info.globalcode.sql.dk;
f32dac78d13a WOW some classes LOL; TODO: refactor
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
    19
34
9335cf31c0f2 first working version
František Kučera <franta-hg@frantovo.cz>
parents: 16
diff changeset
    20
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
    21
import java.sql.Connection;
f32dac78d13a WOW some classes LOL; TODO: refactor
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
    22
import java.sql.PreparedStatement;
34
9335cf31c0f2 first working version
František Kučera <franta-hg@frantovo.cz>
parents: 16
diff changeset
    23
import java.sql.SQLException;
9335cf31c0f2 first working version
František Kučera <franta-hg@frantovo.cz>
parents: 16
diff changeset
    24
import java.util.List;
1
f32dac78d13a WOW some classes LOL; TODO: refactor
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
    25
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
 *
f32dac78d13a WOW some classes LOL; TODO: refactor
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
    28
 * @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
    29
 */
f32dac78d13a WOW some classes LOL; TODO: refactor
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
    30
public class SQLCommandNumbered extends SQLCommand {
f32dac78d13a WOW some classes LOL; TODO: refactor
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
    31
34
9335cf31c0f2 first working version
František Kučera <franta-hg@frantovo.cz>
parents: 16
diff changeset
    32
	private List<Parameter> parameters;
9335cf31c0f2 first working version
František Kučera <franta-hg@frantovo.cz>
parents: 16
diff changeset
    33
9335cf31c0f2 first working version
František Kučera <franta-hg@frantovo.cz>
parents: 16
diff changeset
    34
	public SQLCommandNumbered(COMMAND_TYPE commandType, String query, List<Parameter> parameters) {
9335cf31c0f2 first working version
František Kučera <franta-hg@frantovo.cz>
parents: 16
diff changeset
    35
		super(commandType, query);
9335cf31c0f2 first working version
František Kučera <franta-hg@frantovo.cz>
parents: 16
diff changeset
    36
		this.parameters = parameters;
9335cf31c0f2 first working version
František Kučera <franta-hg@frantovo.cz>
parents: 16
diff changeset
    37
	}
9335cf31c0f2 first working version
František Kučera <franta-hg@frantovo.cz>
parents: 16
diff changeset
    38
1
f32dac78d13a WOW some classes LOL; TODO: refactor
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
    39
	@Override
34
9335cf31c0f2 first working version
František Kučera <franta-hg@frantovo.cz>
parents: 16
diff changeset
    40
	public PreparedStatement prepareStatement(Connection c) throws SQLException {
9335cf31c0f2 first working version
František Kučera <franta-hg@frantovo.cz>
parents: 16
diff changeset
    41
		return c.prepareStatement(getQuery());
1
f32dac78d13a WOW some classes LOL; TODO: refactor
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
    42
	}
f32dac78d13a WOW some classes LOL; TODO: refactor
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
    43
f32dac78d13a WOW some classes LOL; TODO: refactor
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
    44
	@Override
34
9335cf31c0f2 first working version
František Kučera <franta-hg@frantovo.cz>
parents: 16
diff changeset
    45
	public void parametrize(PreparedStatement ps) throws SQLException {
9335cf31c0f2 first working version
František Kučera <franta-hg@frantovo.cz>
parents: 16
diff changeset
    46
		int i = 1;
9335cf31c0f2 first working version
František Kučera <franta-hg@frantovo.cz>
parents: 16
diff changeset
    47
		for (Parameter p : notNull(parameters)) {
9335cf31c0f2 first working version
František Kučera <franta-hg@frantovo.cz>
parents: 16
diff changeset
    48
			ps.setObject(i++, p.getValue(), p.getType());
9335cf31c0f2 first working version
František Kučera <franta-hg@frantovo.cz>
parents: 16
diff changeset
    49
		}
9335cf31c0f2 first working version
František Kučera <franta-hg@frantovo.cz>
parents: 16
diff changeset
    50
	}
9335cf31c0f2 first working version
František Kučera <franta-hg@frantovo.cz>
parents: 16
diff changeset
    51
9335cf31c0f2 first working version
František Kučera <franta-hg@frantovo.cz>
parents: 16
diff changeset
    52
	@Override
9335cf31c0f2 first working version
František Kučera <franta-hg@frantovo.cz>
parents: 16
diff changeset
    53
	public List<Parameter> getParameters() {
9335cf31c0f2 first working version
František Kučera <franta-hg@frantovo.cz>
parents: 16
diff changeset
    54
		return parameters;
1
f32dac78d13a WOW some classes LOL; TODO: refactor
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
    55
	}
f32dac78d13a WOW some classes LOL; TODO: refactor
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
    56
}