|
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 */ |
|
18 package info.globalcode.sql.dk; |
|
19 |
|
20 import static info.globalcode.sql.dk.Functions.notNull; |
|
21 import java.sql.PreparedStatement; |
|
22 import java.sql.SQLException; |
|
23 import java.util.List; |
|
24 |
|
25 /** |
|
26 * Has ordinal/numbered parameters. |
|
27 * |
|
28 * @author Ing. František Kučera (frantovo.cz) |
|
29 */ |
|
30 public class SQLCommandNumbered extends SQLCommand { |
|
31 |
|
32 private List<? extends Parameter> parameters; |
|
33 |
|
34 public SQLCommandNumbered(String query, List<? extends Parameter> parameters) { |
|
35 super(query); |
|
36 this.parameters = parameters; |
|
37 } |
|
38 |
|
39 @Override |
|
40 public void parametrize(PreparedStatement ps) throws SQLException { |
|
41 int i = 1; |
|
42 for (Parameter p : notNull(parameters)) { |
|
43 ps.setObject(i++, p.getValue(), p.getType().getCode()); |
|
44 } |
|
45 } |
|
46 |
|
47 @Override |
|
48 public List<? extends Parameter> getParameters() { |
|
49 return parameters; |
|
50 } |
|
51 } |