View Javadoc

1   package liquibase.util;
2   
3   import java.sql.Types;
4   import java.util.Arrays;
5   import java.util.List;
6   
7   public class SqlUtil {
8   
9       public static boolean isNumeric(int dataType) {
10          List<Integer> numericTypes = Arrays.asList(Types.BIGINT, Types.BIT, Types.INTEGER, Types.SMALLINT,
11                  Types.TINYINT, Types.DECIMAL, Types.DOUBLE, Types.FLOAT, Types.NUMERIC, Types.REAL);
12  
13          return numericTypes.contains(dataType);
14      }
15  
16      public static boolean isBoolean(int dataType) {
17          return dataType == Types.BOOLEAN;
18      }
19  
20      public static boolean isDate(int dataType) {
21          List<Integer> validTypes = Arrays.asList(Types.DATE, Types.TIME, Types.TIMESTAMP);
22  
23          return validTypes.contains(dataType);
24      }
25  }