author | František Kučera <franta-hg@frantovo.cz> |
Thu, 24 Oct 2019 21:43:08 +0200 | |
branch | v_0 |
changeset 250 | aae5009bd0af |
parent 238 | 4a1864c3e867 |
permissions | -rw-r--r-- |
16 | 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 |
|
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 | 8 |
* |
9 |
* This program is distributed in the hope that it will be useful, |
|
10 |
* but WITHOUT ANY WARRANTY; without even the implied warranty of |
|
11 |
* MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the |
|
12 |
* GNU General Public License for more details. |
|
13 |
* |
|
14 |
* You should have received a copy of the GNU General Public License |
|
15 |
* along with this program. If not, see <http://www.gnu.org/licenses/>. |
|
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 | 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 |
} |