Classes in this File | Line Coverage | Branch Coverage | Complexity | ||||
SqlUpdateStatement |
|
| 2.6666666666666665;2.667 |
1 | package org.apache.ojb.broker.accesslayer.sql; | |
2 | ||
3 | /* Copyright 2002-2005 The Apache Software Foundation | |
4 | * | |
5 | * Licensed under the Apache License, Version 2.0 (the "License"); | |
6 | * you may not use this file except in compliance with the License. | |
7 | * You may obtain a copy of the License at | |
8 | * | |
9 | * http://www.apache.org/licenses/LICENSE-2.0 | |
10 | * | |
11 | * Unless required by applicable law or agreed to in writing, software | |
12 | * distributed under the License is distributed on an "AS IS" BASIS, | |
13 | * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. | |
14 | * See the License for the specific language governing permissions and | |
15 | * limitations under the License. | |
16 | */ | |
17 | ||
18 | import org.apache.ojb.broker.metadata.ClassDescriptor; | |
19 | import org.apache.ojb.broker.metadata.FieldDescriptor; | |
20 | import org.apache.ojb.broker.util.logging.Logger; | |
21 | ||
22 | /** | |
23 | * Model an UPDATE Statement | |
24 | * | |
25 | * @author <a href="mailto:jbraeuchi@hotmail.com">Jakob Braeuchi</a> | |
26 | * @version $Id: SqlUpdateStatement.java,v 1.1 2007-08-24 22:17:39 ewestfal Exp $ | |
27 | */ | |
28 | public class SqlUpdateStatement extends SqlPkStatement | |
29 | { | |
30 | protected String sql; | |
31 | ||
32 | /** | |
33 | * Constructor for SqlUpdateStatement. | |
34 | * | |
35 | * @param cld | |
36 | * @param logger | |
37 | */ | |
38 | public SqlUpdateStatement(ClassDescriptor cld, Logger logger) | |
39 | { | |
40 | super(cld, logger); | |
41 | } | |
42 | ||
43 | /** | |
44 | * generates a SET-phrase for a prepared update statement. | |
45 | * | |
46 | * @param stmt the StringBuffer | |
47 | */ | |
48 | private void appendSetClause(ClassDescriptor cld, StringBuffer stmt) | |
49 | { | |
50 | FieldDescriptor[] fields = cld.getNonPkRwFields(); | |
51 | ||
52 | if(fields.length == 0) | |
53 | { | |
54 | return; | |
55 | } | |
56 | ||
57 | stmt.append(" SET "); | |
58 | for(int i = 0; i < fields.length; i++) | |
59 | { | |
60 | stmt.append(fields[i].getColumnName()); | |
61 | stmt.append("=?"); | |
62 | if(i < fields.length - 1) | |
63 | { | |
64 | stmt.append(","); | |
65 | } | |
66 | } | |
67 | } | |
68 | ||
69 | /** | |
70 | * @see SqlStatement#getStatement() | |
71 | */ | |
72 | public String getStatement() | |
73 | { | |
74 | if(sql == null) | |
75 | { | |
76 | StringBuffer stmt = new StringBuffer(1024); | |
77 | ClassDescriptor cld = getClassDescriptor(); | |
78 | ||
79 | stmt.append("UPDATE "); | |
80 | appendTable(cld, stmt); | |
81 | appendSetClause(cld, stmt); | |
82 | appendWhereClause(cld, true, stmt); //use Locking | |
83 | ||
84 | sql = stmt.toString(); | |
85 | } | |
86 | return sql; | |
87 | } | |
88 | ||
89 | } |