author | František Kučera <franta-hg@frantovo.cz> |
Mon, 04 Mar 2019 20:15:24 +0100 | |
branch | v_0 |
changeset 238 | 4a1864c3e867 |
parent 155 | java/sql-dk/src/info/globalcode/sql/dk/SQLCommandNumbered.java@eb3676c6929b |
child 250 | aae5009bd0af |
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 |
|
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 |
*/ |
|
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.PreparedStatement; |
34
9335cf31c0f2
first working version
František Kučera <franta-hg@frantovo.cz>
parents:
16
diff
changeset
|
22 |
import java.sql.SQLException; |
9335cf31c0f2
first working version
František Kučera <franta-hg@frantovo.cz>
parents:
16
diff
changeset
|
23 |
import java.util.List; |
1
f32dac78d13a
WOW some classes LOL; TODO: refactor
František Kučera <franta-hg@frantovo.cz>
parents:
diff
changeset
|
24 |
|
f32dac78d13a
WOW some classes LOL; TODO: refactor
František Kučera <franta-hg@frantovo.cz>
parents:
diff
changeset
|
25 |
/** |
155 | 26 |
* Has ordinal/numbered parameters. |
1
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 |
|
143
1336bb9a4499
convert named parameters to numbered
František Kučera <franta-hg@frantovo.cz>
parents:
68
diff
changeset
|
32 |
private List<? extends Parameter> parameters; |
34
9335cf31c0f2
first working version
František Kučera <franta-hg@frantovo.cz>
parents:
16
diff
changeset
|
33 |
|
143
1336bb9a4499
convert named parameters to numbered
František Kučera <franta-hg@frantovo.cz>
parents:
68
diff
changeset
|
34 |
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
|
35 |
super(query); |
34
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 void parametrize(PreparedStatement ps) throws SQLException { |
9335cf31c0f2
first working version
František Kučera <franta-hg@frantovo.cz>
parents:
16
diff
changeset
|
41 |
int i = 1; |
9335cf31c0f2
first working version
František Kučera <franta-hg@frantovo.cz>
parents:
16
diff
changeset
|
42 |
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
|
43 |
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
|
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 |
|
9335cf31c0f2
first working version
František Kučera <franta-hg@frantovo.cz>
parents:
16
diff
changeset
|
47 |
@Override |
143
1336bb9a4499
convert named parameters to numbered
František Kučera <franta-hg@frantovo.cz>
parents:
68
diff
changeset
|
48 |
public List<? extends Parameter> getParameters() { |
34
9335cf31c0f2
first working version
František Kučera <franta-hg@frantovo.cz>
parents:
16
diff
changeset
|
49 |
return parameters; |
1
f32dac78d13a
WOW some classes LOL; TODO: refactor
František Kučera <franta-hg@frantovo.cz>
parents:
diff
changeset
|
50 |
} |
f32dac78d13a
WOW some classes LOL; TODO: refactor
František Kučera <franta-hg@frantovo.cz>
parents:
diff
changeset
|
51 |
} |