1、mysql 4 是不支持子查询的;
2、mysql 4 中 不相关联的表不能一起查询,可以把类之间的关联关系加上在进行相关查询;
3、Object 转化成int, long, double等
int varInt = Integer.parseInt(object.toString());
double varDouble = Double.parseDouble(object.toString());
long varLong = Long.parseLong(object.toString());
4、lang, double, int 与 Long, Double, Integer 之间的转换
Long varLong = new Long(varlong);
Long varLong = Integer.valueOf(varlong);(java1.5以下可能不支持)
long varlong = varLong.longValue();
Double varDouble = Double.valueOf(vardouble);
Double varDouble = new Double(vardouble);
double vardouble = varDouble.doubleValue();
Integer varInteger = new Integer(varint);
Integer varInteger = Integer.valueOf(varint);
int varint = varInteger.intValue();