生成带" AND "前缀小于查询的SQL片段.
@param field 数据库字段
@param value 值
@return ZealotKhala实例
422201
public ZealotKhala andLessThan(String field, Object value) {
        return this.doNormal(ZealotConst.AND_PREFIX, field, value, ZealotConst.LT_SUFFIX, true);
    }
537199
private ZealotKhala doBetween(String prefix, String field, Object startValue, Object endValue, boolean match) {
        if (match) {
            SqlInfoBuilder.newInstace(this.source.setPrefix(prefix)).buildBetweenSql(field, startValue, endValue);
            this.source.resetPrefix();
        }
        return this;
    }
278781
@SuppressWarnings("unchecked")
    private ZealotKhala doInByType(String prefix, String field, Object value,
            boolean match, int objType, boolean positive) {
        if (match) {
            // 赋予source对象in SQL片段的前缀和后缀操作符.
            this.source.setPrefix(prefix).setSuffix(positive ? ZealotConst.IN_SUFFIX : ZealotConst.NOT_IN_SUFFIX);
            // 根据对象类型调用对应的生成in查询的sql片段方法,否则抛出类型不符合的异常
            switch (objType) {
                // 如果类型是数组.
                case ZealotConst.OBJTYPE_ARRAY:
                    SqlInfoBuilder.newInstace(source).buildInSql(field, (Object[]) value);
                    break;
                // 如果类型是Java集合.
                case ZealotConst.OBJTYPE_COLLECTION:
                    JavaSqlInfoBuilder.newInstace(source).buildInSqlByCollection(field, (Collection<Object>) value);
                    break;
                default:
                    throw new NotCollectionOrArrayException("in查询的值不是有效的集合或数组!");
            }
            this.source.resetPrefix();
        }
        return this;
    }
535566
public ZealotKhala orIsNotNull(String field) {
        return this.doIsNull(ZealotConst.OR_PREFIX, field, true,false);
    }
1309506
public <T> List<Entity> find(String field, T value) throws SQLException {
		return this.find(Entity.create(tableName).set(field, value));
	}
992947
public static ColumnValue and(String column, Serializable value) {
        return new ColumnValue(column, AND, value);
    }
978827
public SqlInfo buildLikeSql(String fieldText, Object value) {
        // 由于默认配置的suffix的值只是" LIKE "和" NOT LIKE "两个关键字，生成的LIKE SQL片段需要加上" ? "占位符.
        this.suffix = StringHelper.isBlank(this.suffix) ? ZealotConst.LIKE_KEY : this.suffix;
        join.append(prefix).append(fieldText).append(suffix).append("? ");
        params.add("%" + value + "%");
        return sqlInfo.setJoin(join).setParams(params);
    }
1206571
public static Builder pushAll(String field, Object... values) {
        return new Builder().pushAll(field, values);
    }
1353421
public Object convertStringToJavaField(String value, int columnPos) throws SQLException {
		if (value == null) {
			return null;
		} else {
			return fieldConverter.resultStringToJava(this, value, columnPos);
		}
	}
864887
public ZealotKhala orLessThan(String field, Object value) {
        return this.doNormal(ZealotConst.OR_PREFIX, field, value, ZealotConst.LT_SUFFIX, true);
    }
432887
public ZealotKhala andNotLike(String field, Object value) {
        return this.doLike(ZealotConst.AND_PREFIX, field, value, true, false);
    }
763743
public ZealotKhala orNotEqual(String field, Object value) {
        return this.doNormal(ZealotConst.OR_PREFIX, field, value, ZealotConst.NOT_EQUAL_SUFFIX, true);
    }
629884
public DB2ESImportBuilder addFieldValue(String fieldName, Object value){
		addFieldValue(  fieldValues,  fieldName,  value);
		return this;
	}
211002
public ZealotKhala andIsNull(String field) {
        return this.doIsNull(ZealotConst.AND_PREFIX, field, true,true);
    }
641968
public ZealotKhala orBetween(String field, Object startValue, Object endValue) {
        return this.doBetween(ZealotConst.OR_PREFIX, field, startValue, endValue, true);
    }
510719
public static Query withMatchingString(String field, String value, boolean caseInsensitive) {
        return caseInsensitive ? regex(field, escapeRegExPattern(value), caseInsensitive, false, false, false) : withValue(field, eq, value);
    }
761673
public static final void appendValueToSql(StringBuilder sql, Object value) {
        if (value == null) {
            sql.append("NULL");
        } else if (value instanceof Boolean) {
            Boolean bool = (Boolean)value;
            if (bool) {
                sql.append('1');
            } else {
                sql.append('0');
            }
        } else {
            appendEscapedSQLString(sql, value.toString());
        }
    }