| 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 | } |