Java SQL Type getExpressionChoices(int type)

Description

get Expression Choices

License

Open Source License

Declaration

public static String[] getExpressionChoices(int type) 

Method Source Code

//package com.java2s;
/*//from w ww  . j av  a 2s  .co  m
* Copyright 2002 - 2013 Pentaho Corporation.  All rights reserved.
* 
* This software was developed by Pentaho Corporation and is provided under the terms
* of the Mozilla Public License, Version 1.1, or any later version. You may not use
* this file except in compliance with the license. If you need a copy of the license,
* please go to http://www.mozilla.org/MPL/MPL-1.1.txt. TThe Initial Developer is Pentaho Corporation.
*
* Software distributed under the Mozilla Public License is distributed on an "AS IS"
* basis, WITHOUT WARRANTY OF ANY KIND, either express or  implied. Please refer to
* the license for the specific language governing your rights and limitations.
*/

import java.sql.Types;

public class Main {
    public static String[] getExpressionChoices(int type) {
        String[] choices = new String[] { "none", "sum", "average", "min", "max", "item-count", "group-count" }; //$NON-NLS-1$ //$NON-NLS-2$ //$NON-NLS-3$ //$NON-NLS-4$ //$NON-NLS-5$ //$NON-NLS-6$ //$NON-NLS-7$
        if (type == Types.VARCHAR) {
            choices = new String[] { "none", "item-count", "group-count" }; //$NON-NLS-1$ //$NON-NLS-2$ //$NON-NLS-3$
        } else if (type == Types.DATE || type == Types.TIME || type == Types.TIMESTAMP) {
            choices = new String[] { "none", "item-count", "group-count" }; //$NON-NLS-1$ //$NON-NLS-2$ //$NON-NLS-3$
        }
        return choices;
    }
}

Related

1. getDefaultPrecision(int sqlType)
2. getDefaultScale(int sqlType)
3. getDefaultValue(Class type)
4. getDoubleTypeString(Connection conn)
5. getDoubleTypeString(Connection conn)
6. getFormatTypeAsString(int fieldType)
7. getInsertarEmpresa()
8. getIntTypeString(Connection conn)
9. getIntValue(String typeName)