svn-gvsig-desktop / trunk / org.gvsig.desktop / org.gvsig.desktop.compat.cdc / org.gvsig.fmap.dal / org.gvsig.fmap.dal.db / org.gvsig.fmap.dal.db.jdbc / src / main / java / org / gvsig / fmap / dal / store / jdbc2 / spi / operations / UpdatePassThroughOperation.java @ 46517
History | View | Annotate | Download (3.44 KB)
1 | 45065 | jjdelcerro | /**
|
---|---|---|---|
2 | * gvSIG. Desktop Geographic Information System.
|
||
3 | *
|
||
4 | * Copyright (C) 2007-2020 gvSIG Association.
|
||
5 | *
|
||
6 | * This program is free software; you can redistribute it and/or
|
||
7 | * modify it under the terms of the GNU General Public License
|
||
8 | * as published by the Free Software Foundation; either version 3
|
||
9 | * of the License, or (at your option) any later version.
|
||
10 | *
|
||
11 | * This program is distributed in the hope that it will be useful,
|
||
12 | * but WITHOUT ANY WARRANTY; without even the implied warranty of
|
||
13 | * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
|
||
14 | * GNU General Public License for more details.
|
||
15 | *
|
||
16 | * You should have received a copy of the GNU General Public License
|
||
17 | * along with this program; if not, write to the Free Software
|
||
18 | * Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston,
|
||
19 | * MA 02110-1301, USA.
|
||
20 | *
|
||
21 | * For any additional information, do not hesitate to contact us
|
||
22 | * at info AT gvsig.com, or visit our website www.gvsig.com.
|
||
23 | */
|
||
24 | 43020 | jjdelcerro | package org.gvsig.fmap.dal.store.jdbc2.spi.operations; |
25 | |||
26 | 43377 | jjdelcerro | import java.sql.Statement; |
27 | 45473 | fdiaz | import org.gvsig.expressionevaluator.Expression; |
28 | 43020 | jjdelcerro | import org.gvsig.fmap.dal.exception.DataException; |
29 | 46315 | jjdelcerro | import org.gvsig.fmap.dal.store.jdbc2.JDBCConnection; |
30 | 43020 | jjdelcerro | import org.gvsig.fmap.dal.store.jdbc2.JDBCHelper; |
31 | import org.gvsig.fmap.dal.store.jdbc2.JDBCUtils; |
||
32 | 45473 | fdiaz | import org.gvsig.fmap.dal.store.jdbc2.OperationsFactory.TableReference; |
33 | import org.gvsig.fmap.dal.store.jdbc2.spi.JDBCSQLBuilderBase; |
||
34 | 43020 | jjdelcerro | |
35 | 45473 | fdiaz | public class UpdatePassThroughOperation extends AbstractConnectionOperation { |
36 | 43377 | jjdelcerro | |
37 | 45473 | fdiaz | private final Object[] parameters; |
38 | private final Expression filter; |
||
39 | private final TableReference table; |
||
40 | |||
41 | 43020 | jjdelcerro | |
42 | 45473 | fdiaz | public UpdatePassThroughOperation(
|
43 | 43020 | jjdelcerro | JDBCHelper helper, |
44 | 45473 | fdiaz | TableReference table, |
45 | Object[] parameters, |
||
46 | Expression filter
|
||
47 | 43020 | jjdelcerro | ) { |
48 | super(helper);
|
||
49 | 45473 | fdiaz | this.table = table;
|
50 | this.parameters = parameters;
|
||
51 | this.filter = filter;
|
||
52 | 43020 | jjdelcerro | } |
53 | |||
54 | @Override
|
||
55 | 46315 | jjdelcerro | public final Object perform(JDBCConnection conn) throws DataException { |
56 | 45473 | fdiaz | return execute(this.table, this.parameters, this.filter); |
57 | 43020 | jjdelcerro | } |
58 | |||
59 | 45473 | fdiaz | public Object execute( |
60 | TableReference table, |
||
61 | Object[] parameters, |
||
62 | Expression filter
|
||
63 | ) { |
||
64 | 43377 | jjdelcerro | Statement st = null; |
65 | 45473 | fdiaz | String sql = getSQL(table, parameters, filter);
|
66 | 43020 | jjdelcerro | try {
|
67 | 45425 | jjdelcerro | st = this.getConnection().createStatement();
|
68 | 45473 | fdiaz | JDBCUtils.executeUpdate(st, sql); |
69 | JDBCUtils.closeQuietly(st); |
||
70 | return null; |
||
71 | 45425 | jjdelcerro | } catch (Exception ex) { |
72 | 43377 | jjdelcerro | JDBCUtils.closeQuietly(st); |
73 | 45437 | fdiaz | throw new RuntimeException("Can't execute query ["+sql+"].",ex); |
74 | 43020 | jjdelcerro | } |
75 | } |
||
76 | 45437 | fdiaz | |
77 | 45473 | fdiaz | public String getSQL( |
78 | TableReference table, |
||
79 | Object[] parameters, |
||
80 | Expression filter) {
|
||
81 | |||
82 | JDBCSQLBuilderBase sqlbuilder = createSQLBuilder(); |
||
83 | 45437 | fdiaz | |
84 | 45473 | fdiaz | sqlbuilder.update().table() |
85 | .database(this.table.getDatabase())
|
||
86 | .schema(this.table.getSchema())
|
||
87 | .name(this.table.getTable());
|
||
88 | |||
89 | |||
90 | for (int i = 0; i < parameters.length-1; i+=2){ |
||
91 | String field = (String) parameters[i]; |
||
92 | sqlbuilder.update().column().name(field).with_value(sqlbuilder.expression().constant(parameters[i+1]));
|
||
93 | } |
||
94 | |||
95 | if(filter != null ){ |
||
96 | sqlbuilder.update().where().set(filter.getCode().toValue()); |
||
97 | } |
||
98 | |||
99 | String sql = sqlbuilder.update().toString();
|
||
100 | return sql;
|
||
101 | |||
102 | |||
103 | |||
104 | |||
105 | } |
||
106 | |||
107 | 43020 | jjdelcerro | } |