sf.database.jdbc.extension

Class ObjectJacksonMapping<T>

java.lang.Object

sf.database.jdbc.extension.ObjectJacksonMapping<T>

Type Parameters:

T -

All Implemented Interfaces:

TypeHandler<T>

Direct Known Subclasses:

ObjectJsonMapping

public class ObjectJacksonMapping<T>
extends Object
implements TypeHandler<T>

jackson实现的json映射.

Constructor Summary

Constructors

Constructor and Description
ObjectJacksonMapping()
ObjectJacksonMapping(com.fasterxml.jackson.databind.ObjectMapper mapper)

Method Summary

Modifier and Type	Method and Description
T	get(CallableStatement cs, int index)
T	get(CallableStatement cs, String parameterName)
T	get(ResultSet rs, int n) 从结果集里获取一个字段的值
T	get(ResultSet rs, String columnName) 从结果集里获取一个字段的值
Class<T>	getDefaultJavaType() 类型
String	getSqlExpression(Object value, DBDialect profile) 获取sql表达式
int	getSqlType() java.sql.Types的值
Object	set(CallableStatement cs, Object obj, String parameterName)
Object	set(PreparedStatement ps, Object obj, int index) 为缓冲语句设置值
void	setColumnMapping(ColumnMapping columnMapping) 设置返回的class,大部分的情况下不需要实现,只对范型返回类型的情况使用
void	setDefaultJavaType(Class<T> clz) 设置返回的class,大部分的情况下不需要实现,只对枚举或需要自定义返回类型的情况使用 和getDefaultJavaType() 方法成对出现
void	update(ResultSet rs, int columnIndex, Object value)
void	update(ResultSet rs, String columnLabel, Object value) 为了支持悲观锁中的数据类型转换
static String	wrapSqlStr(String s) 用单引号包围字符串，并将其中的单引号按SQL转义

Methods inherited from class java.lang.Object

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

Methods inherited from interface sf.database.jdbc.type.TypeHandler

setSqlType

Constructor Detail

ObjectJacksonMapping

public ObjectJacksonMapping()

ObjectJacksonMapping

public ObjectJacksonMapping(com.fasterxml.jackson.databind.ObjectMapper mapper)

Method Detail

getDefaultJavaType

public Class<T> getDefaultJavaType()

Description copied from interface: TypeHandler

类型

Specified by:

getDefaultJavaType in interface TypeHandler<T>

Returns:

setDefaultJavaType

public void setDefaultJavaType(Class<T> clz)

Description copied from interface: TypeHandler

设置返回的class,大部分的情况下不需要实现,只对枚举或需要自定义返回类型的情况使用 和getDefaultJavaType() 方法成对出现

Specified by:

setDefaultJavaType in interface TypeHandler<T>

Parameters:

clz - 设置java的数据类型

getSqlType

public int getSqlType()

Description copied from interface: TypeHandler

java.sql.Types的值

Specified by:

getSqlType in interface TypeHandler<T>

Returns:

setColumnMapping

public void setColumnMapping(ColumnMapping columnMapping)

Description copied from interface: TypeHandler

设置返回的class,大部分的情况下不需要实现,只对范型返回类型的情况使用

Specified by:

setColumnMapping in interface TypeHandler<T>

get

public T get(ResultSet rs,
             int n)
      throws SQLException

Description copied from interface: TypeHandler

从结果集里获取一个字段的值

Specified by:

get in interface TypeHandler<T>

Parameters:

rs - 结果集

n - 索引

Returns:

字段值

Throws:

SQLException

get

public T get(ResultSet rs,
             String columnName)
      throws SQLException

Description copied from interface: TypeHandler

从结果集里获取一个字段的值

Specified by:

get in interface TypeHandler<T>

Parameters:

rs - 结果集

columnName - 列名

Returns:

字段值

Throws:

SQLException

get

public T get(CallableStatement cs,
             int index)
      throws SQLException

Specified by:

get in interface TypeHandler<T>

Throws:

SQLException

get

public T get(CallableStatement cs,
             String parameterName)
      throws SQLException

Specified by:

get in interface TypeHandler<T>

Throws:

SQLException

update

public void update(ResultSet rs,
                   String columnLabel,
                   Object value)
            throws SQLException

Description copied from interface: TypeHandler

为了支持悲观锁中的数据类型转换

Specified by:

update in interface TypeHandler<T>

Throws:

SQLException

update

public void update(ResultSet rs,
                   int columnIndex,
                   Object value)
            throws SQLException

Specified by:

update in interface TypeHandler<T>

Throws:

SQLException

set

public Object set(PreparedStatement ps,
                  Object obj,
                  int index)
           throws SQLException

Description copied from interface: TypeHandler

为缓冲语句设置值

一个值可以被设置到多个占位符中

Specified by:

set in interface TypeHandler<T>

Parameters:

ps - 缓冲语句

obj - 值

index - 占位符位置，从 1 开始

Returns:

实际被设置到Statement中的值。
许多数据类型在设置到JDBC Statement中时需要转换类型，例如java.util.Date需要转换为java.sql.Date。

Throws:

SQLException

set

public Object set(CallableStatement cs,
                  Object obj,
                  String parameterName)
           throws SQLException

Specified by:

set in interface TypeHandler<T>

Throws:

SQLException

getSqlExpression

public String getSqlExpression(Object value,
                               DBDialect profile)

Description copied from interface: TypeHandler

获取sql表达式

Specified by:

getSqlExpression in interface TypeHandler<T>

Returns:

wrapSqlStr

public static String wrapSqlStr(String s)

用单引号包围字符串，并将其中的单引号按SQL转义

Parameters:

s -

Returns: