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 }