Start line:  
End line:  

Snippet Preview

Snippet HTML Code

Stack Overflow Questions
  /*
   * Copyright 2014-2015 the original author or authors.
   *
   * Licensed under the Apache License, Version 2.0 (the "License");
   * you may not use this file except in compliance with the License.
   * You may obtain a copy of the License at
   *
   *     http://www.apache.org/licenses/LICENSE-2.0
   *
  * Unless required by applicable law or agreed to in writing, software
  * distributed under the License is distributed on an "AS IS" BASIS,
  * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND,
  * either express or implied. See the License for the specific language
  * governing permissions and limitations under the License.
  */
 package org.dbflute.cbean.sqlclause;
 
SqlClause for Sybase.

Author(s):
jflute
 
 public class SqlClauseSybase extends AbstractSqlClause {
 
     // ===================================================================================
     //                                                                          Definition
     //                                                                          ==========
     
The serial version UID for object serialization. (Default)
 
     private static final long serialVersionUID = 1L;
 
     // ===================================================================================
     //                                                                           Attribute
     //                                                                           =========
     
String of fetch-first as select-hint.
 
     protected String _fetchFirstSelectHint = "";

    
String of lock as sql-suffix.
 
     protected String _lockSqlSuffix = "";
 
     // ===================================================================================
     //                                                                         Constructor
     //                                                                         ===========
     
Constructor.

Parameters:
tableDbName The DB name of table. (NotNull)
 
     public SqlClauseSybase(String tableDbName) {
         super(tableDbName);
     }
 
     // ===================================================================================
     //                                                                Main Clause Override
     //                                                                ====================
     @Override
     protected boolean isUnionNormalSelectEnclosingRequired() {
         return true;
     }
 
     // ===================================================================================
     //                                                               Clause Parts Override
     //                                                               =====================
     @Override
     protected void appendSelectHint(StringBuilder sb) {
         if (needsUnionNormalSelectEnclosing()) {
             return// because clause should be enclosed when union normal select
         }
         super.appendSelectHint(sb);
     }
 
     // ===================================================================================
     //                                                                    OrderBy Override
     //                                                                    ================
     @Override
         return createOrderByNullsSetupperByCaseWhen();
     }
 
     // ===================================================================================
     //                                                                 FetchScope Override
     //                                                                 ===================
     
 
     protected void doFetchFirst() {
         if (isFetchSizeSupported()) {
              = " top " + getFetchSize();
         }
     }

    
 
     protected void doFetchPage() {
         if (isFetchSizeSupported()) {
             if (isFetchStartIndexSupported()) {
                  = " top " + getFetchSize();
            } else {
                 = " top " + getPageEndIndex();
            }
        }
    }

    
    protected void doClearFetchPageClause() {
         = "";
    }

    

Returns:
The determination, true or false.
    public boolean isFetchStartIndexSupported() {
        return false;
    }
    // ===================================================================================
    //                                                                       Lock Override
    //                                                                       =============
    
    public void lockForUpdate() {
         = " for update";
    }
    // ===================================================================================
    //                                                                       Hint Override
    //                                                                       =============
    
    protected String createSelectHint() {
        return ;
    }

    
    protected String createFromBaseTableHint() {
        return "";
    }

    
    protected String createFromHint() {
        return "";
    }

    
    protected String createSqlSuffix() {
        return ;
    }
    // [DBFlute-0.9.8.4]
    // ===================================================================================
    //                                                                               DBWay
    //                                                                               =====
    public DBWay dbway() {
        return ..dbway();
    }
New to GrepCode? Check out our FAQ X