sf.database.jdbc.type

Class FileBlobType

java.lang.Object

sf.database.jdbc.type.FileBlobType

All Implemented Interfaces:

TypeHandler<File>

public class FileBlobType
extends Object
implements TypeHandler<File>

sqlite 不支持blob类型

Constructor Summary

Constructors

Constructor and Description
FileBlobType()

Method Summary

Modifier and Type	Method and Description
File	get(CallableStatement rs, int index)
File	get(CallableStatement cs, String parameterName)
File	get(ResultSet rs, int index) 从结果集里获取一个字段的值
File	get(ResultSet rs, String columnName) 从结果集里获取一个字段的值
Class<File>	getDefaultJavaType() 类型
int	getSqlType() java.sql.Types的值
Object	set(CallableStatement cs, Object obj, String parameterName)
Object	set(PreparedStatement ps, Object obj, int i) 为缓冲语句设置值
void	update(ResultSet rs, int columnIndex, Object value)
void	update(ResultSet rs, String columnLabel, Object value) 为了支持悲观锁中的数据类型转换
File	valueToFile(Object obj)

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

getSqlExpression, setColumnMapping, setDefaultJavaType, setSqlType

Constructor Detail

FileBlobType

public FileBlobType()

Method Detail

get

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

Description copied from interface: TypeHandler

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

Specified by:

get in interface TypeHandler<File>

Parameters:

rs - 结果集

columnName - 列名

Returns:

字段值

Throws:

SQLException

get

public File get(ResultSet rs,
                int index)
         throws SQLException

Description copied from interface: TypeHandler

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

Specified by:

get in interface TypeHandler<File>

Parameters:

rs - 结果集

index - 索引

Returns:

字段值

Throws:

SQLException

get

public File get(CallableStatement rs,
                int index)
         throws SQLException

Specified by:

get in interface TypeHandler<File>

Throws:

SQLException

get

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

Specified by:

get in interface TypeHandler<File>

Throws:

SQLException

set

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

Description copied from interface: TypeHandler

为缓冲语句设置值

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

Specified by:

set in interface TypeHandler<File>

Parameters:

ps - 缓冲语句

obj - 值

i - 占位符位置，从 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<File>

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<File>

Throws:

SQLException

update

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

Specified by:

update in interface TypeHandler<File>

Throws:

SQLException

getSqlType

public int getSqlType()

Description copied from interface: TypeHandler

java.sql.Types的值

Specified by:

getSqlType in interface TypeHandler<File>

Returns:

getDefaultJavaType

public Class<File> getDefaultJavaType()

Description copied from interface: TypeHandler

类型

Specified by:

getDefaultJavaType in interface TypeHandler<File>

Returns:

valueToFile

public File valueToFile(Object obj)
                 throws SQLException

Throws:

SQLException