private int compareObject(byte[] left, byte[] right, OrderCol orderCol) {
/*
* mysql的日期也是数字字符串方式表达，因此可以跟整数等一起对待
* BLOB相关类型和GEOMETRY类型不支持排序，略掉
* ENUM和SET类型都是字符串，按字符串处理
*/
switch (orderCol.getColMeta().getColType()) {
case ColMeta.COL_TYPE_INT:
case ColMeta.COL_TYPE_LONG:
case ColMeta.COL_TYPE_SHORT:
case ColMeta.COL_TYPE_FLOAT:
case ColMeta.COL_TYPE_INT24:
case ColMeta.COL_TYPE_DOUBLE:
case ColMeta.COL_TYPE_DECIMAL:
case ColMeta.COL_TYPE_LONGLONG:
case ColMeta.COL_TYPE_NEWDECIMAL:
case ColMeta.COL_TYPE_BIT:
case ColMeta.COL_TYPE_DATE:
case ColMeta.COL_TYPE_TIME:
case ColMeta.COL_TYPE_YEAR:
case ColMeta.COL_TYPE_NEWDATE:
case ColMeta.COL_TYPE_DATETIME:
case ColMeta.COL_TYPE_TIMSTAMP:
return ByteUtil.compareNumberByte(left, right);
case ColMeta.COL_TYPE_STRING:
case ColMeta.COL_TYPE_VAR_STRING:
case ColMeta.COL_TYPE_SET:
case ColMeta.COL_TYPE_ENUM:
return CompareUtil.compareString(ByteUtil.getString(left), ByteUtil.getString(right));
}
return 0;
}
public static final int compareObject(Object l, Object r, OrderCol orderCol) {
int colType = orderCol.getColMeta().getColType();
byte[] left = (byte[]) l;
byte[] right = (byte[]) r;
// System.out.println("------------" + colType);
switch (colType) {
case ColMeta.COL_TYPE_DECIMAL:
case ColMeta.COL_TYPE_INT:
case ColMeta.COL_TYPE_SHORT:
case ColMeta.COL_TYPE_LONG:
case ColMeta.COL_TYPE_FLOAT:
case ColMeta.COL_TYPE_DOUBLE:
case ColMeta.COL_TYPE_LONGLONG:
case ColMeta.COL_TYPE_INT24:
case ColMeta.COL_TYPE_NEWDECIMAL:
// 因为mysql的日期也是数字字符串方式表达，因此可以跟整数等一起对待
case ColMeta.COL_TYPE_DATE:
case ColMeta.COL_TYPE_TIMSTAMP:
case ColMeta.COL_TYPE_TIME:
case ColMeta.COL_TYPE_YEAR:
case ColMeta.COL_TYPE_DATETIME:
case ColMeta.COL_TYPE_NEWDATE:
case ColMeta.COL_TYPE_BIT:
return ByteUtil.compareNumberByte(left, right);
case ColMeta.COL_TYPE_VAR_STRING:
case ColMeta.COL_TYPE_STRING:
// ENUM和SET类型都是字符串，按字符串处理
case ColMeta.COL_TYPE_ENUM:
case ColMeta.COL_TYPE_SET:
return CompareUtil.compareString(ByteUtil.getString(left), ByteUtil.getString(right));
// BLOB相关类型和GEOMETRY类型不支持排序，略掉
}
return 0;
}