xin.xihc.jba.utils

Class SQLConvert

java.lang.Object

xin.xihc.jba.utils.SQLConvert

public final class SQLConvert
extends Object

数据库语句转换

Version:

1.0

Author:

xihc

Field Summary

Fields

Modifier and Type	Field and Description
static String	commaSeparator

Constructor Summary

Constructors

Constructor and Description
SQLConvert()

Method Summary

Modifier and Type	Method and Description
static String	between(String fieldName, Map<String,Object> modelValue) between
static String	eq(String fieldName, Map<String,Object> modelValue) 等于
static String	gt(String fieldName, Map<String,Object> modelValue, boolean andEqueals) 大于、大于等于
static String	in(String fieldName, Map<String,Object> modelValue, boolean isNot) in
static String	like(String fieldName, Map<String,Object> modelValue) like
static String	lt(String fieldName, Map<String,Object> modelValue, boolean andEqueals) 小于、小于等于
static String	toString(List<Object> vals)
static String	toString(Object[] vals)

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Field Detail

commaSeparator

public static final String commaSeparator

See Also:

Constant Field Values

Constructor Detail

SQLConvert

public SQLConvert()

Method Detail

like

public static String like(String fieldName,
                          Map<String,Object> modelValue)

like

Parameters:

fieldName -

modelValue -

Returns:

eq

public static String eq(String fieldName,
                        Map<String,Object> modelValue)

等于

Parameters:

fieldName -

modelValue -

Returns:

between

public static String between(String fieldName,
                             Map<String,Object> modelValue)

between

Parameters:

fieldName -

modelValue -

Returns:

in

public static String in(String fieldName,
                        Map<String,Object> modelValue,
                        boolean isNot)

in

Parameters:

fieldName -

modelValue -

Returns:

gt

public static String gt(String fieldName,
                        Map<String,Object> modelValue,
                        boolean andEqueals)

大于、大于等于

Parameters:

fieldName -

modelValue -

Returns:

lt

public static String lt(String fieldName,
                        Map<String,Object> modelValue,
                        boolean andEqueals)

小于、小于等于

Parameters:

fieldName -

modelValue -

Returns:

toString

public static String toString(Object[] vals)

Parameters:

vals -

Returns:

toString

public static String toString(List<Object> vals)

Parameters:

vals -

Returns: