author | František Kučera <franta-hg@frantovo.cz> |
Wed, 01 Jan 2014 02:56:08 +0100 | |
branch | v_0 |
changeset 108 | d06d90b28217 |
parent 68 | 574cd7fbb5b2 |
child 143 | 1336bb9a4499 |
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 |
/** |
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 |
|
34
9335cf31c0f2
first working version
František Kučera <franta-hg@frantovo.cz>
parents:
16
diff
changeset
|
31 |
private List<Parameter> parameters; |
9335cf31c0f2
first working version
František Kučera <franta-hg@frantovo.cz>
parents:
16
diff
changeset
|
32 |
|
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
|
33 |
public SQLCommandNumbered(String query, List<Parameter> parameters) { |
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 |
9335cf31c0f2
first working version
František Kučera <franta-hg@frantovo.cz>
parents:
16
diff
changeset
|
47 |
public List<Parameter> getParameters() { |
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 |
} |